Package tb_contract

Package tb_contract_payment

Common Business interface for the Contract Payment Detail API (CONTRACT_PAYMENT).

Program units

f_api_version	Returns the API version number.
f_exists	Checks if a record exists.
f_exists_student	Checks if a student has payment detail for specified Contract.
f_isequal	Compares two records for equality.
f_max_tran_number	Return maximum contract payment detail transaction number.
f_query_all	Selects all records for the entity.
f_query_one	Selects one record using the key.
f_query_by_rowid	Selects one record using the ROWID.
f_query_one_lock	Selects one record and locks it.
f_sum_amount	Sum the amount column of the payment detail.
f_sum_balance	Sum the balance column of the payment detail.
p_adjust_balance	Add adjustment amount to the existing balance of a record (used in payment application).
p_create	Creates a record.
p_delete	Deletes a record.
p_delete_all	Deletes all detail records associated with a Contract Payment.
p_lock	Locks a record.
p_overpay_to_contract	Creates refund to Contract sponsor.
p_overpay_to_student	Transfers credit to Student.
p_update	Updates a record.

Types

contract_payment_rec	Business Entity record type
contract_payment_ref	Entity cursor variable type
contract_payment_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(16) := 'CONTRACT_PAYMENT';

Business Entity Name

M_BASE_TABLE_NAME

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

Base table name

contract_payment_rec

TYPE contract_payment_rec IS RECORD (
  r_cont_pidm               tbrcpdt.tbrcpdt_cont_pidm%TYPE,
  r_cont_tran_number        tbrcpdt.tbrcpdt_cont_tran_number%TYPE,
  r_tran_number             tbrcpdt.tbrcpdt_tran_number%TYPE,
  r_stu_pidm                tbrcpdt.tbrcpdt_stu_pidm%TYPE,
  r_term_code               tbrcpdt.tbrcpdt_term_code%TYPE,
  r_contract_number         tbrcpdt.tbrcpdt_contract_number%TYPE,
  r_amount                  tbrcpdt.tbrcpdt_amount%TYPE,
  r_balance                 tbrcpdt.tbrcpdt_balance%TYPE,
  r_rfnd_stdn_amt           tbrcpdt.tbrcpdt_rfnd_stdn_amt%TYPE,
  r_rfnd_cont_amt           tbrcpdt.tbrcpdt_rfnd_cont_amt%TYPE,
  r_name_provided           tbrcpdt.tbrcpdt_name_provided%TYPE,
  r_tran_number_paid        tbrcpdt.tbrcpdt_tran_number_paid%TYPE,
  r_final_ind               tbrcpdt.tbrcpdt_final_ind%TYPE,
  r_refund_ind              tbrcpdt.tbrcpdt_refund_ind%TYPE,
  r_user_id                 tbrcpdt.tbrcpdt_user_id%TYPE,
  r_create_user             tbrcpdt.tbrcpdt_create_user%TYPE,
  r_data_origin             tbrcpdt.tbrcpdt_data_origin%TYPE,
  r_internal_record_id      gb_common.internal_record_id_type);

Business Entity record type

contract_payment_ref

TYPE contract_payment_ref IS REF CURSOR RETURN contract_payment_rec;

Entity cursor variable type

contract_payment_tab

TYPE contract_payment_tab IS TABLE OF contract_payment_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_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 DEFAULT NULL,
                  p_rowid            gb_common.internal_record_id_type DEFAULT NULL)
  RETURN VARCHAR2

Checks if a record exists.
If detail tran number left null, checks for any detail associated with this payment transaction.

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)
	p_rowid	Database ROWID of the record to be selected. VARCHAR2(18)

Returns

Y if found, otherwise N.

f_exists_student

Function f_exists_student(p_stu_pidm         tbrcpdt.tbrcpdt_stu_pidm%TYPE,
                          p_cont_pidm        tbrcpdt.tbrcpdt_cont_pidm%TYPE,
                          p_term_code        tbrcpdt.tbrcpdt_term_code%TYPE DEFAULT NULL,
                          p_contract_number  tbrcpdt.tbrcpdt_contract_number%TYPE DEFAULT NULL,
                          p_cont_tran_number tbrcpdt.tbrcpdt_cont_tran_number%TYPE DEFAULT NULL)
  RETURN VARCHAR2

Checks if a student has payment detail for specified Contract.

Parameters

	p_stu_pidm	Internal Identification Number of the student to verify. NUMBER(8) Required
	p_cont_pidm	Internal Identification Number of the contract sponsor who has made payment. NUMBER(8) Required
	p_term_code	Term code of the contract for which payment has been made. VARCHAR2(6)
	p_contract_number	Contract number for which payment has been made. NUMBER(8)
	p_cont_tran_number	Transaction number of the payment in the sponsor receivable account. NUMBER(8)

Returns

Y if found, otherwise N.

f_isequal

Function f_isequal(rec_one contract_payment_rec,
                   rec_two contract_payment_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 contract_payment_rec Required
	rec_two	The second record to compare. Type contract_payment_rec Required

Returns

Y if all values in records are equal, otherwise N. Nulls match Nulls.

f_max_tran_number

Function f_max_tran_number(p_cont_pidm        tbrcpdt.tbrcpdt_cont_pidm%TYPE,
                           p_cont_tran_number tbrcpdt.tbrcpdt_cont_tran_number%TYPE)
  RETURN tbrcpdt.tbrcpdt_tran_number%TYPE

Return maximum contract payment detail transaction number.

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

Returns

Maximum transaction number that exists on the account

f_query_all

Function f_query_all(p_cont_pidm        tbrcpdt.tbrcpdt_cont_pidm%TYPE,
                     p_cont_tran_number tbrcpdt.tbrcpdt_cont_tran_number%TYPE,
                     p_stu_pidm         tbrcpdt.tbrcpdt_stu_pidm%TYPE DEFAULT NULL,
                     p_contract_number  tbrcpdt.tbrcpdt_contract_number%TYPE DEFAULT NULL,
                     p_term_code        tbrcpdt.tbrcpdt_term_code%TYPE DEFAULT NULL)
  RETURN contract_payment_ref

Selects all records for the entity.

Contract PIDM and transaction number are required.
If Student PIDM, Contract Number, or Term Code are left NULL, all records are returned without regard to the value of data in those fields.

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_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_contract_number	Contract number for which payment has been made. NUMBER(8)
	p_term_code	Term code of the contract for which payment has been made. VARCHAR2(6)

Returns

A cursor variable that will fetch a set of records.

f_query_one

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

Selects one record using the key.

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

Returns

A cursor variable that will fetch exactly one record.

f_query_by_rowid

Function f_query_by_rowid(p_rowid gb_common.internal_record_id_type)
  RETURN contract_payment_ref

Selects one record using the 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_one_lock

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

Selects one record and locks it.

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_rowid	Database ROWID of the record to be selected. VARCHAR2(18)

Returns

A cursor variable for one record, locking the record.

f_sum_amount

Function f_sum_amount(p_cont_pidm        tbrcpdt.tbrcpdt_cont_pidm%TYPE,
                      p_cont_tran_number tbrcpdt.tbrcpdt_cont_tran_number%TYPE)
  RETURN NUMBER

Sum the amount column of the payment detail.

This function will return a null when no records match the parameters provided.

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

Returns

Sum of the Amount column, or null if no records match parameters.

f_sum_balance

Function f_sum_balance(p_cont_pidm        tbrcpdt.tbrcpdt_cont_pidm%TYPE,
                       p_cont_tran_number tbrcpdt.tbrcpdt_cont_tran_number%TYPE)
  RETURN NUMBER

Sum the balance column of the payment detail.

This function will return a null when no records match the parameters provided.

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

Returns

Sum of the Balance column, or null if no records match parameters.

p_adjust_balance

Procedure p_adjust_balance(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_adjust_amount    tbrcpdt.tbrcpdt_balance%TYPE)

Add adjustment amount to the existing balance of a record (used in payment application).
Enabled only for un-application of payments, and should not be used for other purposes.

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_adjust_amount	Amount to add to balance to increase (decrease) outstanding payment detail amount. NUMBER(12,2) Required.

p_create

Procedure p_create(p_cont_pidm        tbrcpdt.tbrcpdt_cont_pidm%TYPE,
                   p_cont_tran_number tbrcpdt.tbrcpdt_cont_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 DEFAULT 'N',
                   p_refund_ind       tbrcpdt.tbrcpdt_refund_ind%TYPE DEFAULT 'N',
                   p_user_id          tbrcpdt.tbrcpdt_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_data_origin      tbrcpdt.tbrcpdt_data_origin%TYPE DEFAULT NULL,
                   p_tran_number_out  OUT tbrcpdt.tbrcpdt_tran_number%TYPE,
                   p_rowid_out        OUT gb_common.internal_record_id_type)

Creates a 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_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 (informational only). VARCHAR2(1)

	Y	Contract payment is last one expected for the student
	N	Additional contract payment may be received (default)

p_refund_ind

Indicates if overage may be given to student, or should be returned to sponsor (informational only). VARCHAR2(1)

	Y	Overpayment may be credited to the student
	N	Have not recorded permission to credit overpayment to student (default)

p_user_id

The Oracle ID for the user who created or last updated the record. VARCHAR2(30) Required

p_data_origin

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

p_tran_number_out

Returns transaction number assigned to the payment detail record. NUMBER(8) Required

p_rowid_out

Database ROWID of the record to be created. VARCHAR2(18) Required

p_delete

Procedure p_delete(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_rowid            gb_common.internal_record_id_type DEFAULT NULL)

Deletes a 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_rowid	Database ROWID of the record to be deleted. VARCHAR2(18)

p_delete_all

Procedure p_delete_all(p_cont_pidm        tbrcpdt.tbrcpdt_cont_pidm%TYPE,
                       p_cont_tran_number tbrcpdt.tbrcpdt_cont_tran_number%TYPE)

Deletes all detail records associated with a Contract Payment.

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_lock

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

Locks a record.
If the 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_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_rowid_inout	Database ROWID of the record to be locked. VARCHAR2(18) Required

p_overpay_to_contract

Procedure p_overpay_to_contract(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_detail_code      tbbdetc.tbbdetc_detail_code%TYPE,
                                p_desc             tbbdetc.tbbdetc_desc%TYPE DEFAULT NULL,
                                p_amount           tbrcpdt.tbrcpdt_amount%TYPE,
                                p_user_id          tbrcpdt.tbrcpdt_user_id%TYPE DEFAULT gb_common.f_sct_user,
                                p_data_origin      tbrcpdt.tbrcpdt_data_origin%TYPE DEFAULT NULL)

Creates refund to Contract sponsor.

Procedure will create a Charge for a Refund on the Contract account.
When Student is known, cross-reference PIDM and transaction number paid are populated on the refund record.
When payment is unassigned, cross-reference PIDM is left NULL, transaction number paid is recorded in the detail transaction, and the Name Provided is recorded in the Account Charge/Payment Detail Text Table (TBRACDT).
The Payment Detail is processed through Application of Payments.

Note that any process which calls this procedure is responsible for committing the changes made.

Parameters

	p_cont_pidm	Internal Identification Number of the contract sponsor who has made payment. NUMBER(8) Required
	p_cont_tran_number	Transaction number of the payment in the sponsor receivable account. NUMBER(8) Required
	p_tran_number	Transaction number assigned to the payment detail record. NUMBER(8) Required
	p_detail_code	Refund detail code associated with the transaction, valid in TBBDETC. VARCHAR2(4) Required
	p_desc	Free-Form description associated with the transaction. Default value comes from the Detail Code description (TBBDETC). VARCHAR2(30)
	p_amount	Amount of the transaction. NUMBER(12,2) Required
	p_user_id	ID of the user processing the transaction. VARCHAR2(30)
	p_data_origin	Source system processing the transaction. VARCHAR2(30)

p_overpay_to_student

Procedure p_overpay_to_student(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_detail_code      tbbdetc.tbbdetc_detail_code%TYPE,
                               p_desc             tbbdetc.tbbdetc_desc%TYPE DEFAULT NULL,
                               p_amount           tbrcpdt.tbrcpdt_amount%TYPE,
                               p_user_id          tbrcpdt.tbrcpdt_user_id%TYPE DEFAULT gb_common.f_sct_user,
                               p_data_origin      tbrcpdt.tbrcpdt_data_origin%TYPE DEFAULT NULL)

Transfers credit to Student.

Procedure will create a Payment on Student account, with off-setting Payment reversal on the Contract account. Cross-reference PIDM and transaction number paid are populated, and the Payment Detail is processed through Application of Payments.

Note that any process which calls this procedure is responsible for committing the changes made.

Parameters

	p_cont_pidm	Internal Identification Number of the contract sponsor who has made payment. NUMBER(8) Required
	p_cont_tran_number	Transaction number of the payment in the sponsor receivable account. NUMBER(8) Required
	p_tran_number	Transaction number assigned to the payment detail record. NUMBER(8) Required
	p_detail_code	Payment detail code for the transaction, valid in TBBDETC. VARCHAR2(4) Required
	p_desc	Free-Form description associated with the transaction. Default value comes from the Detail Code description (TBBDETC). VARCHAR2(30)
	p_amount	Amount of the transaction. NUMBER(12,2) Required
	p_user_id	ID of the user processing the transaction. VARCHAR2(30)
	p_data_origin	Source system processing the transaction. VARCHAR2(30)

p_update

Procedure p_update(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 dml_common.f_unspecified_number,
                   p_term_code        tbrcpdt.tbrcpdt_term_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_contract_number  tbrcpdt.tbrcpdt_contract_number%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_amount           tbrcpdt.tbrcpdt_amount%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_balance          tbrcpdt.tbrcpdt_balance%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_rfnd_stdn_amt    tbrcpdt.tbrcpdt_rfnd_stdn_amt%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_rfnd_cont_amt    tbrcpdt.tbrcpdt_rfnd_cont_amt%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_name_provided    tbrcpdt.tbrcpdt_name_provided%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_tran_number_paid tbrcpdt.tbrcpdt_tran_number_paid%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_final_ind        tbrcpdt.tbrcpdt_final_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_refund_ind       tbrcpdt.tbrcpdt_refund_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_user_id          tbrcpdt.tbrcpdt_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_data_origin      tbrcpdt.tbrcpdt_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_rowid            gb_common.internal_record_id_type DEFAULT NULL)

Updates a 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)

p_contract_number

Contract number for which payment has been made. NUMBER(8)

p_amount

Amount of the payment. NUMBER(12,2)

p_balance

Remaining balance of the payment that has not been applied to charges. NUMBER(12,2)

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 (informational only). VARCHAR2(1)

	Y	Contract payment is last one expected for the student
	N	Additional contract payment may be received (default)

p_refund_ind

Indicates if overage may be given to student, or should be returned to sponsor (informational only). VARCHAR2(1)

	Y	Overpayment may be credited to the student
	N	Have not recorded permission to credit overpayment to student (default)

p_user_id

The Oracle ID for the user who created or last updated the record. VARCHAR2(30) Required

p_data_origin

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

p_rowid

Database ROWID of the record to be updated. VARCHAR2(18)