index

Package RP_APPL_AIDY_BTYP

Common Business interface for the APPL_AIDY_BTYP API (rb_appl_aidy_btyp).

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_create   Creates a record.
p_update   Updates a record.
p_delete   Deletes a record.

f_exists 

Function f_exists(p_aidy_code rbbabud.rbbabud_aidy_code%TYPE,
                  p_pidm      rbbabud.rbbabud_pidm%TYPE,
                  p_btyp_code rbbabud.rbbabud_btyp_code%TYPE,
                  p_tfc_ind   rbbabud.rbbabud_tfc_ind%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 associated with information in this record. VARCHAR2(4) Required Key
p_pidm   The internal system student identification number. NUMBER(8) Required Key
p_btyp_code   Code indicating which budget types have been associated with the student applicant. VARCHAR2(4) Required Key
p_tfc_ind   Indicator to show which Expected Family Contribution is to be used for this student when calculating need. VARCHAR2(1) Required 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 rbbabud.rbbabud_aidy_code%TYPE,
                     p_pidm      rbbabud.rbbabud_pidm%TYPE,
                     p_btyp_code rbbabud.rbbabud_btyp_code%TYPE DEFAULT NULL,
                     p_tfc_ind   rbbabud.rbbabud_tfc_ind%TYPE DEFAULT NULL)
  RETURN rb_appl_aidy_btyp.appl_aidy_btyp_ref

Selects all records for the entity.

Parameters
p_aidy_code   The aid year associated with information in this record. VARCHAR2(4) Required Key
p_pidm   The internal system student identification number. NUMBER(8) Required Key
p_btyp_code   Code indicating which budget types have been associated with the student applicant. VARCHAR2(4) Required Key
p_tfc_ind   Indicator to show which Expected Family Contribution is to be used for this student when calculating need. VARCHAR2(1) Required Key

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

f_query_one 

Function f_query_one(p_aidy_code rbbabud.rbbabud_aidy_code%TYPE,
                     p_pidm      rbbabud.rbbabud_pidm%TYPE,
                     p_btyp_code rbbabud.rbbabud_btyp_code%TYPE,
                     p_tfc_ind   rbbabud.rbbabud_tfc_ind%TYPE)
  RETURN rb_appl_aidy_btyp.appl_aidy_btyp_ref

Selects one record using key.

Parameters
p_aidy_code   The aid year associated with information in this record. VARCHAR2(4) Required Key
p_pidm   The internal system student identification number. NUMBER(8) Required Key
p_btyp_code   Code indicating which budget types have been associated with the student applicant. VARCHAR2(4) Required Key
p_tfc_ind   Indicator to show which Expected Family Contribution is to be used for this student when calculating need. VARCHAR2(1) Required Key

Returns
A cursor variable that will fetch exactly one record.

p_create 

Procedure p_create(p_aidy_code       rbbabud.rbbabud_aidy_code%TYPE,
                   p_pidm            rbbabud.rbbabud_pidm%TYPE,
                   p_tfc_ind         rbbabud.rbbabud_tfc_ind%TYPE,
                   p_btyp_code       rbbabud.rbbabud_btyp_code%TYPE,
                   p_user_id         rbbabud.rbbabud_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_sys_ind         rbbabud.rbbabud_sys_ind%TYPE,
                   p_info_access_ind rbbabud.rbbabud_info_access_ind%TYPE,
                   p_data_origin     rbbabud.rbbabud_data_origin%TYPE DEFAULT NULL,
                   p_rowid_out       OUT gb_common.internal_record_id_type)

Creates a record.

Parameters
p_aidy_code   The aid year associated with information in this record. VARCHAR2(4) Required Key
p_pidm   The internal system student identification number. NUMBER(8) Required Key
p_tfc_ind   Indicator to show which Expected Family Contribution is to be used for this student when calculating need. VARCHAR2(1) Required Key
p_btyp_code   Code indicating which budget types have been associated with the student applicant. VARCHAR2(4) Required Key
p_user_id   The user ID of the person who inserted or last updated this record. VARCHAR2(30)
p_sys_ind   Indicator to show if the student's budget type was assigned (M)anually or by the (S)ystem. VARCHAR2(1) Required
p_info_access_ind   Indicates if budget information for this applicant may be accessed via Banner Web.  This indicator is used in conjunction with the Null Info Access Indicator Rule column in the Web Rules table. VARCHAR2(1) Required
p_data_origin   Source system that created or updated the data. VARCHAR2(30)
p_rowid_out   Database ROWID of the record to be created. VARCHAR2(18) Required

p_update 

Procedure p_update(p_aidy_code       rbbabud.rbbabud_aidy_code%TYPE,
                   p_pidm            rbbabud.rbbabud_pidm%TYPE,
                   p_tfc_ind         rbbabud.rbbabud_tfc_ind%TYPE,
                   p_btyp_code       rbbabud.rbbabud_btyp_code%TYPE,
                   p_user_id         rbbabud.rbbabud_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_sys_ind         rbbabud.rbbabud_sys_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_info_access_ind rbbabud.rbbabud_info_access_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_data_origin     rbbabud.rbbabud_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_rowid           gb_common.internal_record_id_type DEFAULT NULL)

Updates a record.

Parameters
p_aidy_code   The aid year associated with information in this record. VARCHAR2(4) Required Key
p_pidm   The internal system student identification number. NUMBER(8) Required Key
p_tfc_ind   Indicator to show which Expected Family Contribution is to be used for this student when calculating need. VARCHAR2(1) Required Key
p_btyp_code   Code indicating which budget types have been associated with the student applicant. VARCHAR2(4) Required Key
p_user_id   The user ID of the person who inserted or last updated this record. VARCHAR2(30)
p_sys_ind   Indicator to show if the student's budget type was assigned (M)anually or by the (S)ystem. VARCHAR2(1) Required
p_info_access_ind   Indicates if budget information for this applicant may be accessed via Banner Web.  This indicator is used in conjunction with the Null Info Access Indicator Rule column in the Web Rules table. VARCHAR2(1) Required
p_data_origin   Source system that created or updated the data. VARCHAR2(30)
p_rowid   Database ROWID of the record to be updated. VARCHAR2(18)

p_delete 

Procedure p_delete(p_aidy_code rbbabud.rbbabud_aidy_code%TYPE,
                   p_pidm      rbbabud.rbbabud_pidm%TYPE,
                   p_btyp_code rbbabud.rbbabud_btyp_code%TYPE,
                   p_tfc_ind   rbbabud.rbbabud_tfc_ind%TYPE,
                   p_rowid     gb_common.internal_record_id_type DEFAULT NULL)

Deletes a record.

Parameters
p_aidy_code   The aid year associated with information in this record. VARCHAR2(4) Required Key
p_pidm   The internal system student identification number. NUMBER(8) Required Key
p_btyp_code   Code indicating which budget types have been associated with the student applicant. VARCHAR2(4) Required Key
p_tfc_ind   Indicator to show which Expected Family Contribution is to be used for this student when calculating need. VARCHAR2(1) Required Key
p_rowid   Database ROWID of the record to be deleted. VARCHAR2(18)