Data Load And Metadata Load Signature

Data Load And Metadata Load Signature

CREATE OR REPLACE PACKAGE APPS.icx_ecc_util_pvt AUTHID CURRENT_USER AS
/* $Header: ICXECCUS.pls 120.0.1 2018/11/29 11:10:32 noship $ */ g_icx_ecc_ins_op CONSTANT VARCHAR2(30) := 'INSERT'; g_icx_ecc_upd_op CONSTANT VARCHAR2(30) := 'UPDATE'; g_icx_ecc_del_op CONSTANT VARCHAR2(30) := 'DELETE'; g_icx_ecc_ups_op CONSTANT VARCHAR2(30) := 'UPSERT';
g_icx_exc_op CONSTANT VARCHAR2(30) := 'EXECUTE'; g_icx_dsc_op CONSTANT VARCHAR2(30) := 'DESCRIBE';
g_icx_dsc_att_op CONSTANT VARCHAR2(30) := 'DESCRIBE|ATTRIBUTE';
g_icx_dsc_pre_op CONSTANT VARCHAR2(30) := 'DESCRIBE|PRECEDENCE_RULE';
g_icx_exc_op CONSTANT VARCHAR2(30) := 'EXECUTE'; g_icx_exc_att_op CONSTANT VARCHAR2(30) := 'EXECUTE|ATTRIBUTE';
g_icx_exc_pre_op CONSTANT VARCHAR2(30) := 'EXECUTE|PRECEDENCE_RULE';
/*
** GET_ECC_DATA_LOAD_INFO - Retrieves the data load details for the given data set key
**
** IN parameters
**      p_dataset_key - data set key
**      p_load_type - Indicating Full or incremental load (F/I/Custom).For custom there are no data load rules defined
**      p_ds_last_success_run - Returns the last successful etl run for the data set key
**      OUT parameters
**      x_ecc_ds_meta_rec - ecc_ds_meta_rec
**      x_return_status - return status
*/
----------------------------------------------------------------------
PROCEDURE get_ecc_data_load_info ( p_dataset_key        IN VARCHAR2,
p_load_type             IN VARCHAR2, p_ds_last_success_run              IN TIMESTAMP, p_languages       IN VARCHAR2,
p_addl_params   IN ecc_sec_field_values, x_ecc_ds_meta_rec      OUT NOCOPY ecc_ds_meta_rec, x_return_status     OUT NOCOPY VARCHAR2
);
----------------------------------------------------------------------
/*
** GET_SQL_TEXT - Retrieves the sql text for a data set
** IN parameters
**      p_dataset_key - data set key
**      p_load_type - Indicating Full or incremental load (F/I/Custom).For custom there are no data load rules defined
**      p_operation - Indicates the operations INSERT,UPDATE,DELETE and UPSERT
**      p_data_type - Indicates the type of data
**      p_ds_last_success_run - Returns the last successful etl run for the data set key
**      RETURNS sql text
*/
FUNCTION get_sql_text (
p_dataset_key   IN VARCHAR2,
p_load_type     IN VARCHAR2,
p_operation     IN VARCHAR2,
p_data_type     IN VARCHAR2, p_ds_last_success_run      IN TIMESTAMP, p_languages       IN VARCHAR2
) RETURN CLOB;
PROCEDURE create_ecc_desc_view ( p_category_id IN NUMBER
);
PROCEDURE create_ecc_desc_views; PROCEDURE drop_ecc_desc_views; PROCEDURE get_desc_metadata_load_info (
p_dataset_key   IN VARCHAR2,
p_dataset_attrs IN ecc_sec_field_values DEFAULT NULL, p_languages               IN VARCHAR2,
x_ecc_ds_meta_rec       OUT NOCOPY ecc_ds_meta_rec, x_return_status     OUT NOCOPY VARCHAR2
);

FUNCTION makencname ( p_attribute_name IN VARCHAR2
) RETURN VARCHAR2;
PROCEDURE submit_ecc_data_load (
errbuf  OUT NOCOPY VARCHAR2,
retcode OUT NOCOPY VARCHAR2,
p_system_name   IN VARCHAR2, p_load_type        IN VARCHAR2,
p_languages     IN VARCHAR2,
p_log_level     IN VARCHAR2, p_trace_enabled    IN VARCHAR2
);
END icx_ecc_util_pvt;
/