index

Package gb_hold_rules

This package provides the support subprograms for the Hold API (gb_hold).

Program units
p_register_entity   Registers the attribute/value pairs to the message cache.
p_register_entity   Registers the attribute/value pairs to the message cache.
p_validate   Validates all the data in the record.

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_internal_record_id VARCHAR2)

Registers the attribute/value pairs to the message cache.
This signature uses the ROWID only for the delete operations.

Parameters
p_internal_record_id   Database ROWID. VARCHAR2(18)

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_pidm               sprhold.sprhold_pidm%TYPE,
                            p_hldd_code          sprhold.sprhold_hldd_code%TYPE,
                            p_user               sprhold.sprhold_user%TYPE,
                            p_from_date          sprhold.sprhold_from_date%TYPE,
                            p_to_date            sprhold.sprhold_to_date%TYPE,
                            p_release_ind        sprhold.sprhold_release_ind%TYPE,
                            p_reason             sprhold.sprhold_reason%TYPE,
                            p_amount_owed        sprhold.sprhold_amount_owed%TYPE,
                            p_orig_code          sprhold.sprhold_orig_code%TYPE,
                            p_data_origin        sprhold.sprhold_data_origin%TYPE,
                            p_internal_record_id VARCHAR2)

Registers the attribute/value pairs to the message cache.
This signature registers all the parameters.

Parameters
p_pidm   Internal identification number of the person record. NUMBER(8) Required
p_hldd_code   Type of hold on the person record. VARCHAR2(2) Required
p_user   Oracle ID of the user initiating the hold. VARCHAR2(30) Required
p_from_date   Effective begin date of the hold. DATE Required
p_to_date   Date the hold expires. DATE Required
p_release_ind   Y - allow only the system user to release the hold. VARCHAR2(1) Required
p_reason   Free-format field which identifies the reason the hold was placed. VARCHAR2(30)
p_amount_owed   Monetary amount associated with the hold. NUMBER(7,2)
p_orig_code   Person or office who authorized the hold status. VARCHAR2(4)
p_data_origin   Source system that generated the data. VARCHAR2(30)
p_internal_record_id   Database ROWID. VARCHAR2(18)

p_validate 

PROCEDURE p_validate(p_pidm        sprhold.sprhold_pidm%TYPE,
                     p_hldd_code   sprhold.sprhold_hldd_code%TYPE,
                     p_user        sprhold.sprhold_user%TYPE,
                     p_from_date   sprhold.sprhold_from_date%TYPE,
                     p_to_date     sprhold.sprhold_to_date%TYPE,
                     p_release_ind sprhold.sprhold_release_ind%TYPE,
                     p_reason      sprhold.sprhold_reason%TYPE DEFAULT NULL,
                     p_amount_owed sprhold.sprhold_amount_owed%TYPE DEFAULT NULL,
                     p_orig_code   sprhold.sprhold_orig_code%TYPE DEFAULT NULL,
                     p_data_origin sprhold.sprhold_data_origin%TYPE DEFAULT NULL)

Validates all the data in the record.

Parameters
p_pidm   Internal identification number of the person record. NUMBER(8) Required
p_hldd_code   Type of hold on the person record. VARCHAR2(2) Required
p_user   Oracle ID of the user initiating the hold. VARCHAR2(30) Required
p_from_date   Effective begin date of the hold. DATE Required
p_to_date   Date the hold expires. DATE Required
p_release_ind   Y - allow only the system user to release the hold. VARCHAR2(1) Required
p_reason   Free-format field which identifies the reason the hold was placed. VARCHAR2(30)
p_amount_owed   Monetary amount associated with the hold. NUMBER(7,2)
p_orig_code   Person or office who authorized the hold status. VARCHAR2(4)
p_data_origin   Source system that generated the data. VARCHAR2(30)