|
Package rp_applicant_status AUDIT_TRAIL_MSGKEY_UPDATEPROJECT : MSGKEY MODULE : ROKP_APPL_STATUS0 SOURCE : enUS TARGET : I18N DATE : Wed Jul 30 14:25:04 2014 MSGSIGN : #0000000000000000 TMI18N.ETR DO NOT CHANGE-- |
| Program units |
| f_api_version | Returns the API version number. |
| f_exists | Checks if a record exists. |
| f_query_all | Selects all records for the entity. |
| f_query_one | Selects one record using the key. |
| p_create | Creates a record. |
| p_update | Updates a record. |
f_api_version
Function f_api_version RETURN PLS_INTEGER
Returns the API version number.
| Returns |
|
Version of the API signature. Changes only when the signature changes. |
f_exists
Function f_exists(p_aidy_code rorstat.rorstat_aidy_code%TYPE,
p_pidm rorstat.rorstat_pidm%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_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 rorstat.rorstat_aidy_code%TYPE,
p_pidm rorstat.rorstat_pidm%TYPE)
RETURN rb_applicant_status.applicant_status_ref
Selects all records for the entity.
- If only an aid year code is entered, all applicant status records for the aid year will be returned.
- If only a pidm is entered, all applicant status records for the pidm will be returned.
| Parameters |
| p_aidy_code |
The aid year associated with information in this record. VARCHAR2(4) | |
| p_pidm |
The internal system student identification number. NUMBER(8) |
| Returns |
|
A cursor variable that will fetch a set of records. |
f_query_one
Function f_query_one(p_aidy_code rorstat.rorstat_aidy_code%TYPE,
p_pidm rorstat.rorstat_pidm%TYPE)
RETURN rb_applicant_status.applicant_status_ref
Selects one record using the 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 |
| Returns |
|
A cursor variable that will fetch exactly one record. |
p_create
Procedure p_create(p_aidy_code rorstat.rorstat_aidy_code%TYPE,
p_pidm rorstat.rorstat_pidm%TYPE,
p_lock_ind rorstat.rorstat_lock_ind%TYPE DEFAULT NULL,
p_pgrp_lock_ind rorstat.rorstat_pgrp_lock_ind%TYPE DEFAULT NULL,
p_bgrp_proc_ind rorstat.rorstat_bgrp_proc_ind%TYPE DEFAULT NULL,
p_pgrp_proc_ind rorstat.rorstat_pgrp_proc_ind%TYPE DEFAULT NULL,
p_tgrp_proc_ind rorstat.rorstat_tgrp_proc_ind%TYPE DEFAULT NULL,
p_pckg_fund_proc_ind rorstat.rorstat_pckg_fund_proc_ind%TYPE DEFAULT NULL,
p_ver_complete rorstat.rorstat_ver_complete%TYPE DEFAULT NULL,
p_ver_pay_ind rorstat.rorstat_ver_pay_ind%TYPE DEFAULT NULL,
p_aprd_code rorstat.rorstat_aprd_code%TYPE DEFAULT NULL,
p_pgrp_code rorstat.rorstat_pgrp_code%TYPE DEFAULT NULL,
p_tgrp_code rorstat.rorstat_tgrp_code%TYPE DEFAULT NULL,
p_recalc_na_ind rorstat.rorstat_recalc_na_ind%TYPE DEFAULT NULL,
p_appl_rcvd_date rorstat.rorstat_appl_rcvd_date%TYPE DEFAULT NULL,
p_pckg_comp_date rorstat.rorstat_pckg_comp_date%TYPE DEFAULT NULL,
p_pri_sar_pgi rorstat.rorstat_pri_sar_pgi%TYPE DEFAULT NULL,
p_sec_sar_pgi rorstat.rorstat_sec_sar_pgi%TYPE DEFAULT NULL,
p_sar_date rorstat.rorstat_sar_date%TYPE DEFAULT NULL,
p_sar_tran_no rorstat.rorstat_sar_tran_no%TYPE DEFAULT NULL,
p_sar_ssn rorstat.rorstat_sar_ssn%TYPE DEFAULT NULL,
p_sar_init rorstat.rorstat_sar_init%TYPE DEFAULT NULL,
p_cm_sc_lock_ind rorstat.rorstat_cm_sc_lock_ind%TYPE DEFAULT NULL,
p_cm_pc_lock_ind rorstat.rorstat_cm_pc_lock_ind%TYPE DEFAULT NULL,
p_cm_tfc_lock_ind rorstat.rorstat_cm_tfc_lock_ind%TYPE DEFAULT NULL,
p_pgi_lock_ind rorstat.rorstat_pgi_lock_ind%TYPE DEFAULT NULL,
p_inst_sc_lock_ind rorstat.rorstat_inst_sc_lock_ind%TYPE DEFAULT NULL,
p_inst_pc_lock_ind rorstat.rorstat_inst_pc_lock_ind%TYPE DEFAULT NULL,
p_awd_ltr_ind rorstat.rorstat_awd_ltr_ind%TYPE DEFAULT NULL,
p_trk_ltr_ind rorstat.rorstat_trk_ltr_ind%TYPE DEFAULT NULL,
p_addl_stfd_elig_ind rorstat.rorstat_addl_stfd_elig_ind%TYPE DEFAULT NULL,
p_im_lock rorstat.rorstat_im_lock%TYPE DEFAULT NULL,
p_fm_batch_lock rorstat.rorstat_fm_batch_lock%TYPE DEFAULT NULL,
p_im_batch_lock rorstat.rorstat_im_batch_lock%TYPE DEFAULT NULL,
p_nslds_ovrd_ind rorstat.rorstat_nslds_ovrd_ind%TYPE DEFAULT NULL,
p_former_heal_ind rorstat.rorstat_former_heal_ind%TYPE DEFAULT NULL,
p_pell_lt_half_coa rorstat.rorstat_pell_lt_half_coa%TYPE DEFAULT NULL,
p_info_access_ind rorstat.rorstat_info_access_ind%TYPE DEFAULT NULL,
p_borrower_based_cde rorstat.rorstat_borrower_based_cde%TYPE DEFAULT NULL,
p_pell_orig_ind rorstat.rorstat_pell_orig_ind%TYPE DEFAULT NULL,
p_pell_disb_lock_ind rorstat.rorstat_pell_disb_lock_ind%TYPE DEFAULT NULL,
p_post_ba_pell_ovrd rorstat.rorstat_post_ba_pell_ovrd%TYPE DEFAULT NULL,
p_sub_loan_excl_amt rorstat.rorstat_sub_loan_excl_amt%TYPE DEFAULT NULL,
p_tgrp_code_lock_ind rorstat.rorstat_tgrp_code_lock_ind%TYPE DEFAULT NULL,
p_bgrp_code_lock_ind rorstat.rorstat_bgrp_code_lock_ind%TYPE DEFAULT NULL,
p_pgrp_code_lock_ind rorstat.rorstat_pgrp_code_lock_ind%TYPE DEFAULT NULL,
p_turn_off_pell_ind rorstat.rorstat_turn_off_pell_ind%TYPE DEFAULT NULL,
p_data_origin rorstat.rorstat_data_origin%TYPE DEFAULT NULL,
p_prep_or_teach_ind rorstat.rorstat_prep_or_teach_ind%TYPE DEFAULT NULL,
p_acg_disb_lock_ind rorstat.rorstat_acg_disb_lock_ind%TYPE DEFAULT NULL,
p_smart_disb_lock_ind rorstat.rorstat_smart_disb_lock_ind%TYPE DEFAULT NULL,
p_auto_zero_efc_ind rorstat.rorstat_auto_zero_efc_ind%TYPE DEFAULT NULL,
p_dep_no_par_data rorstat.rorstat_dep_no_par_data%TYPE DEFAULT NULL,
p_aprd_code_pell rorstat.rorstat_aprd_code_pell%TYPE DEFAULT NULL,
p_post_911_pell_elig rorstat.rorstat_post_911_pell_elig%TYPE DEFAULT NULL,
p_bgrp_code rorstat.rorstat_bgrp_code%TYPE DEFAULT NULL,
p_pbud_info_access_ind rorstat.rorstat_pbud_info_access_ind%TYPE DEFAULT NULL,
p_high_pell_leu_flag rorstat.rorstat_high_pell_leu_flag%TYPE DEFAULT NULL,
p_ss_info_access_ind rorstat.rorstat_ss_info_access_ind%TYPE DEFAULT NULL,
p_xes rorstat.rorstat_xes%TYPE DEFAULT NULL,
p_xes_algo_code rorstat.rorstat_xes_algo_code%TYPE DEFAULT NULL,
p_xes_seq_no rorstat.rorstat_xes_seq_no%TYPE DEFAULT NULL,
p_xes_lock_ind rorstat.rorstat_xes_lock_ind%TYPE DEFAULT NULL,
p_aprd_algo_code rorstat.rorstat_aprd_algo_code%TYPE DEFAULT NULL,
p_aprd_seq_no rorstat.rorstat_aprd_seq_no%TYPE DEFAULT NULL,
p_aprd_algo_code_pell rorstat.rorstat_aprd_algo_code_pell%TYPE DEFAULT NULL,
p_aprd_seq_no_pell rorstat.rorstat_aprd_seq_no_pell%TYPE DEFAULT NULL,
p_recalc_im_ind rorstat.rorstat_recalc_im_ind%TYPE DEFAULT NULL,
p_im_need_date rorstat.rorstat_im_need_date%TYPE DEFAULT NULL,
p_ovrde_sayr_code rorstat.rorstat_ovrde_sayr_code%TYPE DEFAULT NULL, -- 082201-1
p_ovrde_sayr_algo_code rorstat.rorstat_ovrde_sayr_algo_code%TYPE DEFAULT NULL, -- 082201-1
p_ovrde_sayr_seq_no rorstat.rorstat_ovrde_sayr_seq_no%TYPE DEFAULT NULL -- 082201-1
)
Creates a record.
The following are the minimum parameters required to create an applicant status entry:
P_AIDY_CODE
P_PIDM
A budget group code cannot be supplied when creating an applicant status entry.
This procedure will:
- Create an entry in the Applicant Status Table (RORSTAT).
- If necessary, create an entry in the Satisfactory Academic Progress Rules Table (RORSAPR).
- Create an entry in the Mail Table (GURMAIL) if a corresponding entry was created in the
Satisfactory Academic Progress Rules Table (RORSAPR).
- If necessary, create an entry in the Applicant Non Year User-Defined Data Table (ROBNYUD).
- If necessary, create an entry in the Applicant User-Defined Data Table (ROBUSDF).
- As of the 2014-2015 aid year, create entries in the Applicant Period Status Table (RORPRST) for each
period that exists in the applicant's aid period and the applicant's Pell aid period.
If an aid period code is not supplied the default aid period code associated with the aid year in the Financial Aid Institution Table (ROBINST) will default.
If a tracking group code is supplied, the requirements associated with the tracking group code in the Tracking Group/Requirements Rules Table (RRRGREQ) will be added to the Applicant Requirements Table (RRRAREQ). The Applicant Status Table (RORSTAT) will be updated with the result.
As of the 2014-2015 aid year, the aid year expected enrollment status has been added to the Applicant Status Table.
If the expected enrollment status is not supplied, the default value will be determined by the Default Aid Year Status or calculated using the Default Aid Year Algorithmic Rule Code in the Financial Aid Institution Table (ROBINST).
| 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_lock_ind |
Indicates whether the applicant's Need Analysis record is locked. VARCHAR2(1) | |
| p_pgrp_lock_ind |
Indicates whether the applicant's award package is locked. VARCHAR2(1) | |
| p_bgrp_proc_ind |
Indicates whether the applicant is waiting for batch budget group assignment. VARCHAR2(1) | |
| p_pgrp_proc_ind |
Indicates whether the applicant is waiting for batch packaging group assignment. VARCHAR2(1) | |
| p_tgrp_proc_ind |
Indicates whether the applicant is waiting for batch tracking group assignment. VARCHAR2(1) | |
| p_pckg_fund_proc_ind |
Indicates whether the applicant is waiting for batch packaging. VARCHAR2(1) | |
| p_ver_complete |
Indicates whether verification has been completed. VARCHAR2(1) | |
| p_ver_pay_ind |
The code assigned as the applicant's verification status. VARCHAR2(1) | |
| p_aprd_code |
The aid period assigned to the applicant. VARCHAR2(6) | |
| p_pgrp_code |
The packaging group assigned to the applicant. VARCHAR2(6) | |
| p_tgrp_code |
The tracking group assigned to the applicant. VARCHAR2(6) | |
| p_recalc_na_ind |
Indicates whether the applicant is waiting for batch need analysis. VARCHAR2(1) | |
| p_appl_rcvd_date |
The date on which the applicant's financial aid application was received, processed or created, depending on the institutional option. DATE | |
| p_pckg_comp_date |
The date the financial aid package was completed for the applicant. DATE | |
| p_pri_sar_pgi |
The primary SAR expected family contribution. NUMBER(5) | |
| p_sec_sar_pgi |
The secondary SAR expected family contribution. NUMBER(5) | |
| p_sar_date |
The date the SAR was complete and ready for payment. DATE | |
| p_sar_tran_no |
The SAR transaction number portion of the SAR identification number. VARCHAR2(2) | |
| p_sar_ssn |
The original SAR social security number portion of the SAR identification number. VARCHAR2(15) | |
| p_sar_init |
The first two characters of the last name portion of the SAR identification number. VARCHAR2(2) | |
| p_cm_sc_lock_ind |
Indicates whether the federal methodology student contribution is locked. VARCHAR2(1) | |
| p_cm_pc_lock_ind |
Indicates whether the federal methodology parent contribution is locked. VARCHAR2(1) | |
| p_cm_tfc_lock_ind |
Indicates whether the federal methodology expected family contribution is locked. VARCHAR2(1) | |
| p_pgi_lock_ind |
Indicates whether the primary Pell expected family contribution is locked. VARCHAR2(1) | |
| p_inst_sc_lock_ind |
Indicates whether the institutional methodology student contribution is locked. VARCHAR2(1) | |
| p_inst_pc_lock_ind |
Indicates whether the institutional methodology parent contribution is locked. VARCHAR2(1) | |
| p_awd_ltr_ind |
Indicates whether an award letter should be generated for the applicant. VARCHAR2(1) | |
| p_trk_ltr_ind |
Indicates whether a tracking letter should be generated for the applicant. VARCHAR2(1) | |
| p_addl_stfd_elig_ind |
Indicates if an applicant is eligible for additional Stafford awards. VARCHAR2(1) | |
| p_im_lock |
Indicates whether the IM data is locked from any type of update. VARCHAR2(1) | |
| p_fm_batch_lock |
Indicates whether the federal methodology data is locked from any updating by the batch data load process. VARCHAR2(1) | |
| p_im_batch_lock |
Indicates whether the institutional methodology data is locked from any updating by the batch data load process. VARCHAR2(1) | |
| p_nslds_ovrd_ind |
Indicates which validation tests the Packaging/Disbursement processes should override. VARCHAR2(1) | |
| p_former_heal_ind |
Indicates whether this applicant qualifies for additional Stafford Unsubsidized loans up to the HPPA limits. VARCHAR2(1) | |
| p_pell_lt_half_coa |
The applicant's Pell cost of attendance if enrolled for less than half time. NUMBER(9) | |
| p_info_access_ind |
Indicates if award information for this applicant may be accessed via Voice Response, Banner Self-Service and similar methods. This indicator is used in conjunction with the Info Access Indicator Rule column in the Web Rules table. VARCHAR2(1) | |
| p_borrower_based_cde |
Indicates whether the applicant's loans are processed using a borrower-based academic year rather than the standard award year. VARCHAR2(1) | |
| p_pell_orig_ind |
Indicates whether an updated Pell Origination Record is to be created automatically. VARCHAR2(1) | |
| p_pell_disb_lock_ind |
Indicates that all disbursement activity for Pell is prevented due to COD Disbursement Reference numbers 91 - 99. VARCHAR2(1) | |
| p_post_ba_pell_ovrd |
Indicates if a post Bachelor degree applicant can receive Pell grant funds. VARCHAR2(1) | |
| p_sub_loan_excl_amt |
The amount of the resource that should be excluded when determining eligibility for a subsidized loan. NUMBER(5) | |
| p_tgrp_code_lock_ind |
Identifies if the requirements tracking group code is locked preventing further updates. VARCHAR2(1) | |
| p_bgrp_code_lock_ind |
Identifies if the budget group code is locked preventing further updates. VARCHAR2(1) | |
| p_pgrp_code_lock_ind |
Identifies if the packaging group code is locked preventing further updates. VARCHAR2(1) | |
| p_data_origin |
The latest source for the data contained in this record. VARCHAR2(30) | |
| p_prep_or_teach_ind |
Indicates if specific loan limits should be applied due to enrollment in preparatory coursework required prior to enrolling in an undergraduate degree or certificate program or a graduate or professional program, or due to coursework necessary for teacher certification. VARCHAR2(1) | |
| p_acg_disb_lock_ind |
Indicates that all disbursement activity for ACG is prevented due to a COD Negative Disbursement record. VARCHAR2(1) | |
| p_smart_disb_lock_ind |
Indicates that all disbursement activity for SMART is prevented due to a COD Negative Disbursement record. VARCHAR2(1) | |
| p_auto_zero_efc_ind |
Indicates that the qualifying criteria for Auto Zero EFC were met. VARCHAR2(1) | |
| p_dep_no_par_data |
Indicates if the dependent student is eligible for unsubsidized Stafford even though parent data has not been submitted on the FAFSA. VARCHAR2(1) | |
| p_aprd_code_pell |
The aid period to be used for Pell grants. VARCHAR2(6) | |
| p_post_911_pell_elig |
Indicates if student qualifies for full Pell eligibility due to a parent or guardian who died as a result of military service in Iraq or Afghanistan after September 11, 2001 (includes IASG). VARCHAR2(1) | |
| p_bgrp_code |
The budget group assigned to the applicant. VARCHAR2(6) | |
| p_pbud_info_access_ind |
Indicator to control whether to show period budgets in Self-service web. VARCHAR2(1) | |
| p_high_pell_leu_flag |
Indicates if the student has a high Pell LEU that reduces or eliminates their Pell eligibility for the aid year. VARCHAR2(1) | |
| p_ss_info_access_ind |
Indicates whether the shopping sheet link(s) will appear for the student in self-service. VARCHAR2(1) | |
| p_xes |
The student's expected enrollment status for the aid year. VARCHAR2(1) | |
| p_xes_algo_code |
The algorithmic rule code used to calculate the expected enrollment status. VARCHAR2(30) | |
| p_xes_seq_no |
The sequence number of the rule code used to calculate the expected enrollment status. NUMBER(5) | |
| p_xes_lock_ind |
Identifies if the expected enrollment status is locked preventing further updates. VARCHAR2(1) Required | |
| p_aprd_algo_code |
The algorithmic rule code used to calculate the aid period code. VARCHAR2(30) | |
| p_aprd_seq_no |
The sequence number of the rule code used to calculate the aid period code. NUMBER(5) | |
| p_aprd_algo_code_pell |
The algorithmic rule code used to calculate the Pell aid period code. VARCHAR2(30) | |
| p_aprd_seq_no_pell |
The sequence number of the rule code used to calculate the Pell aid period code. NUMBER(5) | |
| p_recalc_im_ind |
Indicates whether the applicant is waiting for batch IM need analysis. VARCHAR2(1) Required | |
| p_im_need_date |
The date the last IM need analysis calculation was performed for the applicant. DATE | |
| p_ovrde_sayr_code |
The SAY Code to be used for loan origination instead of the SAY Code associated with the student.s aid period. VARCHAR2(15) | |
| p_ovrde_sayr_algo_code |
The algorithmic rule code used to calculate the SAY code. VARCHAR2(30) | |
| p_ovrde_sayr_seq_no |
The sequence number of the rule code used to calculate the SAY code. NUMBER(5) |
p_update
Procedure p_update(p_aidy_code rorstat.rorstat_aidy_code%TYPE,
p_pidm rorstat.rorstat_pidm%TYPE,
p_lock_ind rorstat.rorstat_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_pgrp_lock_ind rorstat.rorstat_pgrp_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_bgrp_proc_ind rorstat.rorstat_bgrp_proc_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_pgrp_proc_ind rorstat.rorstat_pgrp_proc_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_tgrp_proc_ind rorstat.rorstat_tgrp_proc_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_pckg_fund_proc_ind rorstat.rorstat_pckg_fund_proc_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_ver_complete rorstat.rorstat_ver_complete%TYPE DEFAULT dml_common.f_unspecified_string,
p_ver_pay_ind rorstat.rorstat_ver_pay_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_pgrp_code rorstat.rorstat_pgrp_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_tgrp_code rorstat.rorstat_tgrp_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_recalc_na_ind rorstat.rorstat_recalc_na_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_appl_rcvd_date rorstat.rorstat_appl_rcvd_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_pckg_comp_date rorstat.rorstat_pckg_comp_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_pri_sar_pgi rorstat.rorstat_pri_sar_pgi%TYPE DEFAULT dml_common.f_unspecified_number,
p_sec_sar_pgi rorstat.rorstat_sec_sar_pgi%TYPE DEFAULT dml_common.f_unspecified_number,
p_sar_date rorstat.rorstat_sar_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_sar_tran_no rorstat.rorstat_sar_tran_no%TYPE DEFAULT dml_common.f_unspecified_string,
p_sar_ssn rorstat.rorstat_sar_ssn%TYPE DEFAULT dml_common.f_unspecified_string,
p_sar_init rorstat.rorstat_sar_init%TYPE DEFAULT dml_common.f_unspecified_string,
p_cm_sc_lock_ind rorstat.rorstat_cm_sc_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_cm_pc_lock_ind rorstat.rorstat_cm_pc_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_cm_tfc_lock_ind rorstat.rorstat_cm_tfc_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_pgi_lock_ind rorstat.rorstat_pgi_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_inst_sc_lock_ind rorstat.rorstat_inst_sc_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_inst_pc_lock_ind rorstat.rorstat_inst_pc_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_awd_ltr_ind rorstat.rorstat_awd_ltr_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_trk_ltr_ind rorstat.rorstat_trk_ltr_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_addl_stfd_elig_ind rorstat.rorstat_addl_stfd_elig_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_im_lock rorstat.rorstat_im_lock%TYPE DEFAULT dml_common.f_unspecified_string,
p_fm_batch_lock rorstat.rorstat_fm_batch_lock%TYPE DEFAULT dml_common.f_unspecified_string,
p_im_batch_lock rorstat.rorstat_im_batch_lock%TYPE DEFAULT dml_common.f_unspecified_string,
p_nslds_ovrd_ind rorstat.rorstat_nslds_ovrd_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_former_heal_ind rorstat.rorstat_former_heal_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_pell_lt_half_coa rorstat.rorstat_pell_lt_half_coa%TYPE DEFAULT dml_common.f_unspecified_number,
p_info_access_ind rorstat.rorstat_info_access_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_borrower_based_cde rorstat.rorstat_borrower_based_cde%TYPE DEFAULT dml_common.f_unspecified_string,
p_pell_orig_ind rorstat.rorstat_pell_orig_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_pell_disb_lock_ind rorstat.rorstat_pell_disb_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_post_ba_pell_ovrd rorstat.rorstat_post_ba_pell_ovrd%TYPE DEFAULT dml_common.f_unspecified_string,
p_sub_loan_excl_amt rorstat.rorstat_sub_loan_excl_amt%TYPE DEFAULT dml_common.f_unspecified_number,
p_tgrp_code_lock_ind rorstat.rorstat_tgrp_code_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_bgrp_code_lock_ind rorstat.rorstat_bgrp_code_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_pgrp_code_lock_ind rorstat.rorstat_pgrp_code_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_turn_off_pell_ind rorstat.rorstat_turn_off_pell_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_data_origin rorstat.rorstat_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
p_prep_or_teach_ind rorstat.rorstat_prep_or_teach_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_acg_disb_lock_ind rorstat.rorstat_acg_disb_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_smart_disb_lock_ind rorstat.rorstat_smart_disb_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_auto_zero_efc_ind rorstat.rorstat_auto_zero_efc_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_dep_no_par_data rorstat.rorstat_dep_no_par_data%TYPE DEFAULT dml_common.f_unspecified_string,
p_aprd_code_pell rorstat.rorstat_aprd_code_pell%TYPE DEFAULT dml_common.f_unspecified_string,
p_post_911_pell_elig rorstat.rorstat_post_911_pell_elig%TYPE DEFAULT dml_common.f_unspecified_string,
p_aprd_code rorstat.rorstat_aprd_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_bgrp_code rorstat.rorstat_bgrp_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_pbud_info_access_ind rorstat.rorstat_pbud_info_access_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_high_pell_leu_flag rorstat.rorstat_high_pell_leu_flag%TYPE DEFAULT dml_common.f_unspecified_string,
p_ss_info_access_ind rorstat.rorstat_ss_info_access_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_xes rorstat.rorstat_xes%TYPE DEFAULT dml_common.f_unspecified_string,
p_xes_algo_code rorstat.rorstat_xes_algo_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_xes_seq_no rorstat.rorstat_xes_seq_no%TYPE DEFAULT dml_common.f_unspecified_number,
p_xes_lock_ind rorstat.rorstat_xes_lock_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_aprd_algo_code rorstat.rorstat_aprd_algo_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_aprd_seq_no rorstat.rorstat_aprd_seq_no%TYPE DEFAULT dml_common.f_unspecified_number,
p_aprd_algo_code_pell rorstat.rorstat_aprd_algo_code_pell%TYPE DEFAULT dml_common.f_unspecified_string,
p_aprd_seq_no_pell rorstat.rorstat_aprd_seq_no_pell%TYPE DEFAULT dml_common.f_unspecified_number,
p_recalc_im_ind rorstat.rorstat_recalc_im_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_im_need_date rorstat.rorstat_im_need_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_ovrde_sayr_code rorstat.rorstat_ovrde_sayr_code%TYPE DEFAULT dml_common.f_unspecified_string, -- 082201-1
p_ovrde_sayr_algo_code rorstat.rorstat_ovrde_sayr_algo_code%TYPE DEFAULT dml_common.f_unspecified_string, -- 082201-1
p_ovrde_sayr_seq_no rorstat.rorstat_ovrde_sayr_seq_no%TYPE DEFAULT dml_common.f_unspecified_number -- 082201-1
)
Updates a record.
This procedure will update an entry in the Applicant Status Table (RORSTAT).
If a tracking group code is supplied, the entries in the Applicant Requirements Table (RRRAREQ) will be maintained. The Applicant Status Table (RORSTAT) will be updated with the result.
If the SAR completed date is supplied, the entries in the Applicant Requirements Table (RRRAREQ) for Pell will be maintained. The Applicant Status Table (RORSTAT) will be updated with the result.
If the federal methodology student contribution is unlocked and a need analysis calculation was performed, the locked federal methodology student contribution will be replaced with the federal methodology student contribution from the last need analysis calculation. The federal methodology expected family contribution will be recalculated.
If the federal methodology parent contribution is unlocked and a need analysis calculation was performed, the locked federal methodology parent contribution will be replaced with the federal methodology parent contribution from the last need analysis calculation. The federal methodology expected family contribution will be recalculated.
If the Pell expected family contribution is unlocked and a need analysis calculation was performed, the locked Pell expected family contribution will be replaced with the Pell expected family contribution from the last need analysis calculation.
If the institutional methodology student contribution is unlocked and a need analysis calculation was performed, the locked institutional methodology student contribution will be replaced with the institutional methodology student contribution from the last need analysis calculation.
If the institutional methodology parent contribution is unlocked and a need analysis calculation was performed, the locked institutional methodology parent contribution will be replaced with the institutional methodology parent contribution from the last need analysis calculation.
As of the 2014-2015 aid year, if the applicant's aid period or the applicant's Pell aid period is updated, entries in the Applicant Period Status Table (RORPRST) will be added or deleted to reflect the periods.
If the Applicant Period Status Table (RORPRST) is frozen for a period, that period cannot be deleted from the applicant's aid period or Pell Aid Period.
| 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_lock_ind |
Indicates whether the applicant's Need Analysis record is locked. VARCHAR2(1) | |
| p_pgrp_lock_ind |
Indicates whether the applicant's award package is locked. VARCHAR2(1) | |
| p_bgrp_proc_ind |
Indicates whether the applicant is waiting for batch budget group assignment. VARCHAR2(1) | |
| p_pgrp_proc_ind |
Indicates whether the applicant is waiting for batch packaging group assignment. VARCHAR2(1) | |
| p_tgrp_proc_ind |
Indicates whether the applicant is waiting for batch tracking group assignment. VARCHAR2(1) | |
| p_pckg_fund_proc_ind |
Indicates whether the applicant is waiting for batch packaging. VARCHAR2(1) | |
| p_ver_complete |
Indicates whether verification has been completed. VARCHAR2(1) | |
| p_ver_pay_ind |
The code assigned as the applicant's verification status. VARCHAR2(1) | |
| p_pgrp_code |
The packaging group assigned to the applicant. VARCHAR2(6) | |
| p_tgrp_code |
The tracking group assigned to the applicant. VARCHAR2(6) | |
| p_recalc_na_ind |
Indicates whether the applicant is waiting for batch need analysis. VARCHAR2(1) | |
| p_appl_rcvd_date |
The date on which the applicant's financial aid application was received, processed or created, depending on the institutional option. DATE | |
| p_pckg_comp_date |
The date the financial aid package was completed for the applicant. DATE | |
| p_pri_sar_pgi |
The primary SAR expected family contribution. NUMBER(5) | |
| p_sec_sar_pgi |
The secondary SAR expected family contribution. NUMBER(5) | |
| p_sar_date |
The date the SAR was complete and ready for payment. DATE | |
| p_sar_tran_no |
The SAR transaction number portion of the SAR identification number. VARCHAR2(2) | |
| p_sar_ssn |
The original SAR social security number portion of the SAR identification number. VARCHAR2(16) | |
| p_sar_init |
The first two characters of the last name portion of the SAR identification number. VARCHAR2(2) | |
| p_cm_sc_lock_ind |
Indicates whether the federal methodology student contribution is locked. VARCHAR2(1) | |
| p_cm_pc_lock_ind |
Indicates whether the federal methodology parent contribution is locked. VARCHAR2(1) | |
| p_cm_tfc_lock_ind |
Indicates whether the federal methodology expected family contribution is locked. VARCHAR2(1) | |
| p_pgi_lock_ind |
Indicates whether the primary Pell expected family contribution is locked. VARCHAR2(1) | |
| p_inst_sc_lock_ind |
Indicates whether the institutional methodology student contribution is locked. VARCHAR2(1) | |
| p_inst_pc_lock_ind |
Indicates whether the institutional methodology parent contribution is locked. VARCHAR2(1) | |
| p_awd_ltr_ind |
Indicates whether an award letter should be generated for the applicant. VARCHAR2(1) | |
| p_trk_ltr_ind |
Indicates whether a tracking letter should be generated for the applicant. VARCHAR2(1) | |
| p_addl_stfd_elig_ind |
Indicates if an applicant is eligible for additional Stafford awards. VARCHAR2(1) | |
| p_im_lock |
Indicates whether the IM data is locked from any type of update. VARCHAR2(1) | |
| p_fm_batch_lock |
Indicates whether the federal methodology data is locked from any updating by the batch data load process. VARCHAR2(1) | |
| p_im_batch_lock |
Indicates whether the institutional methodology data is locked from any updating by the batch data load process. VARCHAR2(1) | |
| p_nslds_ovrd_ind |
Indicates which validation tests the Packaging/Disbursement processes should override. VARCHAR2(1) | |
| p_former_heal_ind |
Indicates whether this applicant qualifies for additional Stafford Unsubsidized loans up to the HPPA limits. VARCHAR2(1) | |
| p_pell_lt_half_coa |
The applicant's Pell cost of attendance if enrolled for less than half time. NUMBER(9) | |
| p_info_access_ind |
Indicates if award information for this applicant may be accessed via Voice Response, Banner Self-Service and similar methods. This indicator is used in conjunction with the Info Access Indicator Rule column in the Web Rules table. VARCHAR2(1) | |
| p_borrower_based_cde |
Indicates whether the applicant's loans are processed using a borrower-based academic year rather than the standard award year. VARCHAR2(1) | |
| p_pell_orig_ind |
Indicates whether an updated Pell Origination Record is to be created automatically. VARCHAR2(1) | |
| p_pell_disb_lock_ind |
Indicates that all disbursement activity for Pell is prevented due to COD Disbursement Reference numbers 91 - 99. VARCHAR2(1) | |
| p_post_ba_pell_ovrd |
Indicates if a post Bachelor degree applicant can receive Pell grant funds. VARCHAR2(1) | |
| p_sub_loan_excl_amt |
The amount of the resource that should be excluded when determining eligibility for a subsidized loan. NUMBER(5) | |
| p_tgrp_code_lock_ind |
Identifies if the requirements tracking group code is locked preventing further updates. VARCHAR2(1) | |
| p_bgrp_code_lock_ind |
Identifies if the budget group code is locked preventing further updates. VARCHAR2(1) | |
| p_pgrp_code_lock_ind |
Identifies if the packaging group code is locked preventing further updates. VARCHAR2(1) | |
| p_turn_off_pell_ind |
Indicates if the Pell process should be prevented from automatically running for the applicant. VARCHAR2(1) | |
| p_data_origin |
The latest source for the data contained in this record. VARCHAR2(30) | |
| p_prep_or_teach_ind |
Indicates if specific loan limits should be applied due to enrollment in preparatory coursework required prior to enrolling in an undergraduate degree or certificate program or a graduate or professional program, or due to coursework necessary for teacher certification. VARCHAR2(1) | |
| p_acg_disb_lock_ind |
Indicates that all disbursement activity for ACG is prevented due to a COD Negative Disbursement record. VARCHAR2(1) | |
| p_smart_disb_lock_ind |
Indicates that all disbursement activity for SMART is prevented due to a COD Negative Disbursement record. VARCHAR2(1) | |
| p_auto_zero_efc_ind |
Indicates that the qualifying criteria for Auto Zero EFC were met. VARCHAR2(1) | |
| p_dep_no_par_data |
Indicates if the dependent student is eligible for unsubsidized Stafford even though parent data has not been submitted on the FAFSA. VARCHAR2(1) | |
| p_aprd_code_pell |
The aid period to be used for Pell grants. VARCHAR2(6) | |
| p_post_911_pell_elig |
Indicates if student qualifies for full Pell eligibility due to a parent or guardian who died as a result of military service in Iraq or Afghanistan after September 11, 2001 (includes IASG). VARCHAR2(1) | |
| p_aprd_code |
The aid period assigned to the applicant. VARCHAR2(6) | |
| p_bgrp_code |
The budget group assigned to the applicant. VARCHAR2(6) | |
| p_pbud_info_access_ind |
Indicator to control whether to show period budgets in Self-service web. VARCHAR2(1) | |
| p_high_pell_leu_flag |
Indicates if the student has a high Pell LEU that reduces or eliminates their Pell eligibility for the aid year. VARCHAR2(1) | |
| p_ss_info_access_ind |
Indicates whether the shopping sheet link(s) will appear for the student in self-service. VARCHAR2(1) | |
| p_xes |
The student's expected enrollment status for the aid year. VARCHAR2(1) | |
| p_xes_algo_code |
The algorithmic rule code used to calculate the expected enrollment status. VARCHAR2(30) | |
| p_xes_seq_no |
The sequence number of the rule code used to calculate the expected enrollment status. NUMBER(5) | |
| p_xes_lock_ind |
Identifies if the expected enrollment status is locked preventing further updates. VARCHAR2(1) Required | |
| p_aprd_algo_code |
The algorithmic rule code used to calculate the aid period code. VARCHAR2(30) | |
| p_aprd_seq_no |
The sequence number of the rule code used to calculate the aid period code. NUMBER(5) | |
| p_aprd_algo_code_pell |
The algorithmic rule code used to calculate the Pell aid period code. VARCHAR2(30) | |
| p_aprd_seq_no_pell |
The sequence number of the rule code used to calculate the Pell aid period code. NUMBER(5) | |
| p_recalc_im_ind |
Indicates whether the applicant is waiting for batch IM need analysis. VARCHAR2(1) Required | |
| p_im_need_date |
The date the last IM need analysis calculation was performed for the applicant. DATE | |
| p_ovrde_sayr_code |
The SAY Code to be used for loan origination instead of the SAY Code associated with the student.s aid period. VARCHAR2(15) | |
| p_ovrde_sayr_algo_code |
The algorithmic rule code used to calculate the SAY code. VARCHAR2(30) | |
| p_ovrde_sayr_seq_no |
The sequence number of the rule code used to calculate the SAY code. NUMBER(5) |