Package nb_job_labor

Package nb_job_labor_rules

NOTE: Please be advised that this API is currently intended to only support internal operations. To ensure data integrity, this api is not supported when called by external applications or interfaces to manipulate data. The recommendation for external applications is to use message level integration to integrate with this entitity in SCT Banner.

Program units

p_register_entity	Registers the attribute value pairs to the message cache.
p_register_entity	Register the attribute/value pairs to the message cache for create and update operations.
p_validate	The p_validate procedure validates all the input parameter fields and builds a valid job labor distribution record.
p_validate_delete	The p_validate procedure validates all the input parameter fields and builds a valid job labor distribution record.

p_register_entity

Procedure p_register_entity(p_operation_type     NUMBER,
                            p_internal_record_id gb_common.internal_record_id_type)

Registers the attribute value pairs to the message cache.

This signature is used for delete operations only and registers the rowid for the row being deleted.

Parameters

p_operation_type

Type of DML operation. NUMBER Required

	gb_event.CREATE_OPERATION	Creates an employee record.
	gb_event.UPDATE_OPERATION	Updates an employee record.

p_internal_record_id

Database ROWID

p_register_entity

Procedure p_register_entity(p_operation_type         NUMBER,
                            p_pidm                   nbrjlbd.nbrjlbd_pidm%TYPE,
                            p_posn                   nbrjlbd.nbrjlbd_posn%TYPE,
                            p_suff                   nbrjlbd.nbrjlbd_suff%TYPE,
                            p_effective_date         nbrjlbd.nbrjlbd_effective_date%TYPE,
                            p_coas_code              nbrjlbd.nbrjlbd_coas_code%TYPE,
                            p_acci_code              nbrjlbd.nbrjlbd_acci_code%TYPE,
                            p_fund_code              nbrjlbd.nbrjlbd_fund_code%TYPE,
                            p_orgn_code              nbrjlbd.nbrjlbd_orgn_code%TYPE,
                            p_acct_code              nbrjlbd.nbrjlbd_acct_code%TYPE,
                            p_prog_code              nbrjlbd.nbrjlbd_prog_code%TYPE,
                            p_actv_code              nbrjlbd.nbrjlbd_actv_code%TYPE,
                            p_locn_code              nbrjlbd.nbrjlbd_locn_code%TYPE,
                            p_proj_code              nbrjlbd.nbrjlbd_proj_code%TYPE,
                            p_ctyp_code              nbrjlbd.nbrjlbd_ctyp_code%TYPE,
                            p_acct_code_external     nbrjlbd.nbrjlbd_acct_code_external%TYPE,
                            p_percent                nbrjlbd.nbrjlbd_percent%TYPE,
                            p_encd_num               nbrjlbd.nbrjlbd_encd_num%TYPE,
                            p_encd_seq_num           nbrjlbd.nbrjlbd_encd_seq_num%TYPE,
                            p_salary_encumbrance     nbrjlbd.nbrjlbd_salary_encumbrance%TYPE,
                            p_salary_enc_to_post     nbrjlbd.nbrjlbd_salary_enc_to_post%TYPE,
                            p_fringe_encumbrance     nbrjlbd.nbrjlbd_fringe_encumbrance%TYPE,
                            p_fringe_enc_to_post     nbrjlbd.nbrjlbd_fringe_enc_to_post%TYPE,
                            p_fund_code_fringe       nbrjlbd.nbrjlbd_fund_code_fringe%TYPE,
                            p_orgn_code_fringe       nbrjlbd.nbrjlbd_orgn_code_fringe%TYPE,
                            p_acct_code_fringe       nbrjlbd.nbrjlbd_acct_code_fringe%TYPE,
                            p_prog_code_fringe       nbrjlbd.nbrjlbd_prog_code_fringe%TYPE,
                            p_actv_code_fringe       nbrjlbd.nbrjlbd_actv_code_fringe%TYPE,
                            p_locn_code_fringe       nbrjlbd.nbrjlbd_locn_code_fringe%TYPE,
                            p_change_ind             nbrjlbd.nbrjlbd_change_ind%TYPE,
                            p_fringe_residual        nbrjlbd.nbrjlbd_fringe_residual%TYPE,
                            p_fringe_res_to_post     nbrjlbd.nbrjlbd_fringe_res_to_post%TYPE,
                            p_user_id                nbrjlbd.nbrjlbd_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin            nbrjlbd.nbrjlbd_data_origin%TYPE,
                            p_future_salary_enc      nbrjlbd.nbrjlbd_future_salary_enc%TYPE,
                            p_future_fringe_enc      nbrjlbd.nbrjlbd_future_fringe_enc%TYPE,
                            p_future_fringe_residual nbrjlbd.nbrjlbd_future_fringe_residual%TYPE,
                            p_future_sal_enc_to_post nbrjlbd.nbrjlbd_future_sal_enc_to_post%TYPE,
                            p_future_frg_enc_to_post nbrjlbd.nbrjlbd_future_frg_enc_to_post%TYPE,
                            p_future_frg_res_to_post nbrjlbd.nbrjlbd_future_frg_res_to_post%TYPE,
                            p_enc_override_end_date  nbrjlbd.nbrjlbd_enc_override_end_date%TYPE,
                            p_enc_last_recast_date   nbrjlbd.nbrjlbd_enc_last_recast_date%TYPE,
                            p_enc_last_calc_date     nbrjlbd.nbrjlbd_enc_last_calc_date%TYPE,
                            p_encd_num_fringe        nbrjlbd.nbrjlbd_encd_num_fringe%TYPE,
                            p_encd_seq_num_fringe    nbrjlbd.nbrjlbd_encd_seq_num_fringe%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

p_posn

Position Number. VARCHAR2(6) Required

p_suff

Suffix of the job. VARCHAR2(2) Required

p_effective_date

Date that the labor distribution record becomes effective. DATE Required

p_coas_code

Valued only if Banner Finance is installed. VARCHAR2(1)

p_acci_code

Valued only if Banner Finance is installed. VARCHAR2(6)

p_fund_code

Valued only if Banner Finance is installed. VARCHAR2(6)

p_orgn_code

Valued only if Banner Finance is installed. VARCHAR2(6)

p_acct_code

Valued only if Banner Finance is installed. VARCHAR2(6)

p_prog_code

Valued only if Banner Finance is installed. VARCHAR2(6)

p_actv_code

Valued only if Banner Finance is installed. VARCHAR2(6)

p_locn_code

Valued only if Banner Finance is installed. VARCHAR2(6)

p_proj_code

Project Code the within Finance Cost Accounting Module. VARCHAR2(8)

p_ctyp_code

Cost Type within the Finance Cost Accounting Module. VARCHAR2(2)

p_acct_code_external

A free form Account Code to allow update of an accounting system other than Banner Finance. VARCHAR2(60)

p_percent

Percent of pay to be applied to this labor distribution. NUMBER(5,2) Required

p_encd_num

The Encumbrance Number used to interface with Banner Finance. VARCHAR2(8)

p_encd_seq_num

The Encumbrance Sequence Number used to interface with Banner Finance. NUMBER(4)

p_salary_encumbrance

Amount of salary encumbered to this labor distribution for the active fiscal year. NUMBER(11,2)

p_salary_enc_to_post

Amount of salary encumbrance that will be posted to the Finance system. NUMBER(11,2) Required

p_fringe_encumbrance

Amount of fringe benefits encumbered to this labor distribution for the active fiscal year. NUMBER(11,2)

p_fringe_enc_to_post

Amount of fringe benefits encumbrance that will be posted to the Finance system. NUMBER(11,2) Required

p_fund_code_fringe

Valued only if Banner Finance is installed. VARCHAR2(6)

p_orgn_code_fringe

Valued only if Banner Finance is installed. VARCHAR2(6)

p_acct_code_fringe

Valued only if Banner Finance is installed. VARCHAR2(6)

p_prog_code_fringe

Valued only if Banner Finance is installed. VARCHAR2(6)

p_actv_code_fringe

Valued only if Banner Finance is installed. VARCHAR2(6)

p_locn_code_fringe

Valued only if Banner Finance is installed. VARCHAR2(6)

p_change_ind

Specifies if the record is active or to be deleted. VARCHAR2(1) Required

	A	Active
	D	Backout (initiated from NBAJOBS LD changes)
	F	Fringe Backout (initiated from NTRFBLD LD changes)
	H	History.

p_fringe_residual

Fringe encumbrance residual amount assigned to this externally funded labor distribution. NUMBER(11,2)

p_fringe_res_to_post

Amount of fringe encumbrance residual to post to this externally funded labor distribution. NUMBER(11,2)

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_future_salary_enc

Amount of salary encumbered to a labor distribution for future fiscal years. NUMBER(17,2)

p_future_fringe_enc

Amount of fringe benefits encumbered to a labor distribution for future fiscal years. NUMBER(17,2)

p_future_fringe_residual

Amount of fringe encumbrance residual assigned to a labor distribution for future fiscal years. NUMBER(17,2)

p_future_sal_enc_to_post

Amount of future salary encumbrance that will be posted to finance system for specified labor distribution. NUMBER(17,2)

p_future_frg_enc_to_post

Amount of future fringe benefit encumbrance that will be posted to finance system for specified labor distribution. NUMBER(17,2)

p_future_frg_res_to_post

Amount of future fringe encumbrance residual that will be posted to finance system for specified externally funded labor distribution. NUMBER(17,2)

p_enc_override_end_date

The end date used to calculate future fiscal year encumbrances for a labor distribution. DATE

p_enc_last_recast_date

The Recast date of the last run of NBPENCM. DATE

p_enc_last_calc_date

The Capture Date of the last NBPENCM run. DATE

p_encd_num_fringe

The Fringe Encumbrance Number used to interface with Banner Finance. VARCHAR2(8)

p_encd_seq_num_fringe

The Fringe Encumbrance Sequence Number used to interface with Banner Finance. NUMBER(4)

p_internal_record_id

Database ROWID VARCHAR2(18) required

p_validate

Procedure p_validate(p_val_rec_inout          IN OUT nb_job_labor.job_labor_rec,
                     p_operation_type         VARCHAR2,
                     p_pidm                   nbrjlbd.nbrjlbd_pidm%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_posn                   nbrjlbd.nbrjlbd_posn%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_suff                   nbrjlbd.nbrjlbd_suff%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_effective_date         nbrjlbd.nbrjlbd_effective_date%TYPE DEFAULT dml_common.f_unspecified_date,
                     p_acci_code              nbrjlbd.nbrjlbd_acci_code%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_fund_code              nbrjlbd.nbrjlbd_fund_code%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_orgn_code              nbrjlbd.nbrjlbd_orgn_code%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_acct_code              nbrjlbd.nbrjlbd_acct_code%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_prog_code              nbrjlbd.nbrjlbd_prog_code%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_actv_code              nbrjlbd.nbrjlbd_actv_code%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_locn_code              nbrjlbd.nbrjlbd_locn_code%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_proj_code              nbrjlbd.nbrjlbd_proj_code%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_ctyp_code              nbrjlbd.nbrjlbd_ctyp_code%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_acct_code_external     nbrjlbd.nbrjlbd_acct_code_external%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_percent                nbrjlbd.nbrjlbd_percent%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_encd_num               nbrjlbd.nbrjlbd_encd_num%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_encd_seq_num           nbrjlbd.nbrjlbd_encd_seq_num%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_salary_encumbrance     nbrjlbd.nbrjlbd_salary_encumbrance%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_salary_enc_to_post     nbrjlbd.nbrjlbd_salary_enc_to_post%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_fringe_encumbrance     nbrjlbd.nbrjlbd_fringe_encumbrance%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_fringe_enc_to_post     nbrjlbd.nbrjlbd_fringe_enc_to_post%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_fund_code_fringe       nbrjlbd.nbrjlbd_fund_code_fringe%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_orgn_code_fringe       nbrjlbd.nbrjlbd_orgn_code_fringe%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_acct_code_fringe       nbrjlbd.nbrjlbd_acct_code_fringe%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_prog_code_fringe       nbrjlbd.nbrjlbd_prog_code_fringe%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_actv_code_fringe       nbrjlbd.nbrjlbd_actv_code_fringe%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_locn_code_fringe       nbrjlbd.nbrjlbd_locn_code_fringe%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_change_ind             nbrjlbd.nbrjlbd_change_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_fringe_residual        nbrjlbd.nbrjlbd_fringe_residual%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_fringe_res_to_post     nbrjlbd.nbrjlbd_fringe_res_to_post%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_user_id                nbrjlbd.nbrjlbd_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_data_origin            nbrjlbd.nbrjlbd_data_origin%TYPE DEFAULT NULL,
                     p_future_salary_enc      nbrjlbd.nbrjlbd_future_salary_enc%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_future_fringe_enc      nbrjlbd.nbrjlbd_future_fringe_enc%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_future_fringe_residual nbrjlbd.nbrjlbd_future_fringe_residual%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_future_sal_enc_to_post nbrjlbd.nbrjlbd_future_sal_enc_to_post%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_future_frg_enc_to_post nbrjlbd.nbrjlbd_future_frg_enc_to_post%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_future_frg_res_to_post nbrjlbd.nbrjlbd_future_frg_res_to_post%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_enc_override_end_date  nbrjlbd.nbrjlbd_enc_override_end_date%TYPE DEFAULT dml_common.f_unspecified_date,
                     p_enc_last_recast_date   nbrjlbd.nbrjlbd_enc_last_recast_date%TYPE DEFAULT dml_common.f_unspecified_date,
                     p_enc_last_calc_date     nbrjlbd.nbrjlbd_enc_last_calc_date%TYPE DEFAULT dml_common.f_unspecified_date,
                     p_encd_num_fringe        nbrjlbd.nbrjlbd_encd_num_fringe%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_encd_seq_num_fringe    nbrjlbd.nbrjlbd_encd_seq_num_fringe%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_warnings_out           OUT gb_common_strings.err_type)

The p_validate procedure validates all the input parameter fields and builds a valid job labor distribution record.
The following edits are performed. All failed edit messages are appended This will be used for Create and Update operations.

Parameters

p_pidm

Internal identification Number of the employee. NUMBER(8) Required

p_posn

Position Number. VARCHAR2(6) Required

p_suff

Suffix of the job. VARCHAR2(2) Required

p_effective_date

Date that the labor distribution record becomes effective. DATE Required

p_coas_code

Valued only if Banner Finance is installed. VARCHAR2(1)

p_acci_code

Valued only if Banner Finance is installed. VARCHAR2(6)

p_fund_code

Valued only if Banner Finance is installed. VARCHAR2(6)

p_orgn_code

Valued only if Banner Finance is installed. VARCHAR2(6)

p_acct_code

Valued only if Banner Finance is installed. VARCHAR2(6)

p_prog_code

Valued only if Banner Finance is installed. VARCHAR2(6)

p_actv_code

Valued only if Banner Finance is installed. VARCHAR2(6)

p_locn_code

Valued only if Banner Finance is installed. VARCHAR2(6)

p_proj_code

Project Code within the Finance Cost Accounting Module. VARCHAR2(8)

p_ctyp_code

Cost Type within the Finance Cost Accounting Module. VARCHAR2(2)

p_acct_code_external

A free form Account Code to allow update of an accounting system other than Banner Finance. VARCHAR2(60)

p_percent

Percent of pay to be applied to this labor distribution. NUMBER(5,2) Required

p_encd_num

The Encumbrance Number used to interface with Banner Finance. VARCHAR2(8)

p_encd_seq_num

The Encumbrance Sequence Number used to interface with Banner Finance. NUMBER(4)

p_salary_encumbrance

Amount of salary encumbered to this labor distribution for the active fiscal year. NUMBER(11,2)

p_salary_enc_to_post

Amount of salary encumbrance that will be posted to the Finance system. NUMBER(11,2) Required

p_fringe_encumbrance

Amount of fringe benefits encumbered to this labor distribution for the active fiscal year. NUMBER(11,2)

p_fringe_enc_to_post

Amount of fringe benefits encumbrance that will be posted to the Finance system. NUMBER(11,2) Required

p_fund_code_fringe

Valued only if Banner Finance is installed. VARCHAR2(6)

p_orgn_code_fringe

Valued only if Banner Finance is installed. VARCHAR2(6)

p_acct_code_fringe

Valued only if Banner Finance is installed. VARCHAR2(6)

p_prog_code_fringe

Valued only if Banner Finance is installed. VARCHAR2(6)

p_actv_code_fringe

Valued only if Banner Finance is installed. VARCHAR2(6)

p_locn_code_fringe

Valued only if Banner Finance is installed. VARCHAR2(6)

p_change_ind

Specifies if the record is active or to be deleted. VARCHAR2(1) Required

	A	Active
	D	Backout (initiated from NBAJOBS LD changes)
	F	Fringe Backout (initiated from NTRFBLD LD changes)
	H	History.

p_fringe_residual

Fringe encumbrance residual amount assigned to this externally funded labor distribution. NUMBER(11,2)

p_fringe_res_to_post

Amount of fringe encumbrance residual to post to this externally funded labor distribution. NUMBER(11,2)

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_future_salary_enc

Amount of salary encumbered to a labor distribution for future fiscal years. NUMBER(17,2)

p_future_fringe_enc

Amount of fringe benefits encumbered to a labor distribution for future fiscal years. NUMBER(17,2)

p_future_fringe_residual

Amount of fringe encumbrance residual assigned to a labor distribution for future fiscal years. NUMBER(17,2)

p_future_sal_enc_to_post

Amount of future salary encumbrance that will be posted to finance system for specified labor distribution. NUMBER(17,2)

p_future_frg_enc_to_post

Amount of future fringe benefit encumbrance that will be posted to finance system for specified labor distribution. NUMBER(17,2)

p_future_frg_res_to_post

Amount of future fringe encumbrance residual that will be posted to finance system for specified externally funded labor distribution. NUMBER(17,2)

p_enc_override_end_date

The end date used to calculate future fiscal year encumbrances for a labor distribution. DATE

p_enc_last_recast_date

The Recast date of the last run of NBPENCM. DATE

p_enc_last_calc_date

The Capture Date of the last NBPENCM run. DATE

p_encd_num_fringe

The Fringe Encumbrance Number used to interface with Banner Finance. VARCHAR2(8)

p_encd_seq_num_fringe

The Fringe Encumbrance Sequence Number used to interface with Banner Finance. NUMBER(4)

p_validate_delete

Procedure p_validate_delete(p_pidm           nbrjlbd.nbrjlbd_pidm%TYPE,
                            p_posn           nbrjlbd.nbrjlbd_posn%TYPE,
                            p_suff           nbrjlbd.nbrjlbd_suff%TYPE,
                            p_effective_date nbrjlbd.nbrjlbd_effective_date%TYPE)

Parameters

	p_pidm	Internal identification Number of the employee. NUMBER(8) Required
	p_posn	Position Number. VARCHAR2(6) Required
	p_suff	Suffix of the job. VARCHAR2(2) Required
	p_effective_date	Date that the labor distribution record becomes effective. DATE Required