Package nb_effcert_dflt_queue

Package nb_effcert_dflt_queue_rules

This package provides messaging support and field validations for the Effort Certification Default Queue Rule API (NB_EFFCERT_DFLT_QUEUE).

Program units

p_register_entity	Registers the attribute value pairs to the message cache for delete operations.
p_register_entity	Registers the attribute/value pairs to the message cache for create and update operations.
p_validate	Validates all data in the record.

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_id                 ntrecdq.ntrecdq_id%TYPE,
                            p_ntrqprt_id         ntrecdq.ntrecdq_ntrqprt_id%TYPE,
                            p_alt_certifier_ind  ntrecdq.ntrecdq_alt_certifier_ind%TYPE,
                            p_grad_cert_req_ind  ntrecdq.ntrecdq_grad_cert_req_ind%TYPE,
                            p_user_id            ntrecdq.ntrecdq_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_pre_review_action  ntrecdq.ntrecdq_pre_review_action%TYPE,
                            p_post_review_action ntrecdq.ntrecdq_post_review_action%TYPE,
                            p_data_origin        ntrecdq.ntrecdq_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_ntrqprt_id

Internally system-generated unique identification number which represents the primary key of the parent record. NUMBER(19) Required Key.

p_alt_certifier_ind

Indicator that determines if a participant is also a valid alternate certifier for the employee. VARCHAR2(1) Required.

	Y	Yes
	N	No

p_grad_cert_req_ind

Indicator that determines if a participant's signature is required for all graduate student Effort Reports. VARCHAR2(1) Required.

	Y	Yes
	N	No

p_user_id

The Oracle ID of the user who changed the record. VARCHAR2(30) Required.

p_pre_review_action

Indicates the required pre-reviewer actions assigned to a participant in the effort reporting queue. VARCHAR2(1) Required.

	F	FYI
	R	Review
	N	None

p_post_review_action

Indicates the required post-reviewer actions assigned to a participant in the effort reporting queue. VARCHAR2(1) Required.

	F	FYI
	R	Review
	N	None

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_ntrqprt_id         ntrecdq.ntrecdq_ntrqprt_id%TYPE,
                     p_alt_certifier_ind  ntrecdq.ntrecdq_alt_certifier_ind%TYPE,
                     p_grad_cert_req_ind  ntrecdq.ntrecdq_grad_cert_req_ind%TYPE,
                     p_user_id            ntrecdq.ntrecdq_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_pre_review_action  ntrecdq.ntrecdq_pre_review_action%TYPE,
                     p_post_review_action ntrecdq.ntrecdq_post_review_action%TYPE,
                     p_data_origin        ntrecdq.ntrecdq_data_origin%TYPE DEFAULT NULL)

Validates all data in the record.

Parameters

p_id

Internally system-generated unique identification number which represents the primary key of the database record. NUMBER(19) Required.

p_ntrqprt_id

Internally system-generated unique identification number which represents the primary key of the parent record. NUMBER(19) Required Key.

p_alt_certifier_ind

Indicator that determines if a participant is also a valid alternate certifier for the employee. VARCHAR2(1) Required.

	Y	Yes
	N	No

p_grad_cert_req_ind

Indicator that determines if a participant's signature is required for all graduate student Effort Reports. VARCHAR2(1) Required.

	Y	Yes
	N	No

p_user_id

The Oracle ID of the user who changed the record. VARCHAR2(30) Required.

p_pre_review_action

Indicates the required pre-reviewer actions assigned to a participant in the effort reporting queue. VARCHAR2(1) Required.

	F	FYI
	R	Review
	N	None

p_post_review_action

Indicates the required post-reviewer actions assigned to a participant in the effort reporting queue. VARCHAR2(1) Required.

	F	FYI
	R	Review
	N	None

p_data_origin

Source system that created or updated the row. VARCHAR2(30).