Package sb_gradapp_graddate

Package sb_gradapp_graddate_rules

Support subprograms for the Graduation Application Graduation Date Availability API (sb_gradapp_graddate).

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_gadr_code          shrgada.shrgada_gadr_code%TYPE,
                            p_seqno              shrgada.shrgada_seqno%TYPE,
                            p_from_date          shrgada.shrgada_from_date%TYPE,
                            p_to_date            shrgada.shrgada_to_date%TYPE,
                            p_ceremony_ind       shrgada.shrgada_ceremony_ind%TYPE,
                            p_user_id            shrgada.shrgada_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_grad_date          shrgada.shrgada_grad_date%TYPE,
                            p_grad_term_code     shrgada.shrgada_grad_term_code%TYPE,
                            p_acyr_code          shrgada.shrgada_acyr_code%TYPE,
                            p_data_origin        shrgada.shrgada_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_gadr_code	Display rule code for the graduation application. VARCHAR2(15) Required Key
	p_seqno	One-up number assigned to the row for the display rule code. NUMBER(4) Required Key
	p_from_date	First date that the graduation date availability record is valid. DATE Required
	p_to_date	Last date that the graduation date availability record is valid. DATE Required
	p_ceremony_ind	Indicator for whether the graduation will have a ceremony. VARCHAR2(1) Required
	p_user_id	ID of the most recent user to create or update the row in the SHRGADA table. VARCHAR2(30) Required
	p_grad_date	Graduation date. DATE
	p_grad_term_code	Graduation term. VARCHAR2(6)
	p_acyr_code	Graduation year. VARCHAR2(4)
	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_gadr_code      shrgada.shrgada_gadr_code%TYPE,
                     p_seqno          shrgada.shrgada_seqno%TYPE,
                     p_from_date      shrgada.shrgada_from_date%TYPE,
                     p_to_date        shrgada.shrgada_to_date%TYPE,
                     p_ceremony_ind   shrgada.shrgada_ceremony_ind%TYPE,
                     p_user_id        shrgada.shrgada_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_grad_date      shrgada.shrgada_grad_date%TYPE DEFAULT NULL,
                     p_grad_term_code shrgada.shrgada_grad_term_code%TYPE DEFAULT NULL,
                     p_acyr_code      shrgada.shrgada_acyr_code%TYPE DEFAULT NULL,
                     p_data_origin    shrgada.shrgada_data_origin%TYPE DEFAULT NULL)

Validates all data in the record.

Parameters

	p_gadr_code	Display rule code for the graduation application. VARCHAR2(15) Required Key
	p_seqno	One-up number assigned to the row for the display rule code. NUMBER(4) Required Key
	p_from_date	First date that the graduation date availability record is valid. DATE Required
	p_to_date	Last date that the graduation date availability record is valid. DATE Required
	p_ceremony_ind	Indicator for whether the graduation will have a ceremony. VARCHAR2(1) Required
	p_user_id	ID of the most recent user to create or update the row in the SHRGADA table. VARCHAR2(30) Required
	p_grad_date	Graduation date. DATE
	p_grad_term_code	Graduation term. VARCHAR2(6)
	p_acyr_code	Graduation year. VARCHAR2(4)
	p_data_origin	Value of the source system that inserted or updated the row. VARCHAR2(30)