Package np_job

Package np_job_labor

This business process control API package provides the common business interface for processing Job Labor Distribution set.

The Job Labor BPI establishes information about the labor distribution assigned to a job. Employee job information must exist for a person when job labor is created.

When job labor is created, updated or deleted, the BPI also creates history records.
It backs out the records during update and delete operations and finally checks for the percent in the job labor set to make sure that it is equal to 100.

HR application security is invoked when performing query, create, delete, and update operations.

To query, create, delete, or update data, you must have access to the employee class, the employee home organization, the employee's jobs 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 labor data will result in no data being found. Consequently, the data cannot be created, deleted or updated.

Program units

f_exists	Checks if a record exists.
f_isequal	Compares two records for equality.
f_query_all	Selects all records for the entity.
f_query_by_date	Selects all records for the entity as of query date.
f_query_one	Selects one record using key.
f_query_by_rowid	Selects one record using ROWID.
f_query_one_lock	Selects one record and locks it.
f_query_last_effective_date	The f_query_last_effective_date function returns the recent job labor distribution effective date.
p_lock
p_create	Creates job labor record set.
p_create	Creates job labor record set.
p_delete	Deletes all the records using the key.
p_update	Creates, updates and deletes records using the ROWID element in each record in the set.
p_update	Creates, updates and deletes records using the ROWID element in each record in the set.
p_copy_forward	Creates a new job labor distribution set.
p_get_plbd_table	Returns the default job labor distribution set in a PL/SQL table.
f_unspecified_labor_table	Returns a null job labor distribution PL/SQL table.

Types

job_labor_rec	Business Entity record type.
job_labor_enc_rec	Business Entity record type.
job_labor_ref	Entity cursor variable type.
job_labor_enc_ref	Entity cursor variable type.
job_labor_tab	Entity table type.
job_labor_enc_tab	Entity table type.
nbrplbd_tabtype	A PL/SQL table type to return default job labor distribution.

job_labor_rec

TYPE job_labor_rec IS RECORD (
  r_pidm                    nbrjlbd.nbrjlbd_pidm%TYPE,
  r_posn                    nbrjlbd.nbrjlbd_posn%TYPE,
  r_suff                    nbrjlbd.nbrjlbd_suff%TYPE,
  r_effective_date          nbrjlbd.nbrjlbd_effective_date%TYPE,
  r_coas_code               nbrjlbd.nbrjlbd_coas_code%TYPE,
  r_acci_code               nbrjlbd.nbrjlbd_acci_code%TYPE,
  r_fund_code               nbrjlbd.nbrjlbd_fund_code%TYPE,
  r_orgn_code               nbrjlbd.nbrjlbd_orgn_code%TYPE,
  r_acct_code               nbrjlbd.nbrjlbd_acct_code%TYPE,
  r_prog_code               nbrjlbd.nbrjlbd_prog_code%TYPE,
  r_actv_code               nbrjlbd.nbrjlbd_actv_code%TYPE,
  r_locn_code               nbrjlbd.nbrjlbd_locn_code%TYPE,
  r_proj_code               nbrjlbd.nbrjlbd_proj_code%TYPE,
  r_ctyp_code               nbrjlbd.nbrjlbd_ctyp_code%TYPE,
  r_acct_code_external      nbrjlbd.nbrjlbd_acct_code_external%TYPE,
  r_percent                 nbrjlbd.nbrjlbd_percent%TYPE,
  r_encd_num                nbrjlbd.nbrjlbd_encd_num%TYPE,
  r_encd_seq_num            nbrjlbd.nbrjlbd_encd_seq_num%TYPE,
  r_salary_encumbrance      nbrjlbd.nbrjlbd_salary_encumbrance%TYPE,
  r_salary_enc_to_post      nbrjlbd.nbrjlbd_salary_enc_to_post%TYPE,
  r_fringe_encumbrance      nbrjlbd.nbrjlbd_fringe_encumbrance%TYPE,
  r_fringe_enc_to_post      nbrjlbd.nbrjlbd_fringe_enc_to_post%TYPE,
  r_fund_code_fringe        nbrjlbd.nbrjlbd_fund_code_fringe%TYPE,
  r_orgn_code_fringe        nbrjlbd.nbrjlbd_orgn_code_fringe%TYPE,
  r_acct_code_fringe        nbrjlbd.nbrjlbd_acct_code_fringe%TYPE,
  r_prog_code_fringe        nbrjlbd.nbrjlbd_prog_code_fringe%TYPE,
  r_actv_code_fringe        nbrjlbd.nbrjlbd_actv_code_fringe%TYPE,
  r_locn_code_fringe        nbrjlbd.nbrjlbd_locn_code_fringe%TYPE,
  r_change_ind              nbrjlbd.nbrjlbd_change_ind%TYPE,
  r_fringe_residual         nbrjlbd.nbrjlbd_fringe_residual%TYPE,
  r_fringe_res_to_post      nbrjlbd.nbrjlbd_fringe_res_to_post%TYPE,
  r_user_id                 nbrjlbd.nbrjlbd_user_id%TYPE,
  r_data_origin             nbrjlbd.nbrjlbd_data_origin%TYPE,
  r_seq_no                  nbrjlhs.nbrjlhs_seq_no%TYPE,
  r_future_salary_enc       nbrjlbd.nbrjlbd_future_salary_enc%TYPE,
  r_future_fringe_enc       nbrjlbd.nbrjlbd_future_fringe_enc%TYPE,
  r_future_fringe_residual  nbrjlbd.nbrjlbd_future_fringe_residual%TYPE,
  r_future_sal_enc_to_post  nbrjlbd.nbrjlbd_future_sal_enc_to_post%TYPE,
  r_future_frg_enc_to_post  nbrjlbd.nbrjlbd_future_frg_enc_to_post%TYPE,
  r_future_frg_res_to_post  nbrjlbd.nbrjlbd_future_frg_res_to_post%TYPE,
  r_enc_override_end_date   nbrjlbd.nbrjlbd_enc_override_end_date%TYPE,
  r_enc_last_recast_date    nbrjlbd.nbrjlbd_enc_last_recast_date%TYPE,
  r_enc_last_calc_date      nbrjlbd.nbrjlbd_enc_last_calc_date%TYPE,
  r_job_end_date            nbrjlhs.nbrjlhs_job_end_date%TYPE,
  r_contract_begin_date     nbrjlhs.nbrjlhs_contract_begin_date%TYPE,
  r_contract_end_date       nbrjlhs.nbrjlhs_contract_end_date%TYPE,
  r_grnt_bud_end_date       nbrjlhs.nbrjlhs_grnt_bud_end_date%TYPE,
  r_fund_term_date          nbrjlhs.nbrjlhs_fund_term_date%TYPE,
  r_encd_num_fringe         nbrjlbd.nbrjlbd_encd_num_fringe%TYPE,
  r_encd_seq_num_fringe     nbrjlbd.nbrjlbd_encd_seq_num_fringe%TYPE,
  r_internal_record_id      gb_common.internal_record_id_type);

Business Entity record type.

job_labor_enc_rec

TYPE job_labor_enc_rec IS RECORD (
  r_pidm                    nbrjlbd.nbrjlbd_pidm%TYPE,
  r_posn                    nbrjlbd.nbrjlbd_posn%TYPE,
  r_suff                    nbrjlbd.nbrjlbd_suff%TYPE,
  r_effective_date          nbrjlbd.nbrjlbd_effective_date%TYPE,
  r_coas_code               nbrjlbd.nbrjlbd_coas_code%TYPE,
  r_acci_code               nbrjlbd.nbrjlbd_acci_code%TYPE,
  r_fund_code               nbrjlbd.nbrjlbd_fund_code%TYPE,
  r_orgn_code               nbrjlbd.nbrjlbd_orgn_code%TYPE,
  r_acct_code               nbrjlbd.nbrjlbd_acct_code%TYPE,
  r_prog_code               nbrjlbd.nbrjlbd_prog_code%TYPE,
  r_actv_code               nbrjlbd.nbrjlbd_actv_code%TYPE,
  r_locn_code               nbrjlbd.nbrjlbd_locn_code%TYPE,
  r_proj_code               nbrjlbd.nbrjlbd_proj_code%TYPE,
  r_ctyp_code               nbrjlbd.nbrjlbd_ctyp_code%TYPE,
  r_acct_code_external      nbrjlbd.nbrjlbd_acct_code_external%TYPE,
  r_percent                 nbrjlbd.nbrjlbd_percent%TYPE,
  r_encd_num                nbrjlbd.nbrjlbd_encd_num%TYPE,
  r_encd_seq_num            nbrjlbd.nbrjlbd_encd_seq_num%TYPE,
  r_salary_encumbrance      nbrjlbd.nbrjlbd_salary_encumbrance%TYPE,
  r_salary_enc_to_post      nbrjlbd.nbrjlbd_salary_enc_to_post%TYPE,
  r_fringe_encumbrance      nbrjlbd.nbrjlbd_fringe_encumbrance%TYPE,
  r_fringe_enc_to_post      nbrjlbd.nbrjlbd_fringe_enc_to_post%TYPE,
  r_fund_code_fringe        nbrjlbd.nbrjlbd_fund_code_fringe%TYPE,
  r_orgn_code_fringe        nbrjlbd.nbrjlbd_orgn_code_fringe%TYPE,
  r_acct_code_fringe        nbrjlbd.nbrjlbd_acct_code_fringe%TYPE,
  r_prog_code_fringe        nbrjlbd.nbrjlbd_prog_code_fringe%TYPE,
  r_actv_code_fringe        nbrjlbd.nbrjlbd_actv_code_fringe%TYPE,
  r_locn_code_fringe        nbrjlbd.nbrjlbd_locn_code_fringe%TYPE,
  r_change_ind              nbrjlbd.nbrjlbd_change_ind%TYPE,
  r_fringe_residual         nbrjlbd.nbrjlbd_fringe_residual%TYPE,
  r_fringe_res_to_post      nbrjlbd.nbrjlbd_fringe_res_to_post%TYPE,
  r_user_id                 nbrjlbd.nbrjlbd_user_id%TYPE,
  r_data_origin             nbrjlbd.nbrjlbd_data_origin%TYPE,
  r_seq_no                  nbrjlhs.nbrjlhs_seq_no%TYPE,
  r_future_salary_enc       nbrjlbd.nbrjlbd_future_salary_enc%TYPE,
  r_future_fringe_enc       nbrjlbd.nbrjlbd_future_fringe_enc%TYPE,
  r_future_fringe_residual  nbrjlbd.nbrjlbd_future_fringe_residual%TYPE,
  r_future_sal_enc_to_post  nbrjlbd.nbrjlbd_future_sal_enc_to_post%TYPE,
  r_future_frg_enc_to_post  nbrjlbd.nbrjlbd_future_frg_enc_to_post%TYPE,
  r_future_frg_res_to_post  nbrjlbd.nbrjlbd_future_frg_res_to_post%TYPE,
  r_enc_override_end_date   nbrjlbd.nbrjlbd_enc_override_end_date%TYPE,
  r_enc_last_recast_date    nbrjlbd.nbrjlbd_enc_last_recast_date%TYPE,
  r_enc_last_calc_date      nbrjlbd.nbrjlbd_enc_last_calc_date%TYPE,
  r_job_end_date            nbrjlhs.nbrjlhs_job_end_date%TYPE,
  r_contract_begin_date     nbrjlhs.nbrjlhs_contract_begin_date%TYPE,
  r_contract_end_date       nbrjlhs.nbrjlhs_contract_end_date%TYPE,
  r_grnt_bud_end_date       nbrjlhs.nbrjlhs_grnt_bud_end_date%TYPE,
  r_fund_term_date          nbrjlhs.nbrjlhs_fund_term_date%TYPE,
  r_job_labor_encumb_tab    nb_job_enc_history.job_enc_history_tab,
  r_encd_num_fringe         nbrjlbd.nbrjlbd_encd_num_fringe%TYPE,
  r_encd_seq_num_fringe     nbrjlbd.nbrjlbd_encd_seq_num_fringe%TYPE,
  r_internal_record_id      gb_common.internal_record_id_type);

Business Entity record type.

job_labor_ref

TYPE job_labor_ref IS REF CURSOR RETURN job_labor_rec;

Entity cursor variable type.

job_labor_enc_ref

TYPE job_labor_enc_ref IS REF CURSOR RETURN job_labor_enc_rec;

Entity cursor variable type.

job_labor_tab

TYPE job_labor_tab IS TABLE OF job_labor_rec INDEX BY BINARY_INTEGER;

Entity table type.

job_labor_enc_tab

TYPE job_labor_enc_tab IS TABLE OF job_labor_enc_rec INDEX BY BINARY_INTEGER;

Entity table type.

nbrplbd_tabtype

TYPE nbrplbd_tabtype IS TABLE OF nbrplbd%ROWTYPE
                        INDEX BY BINARY_INTEGER;

A PL/SQL table type to return default job labor distribution.

f_exists

Function f_exists(p_rowid gb_common.internal_record_id_type)
  RETURN VARCHAR2

Checks if a record exists.

Parameters

p_rowid

Database ROWID of the record to be selected. VARCHAR2(18)

Returns

Y if found, otherwise N.

f_isequal

Function f_isequal(rec_one nb_job_labor.job_labor_rec,
                   rec_two nb_job_labor.job_labor_rec) RETURN VARCHAR2

Compares two records for equality.
Tests each field of rec_one against the corresponding field of rec_two. Two null values are considered equal.

Parameters

	rec_one	The first record to compare. Type job_labor_rec Required
	rec_two	The second record to compare. Type job_labor_rec Required

Returns

Y if all values in records are equal, otherwise N. Nulls match Nulls.

f_query_all

Function f_query_all(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 default null,
                     p_change_ind     nbrjlbd.nbrjlbd_change_ind%TYPE default null)
  RETURN nb_job_labor.job_labor_ref

Selects all records for the entity.

Parameters

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

Returns

A cursor variable that will fetch a set of records.

f_query_by_date

Function f_query_by_date(p_pidm       nbrjlbd.nbrjlbd_pidm%TYPE,
                         p_posn       nbrjlbd.nbrjlbd_posn%TYPE,
                         p_suff       nbrjlbd.nbrjlbd_suff%TYPE,
                         p_query_date nbrjlbd.nbrjlbd_effective_date%TYPE default null,
                         p_change_ind nbrjlbd.nbrjlbd_change_ind%TYPE default null)
  RETURN nb_job_labor.job_labor_ref

Selects all records for the entity as of query date.

Parameters

	p_pidm	Internal Identification Number of the employee. NUMBER(8) Required
	p_posn	Position to which a job is attached. VARCHAR2(6) Required
	p_suff	Unique identifier that helps create and maintain multiple jobs for the same position, for the same employee. VARCHAR2(2) Required
	p_query_date	Date that the labor distribution record becomes effective. DATE Required

Returns

A cursor variable that will fetch a set of records.

f_query_one

Function f_query_one(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,
                     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)
  RETURN nb_job_labor.job_labor_ref

Selects one record using key.

Parameters

p_pidm

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

p_posn

Position to which a job is attached. VARCHAR2(6) Required

p_suff

Unique identifier that helps create and maintain multiple jobs for the same position, for the same employee. 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)

Returns

A cursor variable that will fetch exactly one record.

f_query_by_rowid

Function f_query_by_rowid(p_rowid gb_common.internal_record_id_type)
  RETURN nb_job_labor.job_labor_ref

Selects one record using ROWID.

Parameters

p_rowid

Database ROWID of the record to be selected. VARCHAR2(18) Required

Returns

A cursor variable that will fetch exactly one record.

f_query_one_lock

Function f_query_one_lock(p_rowid gb_common.internal_record_id_type)
  RETURN nb_job_labor.job_labor_ref

Selects one record and locks it.

Parameters

p_rowid

Database ROWID of the record to be selected. VARCHAR2(18)

Returns

A cursor variable for one record, locking the record.

f_query_last_effective_date

Function f_query_last_effective_date(p_pidm NBRJLBD.NBRJLBD_PIDM%TYPE,
                                     p_posn NBRJLBD.NBRJLBD_POSN%TYPE,
                                     p_suff NBRJLBD.NBRJLBD_SUFF%TYPE)
  RETURN DATE

The f_query_last_effective_date function returns the recent job labor distribution effective date.

Parameters

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

p_lock

Procedure p_lock(p_rowid_inout IN OUT gb_common.internal_record_id_type)

p_create

Procedure p_create(p_job_labor_tab IN OUT np_job_labor.job_labor_tab,
                   p_change_reason varchar2 default null,
                   p_warnings_out  OUT gb_common_strings.err_type)

Creates job labor record set.
Creates the history records.
Checks for the percent in the job labor set to make sure that it is equal to 100.

Parameters

p_job_labor_tab

A PL/SQL table to accept the job labor set. This table also returns the records that are created. Each record in the set consists of the following elements.

	p_pidm	Internal identification number of the employee. NUMBER(8) Required
	p_posn	Position to which a job is attached. VARCHAR2(6) Required
	p_suff	Unique identifier that helps create and maintain multiple
	jobs	for the same position, for the same employee. 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_rowid_out	Database ROWID of the record to be created. VARCHAR2(18) Required

p_change_reason

Reason for changing the labor distribution VARCHAR2(60).

p_default_labor_ind

A Default labor Indicator VARCHAR2(60).

p_warnings_out

Warnings from the validation VARCHAR2(4000) Required

p_create

Procedure p_create(p_job_labor_tab IN OUT np_job_labor.job_labor_enc_tab,
                   p_change_reason varchar2 default null,
                   p_warnings_out  OUT gb_common_strings.err_type)

Creates job labor record set.
Creates the history records.
Checks for the percent in the job labor set to make sure that it is equal to 100.

Parameters

p_job_labor_tab

A PL/SQL table to accept the job labor set. This table also returns the records that are created. Each record in the set consists of the following elements.

	p_pidm	Internal identification number of the employee. NUMBER(8) Required
	p_posn	Position to which a job is attached. VARCHAR2(6) Required
	p_suff	Unique identifier that helps create and maintain multiple
	jobs	for the same position, for the same employee. 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_rowid_out	Database ROWID of the record to be created. VARCHAR2(18) Required

p_change_reason

Reason for changing the labor distribution VARCHAR2(60).

p_default_labor_ind

A Default labor Indicator VARCHAR2(60).

p_warnings_out

Warnings from the validation VARCHAR2(4000) Required

p_delete

Procedure p_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,
                   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_warnings_out   OUT gb_common_strings.err_type)

Deletes all the records using the key.
Creates the history records.
It creates backout records.

Parameters

p_pidm

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

	p_posn	Position to which a job is attached. VARCHAR2(6) Required
	p_suff	Unique identifier that helps create and maintain multiple
	jobs	for the same position, for the same employee. VARCHAR2(2) Required

p_effective_date

Date that the labor distribution record becomes effective. DATE 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_change_reason

Reason for changing the labor distribution VARCHAR2(60).

p_warnings_out

Warnings from the validation VARCHAR2(4000) Required

p_update

Procedure p_update(p_job_labor_tab IN OUT np_job_labor.job_labor_tab,
                   p_change_reason varchar2 default null,
                   p_warnings_out  OUT gb_common_strings.err_type)

Creates, updates and deletes records using the ROWID element in each record in the set.
If the ROWID exits in the record set, then the record will be updated.
If the ROWID does not exist, then the record will be created.
If the ROWIDs in the database table are not present in the PL/SQL table, then those records will be deleted.
Creates history records.
It creates backout records.
Checks for the percent in the job labor set to make sure that it is equal to 100.

Parameters

p_job_labor_tab

A PL/SQL table to accept job labor set. This table also returns records that are created. Each record in the set consists of the following elements.

	p_pidm	Internal identification number of the employee. NUMBER(8) Required
	p_posn	Position to which a job is attached. VARCHAR2(6) Required
	p_suff	Unique identifier that helps create and maintain multiple
	jobs	for the same position, for the same employee. 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_rowid_out	Database ROWID of the record to be created. VARCHAR2(18) Required

p_change_reason

Reason for changing the labor distribution VARCHAR2(60).

p_warnings_out

Warnings from the validation VARCHAR2(4000) Required

p_update

Procedure p_update(p_job_labor_tab IN OUT np_job_labor.job_labor_enc_tab,
                   p_change_reason varchar2 default null,
                   p_warnings_out  OUT gb_common_strings.err_type)

Parameters

p_job_labor_tab

A PL/SQL table to accept job labor set. This table also returns records that are created. Each record in the set consists of the following elements.

	p_pidm	Internal identification number of the employee. NUMBER(8) Required
	p_posn	Position to which a job is attached. VARCHAR2(6) Required
	p_suff	Unique identifier that helps create and maintain multiple
	jobs	for the same position, for the same employee. 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_rowid_out	Database ROWID of the record to be created. VARCHAR2(18) Required

p_change_reason

Reason for changing the labor distribution VARCHAR2(60).

p_warnings_out

Warnings from the validation VARCHAR2(4000) Required

p_copy_forward

Procedure p_copy_forward(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_user_id        nbrjlbd.nbrjlbd_user_id%TYPE DEFAULT gb_common.f_sct_user,
                         p_data_origin    nbrjlbd.nbrjlbd_data_origin%TYPE DEFAULT NULL,
                         p_change_reason  varchar2 default null,
                         p_warnings_out   OUT gb_common_strings.err_type)

Creates a new job labor distribution set.
Creates the history records.
Checks for the percent in the job labor set to make sure that it is equal to 100.

Parameters

	p_pidm	Internal identification number of the employee. NUMBER(8) Required
	p_posn	Position to which a job is attached. VARCHAR2(6) Required
	p_suff	Unique identifier that helps create and maintain multiple jobs for the same position, for the same employee. VARCHAR2(2) Required
	p_effective_date	Date that the labor distribution record becomes effective. DATE Required
	p_change_reason	Reason for changing the labor distribution VARCHAR2(60).
	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_warnings_out	Warnings from the validation VARCHAR2(4000) Required

p_get_plbd_table

Procedure p_get_plbd_table(p_posn              IN nbrplbd.nbrplbd_posn%TYPE,
                           p_current_fisc_code IN nbbfisc.nbbfisc_code%TYPE,
                           p_jobs_fisc_code    IN nbbfisc.nbbfisc_code%TYPE,
                           p_ptot_status       IN nbrptot.nbrptot_status%TYPE,
                           p_nbrplbd_table_out OUT nbrplbd_tabtype,
                           p_warning_msg_out   OUT gb_common_strings.err_type,
                           p_error_msg_out     OUT gb_common_strings.err_type)

Returns the default job labor distribution set in a PL/SQL table.

Parameters

	p_posn	Position to which a job is attached. VARCHAR2(6) Required
	p_current_fisc_code	The BANNER HR system defined fiscal year. VARCHAR2(4) Required
	p_jobs_fisc_code	Job Fiscal Code. VARCHAR2(4) Required
	p_ptot_status	Position Total Status. VARCHAR2(1) Required
	p_nbrplbd_table_out	Reason for changing the Labor Distribution VARCHAR2(60).
	p_warning_msg_out	Warnings from the validation VARCHAR2(4000) Required
	p_error_msg_out	Errors from the validation VARCHAR2(4000) Required

f_unspecified_labor_table

Function f_unspecified_labor_table RETURN np_job_labor.job_labor_tab

Returns a null job labor distribution PL/SQL table.