index

Package rp_appl_prds_bgrp


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 rbrapbg.rbrapbg_aidy_code%TYPE,
                  p_pidm      rbrapbg.rbrapbg_pidm%TYPE,
                  p_run_name  rbrapbg.rbrapbg_run_name%TYPE DEFAULT RB_BUDGET_RUN.M_ACTUAL_RUN,
                  p_period    rbrapbg.rbrapbg_period%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_run_name   The name to uniquely identify the run of period budgeting that produced this record. VARCHAR2(30) Required Key
p_period   The period associated with information in this record. VARCHAR2(15) 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 rbrapbg.rbrapbg_aidy_code%TYPE,
                     p_pidm      rbrapbg.rbrapbg_pidm%TYPE,
                     p_run_name  rbrapbg.rbrapbg_run_name%TYPE DEFAULT RB_BUDGET_RUN.M_ACTUAL_RUN,
                     p_period    rbrapbg.rbrapbg_period%TYPE DEFAULT NULL)
  RETURN rb_appl_prds_bgrp.appl_prds_bgrp_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_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 rbrapbg.rbrapbg_aidy_code%TYPE,
                     p_pidm      rbrapbg.rbrapbg_pidm%TYPE,
                     p_run_name  rbrapbg.rbrapbg_run_name%TYPE DEFAULT RB_BUDGET_RUN.M_ACTUAL_RUN,
                     p_period    rbrapbg.rbrapbg_period%TYPE)
  RETURN rb_appl_prds_bgrp.appl_prds_bgrp_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_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          rbrapbg.rbrapbg_aidy_code%TYPE,
                   p_pidm               rbrapbg.rbrapbg_pidm%TYPE,
                   p_run_name           rbrapbg.rbrapbg_run_name%TYPE DEFAULT rb_budget_run.m_actual_run,
                   p_period             rbrapbg.rbrapbg_period%TYPE,
                   p_pbgp_code_lock_ind rbrapbg.rbrapbg_pbgp_code_lock_ind%TYPE DEFAULT NULL,
                   p_budget_freeze_ind  rbrapbg.rbrapbg_budget_freeze_ind%TYPE DEFAULT NULL,
                   p_pbgp_code          rbrapbg.rbrapbg_pbgp_code%TYPE DEFAULT NULL,
                   p_user_id            rbrapbg.rbrapbg_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_data_origin        rbrapbg.rbrapbg_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_period   The period associated with information in this record. VARCHAR2(15) Required Key
p_pbgp_code_lock_ind   Identifies whether the budget group is locked preventing further updates to the group code. VARCHAR2(1)
p_budget_freeze_ind   Identifies whether the period budget is frozen preventing further updates. VARCHAR2(1)
p_pbgp_code   The period budget group assigned to the applicant. VARCHAR2(6)
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_update 

Procedure p_update(p_aidy_code          rbrapbg.rbrapbg_aidy_code%TYPE,
                   p_pidm               rbrapbg.rbrapbg_pidm%TYPE,
                   p_run_name           rbrapbg.rbrapbg_run_name%TYPE DEFAULT rb_budget_run.m_actual_run,
                   p_period             rbrapbg.rbrapbg_period%TYPE,
                   p_pbgp_code_lock_ind rbrapbg.rbrapbg_pbgp_code_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_budget_freeze_ind  rbrapbg.rbrapbg_budget_freeze_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pbgp_code          rbrapbg.rbrapbg_pbgp_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_user_id            rbrapbg.rbrapbg_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_data_origin        rbrapbg.rbrapbg_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_period   The period associated with information in this record. VARCHAR2(15) Required Key
p_pbgp_code_lock_ind   Identifies whether the budget group is locked preventing further updates to the group code. VARCHAR2(1)
p_budget_freeze_ind   Identifies whether the period budget is frozen preventing further updates. VARCHAR2(1)
p_pbgp_code   The period budget group assigned to the applicant. VARCHAR2(6)
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 rbrapbg.rbrapbg_aidy_code%TYPE,
                   p_pidm      rbrapbg.rbrapbg_pidm%TYPE,
                   p_run_name  rbrapbg.rbrapbg_run_name%TYPE DEFAULT RB_BUDGET_RUN.M_ACTUAL_RUN,
                   p_period    rbrapbg.rbrapbg_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_period   The period associated with information in this record. VARCHAR2(15) Required Key