Package gb_streams_columns

Package gb_streams_columns_rules

Support subprograms for the STREAMS_COLUMNS API (gb_streams_columns).

Program units

f_parent_exists
p_register_entity	Register 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.

f_parent_exists

FUNCTION f_parent_exists(p_ctab_seq_no gorccol.gorccol_ctab_seq_no%TYPE)
  RETURN VARCHAR2

p_register_entity

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_internal_record_id gb_common.internal_record_id_type)

Register 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_ctab_seq_no        gorccol.gorccol_ctab_seq_no%TYPE,
                            p_column_name        gorccol.gorccol_column_name%TYPE,
                            p_user_id            gorccol.gorccol_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin        gorccol.gorccol_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_ctab_seq_no	References GORCTAB_SEQ_NO in GORCTAB. Repeats itself for every row in GORCTAB. NUMBER(,) Required Key
	p_column_name	Column name of a table that is monitored. VARCHAR2(30) Required Key
	p_user_id	User ID of the user who created or last updated the row. VARCHAR2(30) Required
	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_ctab_seq_no gorccol.gorccol_ctab_seq_no%TYPE,
                     p_column_name gorccol.gorccol_column_name%TYPE,
                     p_user_id     gorccol.gorccol_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_data_origin gorccol.gorccol_data_origin%TYPE DEFAULT NULL)

Validates all data in the record.

Parameters

	p_ctab_seq_no	References GORCTAB_SEQ_NO in GORCTAB. Repeats itself for every row in GORCTAB. NUMBER(,) Required Key
	p_column_name	Column name of a table that is monitored. VARCHAR2(30) Required Key
	p_user_id	User ID of the user who created or last updated the row. VARCHAR2(30) Required
	p_data_origin	Source system that created or updated the row. VARCHAR2(30)