Package sb_gradapp_displayrule

Package sb_gradapp_displayrule_rules

Support subprograms for the Graduation Application Display Rule API (sb_gradapp_displayrule).

Program units

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.

Parameters

	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_code                   shbgadr.shbgadr_code%TYPE,
                            p_tprt_code              shbgadr.shbgadr_tprt_code%TYPE,
                            p_grad_date_disp_ind     shbgadr.shbgadr_grad_date_disp_ind%TYPE,
                            p_grad_term_disp_ind     shbgadr.shbgadr_grad_term_disp_ind%TYPE,
                            p_grad_year_disp_ind     shbgadr.shbgadr_grad_year_disp_ind%TYPE,
                            p_gast_code              shbgadr.shbgadr_gast_code%TYPE,
                            p_dgmr_upd_ind           shbgadr.shbgadr_dgmr_upd_ind%TYPE,
                            p_disp_dipl_name_web_ind shbgadr.shbgadr_disp_dipl_name_web_ind%TYPE,
                            p_disp_name_cde          shbgadr.shbgadr_disp_name_cde%TYPE,
                            p_disp_middle_cde        shbgadr.shbgadr_disp_middle_cde%TYPE,
                            p_disp_suffix_ind        shbgadr.shbgadr_disp_suffix_ind%TYPE,
                            p_disp_dipl_name_ind     shbgadr.shbgadr_disp_dipl_name_ind%TYPE,
                            p_disp_dipl_upd_name_ind shbgadr.shbgadr_disp_dipl_upd_name_ind%TYPE,
                            p_disp_upd_first_ind     shbgadr.shbgadr_disp_upd_first_ind%TYPE,
                            p_disp_upd_middle_ind    shbgadr.shbgadr_disp_upd_middle_ind%TYPE,
                            p_disp_upd_last_ind      shbgadr.shbgadr_disp_upd_last_ind%TYPE,
                            p_disp_upd_suffix_ind    shbgadr.shbgadr_disp_upd_suffix_ind%TYPE,
                            p_disp_dipl_addr_web_ind shbgadr.shbgadr_disp_dipl_addr_web_ind%TYPE,
                            p_disp_dipl_addr_ind     shbgadr.shbgadr_disp_dipl_addr_ind%TYPE,
                            p_disp_dipl_upd_addr_ind shbgadr.shbgadr_disp_dipl_upd_addr_ind%TYPE,
                            p_charge_ind             shbgadr.shbgadr_charge_ind%TYPE,
                            p_user_id                shbgadr.shbgadr_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_letr_code              shbgadr.shbgadr_letr_code%TYPE,
                            p_disp_name_ntyp_code    shbgadr.shbgadr_disp_name_ntyp_code%TYPE,
                            p_dgmr_upd_grst_code     shbgadr.shbgadr_dgmr_upd_grst_code%TYPE,
                            p_data_origin            shbgadr.shbgadr_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.

Parameters

	p_operation_type	Type of DML operation: create, update, delete. NUMBER Required
	p_code	Display rule code for the graduation application. VARCHAR2(15) Required Key
	p_tprt_code	Transcript verification type to use for graduation application self-service display rules. VARCHAR2(4) Required
	p_grad_date_disp_ind	Indicator for whether graduation dates will be displayed on the self-service graduation application. VARCHAR2(1) Required
	p_grad_term_disp_ind	Indicator for whether graduation terms will be displayed on the self-service graduation application. VARCHAR2(1) Required
	p_grad_year_disp_ind	Indicator for whether graduation years will be displayed on the self-service graduation application. VARCHAR2(1) Required
	p_gast_code	Status code for the graduation application when it is submitted. VARCHAR2(4) Required
	p_dgmr_upd_ind	Indicator for whether the SHRDGMR table will be impacted when the graduation application is submitted. VARCHAR2(1) Required
	p_disp_dipl_name_web_ind	Indicator for whether the diploma name page will be displayed for self-service graduation applications. VARCHAR2(1) Required
	p_disp_name_cde	Indicator for which name is to be displayed on the self-service graduation application diploma name page. VARCHAR2(1) Required
	p_disp_middle_cde	Indicates the format to use when displaying middle name information on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_suffix_ind	Indicator for whether the name suffix information will be displayed on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_dipl_name_ind	Indicator for whether the diploma name will be displayed on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_dipl_upd_name_ind	Indicator for whether the learner may provide a diploma name on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_upd_first_ind	Indicator for whether the learner may update the first name used for the diploma name on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_upd_middle_ind	Indicator for whether the learner may update the middle name used for the diploma name on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_upd_last_ind	Indicator for whether the learner may update the last name used for the diploma name on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_upd_suffix_ind	Indicator for whether the learner may update the suffix used for the diploma name on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_dipl_addr_web_ind	Indicator for whether the diploma mailing address will be displayed self-service page displays for self-service graduation applications. VARCHAR2(1) Required
	p_disp_dipl_addr_ind	Indicator for whether the diploma mailing address will be displayed on the graduation application self-service diploma mailing address page. VARCHAR2(1) Required
	p_disp_dipl_upd_addr_ind	Indicator for whether the diploma mailing address information may be updated. VARCHAR2(1) Required
	p_charge_ind	Indicator for whether a charge will apply when the graduation application is submitted. VARCHAR2(1) Required
	p_user_id	ID of the most recent user to create or update the row in the SHBGADR table. VARCHAR2(30) Required
	p_letr_code	Code for the confirmation letter that will be displayed at the end of the self-service graduation application process. VARCHAR2(15)
	p_disp_name_ntyp_code	Indicates which alternate name should be displayed on the graduation application self-service diploma name page. VARCHAR2(4)
	p_dgmr_upd_grst_code	Graduation status code to use if the SHRDGMR graduation status will be impacted when the graduation application is submitted. VARCHAR2(3)
	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_code                   shbgadr.shbgadr_code%TYPE,
                     p_tprt_code              shbgadr.shbgadr_tprt_code%TYPE,
                     p_grad_date_disp_ind     shbgadr.shbgadr_grad_date_disp_ind%TYPE,
                     p_grad_term_disp_ind     shbgadr.shbgadr_grad_term_disp_ind%TYPE,
                     p_grad_year_disp_ind     shbgadr.shbgadr_grad_year_disp_ind%TYPE,
                     p_gast_code              shbgadr.shbgadr_gast_code%TYPE,
                     p_dgmr_upd_ind           shbgadr.shbgadr_dgmr_upd_ind%TYPE,
                     p_disp_dipl_name_web_ind shbgadr.shbgadr_disp_dipl_name_web_ind%TYPE,
                     p_disp_name_cde          shbgadr.shbgadr_disp_name_cde%TYPE,
                     p_disp_middle_cde        shbgadr.shbgadr_disp_middle_cde%TYPE,
                     p_disp_suffix_ind        shbgadr.shbgadr_disp_suffix_ind%TYPE,
                     p_disp_dipl_name_ind     shbgadr.shbgadr_disp_dipl_name_ind%TYPE,
                     p_disp_dipl_upd_name_ind shbgadr.shbgadr_disp_dipl_upd_name_ind%TYPE,
                     p_disp_upd_first_ind     shbgadr.shbgadr_disp_upd_first_ind%TYPE,
                     p_disp_upd_middle_ind    shbgadr.shbgadr_disp_upd_middle_ind%TYPE,
                     p_disp_upd_last_ind      shbgadr.shbgadr_disp_upd_last_ind%TYPE,
                     p_disp_upd_suffix_ind    shbgadr.shbgadr_disp_upd_suffix_ind%TYPE,
                     p_disp_dipl_addr_web_ind shbgadr.shbgadr_disp_dipl_addr_web_ind%TYPE,
                     p_disp_dipl_addr_ind     shbgadr.shbgadr_disp_dipl_addr_ind%TYPE,
                     p_disp_dipl_upd_addr_ind shbgadr.shbgadr_disp_dipl_upd_addr_ind%TYPE,
                     p_charge_ind             shbgadr.shbgadr_charge_ind%TYPE,
                     p_user_id                shbgadr.shbgadr_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_letr_code              shbgadr.shbgadr_letr_code%TYPE DEFAULT NULL,
                     p_disp_name_ntyp_code    shbgadr.shbgadr_disp_name_ntyp_code%TYPE DEFAULT NULL,
                     p_dgmr_upd_grst_code     shbgadr.shbgadr_dgmr_upd_grst_code%TYPE DEFAULT NULL,
                     p_data_origin            shbgadr.shbgadr_data_origin%TYPE DEFAULT NULL)

Validates all data in the record.

Parameters

	p_code	Display rule code for the graduation application. VARCHAR2(15) Required Key
	p_tprt_code	Transcript verification type to use for graduation application self-service display rules. VARCHAR2(4) Required
	p_grad_date_disp_ind	Indicator for whether graduation dates will be displayed on the self-service graduation application. VARCHAR2(1) Required
	p_grad_term_disp_ind	Indicator for whether graduation terms will be displayed on the self-service graduation application. VARCHAR2(1) Required
	p_grad_year_disp_ind	Indicator for whether graduation years will be displayed on the self-service graduation application. VARCHAR2(1) Required
	p_gast_code	Status code for the graduation application when it is submitted. VARCHAR2(4) Required
	p_dgmr_upd_ind	Indicator for whether the SHRDGMR table will be impacted when the graduation application is submitted. VARCHAR2(1) Required
	p_disp_dipl_name_web_ind	Indicator for whether the diploma name page will be displayed for self-service graduation applications. VARCHAR2(1) Required
	p_disp_name_cde	Indicator for which name is to be displayed on the self-service graduation application diploma name page. VARCHAR2(1) Required
	p_disp_middle_cde	Indicates the format to use when displaying middle name information on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_suffix_ind	Indicator for whether the name suffix information will be displayed on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_dipl_name_ind	Indicator for whether the diploma name will be displayed on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_dipl_upd_name_ind	Indicator for whether the learner may provide a diploma name on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_upd_first_ind	Indicator for whether the learner may update the first name used for the diploma name on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_upd_middle_ind	Indicator for whether the learner may update the middle name used for the diploma name on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_upd_last_ind	Indicator for whether the learner may update the last name used for the diploma name on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_upd_suffix_ind	Indicator for whether the learner may update the suffix used for the diploma name on the graduation application self-service diploma name page. VARCHAR2(1) Required
	p_disp_dipl_addr_web_ind	Indicator for whether the diploma mailing address will be displayed self-service page displays for self-service graduation applications. VARCHAR2(1) Required
	p_disp_dipl_addr_ind	Indicator for whether the diploma mailing address will be displayed on the graduation application self-service diploma mailing address page. VARCHAR2(1) Required
	p_disp_dipl_upd_addr_ind	Indicator for whether the diploma mailing address information may be updated. VARCHAR2(1) Required
	p_charge_ind	Indicator for whether a charge will apply when the graduation application is submitted. VARCHAR2(1) Required
	p_user_id	ID of the most recent user to create or update the row in the SHBGADR table. VARCHAR2(30) Required
	p_letr_code	Code for the confirmation letter that will be displayed at the end of the self-service graduation application process. VARCHAR2(15)
	p_disp_name_ntyp_code	Indicates which alternate name should be displayed on the graduation application self-service diploma name page. VARCHAR2(4)
	p_dgmr_upd_grst_code	Graduation status code to use if the SHRDGMR graduation status will be impacted when the graduation application is submitted. VARCHAR2(3)
	p_data_origin	Value of the source system that inserted or updated the row. VARCHAR2(30)