index

Package rp_appl_prds_comp

Common Business interface for the APPL_PRDS_COMP API (rp_appl_prds_comp).

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.
p_update   Updates a record.

f_exists 

Function f_exists(p_aidy_code rbrapbc.rbrapbc_aidy_code%TYPE,
                  p_pidm      rbrapbc.rbrapbc_pidm%TYPE,
                  p_run_name  rbrapbc.rbrapbc_run_name%TYPE DEFAULT rb_budget_run.M_ACTUAL_RUN,
                  p_pbtp_code rbrapbc.rbrapbc_pbtp_code%TYPE,
                  p_period    rbrapbc.rbrapbc_period%TYPE,
                  p_pbcp_code rbrapbc.rbrapbc_pbcp_code%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
p_pbcp_code   The period budget component assigned to the applicant. VARCHAR2(4) Required Key

Returns
Y if found, otherwise N.

f_query_all 

Function f_query_all(p_aidy_code rbrapbc.rbrapbc_aidy_code%TYPE,
                     p_pidm      rbrapbc.rbrapbc_pidm%TYPE,
                     p_run_name  rbrapbc.rbrapbc_run_name%TYPE DEFAULT rb_budget_run.M_ACTUAL_RUN,
                     p_pbtp_code rbrapbc.rbrapbc_pbtp_code%TYPE DEFAULT NULL,
                     p_period    rbrapbc.rbrapbc_period%TYPE DEFAULT NULL,
                     p_pbcp_code rbrapbc.rbrapbc_pbcp_code%TYPE DEFAULT NULL)
  RETURN rb_appl_prds_comp.appl_prds_comp_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)
p_pbcp_code   The period budget component assigned to the applicant. VARCHAR2(4)

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

f_query_one 

Function f_query_one(p_aidy_code rbrapbc.rbrapbc_aidy_code%TYPE,
                     p_pidm      rbrapbc.rbrapbc_pidm%TYPE,
                     p_run_name  rbrapbc.rbrapbc_run_name%TYPE DEFAULT rb_budget_run.M_ACTUAL_RUN,
                     p_pbtp_code rbrapbc.rbrapbc_pbtp_code%TYPE,
                     p_period    rbrapbc.rbrapbc_period%TYPE,
                     p_pbcp_code rbrapbc.rbrapbc_pbcp_code%TYPE)
  RETURN rb_appl_prds_comp.appl_prds_comp_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
p_pbcp_code   The period budget component assigned to the applicant. VARCHAR2(4) Required Key

Returns
A cursor variable that will fetch exactly one record.

p_create 

Procedure p_create(p_aidy_code   rbrapbc.rbrapbc_aidy_code%TYPE,
                   p_pidm        rbrapbc.rbrapbc_pidm%TYPE,
                   p_run_name    rbrapbc.rbrapbc_run_name%TYPE DEFAULT rb_budget_run.M_ACTUAL_RUN,
                   p_pbtp_code   rbrapbc.rbrapbc_pbtp_code%TYPE,
                   p_period      rbrapbc.rbrapbc_period%TYPE,
                   p_pbcp_code   rbrapbc.rbrapbc_pbcp_code%TYPE,
                   p_amt         rbrapbc.rbrapbc_amt%TYPE,
                   p_sys_ind     rbrapbc.rbrapbc_sys_ind%TYPE DEFAULT NULL,
                   p_abrc_code   rbrapbc.rbrapbc_abrc_code%TYPE DEFAULT NULL,
                   p_seq_no      rbrapbc.rbrapbc_seq_no%TYPE DEFAULT NULL,
                   p_user_id     rbrapbc.rbrapbc_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_data_origin rbrapbc.rbrapbc_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_pbcp_code   The period budget component assigned to the applicant. VARCHAR2(4) Required Key
p_amt   The amount of the specific budget component for the budget being defined. NUMBER(11,2) Required
p_sys_ind   Indicates how the component was created. VARCHAR2(1) Required
p_abrc_code   The rule code used to calculate the period budget component amount. VARCHAR2(30)
p_seq_no   The sequence number of the rule code used to calculate the period budget component amount. NUMBER(5)
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 rbrapbc.rbrapbc_aidy_code%TYPE,
                   p_pidm      rbrapbc.rbrapbc_pidm%TYPE,
                   p_run_name  rbrapbc.rbrapbc_run_name%TYPE DEFAULT rb_budget_run.M_ACTUAL_RUN,
                   p_pbtp_code rbrapbc.rbrapbc_pbtp_code%TYPE,
                   p_period    rbrapbc.rbrapbc_period%TYPE,
                   p_pbcp_code rbrapbc.rbrapbc_pbcp_code%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
p_pbcp_code   The period budget component assigned to the applicant. VARCHAR2(4) Required Key

p_update 

Procedure p_update(p_aidy_code   rbrapbc.rbrapbc_aidy_code%TYPE,
                   p_pidm        rbrapbc.rbrapbc_pidm%TYPE,
                   p_run_name    rbrapbc.rbrapbc_run_name%TYPE DEFAULT rb_budget_run.M_ACTUAL_RUN,
                   p_pbtp_code   rbrapbc.rbrapbc_pbtp_code%TYPE,
                   p_period      rbrapbc.rbrapbc_period%TYPE,
                   p_pbcp_code   rbrapbc.rbrapbc_pbcp_code%TYPE,
                   p_amt         rbrapbc.rbrapbc_amt%TYPE,
                   p_sys_ind     rbrapbc.rbrapbc_sys_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_abrc_code   rbrapbc.rbrapbc_abrc_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_seq_no      rbrapbc.rbrapbc_seq_no%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_user_id     rbrapbc.rbrapbc_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_data_origin rbrapbc.rbrapbc_data_origin%TYPE DEFAULT dml_common.f_unspecified_string)

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_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_pbcp_code   The period budget component assigned to the applicant. VARCHAR2(4) Required Key
p_amt   The amount of the specific budget component for the budget being defined. NUMBER(11,2) Required
p_sys_ind   Indicates how the component was created. VARCHAR2(1) Required
p_abrc_code   The rule code used to calculate the period budget component amount. VARCHAR2(30)
p_seq_no   The sequence number of the rule code used to calculate the period budget component amount. NUMBER(5)
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)