Package sb_transfer_crse_attr

Package sb_transfer_crse_attr_rules

Support subprograms for the Transfer Course Attribute (sb_transfer_crse_attr).

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        shrtcat.shrtcat_primary_key%TYPE,
                            p_sbgi_code          shrtcat.shrtcat_sbgi_code%TYPE,
                            p_program            shrtcat.shrtcat_program%TYPE,
                            p_tlvl_code          shrtcat.shrtcat_tlvl_code%TYPE,
                            p_subj_cde_trns      shrtcat.shrtcat_subj_cde_trns%TYPE,
                            p_crse_numb_trns     shrtcat.shrtcat_crse_numb_trns%TYPE,
                            p_term_code_eff_trns shrtcat.shrtcat_term_code_eff_trns%TYPE,
                            p_attr_cde           shrtcat.shrtcat_attr_cde%TYPE,
                            p_attr_desc          shrtcat.shrtcat_attr_desc%TYPE,
                            p_user_id            shrtcat.shrtcat_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_group              shrtcat.shrtcat_group%TYPE,
                            p_data_origin        shrtcat.shrtcat_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	Primary key of the transfer course record. NUMBER(9) Required Key
	p_sbgi_code	Sending institutions ID code. VARCHAR2(6) Required
	p_program	Program code associated with the transfer course. VARCHAR2(12) Required
	p_tlvl_code	Level code of the transfer course. VARCHAR2(2) Required
	p_subj_cde_trns	Subject code of the transfer course. VARCHAR2(60) Required
	p_crse_numb_trns	Course number of the transfer course. VARCHAR2(60) Required
	p_term_code_eff_trns	Effective term of the transfer course. VARCHAR2(6) Required
	p_attr_cde	Attribute code of the transfer course. VARCHAR2(4) Required
	p_attr_desc	Description of the attribute code of the transfer course. VARCHAR2(30) Required
	p_user_id	User ID of the user who created or last updated the record. VARCHAR2(30) Required
	p_group	Group code associated with the transfer course. 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_primary_key        shrtcat.shrtcat_primary_key%TYPE,
                     p_sbgi_code          shrtcat.shrtcat_sbgi_code%TYPE,
                     p_program            shrtcat.shrtcat_program%TYPE,
                     p_tlvl_code          shrtcat.shrtcat_tlvl_code%TYPE,
                     p_subj_cde_trns      shrtcat.shrtcat_subj_cde_trns%TYPE,
                     p_crse_numb_trns     shrtcat.shrtcat_crse_numb_trns%TYPE,
                     p_term_code_eff_trns shrtcat.shrtcat_term_code_eff_trns%TYPE,
                     p_attr_cde           shrtcat.shrtcat_attr_cde%TYPE,
                     p_attr_desc          shrtcat.shrtcat_attr_desc%TYPE,
                     p_user_id            shrtcat.shrtcat_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_group              shrtcat.shrtcat_group%TYPE DEFAULT NULL,
                     p_data_origin        shrtcat.shrtcat_data_origin%TYPE DEFAULT NULL)

Validates all data in the record.

Parameters

	p_primary_key	Primary key of the transfer course record. NUMBER(9) Required Key
	p_sbgi_code	Sending institutions ID code. VARCHAR2(6) Required
	p_program	Program code associated with the transfer course. VARCHAR2(12) Required
	p_tlvl_code	Level code of the transfer course. VARCHAR2(2) Required
	p_subj_cde_trns	Subject code of the transfer course. VARCHAR2(60) Required
	p_crse_numb_trns	Course number of the transfer course. VARCHAR2(60) Required
	p_term_code_eff_trns	Effective term of the transfer course. VARCHAR2(6) Required
	p_attr_cde	Attribute code of the transfer course. VARCHAR2(4) Required
	p_attr_desc	Description of the attribute code of the transfer course. VARCHAR2(30) Required
	p_user_id	User ID of the user who created or last updated the record. VARCHAR2(30) Required
	p_group	Group code associated with the transfer course. VARCHAR2(2)
	p_data_origin	Source system that created or updated the row. VARCHAR2(30)