index

Package rp_appl_prds_btyp

Common Business logic interface for the APPL_PRDS_BTYP API (rp_appl_prds_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_delete   Deletes a record.

f_exists 

Function f_exists(p_aidy_code rbrapbt.rbrapbt_aidy_code%TYPE,
                  p_pidm      rbrapbt.rbrapbt_pidm%TYPE,
                  p_run_name  rbrapbt.rbrapbt_run_name%TYPE DEFAULT rb_budget_run.M_ACTUAL_RUN,
                  p_pbtp_code rbrapbt.rbrapbt_pbtp_code%TYPE,
                  p_period    rbrapbt.rbrapbt_period%TYPE) 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_run_name   The name to uniquely identify the run of period budgeting that produced this record. VARCHAR2(30)
p_pbtp_code   The period budget type assigned to the applicant. VARCHAR2(4) Required Key
p_period   The period associated with information in this record. VARCHAR2(15) Required Key

Returns
Y if found, otherwise N.

f_query_all 

Function f_query_all(p_aidy_code rbrapbt.rbrapbt_aidy_code%TYPE,
                     p_pidm      rbrapbt.rbrapbt_pidm%TYPE,
                     p_run_name  rbrapbt.rbrapbt_run_name%TYPE DEFAULT rb_budget_run.M_ACTUAL_RUN,
                     p_pbtp_code rbrapbt.rbrapbt_pbtp_code%TYPE DEFAULT NULL,
                     p_period    rbrapbt.rbrapbt_period%TYPE DEFAULT NULL)
  RETURN rb_appl_prds_btyp.appl_prds_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_run_name   The name to uniquely identify the run of period budgeting that produced this record. VARCHAR2(30)
p_pbtp_code   The period budget type assigned to the applicant. VARCHAR2(4)
p_period   The period associated with information in this record. VARCHAR2(15)

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

f_query_one 

Function f_query_one(p_aidy_code rbrapbt.rbrapbt_aidy_code%TYPE,
                     p_pidm      rbrapbt.rbrapbt_pidm%TYPE,
                     p_run_name  rbrapbt.rbrapbt_run_name%TYPE DEFAULT rb_budget_run.M_ACTUAL_RUN,
                     p_pbtp_code rbrapbt.rbrapbt_pbtp_code%TYPE,
                     p_period    rbrapbt.rbrapbt_period%TYPE)
  RETURN rb_appl_prds_btyp.appl_prds_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_run_name   The name to uniquely identify the run of period budgeting that produced this record. VARCHAR2(30)
p_pbtp_code   The period budget type assigned to the applicant. VARCHAR2(4) Required Key
p_period   The period associated with information in this record. VARCHAR2(15) Required Key

Returns
A cursor variable that will fetch exactly one record.

p_create 

Procedure p_create(p_aidy_code   rbrapbt.rbrapbt_aidy_code%TYPE,
                   p_pidm        rbrapbt.rbrapbt_pidm%TYPE,
                   p_run_name    rbrapbt.rbrapbt_run_name%TYPE DEFAULT rb_budget_run.M_ACTUAL_RUN,
                   p_pbtp_code   rbrapbt.rbrapbt_pbtp_code%TYPE,
                   p_period      rbrapbt.rbrapbt_period%TYPE,
                   p_sys_ind     rbrapbt.rbrapbt_sys_ind%TYPE DEFAULT NULL,
                   p_user_id     rbrapbt.rbrapbt_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_data_origin rbrapbt.rbrapbt_data_origin%TYPE DEFAULT gb_common.DATA_ORIGIN)

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_run_name   The name to uniquely identify the run of period budgeting that produced this record. VARCHAR2(30)
p_pbtp_code   The period budget type assigned to the applicant. VARCHAR2(4) Required Key
p_period   The period associated with information in this record. VARCHAR2(15) Required Key
p_sys_ind   Indicates how the type was created. VARCHAR2(1)
p_user_id   The user ID of the person who inserted or last updated this record. VARCHAR2(30)
p_data_origin   The latest source for the data contained in this record. VARCHAR2(30)

p_delete 

Procedure p_delete(p_aidy_code rbrapbt.rbrapbt_aidy_code%TYPE,
                   p_pidm      rbrapbt.rbrapbt_pidm%TYPE,
                   p_run_name  rbrapbt.rbrapbt_run_name%TYPE DEFAULT rb_budget_run.M_ACTUAL_RUN,
                   p_pbtp_code rbrapbt.rbrapbt_pbtp_code%TYPE,
                   p_period    rbrapbt.rbrapbt_period%TYPE)

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_run_name   The name to uniquely identify the run of period budgeting that produced this record. VARCHAR2(30)
p_pbtp_code   The period budget type assigned to the applicant. VARCHAR2(4) Required Key
p_period   The period associated with information in this record. VARCHAR2(15) Required Key