Package tb_deposit

Package tb_deposit_rules

Support subprograms for DEPOSIT.

Program units

p_register_entity	Register the attribute/value pairs to the message cache.
p_register_entity	Register the attribute/value pairs to the message cache.
p_valid_create	Validates and gets default values of a record to be inserted into the table.
p_valid_update	Validates all the data in the record for update.
p_validate	Validates all the data for missing column values, primary and foreign key values in the record for create.

p_register_entity

Procedure p_register_entity(p_operation_type     NUMBER,
                            p_internal_record_id VARCHAR2)

Parameters

p_internal_record_id

Database rowid VARCHAR2(18)

p_register_entity

Procedure p_register_entity(p_operation_type      NUMBER,
                            p_pidm                tbrdepo.tbrdepo_pidm%TYPE,
                            p_tran_number         tbrdepo.tbrdepo_tran_number%TYPE,
                            p_term_code           tbrdepo.tbrdepo_term_code%TYPE,
                            p_detail_code_deposit tbrdepo.tbrdepo_detail_code_deposit%TYPE,
                            p_desc                tbrdepo.tbrdepo_desc%TYPE,
                            p_amount              tbrdepo.tbrdepo_amount%TYPE,
                            p_detail_code_payment tbrdepo.tbrdepo_detail_code_payment%TYPE,
                            p_auto_release_ind    tbrdepo.tbrdepo_auto_release_ind%TYPE,
                            p_acct_feed_ind       tbrdepo.tbrdepo_acct_feed_ind%TYPE,
                            p_user                tbrdepo.tbrdepo_user%TYPE,
                            p_entry_date          tbrdepo.tbrdepo_entry_date%TYPE,
                            p_receipt_number      tbrdepo.tbrdepo_receipt_number%TYPE,
                            p_min_amount          tbrdepo.tbrdepo_min_amount%TYPE,
                            p_expiration_date     tbrdepo.tbrdepo_expiration_date%TYPE,
                            p_release_date        tbrdepo.tbrdepo_release_date%TYPE,
                            p_effective_date      tbrdepo.tbrdepo_effective_date%TYPE,
                            p_session_number      tbrdepo.tbrdepo_session_number%TYPE,
                            p_cshr_end_date       tbrdepo.tbrdepo_cshr_end_date%TYPE,
                            p_curr_code           tbrdepo.tbrdepo_curr_code%TYPE,
                            p_trans_date          tbrdepo.tbrdepo_trans_date%TYPE,
                            p_foreign_amount      tbrdepo.tbrdepo_foreign_amount%TYPE,
                            p_feed_date           tbrdepo.tbrdepo_feed_date%TYPE,
                            p_feed_doc_code       tbrdepo.tbrdepo_feed_doc_code%TYPE,
                            p_atyp_code           tbrdepo.tbrdepo_atyp_code%TYPE,
                            p_atyp_seqno          tbrdepo.tbrdepo_atyp_seqno%TYPE,
                            p_data_origin         tbrdepo.tbrdepo_data_origin%TYPE,
                            p_create_source       tbrdepo.tbrdepo_create_source%TYPE,
                            p_document_number     tbrdepo.tbrdepo_document_number%TYPE,
                            p_balance             tbrdepo.tbrdepo_amount%TYPE,
                            p_internal_record_id  VARCHAR2)

Parameters

p_pidm

Internal Identification Number of the person or non-person account that has a deposit, valid in SPRIDEN. NUMBER(8)

p_tran_number

Transaction number (one-up within entity) of the deposit. NUMBER(8)

p_term_code

Term associated with the deposit. For student deposits valid in STVTERM, or ARTERM for non-student deposits. VARCHAR2(6)

p_detail_code_deposit

Detail code used when the deposit is released to the receivable ledger. Valid in Deposit Detail Definition Table (TBBDEPC). VARCHAR2(4)

p_desc

Free-Form description associated with the deposit. VARCHAR2(30)

p_amount

The amount of the deposit. NUMBER(7,2)

p_detail_code_payment

Detail code associated with the creation of a new deposit, indicating payment media of check, cash, charge, and so on. Valid in TBBDETC. VARCHAR2(4)

p_auto_release_ind

Indicates whether the deposit should be automatically released to the account as of the release date. VARCHAR2(1)

	Y	Automatic release
	N	Manual release

p_acct_feed_ind

The status of the deposit in the accounting feed. VARCHAR2(1)

	Y	Feed transaction
	F	Transaction fed

p_user

User ID of the cashier who created the deposit. VARCHAR2(30)

p_entry_date

Entry date and time of the deposit, when initially created. DATE

p_receipt_number

Receipt number associated with the deposit if generated when the deposit was created. NUMBER(8)

p_min_amount

Minimum amount that must remain as a deposit balance and not be released until the expiration date has passed. NUMBER(7,2)

p_expiration_date

Expiration date of the deposit, after which it may be released to the receivable account without regard to the minimum. DATE

p_release_date

Earliest date when the deposit may be released either automatically or manually. If this field is blank, the deposit may be released at any time. DATE

p_effective_date

Effective date of the deposit. Default value is the date the deposit was entered. DATE

p_session_number

Cashier session number in which this transaction was posted (0 = current session). NUMBER(5)

p_cshr_end_date

End date and time of the cashiering session for this transaction. DATE

p_curr_code

Foreign currency code used when creating a deposit, valid in GTVCURR and GURCURR. VARCHAR2(4)

p_trans_date

Transaction date used by the finance system to control posting to the ledgers. DATE

p_foreign_amount

The amount of the deposit stated in foreign currency. NUMBER(12,2)

p_feed_date

Date this transaction was fed to the finance system. DATE

p_feed_doc_code

Document code used to feed this transaction to the finance system. VARCHAR2(8)

p_atyp_code

In combination with ATYP_SEQNO, the address associated with this deposit for non-student transactions. Valid in STVATYP. VARCHAR2(2)

p_atyp_seqno

In combination with ATYP_CODE, the address associated with this deposit for non-student transactions. Combination valid and active in SPRADDR. NUMBER(2)

p_data_origin

Source system that last created or updated the data. VARCHAR2(30)

p_create_source

Source system that initially created the record. VARCHAR2(30)

p_document_number

Document number that references a source document for the deposit. VARCHAR2(8)

p_internal_record_id

Database rowid VARCHAR2(18)

p_valid_create

Procedure p_valid_create(lv_tbrdepo_row_inout IN OUT tbrdepo%ROWTYPE,
                         p_min_amount         tbrdepo.tbrdepo_min_amount%TYPE,
                         p_override_hold      VARCHAR2)

Validates and gets default values of a record to be inserted into the table.

Parameters

lv_tbrdepo_row_inout

Deposit row to be validated.

p_min_amount

Minimum amount that must remain as a deposit balance and not be released until the expiration date has passed. NUMBER(7,2)

p_override_hold

Parameter to override Accounts Receivable hold. VARCHAR2(1)

	N	Check for AR hold (default)
	Y	Bypass hold checking

p_valid_update

Procedure p_valid_update(lv_validation_rec_inout IN OUT tb_deposit.deposit_rec,
                         lv_existing_rec         tb_deposit.deposit_rec)

Validates all the data in the record for update.

Parameters

	lv_validation_rec	Deposit row to be validated with new columns overlaid on the existing values.
	lv_existing_rec	Deposit row as it exists in the database.

p_validate

Procedure p_validate(lv_tbrdepo_row tbrdepo%ROWTYPE)

Validates all the data for missing column values, primary and foreign key values in the record for create. Called by p_valid_create.

Parameters

lv_tbrdepo_row_in

Deposit row to be validated.