BANINST1@S10B80 |
|
Package sb_admissionsapplication_rules This package provides the support subprograms for the Admissions Application API (sb_admissionsapplication). |
| Program units |
| p_register_entity | Registers the attribute/value pairs to the message cache. |
| p_register_entity | Registers the attribute/value pairs to the message cache. |
| p_validate | Validates all the data in the record. |
p_register_entity
Procedure p_register_entity(p_operation_type NUMBER,
p_internal_record_id VARCHAR2)
Registers the attribute/value pairs to the message cache.
This signature uses the ROWID only for the delete operations.
| Parameters |
| p_internal_record_id |
Database ROWID. VARCHAR2(18) |
p_register_entity
Procedure p_register_entity(p_operation_type NUMBER,
p_pidm saradap.saradap_pidm%TYPE,
p_term_code_entry saradap.saradap_term_code_entry%TYPE,
p_appl_no saradap.saradap_appl_no%TYPE,
p_appl_date saradap.saradap_appl_date%TYPE,
p_apst_code saradap.saradap_apst_code%TYPE,
p_apst_date saradap.saradap_apst_date%TYPE,
p_maint_ind saradap.saradap_maint_ind%TYPE,
p_admt_code saradap.saradap_admt_code%TYPE,
p_styp_code saradap.saradap_styp_code%TYPE,
p_site_code saradap.saradap_site_code%TYPE,
p_resd_code saradap.saradap_resd_code%TYPE,
p_full_part_ind saradap.saradap_full_part_ind%TYPE,
p_sess_code saradap.saradap_sess_code%TYPE,
p_wrsn_code saradap.saradap_wrsn_code%TYPE,
p_intv_code saradap.saradap_intv_code%TYPE,
p_fee_ind saradap.saradap_fee_ind%TYPE,
p_fee_date saradap.saradap_fee_date%TYPE,
p_rate_code saradap.saradap_rate_code%TYPE,
p_egol_code saradap.saradap_egol_code%TYPE,
p_edlv_code saradap.saradap_edlv_code%TYPE,
p_sbgi_code saradap.saradap_sbgi_code%TYPE,
p_recr_code saradap.saradap_recr_code%TYPE,
p_rtyp_code saradap.saradap_rtyp_code%TYPE,
p_web_acct_misc_ind saradap.saradap_web_acct_misc_ind%TYPE,
p_web_cashier_user saradap.saradap_web_cashier_user%TYPE,
p_web_trans_no saradap.saradap_web_trans_no%TYPE,
p_web_amount saradap.saradap_web_amount%TYPE,
p_web_receipt_number saradap.saradap_web_receipt_number%TYPE,
p_waiv_code saradap.saradap_waiv_code%TYPE,
p_data_origin saradap.saradap_data_origin%TYPE,
p_user_id saradap.saradap_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_internal_record_id VARCHAR2,
/* CC 7.3: Add application preference */
p_appl_preference saradap.saradap_appl_preference%TYPE)
Registers the attribute/value pairs to the message cache.
This signature registers all the parameters.
| Parameters |
| p_pidm |
Applicant internal identification number. NUMBER(8) Required Key | |
| p_term_code_entry |
Term associated with the information on the applicant record. VARCHAR2(6) Required Key | |
| p_appl_no |
Application number of the admissions record for a specific term. NUMBER(2) Required Key | |
| p_appl_date |
Date of the application record. DATE Required | |
| p_apst_code |
Status of the application. VARCHAR2(1) Required | |
| p_apst_date |
Date associated with the most current status of the application. DATE Required | |
| p_maint_ind |
Indicates whether the status of the application is being maintained by the system or the user. VARCHAR2(1) Required | |
| p_admt_code |
Admission type of the applicant. VARCHAR2(2) | |
| p_styp_code |
Type of student the applicant will become if admitted. VARCHAR2(1) Required | |
| p_site_code |
Site to which the applicant is applying. VARCHAR2(3) | |
| p_resd_code |
Residency classification of the applicant. VARCHAR2(1) Required | |
| p_full_part_ind |
Indicates whether the applicant's intention is for full- or part-time enrollment. VARCHAR2(1) | |
| p_sess_code |
Session for which the applicant is applying. VARCHAR2(1) | |
| p_wrsn_code |
Reason why an application has been withdrawn. VARCHAR2(2) | |
| p_intv_code |
Status of the interview associated with the applicant. VARCHAR2(1) | |
| p_fee_ind |
Indicates whether an application fee has been assessed. VARCHAR2(1) | |
| p_fee_date |
Date application fee was assessed. DATE | |
| p_rate_code |
Specific assessment rate assigned to the student. VARCHAR2(5) | |
| p_egol_code |
Educational Goal Code. VARCHAR2(2) | |
| p_edlv_code |
Education Level Code. VARCHAR2(3) | |
| p_sbgi_code |
Institution Attending code of the institution the student decided to attend instead of the home institution. VARCHAR2(6) | |
| p_recr_code |
Recruiter Code. VARCHAR2(3) | |
| p_rtyp_code |
Recruit Type code. VARCHAR2(2) | |
| p_web_acct_misc_ind |
Indicator to identify where the record for the application fee is stored if the fee was paid by credit card via the Web. Values are M for Misc, T for TBRACCD. VARCHAR2(1) | |
| p_web_cashier_user |
Oracle ID of the cashier associated with the application fee if the fee was paid by credit card via the Web. VARCHAR2(30) | |
| p_web_trans_no |
Transaction number associated with the application fee if the fee was paid by credit card via the Web. NUMBER(8) | |
| p_web_amount |
Amount of the transaction for an application fee if the fee was paid by credit card via the Web. NUMBER(12,2) | |
| p_web_receipt_number |
Receipt number associated with the application fee if the fee was paid by credit card via the Web. NUMBER(8) | |
| p_waiv_code |
Application fee waiver reason. VARCHAR2(4) | |
| p_data_origin |
Source system that generated the data. VARCHAR2(30) | |
| p_user_id |
Oracle ID of the most recent user to create or update a record. VARCHAR2(30) | |
| p_internal_record_id |
Database ROWID. VARCHAR2(18) | |
| p_appl_preference |
Application preference number. NUMBER(2) |
p_validate
Procedure p_validate(p_pidm saradap.saradap_pidm%TYPE,
p_term_code_entry saradap.saradap_term_code_entry%TYPE,
p_appl_no saradap.saradap_appl_no%TYPE,
p_appl_date saradap.saradap_appl_date%TYPE,
p_apst_code saradap.saradap_apst_code%TYPE,
p_apst_date saradap.saradap_apst_date%TYPE,
p_maint_ind saradap.saradap_maint_ind%TYPE,
p_admt_code saradap.saradap_admt_code%TYPE DEFAULT NULL,
p_styp_code saradap.saradap_styp_code%TYPE,
p_site_code saradap.saradap_site_code%TYPE DEFAULT NULL,
p_resd_code saradap.saradap_resd_code%TYPE,
p_full_part_ind saradap.saradap_full_part_ind%TYPE DEFAULT NULL,
p_sess_code saradap.saradap_sess_code%TYPE DEFAULT NULL,
p_wrsn_code saradap.saradap_wrsn_code%TYPE DEFAULT NULL,
p_intv_code saradap.saradap_intv_code%TYPE DEFAULT NULL,
p_fee_ind saradap.saradap_fee_ind%TYPE DEFAULT NULL,
p_fee_date saradap.saradap_fee_date%TYPE DEFAULT NULL,
p_rate_code saradap.saradap_rate_code%TYPE DEFAULT NULL,
p_egol_code saradap.saradap_egol_code%TYPE DEFAULT NULL,
p_edlv_code saradap.saradap_edlv_code%TYPE DEFAULT NULL,
p_sbgi_code saradap.saradap_sbgi_code%TYPE DEFAULT NULL,
p_recr_code saradap.saradap_recr_code%TYPE DEFAULT NULL,
p_rtyp_code saradap.saradap_rtyp_code%TYPE DEFAULT NULL,
p_web_acct_misc_ind saradap.saradap_web_acct_misc_ind%TYPE DEFAULT NULL,
p_web_cashier_user saradap.saradap_web_cashier_user%TYPE DEFAULT NULL,
p_web_trans_no saradap.saradap_web_trans_no%TYPE DEFAULT NULL,
p_web_amount saradap.saradap_web_amount%TYPE DEFAULT NULL,
p_web_receipt_number saradap.saradap_web_receipt_number%TYPE DEFAULT NULL,
p_waiv_code saradap.saradap_waiv_code%TYPE DEFAULT NULL,
p_data_origin saradap.saradap_data_origin%TYPE DEFAULT NULL,
p_user_id saradap.saradap_user_id%TYPE DEFAULT gb_common.f_sct_user,
/* CC 7.3 Add application preference */
p_appl_preference saradap.saradap_appl_preference%TYPE DEFAULT NULL)
Validates all the data in the record.
| Parameters |
| p_pidm |
Applicant internal identification number. NUMBER(8) Required Key | |
| p_term_code_entry |
Term associated with the information on the applicant record. VARCHAR2(6) Required Key | |
| p_appl_no |
Application number of the admissions record for a specific term. NUMBER(2) Required Key | |
| p_appl_date |
Date of the application record. DATE Required | |
| p_apst_code |
Status of the application. VARCHAR2(1) Required | |
| p_apst_date |
Date associated with the most current status of the application. DATE Required | |
| p_maint_ind |
Indicates whether the status of the application is being maintained by the system or the user. VARCHAR2(1) Required | |
| p_admt_code |
Admission type of the applicant. VARCHAR2(2) | |
| p_styp_code |
Type of student the applicant will become if admitted. VARCHAR2(1) Required | |
| p_site_code |
Site to which the applicant is applying. VARCHAR2(3) | |
| p_resd_code |
Residency classification of the applicant. VARCHAR2(1) Required | |
| p_full_part_ind |
Indicates whether the applicant's intention is for full- or part-time enrollment. VARCHAR2(1) | |
| p_sess_code |
Session for which the applicant is applying. VARCHAR2(1) | |
| p_wrsn_code |
Reason why an application has been withdrawn. VARCHAR2(2) | |
| p_intv_code |
Status of the interview associated with the applicant. VARCHAR2(1) | |
| p_fee_ind |
Indicates whether an application fee has been assessed. VARCHAR2(1) | |
| p_fee_date |
Date application fee was assessed. DATE | |
| p_rate_code |
Specific assessment rate assigned to the student. VARCHAR2(5) | |
| p_egol_code |
Educational Goal Code. VARCHAR2(2) | |
| p_edlv_code |
Education Level Code. VARCHAR2(3) | |
| p_sbgi_code |
Institution Attending code of the institution the student decided to attend instead of the home institution. VARCHAR2(6) | |
| p_recr_code |
Recruiter Code. VARCHAR2(3) | |
| p_rtyp_code |
Recruit Type code. VARCHAR2(2) | |
| p_web_acct_misc_ind |
Indicator to identify where the record for the application fee is stored if the fee was paid by credit card via the Web. Values are M for Misc, T for TBRACCD. VARCHAR2(1) | |
| p_web_cashier_user |
Oracle ID of the cashier associated with the application fee if the fee was paid by credit card via the Web. VARCHAR2(30) | |
| p_web_trans_no |
Transaction number associated with the application fee if the fee was paid by credit card via the Web. NUMBER(8) | |
| p_web_amount |
Amount of the transaction for an application fee if the fee was paid by credit card via the Web. NUMBER(12,2) | |
| p_web_receipt_number |
Receipt number associated with the application fee if the fee was paid by credit card via the Web. NUMBER(8) | |
| p_waiv_code |
Application fee waiver reason. VARCHAR2(4) | |
| p_data_origin |
Source system that generated the data. VARCHAR2(30) | |
| p_user_id |
Oracle ID of the most recent user to create or update a record. VARCHAR2(30) | |
| p_appl_preference |
Application preference number. NUMBER(2) |