[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;