index

Package nb_job_detail_rules

Support subprograms for the Job Detail API (nb_job_detail).

Program units
p_register_entity   Register the attribute value pairs to the message cache for delete operations.
p_register_entity   Register the attribute/value pairs to the message cache for create and update operations.
p_validate   Validates all data in the record.
p_validate_delete   Validates deletion of a record.

p_register_entity 

Procedure p_register_entity(p_operation_type     NUMBER,
                            p_internal_record_id gb_common.internal_record_id_type)

Register the attribute value pairs to the message cache for delete operations.
This signature uses the ROWID only, for the delete operations.

Parameters
p_operation_type   Type of DML operation: create,update,delete. NUMBER Required
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_register_entity 

Procedure p_register_entity(p_operation_type      NUMBER,
                            p_pidm                nbrjobs.nbrjobs_pidm%TYPE,
                            p_posn                nbrjobs.nbrjobs_posn%TYPE,
                            p_suff                nbrjobs.nbrjobs_suff%TYPE,
                            p_effective_date      nbrjobs.nbrjobs_effective_date%TYPE,
                            p_status              nbrjobs.nbrjobs_status%TYPE,
                            p_desc                nbrjobs.nbrjobs_desc%TYPE,
                            p_ecls_code           nbrjobs.nbrjobs_ecls_code%TYPE,
                            p_pict_code           nbrjobs.nbrjobs_pict_code%TYPE,
                            p_coas_code_ts        nbrjobs.nbrjobs_coas_code_ts%TYPE,
                            p_orgn_code_ts        nbrjobs.nbrjobs_orgn_code_ts%TYPE,
                            p_sal_table           nbrjobs.nbrjobs_sal_table%TYPE,
                            p_sal_grade           nbrjobs.nbrjobs_sal_grade%TYPE,
                            p_sal_step            nbrjobs.nbrjobs_sal_step%TYPE,
                            p_appt_pct            nbrjobs.nbrjobs_appt_pct%TYPE,
                            p_fte                 nbrjobs.nbrjobs_fte%TYPE,
                            p_hrs_day             nbrjobs.nbrjobs_hrs_day%TYPE,
                            p_hrs_pay             nbrjobs.nbrjobs_hrs_pay%TYPE,
                            p_shift               nbrjobs.nbrjobs_shift%TYPE,
                            p_reg_rate            nbrjobs.nbrjobs_reg_rate%TYPE,
                            p_assgn_salary        nbrjobs.nbrjobs_assgn_salary%TYPE,
                            p_factor              nbrjobs.nbrjobs_factor%TYPE,
                            p_ann_salary          nbrjobs.nbrjobs_ann_salary%TYPE,
                            p_per_pay_salary      nbrjobs.nbrjobs_per_pay_salary%TYPE,
                            p_pays                nbrjobs.nbrjobs_pays%TYPE,
                            p_per_pay_defer_amt   nbrjobs.nbrjobs_per_pay_defer_amt%TYPE,
                            p_jcre_code           nbrjobs.nbrjobs_jcre_code%TYPE,
                            p_sgrp_code           nbrjobs.nbrjobs_sgrp_code%TYPE,
                            p_empr_code           nbrjobs.nbrjobs_empr_code%TYPE,
                            p_lgcd_code           nbrjobs.nbrjobs_lgcd_code%TYPE,
                            p_locn_code           nbrjobs.nbrjobs_locn_code%TYPE,
                            p_schl_code           nbrjobs.nbrjobs_schl_code%TYPE,
                            p_supervisor_pidm     nbrjobs.nbrjobs_supervisor_pidm%TYPE,
                            p_supervisor_posn     nbrjobs.nbrjobs_supervisor_posn%TYPE,
                            p_supervisor_suff     nbrjobs.nbrjobs_supervisor_suff%TYPE,
                            p_wkcp_code           nbrjobs.nbrjobs_wkcp_code%TYPE,
                            p_jbln_code           nbrjobs.nbrjobs_jbln_code%TYPE,
                            p_pers_chg_date       nbrjobs.nbrjobs_pers_chg_date%TYPE,
                            p_pcat_code           nbrjobs.nbrjobs_pcat_code%TYPE,
                            p_dfpr_code           nbrjobs.nbrjobs_dfpr_code%TYPE,
                            p_encumbrance_hrs     nbrjobs.nbrjobs_encumbrance_hrs%TYPE,
                            p_contract_no         nbrjobs.nbrjobs_contract_no%TYPE,
                            p_strs_assn_code      nbrjobs.nbrjobs_strs_assn_code%TYPE,
                            p_strs_pay_code       nbrjobs.nbrjobs_strs_pay_code%TYPE,
                            p_pers_pay_code       nbrjobs.nbrjobs_pers_pay_code%TYPE,
                            p_time_entry_method   nbrjobs.nbrjobs_time_entry_method%TYPE,
                            p_time_entry_type     nbrjobs.nbrjobs_time_entry_type%TYPE,
                            p_time_in_out_ind     nbrjobs.nbrjobs_time_in_out_ind%TYPE,
                            p_lcat_code           nbrjobs.nbrjobs_lcat_code%TYPE,
                            p_leav_rept_method    nbrjobs.nbrjobs_leav_rept_method%TYPE,
                            p_pict_code_leav_rept nbrjobs.nbrjobs_pict_code_leav_rept%TYPE,
                            p_user_id             nbrjobs.nbrjobs_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin         nbrjobs.nbrjobs_data_origin%TYPE,
                            p_internal_record_id  gb_common.internal_record_id_type)

Register the attribute/value pairs to the message cache for create and update operations.
 
This signature registers the all parameters.

Parameters
p_operation_type   Type of DML operation: create,update,delete. NUMBER Required
p_pidm   Internal identification number of the employee. NUMBER(8) Required Key
p_posn   Position Number. VARCHAR2(6) Required Key
p_suff   Suffix of the job. VARCHAR2(2) Required Key
p_effective_date   Date that the Job Assignment record becomes effective. DATE Required Key
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   The employee class attached to the job, based on the Employee Class entered on the Position Form (NBAPOSN). VARCHAR2(2) Required
p_pict_code   The 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 this job. VARCHAR2(6) Required
p_sal_table   The Salary Table attached to the job. Defaults from the Salary/Rate Rule Form (NTRSALA) via the Position Form (NBAPOSN). VARCHAR2(2)
p_sal_grade   The Salary Grade attached to the job. Defaults from the Salary/Rate Rule Form (NTRSALA) via the Position Form (NBAPOSN). VARCHAR2(5)
p_sal_step   The 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. 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   The full time percentage attached to the job. Defaults to 1. NUMBER(6,3)
p_hrs_day   The hours attached to the job that are normally worked in a day. NUMBER(6,2) Required
p_hrs_pay   The hours attached to the job that are normally worked in a pay period. NUMBER(6,2) Required
p_shift   The shift attached to the job. VARCHAR2(1) Required
p_reg_rate   The regular rate attached to the job.  If this field is entered or defaulted from the Salary/Rate Rule Form, the Assign Salary is system calculated and vice versa. NUMBER(11,6)
p_assgn_salary   The 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   The number of pays per calendar year. NUMBER(3,1) Required
p_ann_salary   The 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_per_pay_salary   Used for deferred pay calculations. NUMBER(11,2) Required
p_pays   Used for deferred pay calculations. NUMBER(3,1) Required
p_per_pay_defer_amt   The amount deferred each pay period for deferred pay calculation. NUMBER(11,2) Required
p_jcre_code   Associates the reason for the change with the Job Detail record. VARCHAR2(5)
p_sgrp_code   The Salary Group Code attached to the job. VARCHAR2(6) Required
p_empr_code   The Employer Identification code 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   The 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 Code attached to the job. VARCHAR2(4)
p_jbln_code   Job Location Code 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   The 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 value selected determines how the employee's salary will be reported to STRS administration on the monthly F-496 report. VARCHAR2(2)
p_pers_pay_code   PERS Pay Code for the employee attached to the job. The value selected determines how the employee's salary will be reported to PERS administration on the PERS Monthly Contribution Report. VARCHAR2(2)
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 the structure of 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. Indicates when entry of time in and out information is required. VARCHAR2(1) Required
Y   Yes
N   No

p_lcat_code   A 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_internal_record_id   Database ROWID VARCHAR2(18) required

p_validate 

Procedure p_validate(p_val_rec_inout             IN OUT nb_job_detail.job_detail_rec,
                     p_operation_type            IN NUMBER,
                     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_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_defer_pay_ind_out         OUT VARCHAR2,
                     p_defer_accruals_out        OUT NUMBER,
                     p_adj_per_pay_salary_out    OUT nbrjobs.nbrjobs_per_pay_salary%TYPE,
                     p_adj_per_pay_defer_amt_out OUT nbrjobs.nbrjobs_per_pay_defer_amt%TYPE,
                     p_warning_msg_out           OUT gb_common_strings.err_type)

Validates all data in the record.

Parameters
p_val_rec_inout   The record that is created (or updated), validated, and returned by this procedure. If p_operation_type is set to gb_event.CREATE_OPERATION, the record is constru cted, validated, and returned. If p_operation_type is set to gb_event.UPDATE_OPERATION, the current record is passed in, the record is overlaid with updated values, and an updated record is returned.
p_operation_type   Type of operation.
gb_event.CREATE_OPERATION   Validate input for a create.
gb_event.UPDATE_OPERATION   Validate input for an update.

p_pidm   Internal identification number of the employee. NUMBER(8) Required Key
p_posn   Position Number. VARCHAR2(6) Required Key
p_suff   Suffix of the job. VARCHAR2(2) Required Key
p_effective_date   Date that the Job Assignment record becomes effective. DATE Required Key
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   The employee class attached to the job, based on the Employee Class entered on the Position Form (NBAPOSN). VARCHAR2(2) Required
p_pict_code   The 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 this job. VARCHAR2(6) Required
p_sal_table   The Salary Table attached to the job. Defaults from the Salary/Rate Rule Form (NTRSALA) via the Position Form (NBAPOSN). VARCHAR2(2)
p_sal_grade   The Salary Grade attached to the job. Defaults from the Salary/Rate Rule Form (NTRSALA) via the Position Form (NBAPOSN). VARCHAR2(5)
p_sal_step   The 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. 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   The full time percentage attached to the job. Defaults to 1. NUMBER(6,3)
p_hrs_day   The hours attached to the job that are normally worked in a day. NUMBER(6,2) Required
p_hrs_pay   The hours attached to the job that are normally worked in a pay period. NUMBER(6,2) Required
p_shift   The shift attached to the job. VARCHAR2(1) Required
p_reg_rate   The regular rate attached to the job.  If this field is entered or defaulted from the Salary/Rate Rule Form, the Assign Salary is system calculated and vice versa. NUMBER(11,6)
p_assgn_salary   The 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   The number of pays per calendar year. NUMBER(3,1) Required
p_ann_salary   The 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   The Salary Group Code attached to the job. VARCHAR2(6) Required
p_empr_code   The Employer Identification code 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   The 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 Code attached to the job. VARCHAR2(4)
p_jbln_code   Job Location Code 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   The 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 value selected determines how the employee's salary will be reported to STRS administration on the monthly F-496 report. VARCHAR2(2)
p_pers_pay_code   PERS Pay Code for the employee attached to the job. The value selected determines how the employee's salary will be reported to PERS administration on the PERS Monthly Contribution Report. VARCHAR2(2)
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 the structure of 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. Indicates when entry of time in and out information is required. VARCHAR2(1) Required
Y   Yes
N   No

p_lcat_code   A 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_warning_msg_out   Returned warning messages. Warning messages will only be returned if the record is successfully deleted. gb_common_strings.err_type

p_validate_delete 

Procedure p_validate_delete(p_val_rec         IN nb_job_detail.job_detail_rec,
                            p_warning_msg_out OUT gb_common_strings.err_type)

Validates deletion of a record.

Parameters
p_val_rec_inout   The record that is being deleted.
p_warning_msg_out   Returned warning messages. Warning messages will only be returned if the record is successfully deleted. gb_common_strings.err_type