index

Package rp_appl_dl_mpn_req

Common Business logic interface for the Applicant Direct Loan Master Promissory Note Requirement Business Process API (rp_appl_dl_mpn_req).

Program units
f_exists   Checks if a record exists.
f_query_all   Selects all records for the entity.
f_query_one   Selects one record using key.
p_update   Updates a record.

f_exists 

Function f_exists(p_aidy_code rlrdmpr.rlrdmpr_aidy_code%TYPE,
                  p_pidm      rlrdmpr.rlrdmpr_pidm%TYPE,
                  p_mpn_type  rlrdmpr.rlrdmpr_mpn_type%TYPE,
                  p_loan_no   rlrdmpr.rlrdmpr_loan_no%TYPE,
                  p_rowid     gb_common.internal_record_id_type DEFAULT NULL)
  RETURN VARCHAR2

Checks if a record exists.

Parameters
p_aidy_code   The aid year to be associated with the information in this record. VARCHAR2(4) Required Key
p_pidm   The internal system student identification number. NUMBER(8) Required Key
p_mpn_type   The type of loan to which this MPN applies. VARCHAR2(1) Required Key
p_loan_no   The loan number associated with this record. NUMBER(4) Key
p_rowid   Database ROWID of the record to be selected. VARCHAR2(18)

Returns
Y if found, otherwise N.

f_query_all 

Function f_query_all(p_aidy_code rlrdmpr.rlrdmpr_aidy_code%TYPE,
                     p_pidm      rlrdmpr.rlrdmpr_pidm%TYPE,
                     p_mpn_type  rlrdmpr.rlrdmpr_mpn_type%TYPE,
                     p_loan_no   rlrdmpr.rlrdmpr_loan_no%TYPE)
  RETURN rb_appl_dl_mpn_req.appl_dl_mpn_req_ref

Selects all records for the entity.

Parameters
p_aidy_code   The aid year to be associated with the information in this record. VARCHAR2(4) Required Key
p_pidm   The internal system student identification number. NUMBER(8) Required Key
p_mpn_type   The type of loan to which this MPN applies. VARCHAR2(1) Required Key
p_loan_no   The loan number associated with this record. NUMBER(4) Key

Returns
A cursor variable that will fetch a set of records.

f_query_one 

Function f_query_one(p_aidy_code rlrdmpr.rlrdmpr_aidy_code%TYPE,
                     p_pidm      rlrdmpr.rlrdmpr_pidm%TYPE,
                     p_mpn_type  rlrdmpr.rlrdmpr_mpn_type%TYPE,
                     p_loan_no   rlrdmpr.rlrdmpr_loan_no%TYPE)
  RETURN rb_appl_dl_mpn_req.appl_dl_mpn_req_ref

Selects one record using key.

Parameters
p_aidy_code   The aid year to be associated with the information in this record. VARCHAR2(4) Required Key
p_pidm   The internal system student identification number. NUMBER(8) Required Key
p_mpn_type   The type of loan to which this MPN applies. VARCHAR2(1) Required Key
p_loan_no   The loan number associated with this record. NUMBER(4) Key

Returns
A cursor variable that will fetch exactly one record.

p_update 

Procedure p_update(p_aidy_code       rlrdmpr.rlrdmpr_aidy_code%TYPE,
                   p_pidm            rlrdmpr.rlrdmpr_pidm%TYPE,
                   p_mpn_type        rlrdmpr.rlrdmpr_mpn_type%TYPE,
                   p_loan_no         rlrdmpr.rlrdmpr_loan_no%TYPE,
                   p_trk_ltr_ind     rlrdmpr.rlrdmpr_trk_ltr_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_info_access_ind rlrdmpr.rlrdmpr_info_access_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_instructions    rlrdmpr.rlrdmpr_instructions%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_data_origin     rlrdmpr.rlrdmpr_data_origin%TYPE DEFAULT dml_common.f_unspecified_string)

Updates a record.

Parameters
p_aidy_code   The aid year to be associated with the information in this record. VARCHAR2(4) Required Key
p_pidm   The internal system student identification number. NUMBER(8) Required Key
p_mpn_type   The type of loan to which this MPN applies. VARCHAR2(1) Required Key
p_loan_no   The loan number associated with this record. NUMBER(4) Key
p_trk_ltr_ind   Indicates that a tracking letter should be generated for this MPN requirement. VARCHAR2(1) Required
p_info_access_ind   Identifies which promissory notes can display in Self-Service. VARCHAR2(1) Required
p_instructions   Instructions for the promissory note that will be displayed for the student in Self-Service. VARCHAR2(2000)
p_data_origin   The latest source for the data contained in this record. VARCHAR2(30)