PACKAGE: APPS.RCI_UNMTG_RISKS_ETL_PKG

Source

1 PACKAGE RCI_UNMTG_RISKS_ETL_PKG AUTHID CURRENT_USER AS
2 --$Header: rciounmretls.pls 120.2.12000000.1 2007/01/16 20:46:38 appldev ship $
3 
4 ---12.30.2005 npanandi: added new version of initial load and obsoleted original one
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 ---12.30.2005 npanandi: added new version of incremental load and obsoleted original one
14 PROCEDURE incr_load(
15    errbuf  IN OUT NOCOPY VARCHAR2
16   ,retcode IN OUT NOCOPY NUMBER);
17 
18   /***
19 PROCEDURE incr_load_obsolete(
20    errbuf  IN OUT NOCOPY VARCHAR2
21   ,retcode IN OUT NOCOPY NUMBER);
22 ***/
23 FUNCTION get_last_run_date ( p_fact_name VARCHAR2) RETURN DATE;
24 
25 FUNCTION err_mesg (
26    p_mesg      IN VARCHAR2
27   ,p_proc_name IN VARCHAR2 DEFAULT NULL
28   ,p_stmt_id   IN NUMBER DEFAULT -1) RETURN VARCHAR2 ;
29 
30 PROCEDURE check_initial_load_setup (
31    x_global_start_date OUT NOCOPY DATE
32   ,x_rci_schema 	   OUT NOCOPY VARCHAR2);
33 
34 END RCI_UNMTG_RISKS_ETL_PKG;