PACKAGE: APPS.RCI_PROC_DETAIL_ETL_PKG

Source

1 PACKAGE RCI_PROC_DETAIL_ETL_PKG AUTHID CURRENT_USER AS
2 --$Header: rciprdtetls.pls 120.4.12000000.1 2007/01/16 20:46:41 appldev ship $
3 
4 /**01.01.2006 npanandi: obsoleted earlier initial_load because of new finstmt ETL query**/
5 PROCEDURE initial_load(
6    errbuf    IN OUT NOCOPY  VARCHAR2
7   ,retcode   IN OUT NOCOPY  NUMBER);
8 
9 PROCEDURE initial_load_obsolete(
10    errbuf    IN OUT NOCOPY  VARCHAR2
11   ,retcode   IN OUT NOCOPY  NUMBER);
12 
13 /**01.01.2006 npanandi: obsoleted earlier incremental_load because of new finstmt ETL query**/
14 PROCEDURE incr_load(
15    errbuf  IN OUT NOCOPY VARCHAR2
16   ,retcode IN OUT NOCOPY NUMBER);
17 
18 PROCEDURE incr_load_obsolete(
19    errbuf  IN OUT NOCOPY VARCHAR2
20   ,retcode IN OUT NOCOPY NUMBER);
21 
22 FUNCTION get_last_run_date ( p_fact_name VARCHAR2) RETURN DATE;
23 
24 FUNCTION err_mesg (
25    p_mesg      IN VARCHAR2
26   ,p_proc_name IN VARCHAR2 DEFAULT NULL
27   ,p_stmt_id   IN NUMBER DEFAULT -1) RETURN VARCHAR2 ;
28 
29 PROCEDURE check_initial_load_setup (
30    x_global_start_date OUT NOCOPY DATE
31   ,x_rci_schema 	   OUT NOCOPY VARCHAR2);
32 
33 END RCI_PROC_DETAIL_ETL_PKG;