1 PACKAGE opi_dbi_common_mod_incr_pkg AS
2 /*$Header: OPIDCMODRS.pls 120.1 2005/08/10 01:51:01 sberi noship $ */
3
4
5 /* Outer wrapper routine for to run the common module */
6 PROCEDURE run_common_module_incr (errbuf OUT NOCOPY VARCHAR2,
7 retcode OUT NOCOPY NUMBER);
8
9
10 /* API for user ETLs to report successful collection */
11 FUNCTION etl_report_success (p_etl_id IN NUMBER, p_source IN NUMBER)
12 RETURN BOOLEAN;
13
14 /* API for ETLs to ensure that bounds are setup correctly for them */
15 FUNCTION incr_end_bounds_setup (p_etl_id IN NUMBER, p_source IN NUMBER)
16 RETURN BOOLEAN;
17
18 /* API for ETL incremental loads to that they are meant to run and not the
19 incremental loads
20 */
21 FUNCTION run_incr_load (p_etl_id IN NUMBER, p_source IN NUMBER)
22 RETURN BOOLEAN;
23
24 END opi_dbi_common_mod_incr_pkg;