index

Package sb_edi_status_rules

This package provides the support subprograms for the EDI Status API (sb_edi_status).
For use with internal processing to produce the XML transcript.

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 the 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 the 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_dcmt_seqno         shredis.shredis_dcmt_seqno%TYPE,
                            p_dsts_code          shredis.shredis_dsts_code%TYPE,
                            p_comp_ind           shredis.shredis_comp_ind%TYPE,
                            p_priority           shredis.shredis_priority%TYPE,
                            p_user               shredis.shredis_user%TYPE DEFAULT gb_common.f_sct_user,
                            p_date_in            shredis.shredis_date_in%TYPE,
                            p_date_out           shredis.shredis_date_out%TYPE,
                            p_data_origin        shredis.shredis_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 the parameters.

Parameters
p_operation_type   Type of DML operation: create, update, delete. NUMBER Required.
p_dcmt_seqno   EDI document ID number. NUMBER(8) Required Key.
p_dsts_code   EDI document disposition status code. VARCHAR2(4) Required Key.
p_comp_ind   [A]ctive/[I]nactive. VARCHAR2(1) Required.
p_priority   EDI document priority. NUMBER(2) Required.
p_user   EDI user name. VARCHAR2(30) Required.
p_date_in   EDI date status became active. DATE Required.
p_date_out   EDI date status became inactive. DATE.
p_data_origin   Source system that created or updated the data. VARCHAR2(30).
p_internal_record_id   Database ROWID. VARCHAR2(18) Required.

p_validate 

PROCEDURE p_validate(p_dcmt_seqno  shredis.shredis_dcmt_seqno%TYPE,
                     p_dsts_code   shredis.shredis_dsts_code%TYPE,
                     p_comp_ind    shredis.shredis_comp_ind%TYPE,
                     p_priority    shredis.shredis_priority%TYPE,
                     p_user        shredis.shredis_user%TYPE DEFAULT gb_common.f_sct_user,
                     p_date_in     shredis.shredis_date_in%TYPE,
                     p_date_out    shredis.shredis_date_out%TYPE DEFAULT NULL,
                     p_data_origin shredis.shredis_data_origin%TYPE DEFAULT NULL);

Validates all the data in the record.

Parameters
p_dcmt_seqno   EDI document ID number. NUMBER(8) Required Key.
p_dsts_code   EDI document disposition status code. VARCHAR2(4) Required Key.
p_comp_ind   [A]ctive/[I]nactive. VARCHAR2(1) Required.
p_priority   EDI document priority. NUMBER(2) Required.
p_user   EDI user name. VARCHAR2(30) Required.
p_date_in   EDI date status became active. DATE Required.
p_date_out   EDI date status became inactive. DATE
p_data_origin   Source system that created or updated the data. VARCHAR2(30).