index

Package tb_contract_payment_rules

Support subprograms for CONTRACT_PAYMENT.

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_cont_pidm          tbrcpdt.tbrcpdt_cont_pidm%TYPE,
                            p_cont_tran_number   tbrcpdt.tbrcpdt_cont_tran_number%TYPE,
                            p_tran_number        tbrcpdt.tbrcpdt_tran_number%TYPE,
                            p_stu_pidm           tbrcpdt.tbrcpdt_stu_pidm%TYPE,
                            p_term_code          tbrcpdt.tbrcpdt_term_code%TYPE,
                            p_contract_number    tbrcpdt.tbrcpdt_contract_number%TYPE,
                            p_amount             tbrcpdt.tbrcpdt_amount%TYPE,
                            p_balance            tbrcpdt.tbrcpdt_balance%TYPE,
                            p_rfnd_stdn_amt      tbrcpdt.tbrcpdt_rfnd_stdn_amt%TYPE,
                            p_rfnd_cont_amt      tbrcpdt.tbrcpdt_rfnd_cont_amt%TYPE,
                            p_name_provided      tbrcpdt.tbrcpdt_name_provided%TYPE,
                            p_tran_number_paid   tbrcpdt.tbrcpdt_tran_number_paid%TYPE,
                            p_final_ind          tbrcpdt.tbrcpdt_final_ind%TYPE,
                            p_refund_ind         tbrcpdt.tbrcpdt_refund_ind%TYPE,
                            p_user_id            tbrcpdt.tbrcpdt_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_create_user        tbrcpdt.tbrcpdt_create_user%TYPE,
                            p_data_origin        tbrcpdt.tbrcpdt_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_cont_pidm   Internal Identification Number of the contract sponsor who has made payment. NUMBER(8) Required Key
p_cont_tran_number   Transaction number of the payment in the sponsor receivable account. NUMBER(8) Required Key
p_tran_number   Transaction number assigned to the payment detail record. NUMBER(8) Required Key
p_stu_pidm   Internal Identification Number of the student for whom payment has been made, matched to cross reference pidm of contract charges. NUMBER(8)
p_term_code   Term code of the contract for which payment has been made. VARCHAR2(6) Required
p_contract_number   Contract number for which payment has been made. NUMBER(8)
p_amount   Amount of the payment. NUMBER(12,2) Required
p_balance   Remaining balance of the payment that has not been applied to charges. NUMBER(12,2) Required
p_rfnd_stdn_amt   Amount processed as credit back to student's receivable account. NUMBER(12,2)
p_rfnd_cont_amt   Amount processed as refund to sponsor. NUMBER(12,2)
p_name_provided   Name as provided by sponsor to identify student. VARCHAR2(120)
p_tran_number_paid   Transaction number of a charge in the sponsor receivable account to which payment should be applied. NUMBER(8)
p_final_ind   Indicates if payment is final amount, which may leave balance due from student. VARCHAR2(1) Required
p_refund_ind   Indicates if overage may be given to student, or should be returned to sponsor. VARCHAR2(1) Required
p_user_id   The Oracle ID for the user who created or last updated the record. VARCHAR2(30) Required
p_create_user   User Id of the cashier who first created the payment detail records. VARCHAR2(30) Required
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_cont_pidm        tbrcpdt.tbrcpdt_cont_pidm%TYPE,
                     p_cont_tran_number tbrcpdt.tbrcpdt_cont_tran_number%TYPE,
                     p_tran_number      tbrcpdt.tbrcpdt_tran_number%TYPE,
                     p_stu_pidm         tbrcpdt.tbrcpdt_stu_pidm%TYPE DEFAULT NULL,
                     p_term_code        tbrcpdt.tbrcpdt_term_code%TYPE,
                     p_contract_number  tbrcpdt.tbrcpdt_contract_number%TYPE DEFAULT NULL,
                     p_amount           tbrcpdt.tbrcpdt_amount%TYPE,
                     p_balance          tbrcpdt.tbrcpdt_balance%TYPE,
                     p_rfnd_stdn_amt    tbrcpdt.tbrcpdt_rfnd_stdn_amt%TYPE DEFAULT NULL,
                     p_rfnd_cont_amt    tbrcpdt.tbrcpdt_rfnd_cont_amt%TYPE DEFAULT NULL,
                     p_name_provided    tbrcpdt.tbrcpdt_name_provided%TYPE DEFAULT NULL,
                     p_tran_number_paid tbrcpdt.tbrcpdt_tran_number_paid%TYPE DEFAULT NULL,
                     p_final_ind        tbrcpdt.tbrcpdt_final_ind%TYPE,
                     p_refund_ind       tbrcpdt.tbrcpdt_refund_ind%TYPE,
                     p_user_id          tbrcpdt.tbrcpdt_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_create_user      tbrcpdt.tbrcpdt_create_user%TYPE,
                     p_data_origin      tbrcpdt.tbrcpdt_data_origin%TYPE DEFAULT NULL,
                     p_existing_rec     tb_contract_payment.contract_payment_rec DEFAULT NULL)

Validates all data in the record.

Parameters
p_cont_pidm   Internal Identification Number of the contract sponsor who has made payment. NUMBER(8) Required Key
p_cont_tran_number   Transaction number of the payment in the sponsor receivable account. NUMBER(8) Required Key
p_tran_number   Transaction number assigned to the payment detail record. NUMBER(8) Required Key
p_stu_pidm   Internal Identification Number of the student for whom payment has been made, matched to cross reference pidm of contract charges. NUMBER(8)
p_term_code   Term code of the contract for which payment has been made. VARCHAR2(6) Required
p_contract_number   Contract number for which payment has been made. NUMBER(8)
p_amount   Amount of the payment. NUMBER(12,2) Required
p_balance   Remaining balance of the payment that has not been applied to charges. NUMBER(12,2) Required
p_rfnd_stdn_amt   Amount processed as credit back to student's receivable account. NUMBER(12,2)
p_rfnd_cont_amt   Amount processed as refund to sponsor. NUMBER(12,2)
p_name_provided   Name as provided by sponsor to identify student. VARCHAR2(120)
p_tran_number_paid   Transaction number of a charge in the sponsor receivable account to which payment should be applied. NUMBER(8)
p_final_ind   Indicates if payment is final amount, which may leave balance due from student. VARCHAR2(1) Required
p_refund_ind   Indicates if overage may be given to student, or should be returned to sponsor. VARCHAR2(1) Required
p_user_id   The Oracle ID for the user who created or last updated the record. VARCHAR2(30) Required
p_create_user   User Id of the cashier who first created the payment detail records. VARCHAR2(30) Required
p_data_origin   Source system that last created or updated the data. VARCHAR2(30)
p_existing_rec   Current TBRCPDT record before updates.