index

Package nb_job_base_rules

Support subprograms for the Job Base API (nb_job_base).

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

p_register_entity 

Procedure p_register_entity(p_operation_type     NUMBER,
                            p_internal_record_id gb_common.internal_record_id_type)

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

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

p_register_entity 

Procedure p_register_entity(p_operation_type         NUMBER,
                            p_pidm                   nbrbjob.nbrbjob_pidm%TYPE,
                            p_posn                   nbrbjob.nbrbjob_posn%TYPE,
                            p_suff                   nbrbjob.nbrbjob_suff%TYPE,
                            p_begin_date             nbrbjob.nbrbjob_begin_date%TYPE,
                            p_end_date               nbrbjob.nbrbjob_end_date%TYPE,
                            p_defer_bal              nbrbjob.nbrbjob_defer_bal%TYPE,
                            p_contract_type          nbrbjob.nbrbjob_contract_type%TYPE,
                            p_salary_encumbrance     nbrbjob.nbrbjob_salary_encumbrance%TYPE,
                            p_contract_begin_date    nbrbjob.nbrbjob_contract_begin_date%TYPE,
                            p_contract_end_date      nbrbjob.nbrbjob_contract_end_date%TYPE,
                            p_total_contract_hrs     nbrbjob.nbrbjob_total_contract_hrs%TYPE,
                            p_total_encumbrance_hrs  nbrbjob.nbrbjob_total_encumbrance_hrs%TYPE,
                            p_step_incr_mon          nbrbjob.nbrbjob_step_incr_mon%TYPE,
                            p_step_incr_day          nbrbjob.nbrbjob_step_incr_day%TYPE,
                            p_coas_code              nbrbjob.nbrbjob_coas_code%TYPE,
                            p_accrue_leave_ind       nbrbjob.nbrbjob_accrue_leave_ind%TYPE,
                            p_civil_service_ind      nbrbjob.nbrbjob_civil_service_ind%TYPE,
                            p_encumbrance_change_ind nbrbjob.nbrbjob_encumbrance_change_ind%TYPE,
                            p_fringe_encumbrance     nbrbjob.nbrbjob_fringe_encumbrance%TYPE,
                            p_ipeds_rept_ind         nbrbjob.nbrbjob_ipeds_rept_ind%TYPE,
                            p_facl_statscan_rept_ind nbrbjob.nbrbjob_facl_statscan_rept_ind%TYPE,
                            p_probation_begin_date   nbrbjob.nbrbjob_probation_begin_date%TYPE,
                            p_probation_end_date     nbrbjob.nbrbjob_probation_end_date%TYPE,
                            p_probation_units        nbrbjob.nbrbjob_probation_units%TYPE,
                            p_eligible_date          nbrbjob.nbrbjob_eligible_date%TYPE,
                            p_user_id                nbrbjob.nbrbjob_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin            nbrbjob.nbrbjob_data_origin%TYPE,
                            p_internal_record_id     gb_common.internal_record_id_type,
                            p_future_salary_enc      nbrbjob.nbrbjob_future_salary_enc%TYPE,
                            p_future_fringe_enc      nbrbjob.nbrbjob_future_fringe_enc%TYPE)

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

Parameters
p_operation_type   Type of DML operation: create,update,delete. NUMBER Required
p_pidm   Internal identification number of the employee. NUMBER(8) Required Key
p_posn   Position to which a job is attached. VARCHAR2(6) Required Key
p_suff   Unique identifier that helps create and maintain multiple jobs for the same position, for the same employee. VARCHAR2(2) Required Key
p_begin_date   Begin date of the job. DATE Required
p_end_date   Date the job will terminate. If date is null, then the job is defined as indefinite. The employee will be paid for this day. DATE
p_defer_bal   Amount of deferred pay accumulated for a job. NUMBER(11,2) Required
p_contract_type   Indicates the type of job. Only one primary job per person is allowed. VARCHAR2(1) Required
P   Primary (default)
S   Secondary
O   Overload

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

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

p_encumbrance_change_ind   Indicates if the encumbrance amount has changed for a job. VARCHAR2(1) Required
Y   Yes
N   No

p_fringe_encumbrance   Cost of fringe benefits that a person will be paid in a job during the current fiscal year. NUMBER(11,2)
p_ipeds_rept_ind   Indicates if a job should be reported on the IPEDS report. VARCHAR2(1) Required
Y   Yes
N   No

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

p_probation_begin_date   Begin date of the probationary period. DATE
p_probation_end_date   End date of the probationary period. This data is calculated based on the Probationary Period and Probation Begin Date, but may be overridden. DATE
p_probation_units   Identifies the number of Probationary Units. It represents months or days depending on the Probationary Period Units institutional setting. NUMBER(3)
p_eligible_date   Eligible date for the step increase. DATE
p_user_id   The Oracle ID of the user who changed the record. VARCHAR2(30)
p_data_origin   Source system that created or updated the row. VARCHAR2(30)
p_internal_record_id   Database ROWID VARCHAR2(18) required
p_future_salary_enc   The estimated amount a person will be paid in a job in future fiscal years. NUMBER(17,2)
p_future_fringe_enc   The estimated cost of fringe benefits a person will be paid in a job in future fiscal years. NUMBER(17,2)

p_validate 

Procedure p_validate(p_val_rec_inout          IN OUT nb_job_base.job_base_rec,
                     p_operation_type         IN NUMBER,
                     p_pidm                   IN nbrbjob.nbrbjob_pidm%TYPE,
                     p_posn                   IN nbrbjob.nbrbjob_posn%TYPE,
                     p_suff                   IN nbrbjob.nbrbjob_suff%TYPE,
                     p_begin_date             IN nbrbjob.nbrbjob_begin_date%TYPE DEFAULT dml_common.f_unspecified_date,
                     p_end_date               IN nbrbjob.nbrbjob_end_date%TYPE DEFAULT dml_common.f_unspecified_date,
                     p_defer_bal              IN nbrbjob.nbrbjob_defer_bal%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_contract_type          IN nbrbjob.nbrbjob_contract_type%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_salary_encumbrance     IN nbrbjob.nbrbjob_salary_encumbrance%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_contract_begin_date    IN nbrbjob.nbrbjob_contract_begin_date%TYPE DEFAULT dml_common.f_unspecified_date,
                     p_contract_end_date      IN nbrbjob.nbrbjob_contract_end_date%TYPE DEFAULT dml_common.f_unspecified_date,
                     p_total_contract_hrs     IN nbrbjob.nbrbjob_total_contract_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_total_encumbrance_hrs  IN nbrbjob.nbrbjob_total_encumbrance_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_step_incr_mon          IN nbrbjob.nbrbjob_step_incr_mon%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_step_incr_day          IN nbrbjob.nbrbjob_step_incr_day%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_accrue_leave_ind       IN nbrbjob.nbrbjob_accrue_leave_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_civil_service_ind      IN nbrbjob.nbrbjob_civil_service_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_encumbrance_change_ind IN nbrbjob.nbrbjob_encumbrance_change_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_fringe_encumbrance     IN nbrbjob.nbrbjob_fringe_encumbrance%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_ipeds_rept_ind         IN nbrbjob.nbrbjob_ipeds_rept_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_facl_statscan_rept_ind IN nbrbjob.nbrbjob_facl_statscan_rept_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_probation_begin_date   IN nbrbjob.nbrbjob_probation_begin_date%TYPE DEFAULT dml_common.f_unspecified_date,
                     p_probation_end_date     IN nbrbjob.nbrbjob_probation_end_date%TYPE DEFAULT dml_common.f_unspecified_date,
                     p_probation_units        IN nbrbjob.nbrbjob_probation_units%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_eligible_date          IN nbrbjob.nbrbjob_eligible_date%TYPE DEFAULT dml_common.f_unspecified_date,
                     p_user_id                IN nbrbjob.nbrbjob_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_data_origin            IN nbrbjob.nbrbjob_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
                     p_warning_msg_out        OUT gb_common_strings.err_type,
                     p_future_salary_enc      IN nbrbjob.nbrbjob_future_salary_enc%TYPE DEFAULT dml_common.f_unspecified_number,
                     p_future_fringe_enc      IN nbrbjob.nbrbjob_future_fringe_enc%TYPE DEFAULT dml_common.f_unspecified_number)

Validates all data in the record.

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

p_pidm   Internal identification number of the employee. NUMBER(8) Required Key
p_posn   Position to which a job is attached. VARCHAR2(6) Required Key
p_suff   Unique identifier that helps create and maintain multiple jobs for the same position, for the same employee. VARCHAR2(2) Required Key
p_begin_date   Begin date of the job. DATE Required
p_end_date   Date the job will terminate. If date is null, then the job is defined as indefinite. The employee will be paid for this day. DATE
p_defer_bal   Amount of deferred pay accumulated for a job. NUMBER(11,2) Required
p_contract_type   Indicates the type of job. Only one primary job per person is allowed. VARCHAR2(1) Required
P   Primary (default)
S   Secondary
O   Overload

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

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

p_encumbrance_change_ind   Indicates if the encumbrance amount has changed for a job. VARCHAR2(1) Required
Y   Yes
N   No

p_fringe_encumbrance   Cost of fringe benefits that a person will be paid in a job during the current fiscal year. NUMBER(11,2)
p_ipeds_rept_ind   Indicates if a job should be reported on the IPEDS report. VARCHAR2(1) Required
Y   Yes
N   No

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

p_probation_begin_date   Begin date of the probationary period. DATE
p_probation_end_date   End date of the probationary period. This data is calculated based on the Probationary Period and Probation Begin Date, but may be overridden. DATE
p_probation_units   Identifies the number of Probationary Units. It represents months or days depending on the Probationary Period Units institutional setting. NUMBER(3)
p_eligible_date   Eligible date for the step increase. DATE
p_user_id   The Oracle ID of the user who changed the record. VARCHAR2(30)
p_data_origin   Source system that created or updated the row. VARCHAR2(30)
p_warning_msg_out   Returned warning messages. Warning messages will only be returned if no validation errors were found. gb_common_strings.err_type
p_future_salary_enc   The estimated amount a person will be paid in a job in future fiscal years. NUMBER(17,2)
p_future_fringe_enc   The estimated cost of fringe benefits a person will be paid in a job in future fiscal years. NUMBER(17,2)

p_validate_delete 

Procedure p_validate_delete(p_val_rec         IN nb_job_base.job_base_rec,
                            p_warning_msg_out OUT gb_common_strings.err_type)

Validates the deletion of a record.

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