index

Package tb_contract_auth_rules

Support subprograms for CONTRACT_AUTH.

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

p_register_entity 

Procedure p_register_entity(p_operation_type     NUMBER,
                            p_internal_record_id gb_common.internal_record_id_type)

Registers the attribute value pairs to the message cache for delete operations.
This signature uses the ROWID only for 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_stu_pidm              tbbcstu.tbbcstu_stu_pidm%TYPE,
                            p_contract_priority     tbbcstu.tbbcstu_contract_priority%TYPE,
                            p_contract_pidm         tbbcstu.tbbcstu_contract_pidm%TYPE,
                            p_contract_number       tbbcstu.tbbcstu_contract_number%TYPE,
                            p_term_code             tbbcstu.tbbcstu_term_code%TYPE,
                            p_del_ind               tbbcstu.tbbcstu_del_ind%TYPE,
                            p_auth_number           tbbcstu.tbbcstu_auth_number%TYPE,
                            p_auth_ind              tbbcstu.tbbcstu_auth_ind%TYPE,
                            p_student_cont_roll_ind tbbcstu.tbbcstu_student_cont_roll_ind%TYPE,
                            p_term_code_expiration  tbbcstu.tbbcstu_term_code_expiration%TYPE,
                            p_sponsor_ref_number    tbbcstu.tbbcstu_sponsor_ref_number%TYPE,
                            p_user_id               tbbcstu.tbbcstu_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_max_student_amount    tbbcstu.tbbcstu_max_student_amount%TYPE,
                            p_data_origin           tbbcstu.tbbcstu_data_origin%TYPE,
                            p_internal_record_id    gb_common.internal_record_id_type)

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

Parameters
p_operation_type   Type of DML operation: create, update, delete. NUMBER Required
p_stu_pidm   Internal Identification Number of the student authorized for charges to be paid through the third party contract. NUMBER(8) Required Key
p_contract_priority   This indicates the priority of this contract for the student, if the student is authorized for more than one contract. NUMBER(2) Required
p_contract_pidm   Internal Identification Number of the non-person account that is sponsor of a third party contract. NUMBER(8) Required Key
p_contract_number   Contract number associated with the third party for the term. NUMBER(8) Required Key
p_term_code   Term associated with the third party contract number. VARCHAR2(6) Required Key
p_del_ind   Delete indicator, to inactivate student from the contract after credits initially created. VARCHAR2(1)
D   Student is inactivated from the contract and any credit should be reversed.
NULL   Student is active in the contract.

p_auth_number   A number issued for a student by a third party when a student is authorized to use a contract. VARCHAR2(30)
p_auth_ind   Authorization for student in the contract. VARCHAR2(1)
Y   Student authorized to have charges paid under the contract (also used when authorization not required).
N   Student is not authorized to have charges paid under the contract.
NULL   Authorization pending.

p_student_cont_roll_ind   Contract roll indicator. VARCHAR2(1) Required
Y   Roll the student to new contract when performing contract roll.
N   Do not roll the student to new contract.

p_term_code_expiration   Expiration term, representing the last term that a student should be copied forward by a contract roll process. VARCHAR2(6)
p_sponsor_ref_number   Reference number supplied by the contract sponsor. VARCHAR2(30)
p_user_id   The unique identification of the user. VARCHAR2(30)
p_max_student_amount   Maximum amount a student can have for this contract. NUMBER(7,2)
p_data_origin   Source system that last created or updated the data. VARCHAR2(30)
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_validate 

Procedure p_validate(p_stu_pidm              tbbcstu.tbbcstu_stu_pidm%TYPE,
                     p_contract_priority     tbbcstu.tbbcstu_contract_priority%TYPE,
                     p_contract_pidm         tbbcstu.tbbcstu_contract_pidm%TYPE,
                     p_contract_number       tbbcstu.tbbcstu_contract_number%TYPE,
                     p_term_code             tbbcstu.tbbcstu_term_code%TYPE,
                     p_del_ind               tbbcstu.tbbcstu_del_ind%TYPE DEFAULT NULL,
                     p_auth_number           tbbcstu.tbbcstu_auth_number%TYPE DEFAULT NULL,
                     p_auth_ind              tbbcstu.tbbcstu_auth_ind%TYPE DEFAULT NULL,
                     p_student_cont_roll_ind tbbcstu.tbbcstu_student_cont_roll_ind%TYPE,
                     p_term_code_expiration  tbbcstu.tbbcstu_term_code_expiration%TYPE DEFAULT NULL,
                     p_sponsor_ref_number    tbbcstu.tbbcstu_sponsor_ref_number%TYPE DEFAULT NULL,
                     p_user_id               tbbcstu.tbbcstu_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_max_student_amount    tbbcstu.tbbcstu_max_student_amount%TYPE DEFAULT NULL,
                     p_data_origin           tbbcstu.tbbcstu_data_origin%TYPE DEFAULT NULL,
                     p_existing_rec          tb_contract_auth.contract_auth_rec DEFAULT NULL)

Validates all data in the record.

Parameters
p_stu_pidm   Internal Identification Number of the student authorized for charges to be paid through the third party contract. NUMBER(8) Required Key
p_contract_priority   This indicates the priority of this contract for the student, if the student is authorized for more than one contract. NUMBER(2) Required
p_contract_pidm   Internal Identification Number of the non-person account that is sponsor of a third party contract. NUMBER(8) Required Key
p_contract_number   Contract number associated with the third party for the term. NUMBER(8) Required Key
p_term_code   Term associated with the third party contract number. VARCHAR2(6) Required Key
p_del_ind   Delete indicator, to inactivate student from the contract after credits initially created. VARCHAR2(1)
D   Student is inactivated from the contract and any credit should be reversed.
NULL   Student is active in the contract.

p_auth_number   A number issued for a student by a third party when a student is authorized to use a contract. VARCHAR2(30)
p_auth_ind   Authorization for student in the contract. VARCHAR2(1)
Y   Student authorized to have charges paid under the contract (also used when authorization not required).
N   Student is not authorized to have charges paid under the contract.
NULL   Authorization pending.

p_student_cont_roll_ind   Contract roll indicator. VARCHAR2(1) Required
Y   Roll the student to new contract when performing contract roll.
N   Do not roll the student to new contract.

p_term_code_expiration   Expiration term, representing the last term that a student should be copied forward by a contract roll process. VARCHAR2(6)
p_sponsor_ref_number   Reference number supplied by the contract sponsor. VARCHAR2(30)
p_user_id   The unique identification of the user. VARCHAR2(30)
p_max_student_amount   Maximum amount a student can have for this contract. NUMBER(7,2)
p_data_origin   Source system that last created or updated the data. VARCHAR2(30)