index

Package BANINST1.fb_circulation_header_rules

Support subprograms for the CIRCULATION_HEADER (fb_circulation_header).

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                    fobcirh.fobcirh_id%TYPE,
                            p_name                  fobcirh.fobcirh_name%TYPE,
                            p_type                  fobcirh.fobcirh_type%TYPE,
                            p_status                fobcirh.fobcirh_status%TYPE,
                            p_owner_pidm            fobcirh.fobcirh_owner_pidm%TYPE,
                            p_active_ind            fobcirh.fobcirh_active_ind%TYPE,
                            p_all_organizations_ind fobcirh.fobcirh_all_organizations_ind%TYPE,
                            p_header_change_ind     fobcirh.fobcirh_header_change_ind%TYPE,
                            p_routing_change_ind    fobcirh.fobcirh_routing_change_ind%TYPE,
                            p_lock_object_ind       fobcirh.fobcirh_lock_object_ind%TYPE,
                            p_template_ind          fobcirh.fobcirh_template_ind%TYPE,
                            p_trigger_enabled_ind   fobcirh.fobcirh_trigger_enabled_ind%TYPE,
                            p_user_id               fobcirh.fobcirh_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin           fobcirh.fobcirh_data_origin%TYPE,
                            p_success_status        fobcirh.fobcirh_success_status%TYPE,
                            p_supl_email_text       fobcirh.fobcirh_supl_email_text%TYPE,
                            p_completion_date       fobcirh.fobcirh_completion_date%TYPE,
                            p_start_date            fobcirh.fobcirh_start_date%TYPE,
                            p_desc                  fobcirh.fobcirh_desc%TYPE,
                            p_trigger_type          fobcirh.fobcirh_trigger_type%TYPE,
                            p_trigger_value         fobcirh.fobcirh_trigger_value%TYPE,
                            p_fobcirh_id            fobcirh.fobcirh_fobcirh_id%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_id   Unique internal identification number of the record. NUMBER(19) Required Key
p_name   User-entered or system-generated name of the circulation. VARCHAR2(240) Required
p_type   Circulation object type. VARCHAR2(200) Required
p_status   Reflects the current status of the Circulation. VARCHAR2(200) Required
p_owner_pidm   the owner of the circulation. NUMBER(8).
p_active_ind   Indicates if the circulation is available for use. VARCHAR2(4) Required
p_all_organizations_ind   Determines whether this circulation is assocated to a singular or multiple organizations.
p_header_change_ind   Determines if you can create a copy of the template and make modifications to the circulation. VARCHAR2(4) Required
p_routing_change_ind   Determines if you can create a copy of the template and make modifications to the circulation routing. VARCHAR2(4) Required
p_lock_object_ind   Determines if the source circulation object is locked and cannot be changed. VARCHAR2(4) Required
p_template_ind   Indicates the circulation is a template circulation or not. VARCHAR2(4) Required
p_trigger_enabled_ind   Indicates the circulation trigger is enabled or not. VARCHAR2(4) Required
p_user_id   The unique identification code of the user who last touched this record. VARCHAR2(120) Required
p_data_origin   Source system that created or updated the row. VARCHAR2(120)
p_success_status   The Approval Status to which the object is moved when the circulation is successful. This means that there are no disapprovals encountered in the Circulation. Not valid if the type is Notification. VARCHAR2(200)
p_supl_email_text   Additional email text to be included on all emails to recipients. VARCHAR2(4000)
p_completion_date   Actual date and time that the circulation was completed. TIMESTAMP(6)
p_start_date   Actual date and time that the circulation was started. TIMESTAMP(6)
p_desc   Circulation description. VARCHAR2(1020)
p_trigger_type   The type of event that starts the Circulation. VARCHAR2(200)
p_trigger_value   The intended string value for a triggerType that would cause the circulation to be run. VARCHAR2(200)
p_fobcirh_id   Unique internal identification number of the source circulation record. NUMBER(19)
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_validate 

Procedure p_validate(p_id                    fobcirh.fobcirh_id%TYPE,
                     p_name                  fobcirh.fobcirh_name%TYPE,
                     p_type                  fobcirh.fobcirh_type%TYPE,
                     p_status                fobcirh.fobcirh_status%TYPE,
                     p_owner_pidm            fobcirh.fobcirh_owner_pidm%TYPE,
                     p_active_ind            fobcirh.fobcirh_active_ind%TYPE,
                     p_all_organizations_ind fobcirh.fobcirh_all_organizations_ind%TYPE,
                     p_header_change_ind     fobcirh.fobcirh_header_change_ind%TYPE,
                     p_routing_change_ind    fobcirh.fobcirh_routing_change_ind%TYPE,
                     p_lock_object_ind       fobcirh.fobcirh_lock_object_ind%TYPE,
                     p_template_ind          fobcirh.fobcirh_template_ind%TYPE,
                     p_trigger_enabled_ind   fobcirh.fobcirh_trigger_enabled_ind%TYPE,
                     p_user_id               fobcirh.fobcirh_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_data_origin           fobcirh.fobcirh_data_origin%TYPE DEFAULT NULL,
                     p_success_status        fobcirh.fobcirh_success_status%TYPE DEFAULT NULL,
                     p_supl_email_text       fobcirh.fobcirh_supl_email_text%TYPE DEFAULT NULL,
                     p_completion_date       fobcirh.fobcirh_completion_date%TYPE DEFAULT NULL,
                     p_start_date            fobcirh.fobcirh_start_date%TYPE DEFAULT NULL,
                     p_desc                  fobcirh.fobcirh_desc%TYPE DEFAULT NULL,
                     p_trigger_type          fobcirh.fobcirh_trigger_type%TYPE DEFAULT NULL,
                     p_trigger_value         fobcirh.fobcirh_trigger_value%TYPE DEFAULT NULL,
                     p_fobcirh_id            fobcirh.fobcirh_fobcirh_id%TYPE DEFAULT NULL)

Validates all data in the record.

Parameters
p_id   Unique internal identification number of the record. NUMBER(19) Required Key
p_name   User-entered or system-generated name of the circulation. VARCHAR2(240) Required
p_type   Circulation object type. VARCHAR2(200) Required
p_status   Reflects the current status of the Circulation. VARCHAR2(200) Required
p_owner_pidm   the owner of the circulation. NUMBER(8).
p_active_ind   Indicates if the circulation is available for use. VARCHAR2(4) Required
p_all_organizations_ind   Determines whether this circulation is associated to a singular or multiple organizations.
p_header_change_ind   Determines if you can create a copy of the template and make modifications to the circulation. VARCHAR2(4) Required
p_routing_change_ind   Determines if you can create a copy of the template and make modifications to the circulation routing. VARCHAR2(4) Required
p_lock_object_ind   Determines if the source circulation object is locked and cannot be changed. VARCHAR2(4) Required
p_template_ind   Indicates the circulation is a template circulation or not. VARCHAR2(4) Required
p_trigger_enabled_ind   Indicates the circulation trigger is enabled or not. VARCHAR2(4) Required
p_user_id   The unique identification code of the user who last touched this record. VARCHAR2(120) Required
p_data_origin   Source system that created or updated the row. VARCHAR2(120)
p_success_status   The Approval Status to which the object is moved when the circulation is successful. This means that there are no disapprovals encountered in the Circulation. Not valid if the type is Notification. VARCHAR2(200)
p_supl_email_text   Additional email text to be included on all emails to recipients. VARCHAR2(4000)
p_completion_date   Actual date and time that the circulation was completed. TIMESTAMP(6)
p_start_date   Actual date and time that the circulation was started. TIMESTAMP(6)
p_desc   Circulation description. VARCHAR2(1020)
p_trigger_type   The type of event that starts the Circulation. VARCHAR2(200)
p_trigger_value   The intended string value for a triggerType that would cause the circulation to be run. VARCHAR2(200)
p_fobcirh_id   Unique internal identification number of the source circulation record. NUMBER(19)