index

Package np_job_assignment

This package provides the common business interface for the Job Assignment BPI (NP_JOB_ASSIGNMENT).

Job Assignment is a business process that combines the Job Base entity processing and the Job Detail entity processing. This BPI provides an interface to maintain data for both entities without having to access the entity level APIs.

Before creating Job Assignment information, position and employee information must be created in Banner.
Procedure p_create is used to create the initial Job Assignment.
Once the Job Assignment exists, p_update must be used to make changes or create a new effective date.

HR application security is invoked when performing query, create, delete, and update operations.
To query, create, delete, or update Job Assignment data, you must have access to the employee class, the time sheet organization, the employer code, and the employee's maximum jobs salary level. Access to these fields is defined by the user ID in the Banner HR security tables. If access is not granted, a query on the Job Assignment data will return a security violation error. Consequently, the data cannot be created, deleted or updated.

Program units
f_api_version   Returns the API version number.
f_exists   Checks if a record exists.
f_query_by_rowid   Selects one record using ROWID.
f_query_by_date   Selects most recent effective-dated record using the key and a query date.
f_query_one   Selects one record using key.
f_query_next   Selects the next effective-dated record relative to the current effective date.
p_create   Creates a record.
p_delete   Deletes a record.
p_update   Updates a record.
p_update_salary_encumbrance   Updates fields related to salary encumbrance.

Types
job_assignment_rec   Business Process record type
job_assignment_ref   Business Process cursor variable type
job_assignment_tab   Business Process table type

job_assignment_rec 

TYPE job_assignment_rec IS RECORD (
   r_pidm                       nbrjobs.nbrjobs_pidm%TYPE,
   r_posn                       nbrjobs.nbrjobs_posn%TYPE,
   r_suff                       nbrjobs.nbrjobs_suff%TYPE,
   r_begin_date                 nbrbjob.nbrbjob_begin_date%TYPE,
   r_end_date                   nbrbjob.nbrbjob_end_date%TYPE,
   r_defer_bal                  nbrbjob.nbrbjob_defer_bal%TYPE,
   r_contract_type              nbrbjob.nbrbjob_contract_type%TYPE,
   r_salary_encumbrance         nbrbjob.nbrbjob_salary_encumbrance%TYPE,
   r_contract_begin_date        nbrbjob.nbrbjob_contract_begin_date%TYPE,
   r_contract_end_date          nbrbjob.nbrbjob_contract_end_date%TYPE,
   r_total_contract_hrs         nbrbjob.nbrbjob_total_contract_hrs%TYPE,
   r_total_encumbrance_hrs      nbrbjob.nbrbjob_total_encumbrance_hrs%TYPE,
   r_step_incr_mon              nbrbjob.nbrbjob_step_incr_mon%TYPE,
   r_step_incr_day              nbrbjob.nbrbjob_step_incr_day%TYPE,
   r_coas_code                  nbrbjob.nbrbjob_coas_code%TYPE,
   r_accrue_leave_ind           nbrbjob.nbrbjob_accrue_leave_ind%TYPE,
   r_civil_service_ind          nbrbjob.nbrbjob_civil_service_ind%TYPE,
   r_encumbrance_change_ind     nbrbjob.nbrbjob_encumbrance_change_ind%TYPE,
   r_fringe_encumbrance         nbrbjob.nbrbjob_fringe_encumbrance%TYPE,
   r_ipeds_rept_ind             nbrbjob.nbrbjob_ipeds_rept_ind%TYPE,
   r_facl_statscan_rept_ind     nbrbjob.nbrbjob_facl_statscan_rept_ind%TYPE,
   r_probation_begin_date       nbrbjob.nbrbjob_probation_begin_date%TYPE,
   r_probation_end_date         nbrbjob.nbrbjob_probation_end_date%TYPE,
   r_probation_units            nbrbjob.nbrbjob_probation_units%TYPE,
   r_eligible_date              nbrbjob.nbrbjob_eligible_date%TYPE,
   r_effective_date             nbrjobs.nbrjobs_effective_date%TYPE,
   r_status                     nbrjobs.nbrjobs_status%TYPE,
   r_desc                       nbrjobs.nbrjobs_desc%TYPE,
   r_ecls_code                  nbrjobs.nbrjobs_ecls_code%TYPE,
   r_pict_code                  nbrjobs.nbrjobs_pict_code%TYPE,
   r_coas_code_ts               nbrjobs.nbrjobs_coas_code_ts%TYPE,
   r_orgn_code_ts               nbrjobs.nbrjobs_orgn_code_ts%TYPE,
   r_sal_table                  nbrjobs.nbrjobs_sal_table%TYPE,
   r_sal_grade                  nbrjobs.nbrjobs_sal_grade%TYPE,
   r_sal_step                   nbrjobs.nbrjobs_sal_step%TYPE,
   r_appt_pct                   nbrjobs.nbrjobs_appt_pct%TYPE,
   r_fte                        nbrjobs.nbrjobs_fte%TYPE,
   r_hrs_day                    nbrjobs.nbrjobs_hrs_day%TYPE,
   r_hrs_pay                    nbrjobs.nbrjobs_hrs_pay%TYPE,
   r_shift                      nbrjobs.nbrjobs_shift%TYPE,
   r_reg_rate                   nbrjobs.nbrjobs_reg_rate%TYPE,
   r_assgn_salary               nbrjobs.nbrjobs_assgn_salary%TYPE,
   r_factor                     nbrjobs.nbrjobs_factor%TYPE,
   r_ann_salary                 nbrjobs.nbrjobs_ann_salary%TYPE,
   r_per_pay_salary             nbrjobs.nbrjobs_per_pay_salary%TYPE,
   r_pays                       nbrjobs.nbrjobs_pays%TYPE,
   r_per_pay_defer_amt          nbrjobs.nbrjobs_per_pay_defer_amt%TYPE,
   r_jcre_code                  nbrjobs.nbrjobs_jcre_code%TYPE,
   r_sgrp_code                  nbrjobs.nbrjobs_sgrp_code%TYPE,
   r_empr_code                  nbrjobs.nbrjobs_empr_code%TYPE,
   r_lgcd_code                  nbrjobs.nbrjobs_lgcd_code%TYPE,
   r_locn_code                  nbrjobs.nbrjobs_locn_code%TYPE,
   r_schl_code                  nbrjobs.nbrjobs_schl_code%TYPE,
   r_supervisor_pidm            nbrjobs.nbrjobs_supervisor_pidm%TYPE,
   r_supervisor_posn            nbrjobs.nbrjobs_supervisor_posn%TYPE,
   r_supervisor_suff            nbrjobs.nbrjobs_supervisor_suff%TYPE,
   r_wkcp_code                  nbrjobs.nbrjobs_wkcp_code%TYPE,
   r_jbln_code                  nbrjobs.nbrjobs_jbln_code%TYPE,
   r_pers_chg_date              nbrjobs.nbrjobs_pers_chg_date%TYPE,
   r_pcat_code                  nbrjobs.nbrjobs_pcat_code%TYPE,
   r_dfpr_code                  nbrjobs.nbrjobs_dfpr_code%TYPE,
   r_encumbrance_hrs            nbrjobs.nbrjobs_encumbrance_hrs%TYPE,
   r_contract_no                nbrjobs.nbrjobs_contract_no%TYPE,
   r_strs_assn_code             nbrjobs.nbrjobs_strs_assn_code%TYPE,
   r_strs_pay_code              nbrjobs.nbrjobs_strs_pay_code%TYPE,
   r_pers_pay_code              nbrjobs.nbrjobs_pers_pay_code%TYPE,
   r_time_entry_method          nbrjobs.nbrjobs_time_entry_method%TYPE,
   r_time_entry_type            nbrjobs.nbrjobs_time_entry_type%TYPE,
   r_time_in_out_ind            nbrjobs.nbrjobs_time_in_out_ind%TYPE,
   r_lcat_code                  nbrjobs.nbrjobs_lcat_code%TYPE,
   r_leav_rept_method           nbrjobs.nbrjobs_leav_rept_method%TYPE,
   r_pict_code_leav_rept        nbrjobs.nbrjobs_pict_code_leav_rept%TYPE,
   r_user_id                    nbrjobs.nbrjobs_user_id%TYPE,
   r_data_origin                nbrjobs.nbrjobs_data_origin%TYPE,
   r_base_internal_record_id    gb_common.internal_record_id_type,
   r_detail_internal_record_id  gb_common.internal_record_id_type,
   r_future_salary_enc          nbrbjob.nbrbjob_future_salary_enc%TYPE,
   r_future_fringe_enc          nbrbjob.nbrbjob_future_fringe_enc%TYPE);

Business Process record type

job_assignment_ref 

TYPE job_assignment_ref IS REF CURSOR RETURN job_assignment_rec;

Business Process cursor variable type

job_assignment_tab 

TYPE job_assignment_tab IS TABLE OF job_assignment_rec INDEX BY BINARY_INTEGER;

Business Process table type

f_api_version 

Function f_api_version RETURN PLS_INTEGER

Returns the API version number.

Returns
Version of the API signature. Changes only when the signature changes.

f_exists 

Function f_exists(p_pidm IN nbrjobs.nbrjobs_pidm%TYPE,
                  p_posn IN nbrjobs.nbrjobs_posn%TYPE,
                  p_suff IN nbrjobs.nbrjobs_suff%TYPE) RETURN VARCHAR2

Checks if a record exists.

Parameters
p_pidm   Internal identification number of the employee. NUMBER(8) Required Key
p_posn   Position to which a job is attached. VARCHAR2(6) Required Key
p_suff   Unique identifier that helps create and maintain multiple jobs for the same position, for the same employee. VARCHAR2(2) Required Key

Returns
Y if found, otherwise N.

f_query_by_rowid 

Function f_query_by_rowid(p_job_base_rowid   IN gb_common.internal_record_id_type,
                          p_job_detail_rowid IN gb_common.internal_record_id_type)
  RETURN job_assignment_ref

Selects one record using ROWID.

Parameters
p_job_base_rowid   Database ROWID of the Job Base record to be selected. VARCHAR2(18) Required
p_job_detail_rowid   Database ROWID of the Job Detail record to be selected. VARCHAR2(18) Required

Returns
A cursor variable that will fetch exactly one record.

f_query_by_date 

Function f_query_by_date(p_pidm       IN nbrjobs.nbrjobs_pidm%TYPE,
                         p_posn       IN nbrjobs.nbrjobs_posn%TYPE,
                         p_suff       IN nbrjobs.nbrjobs_suff%TYPE,
                         p_query_date IN nbrjobs.nbrjobs_effective_date%TYPE)
  RETURN job_assignment_ref

Selects most recent effective-dated record using the key and a query date.

Parameters
p_pidm   Internal identification number of the employee. NUMBER(8) Required Key
p_posn   Position to which a job is attached. VARCHAR2(6) Required Key
p_suff   Unique identifier that helps create and maintain multiple jobs for the same position, for the same employee. VARCHAR2(2) Required Key
p_query_date   Date used to select the most recent effective-dated record. DATE Required Key

Returns
A cursor variable that will fetch the most recent effective-dated record.

f_query_one 

Function f_query_one(p_pidm           IN nbrjobs.nbrjobs_pidm%TYPE,
                     p_posn           IN nbrjobs.nbrjobs_posn%TYPE,
                     p_suff           IN nbrjobs.nbrjobs_suff%TYPE,
                     p_effective_date IN nbrjobs.nbrjobs_effective_date%TYPE)
  RETURN job_assignment_ref

Selects one record using key.

Parameters
p_pidm   Internal identification number of the employee. NUMBER(8) Required Key
p_posn   Position to which a job is attached. VARCHAR2(6) Required Key
p_suff   Unique identifier that helps create and maintain multiple jobs for the same position, for the same employee. VARCHAR2(2) Required Key
p_effective_date   Date that the Job Detail record becomes effective. DATE Required Key

Returns
A cursor variable that will fetch exactly one record.

f_query_next 

Function f_query_next(p_pidm           IN nbrjobs.nbrjobs_pidm%TYPE,
                      p_posn           IN nbrjobs.nbrjobs_posn%TYPE,
                      p_suff           IN nbrjobs.nbrjobs_suff%TYPE,
                      p_effective_date IN nbrjobs.nbrjobs_effective_date%TYPE)
  RETURN job_assignment_ref

Selects the next effective-dated record relative to the current effective date.

Parameters
p_pidm   Internal identification number of the employee. NUMBER(8) Required Key
p_posn   Position to which a job is attached. VARCHAR2(6) Required Key
p_suff   Unique identifier that helps create and maintain multiple jobs for the same position, for the same employee. VARCHAR2(2) Required Key
p_effective_date   Date that the Job Detail record becomes effective. DATE Required Key

Returns
A cursor variable that will fetch the most recent effective-dated record.

p_create 

Procedure p_create(p_pidm                   IN nbrjobs.nbrjobs_pidm%TYPE,
                   p_posn                   IN nbrjobs.nbrjobs_posn%TYPE,
                   p_suff                   IN nbrjobs.nbrjobs_suff%TYPE,
                   p_begin_date             IN nbrbjob.nbrbjob_begin_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_contract_type          IN nbrbjob.nbrbjob_contract_type%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_salary_encumbrance     IN nbrbjob.nbrbjob_salary_encumbrance%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_contract_begin_date    IN nbrbjob.nbrbjob_contract_begin_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_contract_end_date      IN nbrbjob.nbrbjob_contract_end_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_total_contract_hrs     IN nbrbjob.nbrbjob_total_contract_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_total_encumbrance_hrs  IN nbrbjob.nbrbjob_total_encumbrance_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_step_incr_mon          IN nbrbjob.nbrbjob_step_incr_mon%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_step_incr_day          IN nbrbjob.nbrbjob_step_incr_day%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_accrue_leave_ind       IN nbrbjob.nbrbjob_accrue_leave_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_civil_service_ind      IN nbrbjob.nbrbjob_civil_service_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_ipeds_rept_ind         IN nbrbjob.nbrbjob_ipeds_rept_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_facl_statscan_rept_ind IN nbrbjob.nbrbjob_facl_statscan_rept_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_probation_begin_date   IN nbrbjob.nbrbjob_probation_begin_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_probation_end_date     IN nbrbjob.nbrbjob_probation_end_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_probation_units        IN nbrbjob.nbrbjob_probation_units%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_eligible_date          IN nbrbjob.nbrbjob_eligible_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_status                 IN nbrjobs.nbrjobs_status%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_desc                   IN nbrjobs.nbrjobs_desc%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_ecls_code              IN nbrjobs.nbrjobs_ecls_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pict_code              IN nbrjobs.nbrjobs_pict_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_coas_code_ts           IN nbrjobs.nbrjobs_coas_code_ts%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_orgn_code_ts           IN nbrjobs.nbrjobs_orgn_code_ts%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_sal_table              IN nbrjobs.nbrjobs_sal_table%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_sal_grade              IN nbrjobs.nbrjobs_sal_grade%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_sal_step               IN nbrjobs.nbrjobs_sal_step%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_appt_pct               IN nbrjobs.nbrjobs_appt_pct%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_fte                    IN nbrjobs.nbrjobs_fte%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_hrs_day                IN nbrjobs.nbrjobs_hrs_day%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_hrs_pay                IN nbrjobs.nbrjobs_hrs_pay%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_shift                  IN nbrjobs.nbrjobs_shift%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_reg_rate               IN nbrjobs.nbrjobs_reg_rate%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_assgn_salary           IN nbrjobs.nbrjobs_assgn_salary%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_factor                 IN nbrjobs.nbrjobs_factor%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_ann_salary             IN nbrjobs.nbrjobs_ann_salary%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_pays                   IN nbrjobs.nbrjobs_pays%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_jcre_code              IN nbrjobs.nbrjobs_jcre_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_sgrp_code              IN nbrjobs.nbrjobs_sgrp_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_empr_code              IN nbrjobs.nbrjobs_empr_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_lgcd_code              IN nbrjobs.nbrjobs_lgcd_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_locn_code              IN nbrjobs.nbrjobs_locn_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_schl_code              IN nbrjobs.nbrjobs_schl_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_supervisor_pidm        IN nbrjobs.nbrjobs_supervisor_pidm%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_supervisor_posn        IN nbrjobs.nbrjobs_supervisor_posn%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_supervisor_suff        IN nbrjobs.nbrjobs_supervisor_suff%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_wkcp_code              IN nbrjobs.nbrjobs_wkcp_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_jbln_code              IN nbrjobs.nbrjobs_jbln_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pers_chg_date          IN nbrjobs.nbrjobs_pers_chg_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_pcat_code              IN nbrjobs.nbrjobs_pcat_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_dfpr_code              IN nbrjobs.nbrjobs_dfpr_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_encumbrance_hrs        IN nbrjobs.nbrjobs_encumbrance_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_contract_no            IN nbrjobs.nbrjobs_contract_no%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_strs_assn_code         IN nbrjobs.nbrjobs_strs_assn_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_strs_pay_code          IN nbrjobs.nbrjobs_strs_pay_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pers_pay_code          IN nbrjobs.nbrjobs_pers_pay_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_time_entry_method      IN nbrjobs.nbrjobs_time_entry_method%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_time_entry_type        IN nbrjobs.nbrjobs_time_entry_type%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_time_in_out_ind        IN nbrjobs.nbrjobs_time_in_out_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_lcat_code              IN nbrjobs.nbrjobs_lcat_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_leav_rept_method       IN nbrjobs.nbrjobs_leav_rept_method%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pict_code_leav_rept    IN nbrjobs.nbrjobs_pict_code_leav_rept%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_user_id                IN nbrjobs.nbrjobs_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_data_origin            IN nbrjobs.nbrjobs_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_job_earnings_table     IN np_job_earnings.job_earnings_tab DEFAULT np_job_earnings.f_unspecified_earnings_table,
                   p_job_labor_table        IN np_job_labor.job_labor_tab DEFAULT np_job_labor.f_unspecified_labor_table,
                   p_comment                IN VARCHAR2 DEFAULT NULL,
                   p_base_rowid_out         OUT gb_common.internal_record_id_type,
                   p_detail_rowid_out       OUT gb_common.internal_record_id_type,
                   p_warning_msg_out        OUT gb_common_strings.err_type)

Creates a record.
Effective Date does not have to be specified because it will default to the Begin Date.

Parameters
p_pidm   Internal identification number of the employee. NUMBER(8) Required Key
p_posn   Position to which a job is attached. VARCHAR2(6) Required Key
p_suff   Unique identifier that helps create and maintain multiple jobs for the same position, for the same employee. VARCHAR2(2) Required Key
p_begin_date   Begin date of the job. This will also become the effective date of the first Job Detail record. DATE Required
p_contract_type   Indicates the type of job. Only one primary job per person is allowed. VARCHAR2(1) Required
P   Primary (default)
S   Secondary
O   Overload

p_salary_encumbrance   Amount of money that a person will be paid in a job during the current fiscal year. NUMBER(11,2) Required
p_contract_begin_date   Date on which a contract begins. This date is significant for the encumbering process. DATE
p_contract_end_date   Date on which a contract ends. This date is significant for the encumbering process. DATE
p_total_contract_hrs   The total number of hours of the contract.  This is especially helpful if a contract spans multiple fiscal years. NUMBER(6,2)
p_total_encumbrance_hrs   The sum of the Job Detail Encumbrance Hours for the currently active fiscal year. It represents the total hours contracted to be paid in the active fiscal year. NUMBER(6,2)
p_step_incr_mon   Month in which an automatic step increase is to take place. VARCHAR2(2)
p_step_incr_day   Day of the month in which an automatic step increase is to take place. VARCHAR2(2)
p_accrue_leave_ind   Determines whether leave is accrued for a job. VARCHAR2(1) Required
Y   Yes
N   No

p_civil_service_ind   Indicates if an assignment is a civil service job. VARCHAR2(1) Required
Y   Yes
N   No

p_ipeds_rept_ind   Indicates if a job should be reported on the IPEDS report. VARCHAR2(1) Required
Y   Yes
N   No

p_facl_statscan_rept_ind   This indicator will allow the Canadian user to gather data that is necessary for reporting of the Annual Faculty STATSCAN reports. VARCHAR2(1) Required
Y   Yes
N   No

p_probation_begin_date   Begin date of the probationary period. DATE
p_probation_end_date   End date of the probationary period. This data is calculated based on the Probationary Period and Probation Begin Date, but may be overridden. DATE
p_probation_units   Identifies the number of Probationary Units. It represents months or days depending on the Probationary Period Units institutional setting. NUMBER(3)
p_eligible_date   Eligible date for the step increase. DATE
p_status   Status of the job. VARCHAR2(1) Required
A   Active (default)
B   Leave without pay and with benefits
L   Leave without pay and without benefits
F   Leave with full pay and with benefits
P   Leave with partial pay and with benefits
T   Terminated

p_desc   Description of the job. Defaults from the Position Title if left blank. VARCHAR2(60)
p_ecls_code   Employee class attached to the job, based on the employee class entered on the Position Definition Form (NBAPOSN). VARCHAR2(2) Required
p_pict_code   Pay ID attached to the job. VARCHAR2(2) Required
p_coas_code_ts   Valued only if Banner Finance is installed. VARCHAR2(1)
p_orgn_code_ts   Organization where time sheet is sent for the job. VARCHAR2(6) Required
p_sal_table   Salary table attached to the job. Defaults from the Salary/Rate Rule Form (NTRSALA) via the Position Definition Form (NBAPOSN). VARCHAR2(2)
p_sal_grade   Salary grade attached to the job. Defaults from the Salary/Rate Rule Form (NTRSALA) via the Position Definition Form (NBAPOSN). VARCHAR2(5)
p_sal_step   Salary step attached to the job. Defaults from the Salary/Rate Rule Form (NTRSALA) or can be entered online. NUMBER(3)
p_appt_pct   The Appointment percent attached to the Job. This is used to establish the percentage of full-time appointment for an employee in a position. The value defaults from the position record. NUMBER(5,2) Required
p_fte   Full-time percentage attached to the job. Defaults to 1. NUMBER(6,3)
p_hrs_day   Hours attached to the job that are normally worked in a day. NUMBER(6,2) Required
p_hrs_pay   Hours attached to the job that are normally worked in a pay period. NUMBER(6,2) Required
p_shift   Shift attached to the job. VARCHAR2(1) Required
p_reg_rate   Regular rate attached to the job.  If this field is entered or defaulted from the Salary/Rate Rule Form, the assignment salary is system-calculated and vice versa. NUMBER(11,6)
p_assgn_salary   Salary to be paid each pay period. If the assignment salary is entered, the annual salary is calculated based on the factor and vice versa. NUMBER(11,2) Required
p_factor   Number of pays per calendar year. NUMBER(3,1) Required
p_ann_salary   Annual salary attached to the job based on the calendar year. If the annual salary is entered, the assignment salary is system-calculated based the factor and vice versa. NUMBER(11,2) Required
p_pays   Used for deferred pay calculations. NUMBER(3,1) Required
p_jcre_code   Associates the reason for the change with the Job Detail record. VARCHAR2(5)
p_sgrp_code   Salary group attached to the job. VARCHAR2(6) Required
p_empr_code   Employer identification attached to the job. VARCHAR2(4)
p_lgcd_code   Longevity code attached to the job. VARCHAR2(4)
p_locn_code   EEO location attached to the job. VARCHAR2(6)
p_schl_code   EEO school attached to the job. VARCHAR2(6)
p_supervisor_pidm   Internal identification number of the supervisor attached to the job. NUMBER(8)
p_supervisor_posn   Position number of the supervisor attached to the job. VARCHAR2(6)
p_supervisor_suff   Suffix attached to the supervisor's position. VARCHAR2(2)
p_wkcp_code   Workers' Compensation Classification attached to the job. VARCHAR2(4)
p_jbln_code   Job Location attached to the job. VARCHAR2(6)
p_pers_chg_date   Date the change was actually made as opposed to the effective date which is for payroll purposes. DATE Required
p_pcat_code   Generates premium pay attached to the job. VARCHAR2(4)
p_dfpr_code   Defer pay schedule attached to the job. Defaults from PTRDFPR. VARCHAR2(4)
p_encumbrance_hrs   Hours used to calculate the encumbrance amount for a job in the active fiscal year. NUMBER(6,2)
p_contract_no   Job contract number attached to the job. VARCHAR2(8)
p_strs_assn_code   STRS assignment attached to the job. Valid values are STRS mandated. VARCHAR2(2)
p_strs_pay_code   STRS Pay code for the employee attached to the job. The selected value determines how the employee's salary will be reported to STRS administration on the monthly F-496 report. VARCHAR2(2)
0   Annual
1   12 Monthly Payments
2   11 Monthly Payments
3   10 Monthly Payments
4   Hourly
7   13 Payments
8   Daily

p_pers_pay_code   PERS Pay code for the employee attached to the job. The selected value determines how the employee's salary will be reported to PERS administration on the PERS Monthly Contribution Report. VARCHAR2(2)
1   Monthly Pay Rate
2   Monthly Pay Rate (LA)
4   Hourly Pay Rate
8   Daily Pay Rate
9   Miscellaneous Pay Rate

p_time_entry_method   Time Entry Method attached to the job. VARCHAR2(1) Required
P   Payroll
W   Web
D   Departmental
T   Third Party

p_time_entry_type   Time Entry Type attached to the job. It represents how time will be entered over the Web or on the Electronic Approvals of Time Entry Form (PHATIME). VARCHAR2(1) Required
T   Time Sheet
E   Exception Time Only
N   None

p_time_in_out_ind   Time In/Out Indicator attached to the job. It indicates when entry of time in and out information is required. VARCHAR2(1) Required
Y   Yes
N   No

p_lcat_code   Code which identifies a group of leave types. It is used when the Leave by Job method has been selected for leave processing. VARCHAR2(2)
p_leav_rept_method   Leave Report method attached to the job. VARCHAR2(1) Required
P   Payroll
W   Web
D   Departmental
T   Third Party

p_pict_code_leav_rept   Leave Report Pay ID attached to the job and associated with a leave report or leave request. VARCHAR2(2) Required
p_user_id   The Oracle ID of the user who changed the record. VARCHAR2(30)
p_data_origin   Source system that created or updated the row. VARCHAR2(30)
p_job_earnings_table   Earnings given for this Job Assignment.  If none are specified, the earnings will default according to predefined rules. np_job_earnings.jobs_earnings_tab
p_job_labor_table   Labor distributions given for this Job Assignment.  If none are specified, the labor distributions will default from the position. np_job_labor.job_labor_tab
p_comment   Comment to be stored in Job History data. VARCHAR2(1300)
p_base_rowid_out   Database ROWID of the Job Base record to be created. VARCHAR2(18) Required
p_detail_rowid_out   Database ROWID of the Job Detail record to be created. VARCHAR2(18) Required
p_warning_msg_out   Returned warning messages. Warning messages will only be returned if the record is successfully created. gb_common_strings.err_type

p_delete 

Procedure p_delete(p_pidm            IN nbrjobs.nbrjobs_pidm%TYPE,
                   p_posn            IN nbrjobs.nbrjobs_posn%TYPE,
                   p_suff            IN nbrjobs.nbrjobs_suff%TYPE,
                   p_effective_date  IN nbrjobs.nbrjobs_effective_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_user_id         IN nbrjobs.nbrjobs_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_data_origin     IN nbrjobs.nbrjobs_data_origin%TYPE,
                   p_warning_msg_out OUT gb_common_strings.err_type)

Deletes a record.
If the specified effective date is also the begin date of the Job Assignment, the entire Job Assignment will be deleted.

Parameters
p_pidm   Internal identification number of the employee. NUMBER(8) Required Key
p_posn   Position to which a job is attached. VARCHAR2(6) Required Key
p_suff   Unique identifier that helps create and maintain multiple jobs for the same position, for the same employee. VARCHAR2(2) Required Key
p_effective_date   Date that the Job Detail record becomes effective. DATE Required Key
p_user_id   The Oracle ID of the user who changed the record. VARCHAR2(30)
p_data_origin   Source system that created or updated the row. VARCHAR2(30)
p_warning_msg_out   Returned warning messages. Warning messages will only be returned if the record is successfully deleted. gb_common_strings.err_type

p_update 

Procedure p_update(p_pidm                   IN nbrjobs.nbrjobs_pidm%TYPE,
                   p_posn                   IN nbrjobs.nbrjobs_posn%TYPE,
                   p_suff                   IN nbrjobs.nbrjobs_suff%TYPE,
                   p_effective_date         IN nbrjobs.nbrjobs_effective_date%TYPE,
                   p_defer_bal              IN nbrbjob.nbrbjob_defer_bal%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_contract_type          IN nbrbjob.nbrbjob_contract_type%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_salary_encumbrance     IN nbrbjob.nbrbjob_salary_encumbrance%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_contract_begin_date    IN nbrbjob.nbrbjob_contract_begin_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_contract_end_date      IN nbrbjob.nbrbjob_contract_end_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_total_contract_hrs     IN nbrbjob.nbrbjob_total_contract_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_total_encumbrance_hrs  IN nbrbjob.nbrbjob_total_encumbrance_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_step_incr_mon          IN nbrbjob.nbrbjob_step_incr_mon%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_step_incr_day          IN nbrbjob.nbrbjob_step_incr_day%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_accrue_leave_ind       IN nbrbjob.nbrbjob_accrue_leave_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_civil_service_ind      IN nbrbjob.nbrbjob_civil_service_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_ipeds_rept_ind         IN nbrbjob.nbrbjob_ipeds_rept_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_facl_statscan_rept_ind IN nbrbjob.nbrbjob_facl_statscan_rept_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_probation_begin_date   IN nbrbjob.nbrbjob_probation_begin_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_probation_end_date     IN nbrbjob.nbrbjob_probation_end_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_probation_units        IN nbrbjob.nbrbjob_probation_units%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_eligible_date          IN nbrbjob.nbrbjob_eligible_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_status                 IN nbrjobs.nbrjobs_status%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_desc                   IN nbrjobs.nbrjobs_desc%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_ecls_code              IN nbrjobs.nbrjobs_ecls_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pict_code              IN nbrjobs.nbrjobs_pict_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_coas_code_ts           IN nbrjobs.nbrjobs_coas_code_ts%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_orgn_code_ts           IN nbrjobs.nbrjobs_orgn_code_ts%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_sal_table              IN nbrjobs.nbrjobs_sal_table%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_sal_grade              IN nbrjobs.nbrjobs_sal_grade%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_sal_step               IN nbrjobs.nbrjobs_sal_step%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_appt_pct               IN nbrjobs.nbrjobs_appt_pct%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_fte                    IN nbrjobs.nbrjobs_fte%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_hrs_day                IN nbrjobs.nbrjobs_hrs_day%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_hrs_pay                IN nbrjobs.nbrjobs_hrs_pay%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_shift                  IN nbrjobs.nbrjobs_shift%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_reg_rate               IN nbrjobs.nbrjobs_reg_rate%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_assgn_salary           IN nbrjobs.nbrjobs_assgn_salary%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_factor                 IN nbrjobs.nbrjobs_factor%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_ann_salary             IN nbrjobs.nbrjobs_ann_salary%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_pays                   IN nbrjobs.nbrjobs_pays%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_jcre_code              IN nbrjobs.nbrjobs_jcre_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_sgrp_code              IN nbrjobs.nbrjobs_sgrp_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_empr_code              IN nbrjobs.nbrjobs_empr_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_lgcd_code              IN nbrjobs.nbrjobs_lgcd_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_locn_code              IN nbrjobs.nbrjobs_locn_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_schl_code              IN nbrjobs.nbrjobs_schl_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_supervisor_pidm        IN nbrjobs.nbrjobs_supervisor_pidm%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_supervisor_posn        IN nbrjobs.nbrjobs_supervisor_posn%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_supervisor_suff        IN nbrjobs.nbrjobs_supervisor_suff%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_wkcp_code              IN nbrjobs.nbrjobs_wkcp_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_jbln_code              IN nbrjobs.nbrjobs_jbln_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pers_chg_date          IN nbrjobs.nbrjobs_pers_chg_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_pcat_code              IN nbrjobs.nbrjobs_pcat_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_dfpr_code              IN nbrjobs.nbrjobs_dfpr_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_encumbrance_hrs        IN nbrjobs.nbrjobs_encumbrance_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_contract_no            IN nbrjobs.nbrjobs_contract_no%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_strs_assn_code         IN nbrjobs.nbrjobs_strs_assn_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_strs_pay_code          IN nbrjobs.nbrjobs_strs_pay_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pers_pay_code          IN nbrjobs.nbrjobs_pers_pay_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_time_entry_method      IN nbrjobs.nbrjobs_time_entry_method%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_time_entry_type        IN nbrjobs.nbrjobs_time_entry_type%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_time_in_out_ind        IN nbrjobs.nbrjobs_time_in_out_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_lcat_code              IN nbrjobs.nbrjobs_lcat_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_leav_rept_method       IN nbrjobs.nbrjobs_leav_rept_method%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pict_code_leav_rept    IN nbrjobs.nbrjobs_pict_code_leav_rept%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_user_id                IN nbrjobs.nbrjobs_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_data_origin            IN nbrjobs.nbrjobs_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_comment                IN VARCHAR2 DEFAULT NULL,
                   p_warning_msg_out        OUT gb_common_strings.err_type)

Updates a record.

Parameters
p_pidm   Internal identification number of the employee. NUMBER(8) Required Key
p_posn   Position to which a job is attached. VARCHAR2(6) Required Key
p_suff   Unique identifier that helps create and maintain multiple jobs for the same position, for the same employee. VARCHAR2(2) Required Key
p_effective_date   Date that the Job Detail record becomes effective. DATE Required Key
p_defer_bal   Amount of deferred pay accumulated for a job. NUMBER(11,2) Required
p_contract_type   Indicates the type of job. Only one primary job per person is allowed. VARCHAR2(1) Required
P   Primary (default)
S   Secondary
O   Overload

p_salary_encumbrance   Amount of money that a person will be paid in a job during the current fiscal year. NUMBER(11,2) Required
p_contract_begin_date   Date on which a contract begins. This date is significant for the encumbering process. DATE
p_contract_end_date   Date on which a contract ends. This date is significant for the encumbering process. DATE
p_total_contract_hrs   Total number of hours of the contract.  This is especially helpful if a contract spans multiple fiscal years. NUMBER(6,2)
p_total_encumbrance_hrs   The sum of the Job Detail Encumbrance Hours for the currently active fiscal year. It represents the total hours contracted to be paid in the active fiscal year. NUMBER(6,2)
p_step_incr_mon   Month in which an automatic step increase is to take place. VARCHAR2(2)
p_step_incr_day   Day of the month in which an automatic step increase is to take place. VARCHAR2(2)
p_accrue_leave_ind   Determines whether leave is accrued for a job. VARCHAR2(1) Required
Y   Yes
N   No

p_civil_service_ind   Indicates if an assignment is a civil service job. VARCHAR2(1) Required
Y   Yes
N   No

p_ipeds_rept_ind   Indicates if a job should be reported on the IPEDS report. VARCHAR2(1) Required
Y   Yes
N   No

p_facl_statscan_rept_ind   This indicator will allow the Canadian user to gather data that is necessary for reporting of the Annual Faculty STATSCAN reports. VARCHAR2(1) Required
Y   Yes
N   No

p_probation_begin_date   Begin date of the probationary period. DATE
p_probation_end_date   End date of the probationary period. This data is calculated based on the Probationary Period and Probation Begin Date, but may be overridden. DATE
p_probation_units   Identifies the number of Probationary Units. It represents months or days depending on the Probationary Period Units institutional setting. NUMBER(3)
p_eligible_date   Eligible date for the step increase. DATE
p_status   Status of the job. VARCHAR2(1) Required
A   Active (default)
B   Leave without pay and with benefits
L   Leave without pay and without benefits
F   Leave with full pay and with benefits
P   Leave with partial pay and with benefits
T   Terminated

p_desc   Description of the job.  Defaults from the Position Title if left blank. VARCHAR2(60)
p_ecls_code   Employee class attached to the job, based on the employee class entered on the Position Definition Form (NBAPOSN). VARCHAR2(2) Required
p_pict_code   Pay ID attached to the job. VARCHAR2(2) Required
p_coas_code_ts   Valued only if Banner Finance is installed. VARCHAR2(1)
p_orgn_code_ts   Organization where the time sheet is sent for a job. VARCHAR2(6) Required
p_sal_table   Salary table attached to the job. Defaults from the Salary/Rate Rule Form (NTRSALA) via the Position Definition Form (NBAPOSN). VARCHAR2(2)
p_sal_grade   Salary grade attached to the job. Defaults from the Salary/Rate Rule Form (NTRSALA) via the Position Definition Form (NBAPOSN). VARCHAR2(5)
p_sal_step   Salary step attached to the job. Defaults from the Salary/Rate Rule Form (NTRSALA) or can be entered online. NUMBER(3)
p_appt_pct   Appointment percent attached to the job. It establishes the percentage of full-time appointment for an employee in a position. The value defaults from the position record. NUMBER(5,2) Required
p_fte   Full-time percentage attached to the job. Defaults to 1. NUMBER(6,3)
p_hrs_day   Hours attached to the job that are normally worked in a day. NUMBER(6,2) Required
p_hrs_pay   Hours attached to the job that are normally worked in a pay period. NUMBER(6,2) Required
p_shift   Shift attached to the job. VARCHAR2(1) Required
p_reg_rate   Regular rate attached to the job.  If this field is entered or defaulted from the Salary/Rate Rule Form, the assignment salary is system-calculated and vice versa. NUMBER(11,6)
p_assgn_salary   Salary to be paid each pay period. If the assignment salary is entered, the annual salary is calculated based on the factor, and vice versa. NUMBER(11,2) Required
p_factor   Number of pays per calendar year. NUMBER(3,1) Required
p_ann_salary   Annual salary attached to the job based on the calendar year.  If the annual salary is entered, the assignment salary is system-calculated based the factor, and vice versa. NUMBER(11,2) Required
p_pays   Used for deferred pay calculations. NUMBER(3,1) Required
p_jcre_code   Associates the reason for the change with the Job Detail record. VARCHAR2(5)
p_sgrp_code   Salary group attached to the job. VARCHAR2(6) Required
p_empr_code   Employer identification attached to the job. VARCHAR2(4)
p_lgcd_code   Longevity code attached to the job. VARCHAR2(4)
p_locn_code   EEO location attached to the job. VARCHAR2(6)
p_schl_code   EEO school attached to the job. VARCHAR2(6)
p_supervisor_pidm   Internal identification number of the supervisor attached to the job. NUMBER(8)
p_supervisor_posn   Position number of the supervisor attached to the job. VARCHAR2(6)
p_supervisor_suff   Suffix attached to the supervisor's position. VARCHAR2(2)
p_wkcp_code   Workers' Compensation Classification attached to the job. VARCHAR2(4)
p_jbln_code   Job Location attached to the job. VARCHAR2(6)
p_pers_chg_date   Date the change was actually made as opposed to the effective date which is for payroll purposes. DATE Required
p_pcat_code   Generates premium pay attached to the job. VARCHAR2(4)
p_dfpr_code   Defer pay schedule attached to the job. Defaults from PTRDFPR. VARCHAR2(4)
p_encumbrance_hrs   Hours used to calculate the encumbrance amount for this job in the active fiscal year. NUMBER(6,2)
p_contract_no   Job contract number attached to the job. VARCHAR2(8)
p_strs_assn_code   STRS Assignment Code attached to the job. Valid values are STRS mandated. VARCHAR2(2)
p_strs_pay_code   STRS Pay code for the employee attached to the job. The selected value determines how the employee's salary will be reported to STRS administration on the monthly F-496 report. VARCHAR2(2)
0   Annual
1   12 Monthly Payments
2   11 Monthly Payments
3   10 Monthly Payments
4   Hourly
7   13 Payments
8   Daily

p_pers_pay_code   PERS Pay code for the employee attached to the job. The selected value determines how the employee's salary will be reported to PERS administration on the PERS Monthly Contribution Report. VARCHAR2(2)
1   Monthly Pay Rate
2   Monthly Pay Rate (LA)
4   Hourly Pay Rate
8   Daily Pay Rate
9   Miscellaneous Pay Rate

p_time_entry_method   Time Entry Method attached to the job. VARCHAR2(1) Required
P   Payroll
W   Web
D   Departmental
T   Third Party

p_time_entry_type   Time Entry Type attached to the job. It represents how time will be entered over the Web or on the Electronic Approvals of Time Entry Form (PHATIME). VARCHAR2(1) Required
T   Time Sheet
E   Exception Time Only
N   None

p_time_in_out_ind   Time In/Out Indicator attached to the job. It indicates when entry of time in and out information is required. VARCHAR2(1) Required
Y   Yes
N   No

p_lcat_code   Code which identifies a group of leave types. It is used when the Leave by Job Method has been selected for leave processing. VARCHAR2(2)
p_leav_rept_method   Leave Report method attached to the job. VARCHAR2(1) Required
P   Payroll
W   Web
D   Departmental
T   Third Party

p_pict_code_leav_rept   The Leave Report Pay ID attached to the job and associated with a leave report or leave request. VARCHAR2(2) Required
p_user_id   The Oracle ID of the user who changed the record. VARCHAR2(30)
p_data_origin   Source system that created or updated the row. VARCHAR2(30)
p_comment   Comment to be stored in Job History data. VARCHAR2(1300)
p_warning_msg_out   Returned warning messages. Warning messages will only be returned if the record is successfully updated. gb_common_strings.err_type

p_update_salary_encumbrance 

Procedure p_update_salary_encumbrance(p_pidm               IN nbrjobs.nbrjobs_pidm%TYPE,
                                      p_posn               IN nbrjobs.nbrjobs_posn%TYPE,
                                      p_suff               IN nbrjobs.nbrjobs_suff%TYPE,
                                      p_effective_date     IN nbrjobs.nbrjobs_effective_date%TYPE,
                                      p_salary_encumbrance IN nbrbjob.nbrbjob_salary_encumbrance%TYPE DEFAULT dml_common.f_unspecified_number,
                                      p_user_id            IN nbrjobs.nbrjobs_user_id%TYPE DEFAULT gb_common.f_sct_user,
                                      p_data_origin        IN nbrjobs.nbrjobs_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
                                      p_comment            IN VARCHAR2 DEFAULT NULL,
                                      p_warning_msg_out    OUT gb_common_strings.err_type)

Updates fields related to salary encumbrance.

Parameters
p_pidm   Internal identification number of the employee. NUMBER(8) Required Key
p_posn   Position to which a job is attached. VARCHAR2(6) Required Key
p_suff   Unique identifier that helps create and maintain multiple jobs for the same position, for the same employee. VARCHAR2(2) Required Key
p_effective_date   Date that the Job Detail record becomes effective. DATE Required Key
p_salary_encumbrance   Amount of money that a person will be paid in a job during the current fiscal year. NUMBER(11,2) Required
p_user_id   The Oracle ID of the user who changed the record. VARCHAR2(30)
p_data_origin   Source system that created or updated the row. VARCHAR2(30)
p_comment   Comment to be stored in Job History data. VARCHAR2(1300)
p_warning_msg_out   Returned warning messages. Warning messages will only be returned if the record is successfully updated. gb_common_strings.err_type