index

Package nb_job_detail

This package provides the common business interface for Job Detail (NB_JOB_DETAIL).
 

The Job Detail API establishes date effective detail information about employee's job assignment.

Before creating Job Detail information, Job Base data must be created in Banner.

Program units
f_api_version   Returns the API version number.
f_exists   Checks to see 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 the current record as of the given effective date.
f_query_by_rowid   Selects one record using ROWID.
f_query_next   Selects the next record relative to the specified effective date.
f_query_one   Selects one record using key.
f_query_one_lock   Selects one record and locks it.
p_create   Creates a record.
p_delete   Deletes a record.
p_lock   Locks a record.
p_update   Updates a record.

Types
job_detail_rec   Business Entity record type
job_detail_ref   Entity cursor variable type
job_detail_tab   Entity table type

Constants
M_ENTITY_NAME   Business Entity Name
M_BASE_TABLE_NAME   Base table name

M_ENTITY_NAME 

M_ENTITY_NAME    CONSTANT VARCHAR2(10) := 'JOB_DETAIL';

Business Entity Name

M_BASE_TABLE_NAME 

M_BASE_TABLE_NAME    CONSTANT VARCHAR2(7) := 'NBRJOBS';

Base table name

job_detail_rec 

TYPE job_detail_rec IS RECORD (
  r_pidm                    nbrjobs.nbrjobs_pidm%TYPE,
  r_posn                    nbrjobs.nbrjobs_posn%TYPE,
  r_suff                    nbrjobs.nbrjobs_suff%TYPE,
  r_effective_date          nbrjobs.nbrjobs_effective_date%TYPE,
  r_status                  nbrjobs.nbrjobs_status%TYPE,
  r_desc                    nbrjobs.nbrjobs_desc%TYPE,
  r_ecls_code               nbrjobs.nbrjobs_ecls_code%TYPE,
  r_pict_code               nbrjobs.nbrjobs_pict_code%TYPE,
  r_coas_code_ts            nbrjobs.nbrjobs_coas_code_ts%TYPE,
  r_orgn_code_ts            nbrjobs.nbrjobs_orgn_code_ts%TYPE,
  r_sal_table               nbrjobs.nbrjobs_sal_table%TYPE,
  r_sal_grade               nbrjobs.nbrjobs_sal_grade%TYPE,
  r_sal_step                nbrjobs.nbrjobs_sal_step%TYPE,
  r_appt_pct                nbrjobs.nbrjobs_appt_pct%TYPE,
  r_fte                     nbrjobs.nbrjobs_fte%TYPE,
  r_hrs_day                 nbrjobs.nbrjobs_hrs_day%TYPE,
  r_hrs_pay                 nbrjobs.nbrjobs_hrs_pay%TYPE,
  r_shift                   nbrjobs.nbrjobs_shift%TYPE,
  r_reg_rate                nbrjobs.nbrjobs_reg_rate%TYPE,
  r_assgn_salary            nbrjobs.nbrjobs_assgn_salary%TYPE,
  r_factor                  nbrjobs.nbrjobs_factor%TYPE,
  r_ann_salary              nbrjobs.nbrjobs_ann_salary%TYPE,
  r_per_pay_salary          nbrjobs.nbrjobs_per_pay_salary%TYPE,
  r_pays                    nbrjobs.nbrjobs_pays%TYPE,
  r_per_pay_defer_amt       nbrjobs.nbrjobs_per_pay_defer_amt%TYPE,
  r_jcre_code               nbrjobs.nbrjobs_jcre_code%TYPE,
  r_sgrp_code               nbrjobs.nbrjobs_sgrp_code%TYPE,
  r_empr_code               nbrjobs.nbrjobs_empr_code%TYPE,
  r_lgcd_code               nbrjobs.nbrjobs_lgcd_code%TYPE,
  r_locn_code               nbrjobs.nbrjobs_locn_code%TYPE,
  r_schl_code               nbrjobs.nbrjobs_schl_code%TYPE,
  r_supervisor_pidm         nbrjobs.nbrjobs_supervisor_pidm%TYPE,
  r_supervisor_posn         nbrjobs.nbrjobs_supervisor_posn%TYPE,
  r_supervisor_suff         nbrjobs.nbrjobs_supervisor_suff%TYPE,
  r_wkcp_code               nbrjobs.nbrjobs_wkcp_code%TYPE,
  r_jbln_code               nbrjobs.nbrjobs_jbln_code%TYPE,
  r_pers_chg_date           nbrjobs.nbrjobs_pers_chg_date%TYPE,
  r_pcat_code               nbrjobs.nbrjobs_pcat_code%TYPE,
  r_dfpr_code               nbrjobs.nbrjobs_dfpr_code%TYPE,
  r_encumbrance_hrs         nbrjobs.nbrjobs_encumbrance_hrs%TYPE,
  r_contract_no             nbrjobs.nbrjobs_contract_no%TYPE,
  r_strs_assn_code          nbrjobs.nbrjobs_strs_assn_code%TYPE,
  r_strs_pay_code           nbrjobs.nbrjobs_strs_pay_code%TYPE,
  r_pers_pay_code           nbrjobs.nbrjobs_pers_pay_code%TYPE,
  r_time_entry_method       nbrjobs.nbrjobs_time_entry_method%TYPE,
  r_time_entry_type         nbrjobs.nbrjobs_time_entry_type%TYPE,
  r_time_in_out_ind         nbrjobs.nbrjobs_time_in_out_ind%TYPE,
  r_lcat_code               nbrjobs.nbrjobs_lcat_code%TYPE,
  r_leav_rept_method        nbrjobs.nbrjobs_leav_rept_method%TYPE,
  r_pict_code_leav_rept     nbrjobs.nbrjobs_pict_code_leav_rept%TYPE,
  r_user_id                 nbrjobs.nbrjobs_user_id%TYPE,
  r_data_origin             nbrjobs.nbrjobs_data_origin%TYPE,
  r_internal_record_id      gb_common.internal_record_id_type);

Business Entity record type

job_detail_ref 

TYPE job_detail_ref IS REF CURSOR RETURN job_detail_rec;

Entity cursor variable type

job_detail_tab 

TYPE job_detail_tab IS TABLE OF job_detail_rec INDEX BY BINARY_INTEGER;

Entity table type

f_api_version 

Function f_api_version RETURN PLS_INTEGER

Returns the API version number.

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

f_exists 

Function f_exists(p_pidm           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_rowid          gb_common.internal_record_id_type DEFAULT NULL)
  RETURN VARCHAR2

Checks to see if a record exists.

Parameters
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 record becomes effective. DATE Required Key
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 job_detail_rec, rec_two job_detail_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_detail_rec Required
rec_two   The second record to compare. Type job_detail_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 IN nbrjobs.nbrjobs_pidm%TYPE,
                     p_posn IN nbrjobs.nbrjobs_posn%TYPE,
                     p_suff IN nbrjobs.nbrjobs_suff%TYPE)
  RETURN job_detail_ref

Selects all records for the entity.

Parameters
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

Returns
A cursor variable that will fetch the set of records.

f_query_by_date 

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

Selects the current record as of the given effective date.

Parameters
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 record becomes effective. DATE Required Key

Returns
A cursor variable that will fetch the set of records.

f_query_by_rowid 

Function f_query_by_rowid(p_rowid gb_common.internal_record_id_type)
  RETURN job_detail_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_next 

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

Selects the next record relative to the specified effective date.

Parameters
p_pidm   Internal ID Number. NUMBER(8) Required Key
p_posn   The Position to which this job is attached. VARCHAR2(6) Required Key
p_suff   The Suffix attached to the job. VARCHAR2(2) Required Key
p_effective_date   The Date that the record becomes effective. DATE Required Key

Returns
A cursor variable that will fetch the next record relative to the specified effective date.

f_query_one 

Function f_query_one(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)
  RETURN job_detail_ref

Selects one record using key.

Parameters
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 record becomes effective. DATE Required Key

Returns
A cursor variable that will fetch exactly one record.

f_query_one_lock 

Function f_query_one_lock(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_rowid          gb_common.internal_record_id_type DEFAULT NULL)
  RETURN job_detail_ref

Selects one record and locks it.

Parameters
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 record becomes effective. DATE Required Key
p_rowid   Database ROWID of the record to be selected. VARCHAR2(18)

Returns
A cursor variable for one record, locking the record.

p_create 

Procedure p_create(p_pidm                IN nbrjobs.nbrjobs_pidm%TYPE,
                   p_posn                IN nbrjobs.nbrjobs_posn%TYPE,
                   p_suff                IN nbrjobs.nbrjobs_suff%TYPE,
                   p_effective_date      IN nbrjobs.nbrjobs_effective_date%TYPE,
                   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_rowid_out           OUT gb_common.internal_record_id_type,
                   p_warning_msg_out     OUT gb_common_strings.err_type)

Creates a record.

Parameters
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 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_rowid_out   Database ROWID of the record to be created. VARCHAR2(18) Required
p_warning_msg_out   Returned warning messages. Warning messages will only be returned if the record is successfully created. gb_common_strings.err_type

p_delete 

Procedure p_delete(p_pidm            IN nbrjobs.nbrjobs_pidm%TYPE,
                   p_posn            IN nbrjobs.nbrjobs_posn%TYPE,
                   p_suff            IN nbrjobs.nbrjobs_suff%TYPE,
                   p_effective_date  IN nbrjobs.nbrjobs_effective_date%TYPE,
                   p_rowid           IN gb_common.internal_record_id_type DEFAULT NULL,
                   p_warning_msg_out OUT gb_common_strings.err_type)

Deletes a record.

Parameters
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 record becomes effective. DATE Required Key
p_rowid   Database ROWID of the record to be deleted. VARCHAR2(18)
p_warning_msg_out   Returned warning messages. Warning messages will only be returned if the record is successfully updated. gb_common_strings.err_type

p_lock 

Procedure p_lock(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_rowid_inout    IN OUT gb_common.internal_record_id_type)

Locks a record.
If ROWID is not passed in, the record is located using the key values and the ROWID of the locked row is passed in p_rowid_inout

Parameters
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 record becomes effective. DATE Required Key
p_rowid_inout   Database ROWID of the record to be locked. VARCHAR2(18) Required

p_update 

Procedure p_update(p_pidm                IN nbrjobs.nbrjobs_pidm%TYPE,
                   p_posn                IN nbrjobs.nbrjobs_posn%TYPE,
                   p_suff                IN nbrjobs.nbrjobs_suff%TYPE,
                   p_effective_date      IN nbrjobs.nbrjobs_effective_date%TYPE,
                   p_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_rowid               IN gb_common.internal_record_id_type DEFAULT NULL,
                   p_warning_msg_out     OUT gb_common_strings.err_type)

Updates a record.

Parameters
p_pidm   Internal identification number of the employee. NUMBER(8) Required Key
p_posn   Position Number. VARCHAR2(6) Required Key
p_suff   Suffix of the job. VARCHAR2(2) Required Key
p_effective_date   Date that the 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_rowid   Database ROWID of the record to be updated. VARCHAR2(18)
p_warning_msg_out   Returned warning messages. Warning messages will only be returned if the record is successfully deleted. gb_common_strings.err_type