Package sb_incmp_grading

Package sb_incmp_grading_rules

This package provides support for messaging and data validation for the Incomplete Grade Rule API (sb_incmp_grading).

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_primary_key          shrincg.shrincg_primary_key%TYPE,
                            p_term_code_eff        shrincg.shrincg_term_code_eff%TYPE,
                            p_incmp_grading_ind    shrincg.shrincg_incmp_grading_ind%TYPE,
                            p_incmp_grde_over_ind  shrincg.shrincg_incmp_grde_over_ind%TYPE,
                            p_incmp_date_over_type shrincg.shrincg_incmp_date_over_type%TYPE,
                            p_disp_web_ind         shrincg.shrincg_disp_web_ind%TYPE,
                            p_system_req_ind       shrincg.shrincg_system_req_ind%TYPE,
                            p_user_id              shrincg.shrincg_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_levl_code            shrincg.shrincg_levl_code%TYPE,
                            p_data_origin          shrincg.shrincg_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_primary_key	Unique sequence number to identify the incomplete grade rule. NUMBER(9) Required Key
	p_term_code_eff	Term code to identify when the incomplete grade rule becomes effective. VARCHAR2(6) Required
	p_incmp_grading_ind	Indicator for whether incomplete grading logic is active for this rule. Valid values are "Y" or "N". VARCHAR2(1) Required
	p_incmp_grde_over_ind	Indicator for whether faculty can override the default incomplete final grades. Valid values are "Y" or "N". VARCHAR2(1) Required
	p_incmp_date_over_type	Indicator for whether instructors can override the extension date for incompletes. Values are "S"-allow only to shorten, "L"-allow only to lengthen, "A"-allow any date or "N"-not allowed.VARCHAR2(1) Required
	p_disp_web_ind	Indicator for whether the default final grade and extension date are to be displayed on the web for students with incomplete grades. Valid values are "Y" or "N". VARCHAR2(1) Required
	p_system_req_ind	System required indicator. VARCHAR2(1) Required
	p_user_id	ID of the user who inserted or last updated the data. VARCHAR2(30) Required
	p_levl_code	Level code associated to a term; defines an incomplete grade rule. VARCHAR2(2)
	p_data_origin	Source system that created or updated the row. VARCHAR2(30)
	p_internal_record_id	Database ROWID VARCHAR2(18) required

p_validate

Procedure p_validate(p_term_code_eff        shrincg.shrincg_term_code_eff%TYPE,
                     p_incmp_grading_ind    shrincg.shrincg_incmp_grading_ind%TYPE,
                     p_incmp_grde_over_ind  shrincg.shrincg_incmp_grde_over_ind%TYPE,
                     p_incmp_date_over_type shrincg.shrincg_incmp_date_over_type%TYPE,
                     p_disp_web_ind         shrincg.shrincg_disp_web_ind%TYPE,
                     p_system_req_ind       shrincg.shrincg_system_req_ind%TYPE,
                     p_user_id              shrincg.shrincg_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_levl_code            shrincg.shrincg_levl_code%TYPE DEFAULT NULL,
                     p_data_origin          shrincg.shrincg_data_origin%TYPE DEFAULT NULL)

Validates all data in the record.

Parameters

	p_term_code_eff	Term code to identify when the incomplete grade rule becomes effective. VARCHAR2(6) Required
	p_incmp_grading_ind	Indicator for whether incomplete grading logic is active for this rule. Valid values are "Y" or "N". VARCHAR2(1) Required
	p_incmp_grde_over_ind	Indicator for whether faculty can override the default incomplete final grades. Valid values are "Y" or "N". VARCHAR2(1) Required
	p_incmp_date_over_type	Indicator for whether instructors can override the extension date for incompletes. Values are "S"-allow only to shorten, "L"-allow only to lengthen, "A"-allow any date or "N"-not allowed.VARCHAR2(1) Required
	p_disp_web_ind	Indicator for whether the default final grade and extension date are to be displayed on the web for students with incomplete grades. Valid values are "Y" or "N". VARCHAR2(1) Required
	p_system_req_ind	System required indicator. VARCHAR2(1) Required
	p_user_id	ID of the user who inserted or last updated the data. VARCHAR2(30) Required
	p_levl_code	Level code associated to a term; defines an incomplete grade rule. VARCHAR2(2)
	p_data_origin	Source system that created or updated the row. VARCHAR2(30)