PACKAGE: APPS.EDW_NAEDW_PUSH

Source

1 package EDW_NAEDW_PUSH AUTHID CURRENT_USER AS
2 /*$Header: EDWNAEDS.pls 115.15 2002/11/23 00:09:31 vsurendr ship $*/
3 
4 g_dim_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
5 g_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
6 g_number_dims number;
7 
8 g_levels  EDW_OWB_COLLECTION_UTIL.varcharTableType;
9 g_level_status  EDW_OWB_COLLECTION_UTIL.varcharTableType;
10 g_child_level_number  EDW_OWB_COLLECTION_UTIL.numberTableType;
11 g_child_levels  EDW_OWB_COLLECTION_UTIL.varcharTableType;
12 g_child_fk  EDW_OWB_COLLECTION_UTIL.varcharTableType;
13 g_parent_pk  EDW_OWB_COLLECTION_UTIL.varcharTableType;
14 g_number_levels integer;
15 
16 g_level_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
17 g_level_fk_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
18 g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
19 g_level_pk_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
20 g_varchar_pk_index number;
21 g_level_pk_number number;
22 g_level_fk_number number;
23 g_level_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
24 g_level_cols_length EDW_OWB_COLLECTION_UTIL.varcharTableType;
25 g_level_cols_datatype EDW_OWB_COLLECTION_UTIL.varcharTableType;
26 g_level_col_number number;
27 
28 g_unassigned varchar2(3000);
29 g_unassigned_length number;
30 g_invalid varchar2(3000);
31 g_invalid_length number;
32 
33 g_status boolean;
34 g_status_message varchar2(30000);
35 
36 g_insert_stmt varchar2(30000);
37 g_update_stmt varchar2(30000);--if not insert then update
38 g_check_stmt varchar2(10000);
39 G_BODY_INSERT_UPDATE_STMT varchar2(30000);
40 
41 g_err_insert_stmt varchar2(30000);
42 g_err_update_stmt varchar2(30000);--if not insert then update
43 g_err_check_stmt varchar2(10000);
44 G_err_BODY_INSERT_UPDATE_STMT varchar2(30000);
45 
46 
47 g_exec_flag boolean;
48 g_naedw_varchar2 varchar2(400);
49 g_err_varchar2 varchar2(400);
50 g_naedw_date varchar2(400);
51 g_naedw_number varchar2(400);
52 g_err_number varchar2(400);
53 G_ALL_VARCHAR2 varchar2(400);
54 G_ALL_VARCHAR2_MESG varchar2(3000);--fills the user cols of all level
55 g_all_varchar2_mesg_length number;
56 g_all_number varchar2(400);
57 g_all_date varchar2(400);
58 g_dim_string_flag boolean;
59 g_conc_program_id number;
60 g_conc_program_name varchar2(400);
61 g_all_dims_ok boolean;
62 g_naedw_in boolean;
63 g_err_in boolean;
64 g_dim_pk varchar2(400);
65 g_coll_engine_call boolean;
66 g_level_fk_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;
67 g_all_level varchar2(400);
68 PROCEDURE PUSH (Errbuf out NOCOPY varchar2,
69 		retcode out NOCOPY varchar2);
70 PROCEDURE PUSH(Errbuf out NOCOPY varchar2,
71 		retcode out NOCOPY varchar2,
72                 p_dim_string in varchar2);
73 /*
74 called from collection engine for a specific dimension
75 */
76 PROCEDURE PUSH(Errbuf out NOCOPY varchar2,
77 		retcode out NOCOPY varchar2,
78         p_dim_string in varchar2,
79         p_debug boolean);
80 PROCEDURE Read_Metadata;
81 
82 PROCEDURE Parse_Metadata(p_dim_index number);
83 PROCEDURE Make_insert_stmt(p_level_index number);
84 PROCEDURE Make_Update_Stmt(p_level_index number) ;
85 PROCEDURE Init_all;
86 function get_status_message return varchar2 ;
87 PROCEDURE Execute_insert_stmt_level(p_level_index number);
88 PROCEDURE Execute_insert_stmt;
89 PROCEDURE make_body_insert_update_stmt(p_level_index number, p_insert_flag boolean) ;
90 PROCEDURE parse_dim_names(p_dim_string varchar2) ;
91 procedure finish_all(p_flag boolean);
92 function get_time return varchar2 ;
93 procedure write_to_log_file(p_message varchar2) ;
94 procedure write_to_log_file_n(p_message varchar2) ;
95 function get_one_dim_name(p_dim_string varchar2,p_type varchar2) return boolean;
96 function naedw_in_star(p_dim varchar2) return boolean;
97 function get_dim_pk(p_dim varchar2) return boolean;
98 function err_in_star(p_dim varchar2) return boolean;
99 PROCEDURE Execute_err_insert_stmt_level(p_level_index number);
100 PROCEDURE make_err_body_insert_stmt(p_level_index number, p_insert_flag boolean);
101 
102 END EDW_NAEDW_PUSH;