DBA Data[Home] [Help]

PACKAGE: APPS.EDW_INSTANCE_COLLECT

Source


1 package EDW_INSTANCE_COLLECT AUTHID CURRENT_USER AS
2 /*$Header: EDWCINSS.pls 115.7 2002/11/23 00:09:01 vsurendr ship $*/
3 
4 g_status boolean;
5 g_dim_name varchar2(400);
6 g_insert_stmt varchar2(30000);
7 g_update_stmt varchar2(30000);
8 g_collection_start_date date;
9 g_collection_end_date date;
10 g_conc_program_id number;
11 G_CONC_PROGRAM_NAME varchar2(500);
12 g_object_type varchar2(200);
13 g_number_rows_processed number;
14 g_debug boolean;
15 g_status_message varchar2(10000);
16 
17 PROCEDURE COLLECT_DIMENSION(errbuf out NOCOPY varchar2, retcode out NOCOPY varchar2, p_dim_name varchar2);
18 procedure Init_all;
19 procedure make_insert_stmt ;
20 procedure execute_insert_stmt;
21 procedure return_with_success;
22 procedure return_with_error;
23 procedure call_main_collection(errbuf out NOCOPY varchar2, retcode out NOCOPY varchar2);
24 procedure write_to_push_log(p_flag boolean);
25 procedure write_to_log_file(p_message varchar2) ;
26 procedure write_to_log_file_n(p_message varchar2) ;
27 function get_time return varchar2 ;
28 
29 END EDW_INSTANCE_COLLECT;