Package sb_gradapp_paymentopts

Package sb_gradapp_paymentopts_rules

Support subprograms for the Graduation Application Payment Options API (sb_gradapp_paymentopts).

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          shrgapo.shrgapo_gadr_code%TYPE,
                            p_wpyo_code          shrgapo.shrgapo_wpyo_code%TYPE,
                            p_detc_code          shrgapo.shrgapo_detc_code%TYPE,
                            p_chrg               shrgapo.shrgapo_chrg%TYPE,
                            p_user_id            shrgapo.shrgapo_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin        shrgapo.shrgapo_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_wpyo_code	Code of the payment option available for self-service requests. VARCHAR2(4) Required
	p_detc_code	Detail code associated with each charge and payment that can be entered onto an account. VARCHAR2(4) Required Key
	p_chrg	Charge associated with the service. NUMBER(12,2) Required
	p_user_id	ID of the most recent user to create or update the row in the SHRGAPO table. VARCHAR2(30) Required
	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   shrgapo.shrgapo_gadr_code%TYPE,
                     p_wpyo_code   shrgapo.shrgapo_wpyo_code%TYPE,
                     p_detc_code   shrgapo.shrgapo_detc_code%TYPE,
                     p_chrg        shrgapo.shrgapo_chrg%TYPE,
                     p_user_id     shrgapo.shrgapo_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_data_origin shrgapo.shrgapo_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_wpyo_code	Code of the payment option available for self-service requests. VARCHAR2(4) Required
	p_detc_code	Detail code associated with each charge and payment that can be entered onto an account. VARCHAR2(4) Required Key
	p_chrg	Charge associated with the service. NUMBER(12,2) Required
	p_user_id	ID of the most recent user to create or update the row in the SHRGAPO table. VARCHAR2(30) Required
	p_data_origin	Value of the source system that inserted or updated the row. VARCHAR2(30)