|
Package sb_gradapp_rules
Support subprograms for the Graduation Application API (sb_gradapp).
|
f_seqno
Function f_seqno(p_pidm shbgapp.shbgapp_pidm%TYPE) RETURN NUMBER
Returns the sequence number for creation. The key to the graduation application record is the PIDM and a sequence number. The sequence is a one-up by PIDM.
|
|
p_pidm
|
PIDM: Unique internal ID for an individual who has records in the system. Required Key.
|
|
|
Sequence number for creation of a new graduation application.
|
p_register_entity
Procedure p_register_entity(p_operation_type NUMBER,
p_internal_record_id gb_common.internal_record_id_type)
Registers the attribute value pairs to the message cache for delete operations.
This signature uses the ROWID only for delete operations.
|
|
p_operation_type
|
Type of DML operation: create, update, delete. NUMBER Required
|
|
|
p_internal_record_id
|
Database ROWID VARCHAR2(18) Required
|
p_register_entity
Procedure p_register_entity(p_operation_type NUMBER,
p_pidm shbgapp.shbgapp_pidm%TYPE,
p_seqno shbgapp.shbgapp_seqno%TYPE,
p_request_date shbgapp.shbgapp_request_date%TYPE,
p_gast_code shbgapp.shbgapp_gast_code%TYPE,
p_gast_date shbgapp.shbgapp_gast_date%TYPE,
p_user_id shbgapp.shbgapp_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_gadr_code shbgapp.shbgapp_gadr_code%TYPE,
p_dgmr_upd_grst_code shbgapp.shbgapp_dgmr_upd_grst_code%TYPE,
p_grad_date shbgapp.shbgapp_grad_date%TYPE,
p_grad_term_code shbgapp.shbgapp_grad_term_code%TYPE,
p_grad_acyr_code shbgapp.shbgapp_grad_acyr_code%TYPE,
p_grad_attend_cde shbgapp.shbgapp_grad_attend_cde%TYPE,
p_last_name shbgapp.shbgapp_last_name%TYPE,
p_first_name shbgapp.shbgapp_first_name%TYPE,
p_mi shbgapp.shbgapp_mi%TYPE,
p_name_suffix shbgapp.shbgapp_name_suffix%TYPE,
p_street1 shbgapp.shbgapp_street1%TYPE,
p_street2 shbgapp.shbgapp_street2%TYPE,
p_street3 shbgapp.shbgapp_street3%TYPE,
p_street4 shbgapp.shbgapp_street4%TYPE,
p_house_number shbgapp.shbgapp_house_number%TYPE,
p_city shbgapp.shbgapp_city%TYPE,
p_stat_code shbgapp.shbgapp_stat_code%TYPE,
p_zip shbgapp.shbgapp_zip%TYPE,
p_natn_code shbgapp.shbgapp_natn_code%TYPE,
p_term_code_detc shbgapp.shbgapp_term_code_detc%TYPE,
p_wpyo_code shbgapp.shbgapp_wpyo_code%TYPE,
p_detc_detail_code shbgapp.shbgapp_detc_detail_code%TYPE,
p_detc_desc shbgapp.shbgapp_detc_desc%TYPE,
p_chrg shbgapp.shbgapp_chrg%TYPE,
p_fee_date shbgapp.shbgapp_fee_date%TYPE,
p_tran_number shbgapp.shbgapp_tran_number%TYPE,
p_wpyo_receipt_number shbgapp.shbgapp_wpyo_receipt_number%TYPE,
p_data_origin shbgapp.shbgapp_data_origin%TYPE,
p_internal_record_id gb_common.internal_record_id_type)
Registers the attribute/value pairs to the message cache for create and update operations.
This signature registers all parameters.
|
|
p_operation_type
|
Type of DML operation: create, update, delete. NUMBER Required
|
|
|
p_pidm
|
Internal identification number (PIDM) of the learner for which the graduation application was submitted. NUMBER(8) Required Key
|
|
|
p_seqno
|
One-up number for this graduation application submitted by the learner. NUMBER(4) Required Key
|
|
|
p_request_date
|
Date the graduation application was submitted. DATE Required
|
|
|
p_gast_code
|
Status code for the graduation application. VARCHAR2(4) Required
|
|
|
p_gast_date
|
Date the graduation application status was last changed. DATE Required
|
|
|
p_user_id
|
ID of the most recent user to create or update the row in the SHBGAPP table. VARCHAR2(30) Required
|
|
|
p_gadr_code
|
Display rule code in effect when the graduation application was submitted. VARCHAR2(15)
|
|
|
p_dgmr_upd_grst_code
|
Graduation status code to use if the SHRDGMR graduation status will be impacted. VARCHAR2(3)
|
|
|
p_grad_date
|
Requested graduation date. DATE
|
|
|
p_grad_term_code
|
Requested graduation term code. VARCHAR2(6)
|
|
|
p_grad_acyr_code
|
Requested graduation academic year. VARCHAR2(4)
|
|
|
p_grad_attend_cde
|
Indicator for whether the learner plans to attend the graduation ceremony. VARCHAR2(1)
|
|
|
p_last_name
|
Last name requested for printing on the diploma. VARCHAR2(60)
|
|
|
p_first_name
|
First name requested for printing on the diploma. VARCHAR2(15)
|
|
|
p_mi
|
Middle name requested for printing on the diploma. VARCHAR2(15)
|
|
|
p_name_suffix
|
Name suffix requested for printing on the diploma. VARCHAR2(20)
|
|
|
p_street1
|
Requested mailing address street line 1 for diploma. VARCHAR2(30)
|
|
|
p_street2
|
Requested mailing address street line 2 for diploma. VARCHAR2(30)
|
|
|
p_street3
|
Requested mailing address street line 3 for diploma. VARCHAR2(30)
|
|
|
p_street4
|
Requested mailing address street line 4 for diploma. VARCHAR2(30)
|
|
|
p_house_number
|
Requested mailing address house number for diploma. VARCHAR2(10)
|
|
|
p_city
|
Requested mailing address city for diploma. VARCHAR2(20)
|
|
|
p_stat_code
|
Requested mailing address state code for diploma. VARCHAR2(3)
|
|
|
p_zip
|
Requested mailing address zip for diploma. VARCHAR2(10)
|
|
|
p_natn_code
|
Requested mailing address nation code for diploma. VARCHAR2(5)
|
|
|
p_term_code_detc
|
Detail code to use for the billing. VARCHAR2(6)
|
|
|
p_wpyo_code
|
Code of the payment option of the request. VARCHAR2(4)
|
|
|
p_detc_detail_code
|
Charge detail code to be placed on the student's account in billing for submitting a graduation application. VARCHAR2(4)
|
|
|
p_detc_desc
|
Description of the charge detail code if it differs from the default on the Detail Code Control Form. VARCHAR2(30)
|
|
|
p_chrg
|
Monetary amount to be charged for the graduation application. NUMBER(12,2)
|
|
|
p_fee_date
|
Date of the charge. DATE
|
|
|
p_tran_number
|
Transaction number for the charge. NUMBER(4)
|
|
|
p_wpyo_receipt_number
|
Receipt number for the graduation application. NUMBER(8)
|
|
|
p_data_origin
|
Value of the source system that inserted or updated the row. VARCHAR2(30)
|
|
|
p_internal_record_id
|
Database ROWID VARCHAR2(18) required
|
p_validate
Procedure p_validate(p_pidm shbgapp.shbgapp_pidm%TYPE,
p_seqno shbgapp.shbgapp_seqno%TYPE,
p_request_date shbgapp.shbgapp_request_date%TYPE,
p_gast_code shbgapp.shbgapp_gast_code%TYPE,
p_gast_date shbgapp.shbgapp_gast_date%TYPE,
p_user_id shbgapp.shbgapp_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_gadr_code shbgapp.shbgapp_gadr_code%TYPE DEFAULT NULL,
p_dgmr_upd_grst_code shbgapp.shbgapp_dgmr_upd_grst_code%TYPE DEFAULT NULL,
p_grad_date shbgapp.shbgapp_grad_date%TYPE DEFAULT NULL,
p_grad_term_code shbgapp.shbgapp_grad_term_code%TYPE DEFAULT NULL,
p_grad_acyr_code shbgapp.shbgapp_grad_acyr_code%TYPE DEFAULT NULL,
p_grad_attend_cde shbgapp.shbgapp_grad_attend_cde%TYPE DEFAULT NULL,
p_last_name shbgapp.shbgapp_last_name%TYPE DEFAULT NULL,
p_first_name shbgapp.shbgapp_first_name%TYPE DEFAULT NULL,
p_mi shbgapp.shbgapp_mi%TYPE DEFAULT NULL,
p_name_suffix shbgapp.shbgapp_name_suffix%TYPE DEFAULT NULL,
p_street1 shbgapp.shbgapp_street1%TYPE DEFAULT NULL,
p_street2 shbgapp.shbgapp_street2%TYPE DEFAULT NULL,
p_street3 shbgapp.shbgapp_street3%TYPE DEFAULT NULL,
p_street4 shbgapp.shbgapp_street4%TYPE DEFAULT NULL,
p_house_number shbgapp.shbgapp_house_number%TYPE DEFAULT NULL,
p_city shbgapp.shbgapp_city%TYPE DEFAULT NULL,
p_stat_code shbgapp.shbgapp_stat_code%TYPE DEFAULT NULL,
p_zip shbgapp.shbgapp_zip%TYPE DEFAULT NULL,
p_natn_code shbgapp.shbgapp_natn_code%TYPE DEFAULT NULL,
p_term_code_detc shbgapp.shbgapp_term_code_detc%TYPE DEFAULT NULL,
p_wpyo_code shbgapp.shbgapp_wpyo_code%TYPE DEFAULT NULL,
p_detc_detail_code shbgapp.shbgapp_detc_detail_code%TYPE DEFAULT NULL,
p_detc_desc shbgapp.shbgapp_detc_desc%TYPE DEFAULT NULL,
p_chrg shbgapp.shbgapp_chrg%TYPE DEFAULT NULL,
p_fee_date shbgapp.shbgapp_fee_date%TYPE DEFAULT NULL,
p_tran_number shbgapp.shbgapp_tran_number%TYPE DEFAULT NULL,
p_wpyo_receipt_number shbgapp.shbgapp_wpyo_receipt_number%TYPE DEFAULT NULL,
p_data_origin shbgapp.shbgapp_data_origin%TYPE DEFAULT NULL)
Validates all data in the record.
|
|
p_pidm
|
Internal identification number (PIDM) of the learner for which the graduation application was submitted. NUMBER(8) Required Key
|
|
|
p_seqno
|
One-up number for this graduation application submitted by the learner. NUMBER(4) Required Key
|
|
|
p_request_date
|
Date the graduation application was submitted. DATE Required
|
|
|
p_gast_code
|
Status code for the graduation application. VARCHAR2(4) Required
|
|
|
p_gast_date
|
Date the graduation application status was last changed. DATE Required
|
|
|
p_user_id
|
ID of the most recent user to create or update the row in the SHBGAPP table. VARCHAR2(30) Required
|
|
|
p_gadr_code
|
Display rule code in effect when the graduation application was submitted. VARCHAR2(15)
|
|
|
p_dgmr_upd_grst_code
|
Graduation status code to use if the SHRDGMR graduation status will be impacted. VARCHAR2(3)
|
|
|
p_grad_date
|
Requested graduation date. DATE
|
|
|
p_grad_term_code
|
Requested graduation term code. VARCHAR2(6)
|
|
|
p_grad_acyr_code
|
Requested graduation academic year. VARCHAR2(4)
|
|
|
p_grad_attend_cde
|
Indicator for whether the learner plans to attend the graduation ceremony. VARCHAR2(1)
|
|
|
p_last_name
|
Last name requested for printing on the diploma. VARCHAR2(60)
|
|
|
p_first_name
|
First name requested for printing on the diploma. VARCHAR2(15)
|
|
|
p_mi
|
Middle name requested for printing on the diploma. VARCHAR2(15)
|
|
|
p_name_suffix
|
Name suffix requested for printing on the diploma. VARCHAR2(20)
|
|
|
p_street1
|
Requested mailing address street line 1 for diploma. VARCHAR2(30)
|
|
|
p_street2
|
Requested mailing address street line 2 for diploma. VARCHAR2(30)
|
|
|
p_street3
|
Requested mailing address street line 3 for diploma. VARCHAR2(30)
|
|
|
p_street4
|
Requested mailing address street line 4 for diploma. VARCHAR2(30)
|
|
|
p_house_number
|
Requested mailing address house number for diploma. VARCHAR2(10)
|
|
|
p_city
|
Requested mailing address city for diploma. VARCHAR2(20)
|
|
|
p_stat_code
|
Requested mailing address state code for diploma. VARCHAR2(3)
|
|
|
p_zip
|
Requested mailing address zip for diploma. VARCHAR2(10)
|
|
|
p_natn_code
|
Requested mailing address nation code for diploma. VARCHAR2(5)
|
|
|
p_term_code_detc
|
Detail code to use for the billing. VARCHAR2(6)
|
|
|
p_wpyo_code
|
Code of the payment option of the request. VARCHAR2(4)
|
|
|
p_detc_detail_code
|
Charge detail code to be placed on the student's account in billing for submitting a graduation application. VARCHAR2(4)
|
|
|
p_detc_desc
|
Description of the charge detail code if it differs from the default on the Detail Code Control Form. VARCHAR2(30)
|
|
|
p_chrg
|
Monetary amount to be charged for the graduation application. NUMBER(12,2)
|
|
|
p_fee_date
|
Date of the charge. DATE
|
|
|
p_tran_number
|
Transction number for the charge. NUMBER(4)
|
|
|
p_wpyo_receipt_number
|
Receipt number for the graduation application. NUMBER(8)
|
|
|
p_data_origin
|
Value of the source system that inserted or updated the row. VARCHAR2(30)
|