DBA Data[Home] [Help]

PACKAGE: APPS.RCI_CTRL_DETAIL_ETL_PKG

Source


1 PACKAGE RCI_CTRL_DETAIL_ETL_PKG AUTHID CURRENT_USER AS
2 --$Header: rcicdtetls.pls 120.3.12000000.1 2007/01/16 20:46:08 appldev ship $
3 
4 PROCEDURE initial_load(
5    errbuf    IN OUT NOCOPY  VARCHAR2
6   ,retcode   IN OUT NOCOPY  NUMBER);
7 
8 PROCEDURE incr_load(
9    errbuf  IN OUT NOCOPY VARCHAR2
10   ,retcode IN OUT NOCOPY NUMBER);
11 
12 FUNCTION get_last_run_date ( p_fact_name VARCHAR2) RETURN DATE;
13 
14 FUNCTION err_mesg (
15    p_mesg      IN VARCHAR2
16   ,p_proc_name IN VARCHAR2 DEFAULT NULL
17   ,p_stmt_id   IN NUMBER DEFAULT -1) RETURN VARCHAR2 ;
18 
19 PROCEDURE check_initial_load_setup (
20    x_global_start_date OUT NOCOPY DATE
21   ,x_rci_schema 	   OUT NOCOPY VARCHAR2);
22 
23 END RCI_CTRL_DETAIL_ETL_PKG;