index

Package tp_student_receivable

Process APIs related to student accounts receivable.
 
Description
 
StudentAccountTransaction is intended to allow an external system to request that a charge or payment be recorded on a student account in SCT Banner.  This can be used when charges are calculated or payments are received in an external system, but the institution prefers to keep a consolidated student accounts receivable history in the SCT Banner database.
 
 
Operations
 
The AddStudentAccountTransaction message will be used to request that a transaction record be added to a student's Accounts Receivable history in SCT Banner.  The message includes elements required to create this record.  Only one transaction is permitted in each message.
 
A ConfirmAddStudentAccountTransaction response message is returned if the transaction is successfully added to the student's account in SCT Banner.

Program units
f_add_stdn_acct_trans   Service API to add a student account transaction, no Context.
f_add_stdn_acct_trans_source   Service API to add a student account transaction, Context to enable the Source Code used.
f_add_stdn_acct_trans_system   Service API to add a student account transaction, Context for generated System Transactions.
f_add_stdn_acct_trans   Process API to add a student account transaction.

f_add_stdn_acct_trans 

Function f_add_stdn_acct_trans(p_xt xmltype) RETURN CLOB

Service API to add a student account transaction, no Context.

Parameters
p_xt   Request message to add a student account transaction. XMLTYPE.

Returns
CLOB containing response message in XML format. CLOB.

f_add_stdn_acct_trans_source 

Function f_add_stdn_acct_trans_source(p_xt xmltype) RETURN CLOB

Service API to add a student account transaction, Context to enable the Source Code used.

Parameters
p_xt   Request message to add a student account transaction. XMLTYPE.

Returns
CLOB containing response message in XML format. CLOB.

f_add_stdn_acct_trans_system 

Function f_add_stdn_acct_trans_system(p_xt xmltype) RETURN CLOB

Service API to add a student account transaction, Context for generated System Transactions.

Parameters
p_xt   Request message to add a student account transaction. XMLTYPE.

Returns
CLOB containing response message in XML format. CLOB.

f_add_stdn_acct_trans 

Function f_add_stdn_acct_trans(p_request_oot dar_stdn_account_trans,
                               p_set_context VARCHAR2 DEFAULT NULL)
  RETURN uwx_confirm_add_stdn_acct_tran

Process API to add a student account transaction.
 
A transaction will be created via the Receivable API, using the Context if specified.

Parameters
p_request_oot   Request to add student account transaction. DAR_STDN_ACCOUNT_TRANS
p_set_context   Context under which transaction is processed, null sets no Context. VARCHAR2
SYSTEM   - Invoke Context SYSTEM_TRAN=TRUE
SOURCE   - Invoke Context ENABLE_SOURCE for the Source Code being processed


Returns
Response message in OOT format. UWX_CONFIRM_ADD_STDN_ACCT_TRAN