APPS.EDW_INSTANCE_COLLECT dependencies on EDW_INSTANCE_LSTG

Line 35: write_to_log_file_n('Finished moving data from edw_source_instances to edw_instance_lstg,

31: return_with_error;
32: return;
33: else
34: write_to_log_file_n('Executed insert stmt for dimension '||p_dim_name||get_time);
35: write_to_log_file_n('Finished moving data from edw_source_instances to edw_instance_lstg,
36: rows inserted '||g_number_rows_processed);
37: end if;
38: --call the main procedure
39: call_main_collection(errbuf,retcode);

Line 81: g_insert_stmt:='insert into EDW_INSTANCE_LSTG (

77: begin
78: if g_debug then
79: write_to_log_file_n('In make_insert_stmt');
80: end if;
81: g_insert_stmt:='insert into EDW_INSTANCE_LSTG (
82: INSTANCE_CODE,
83: INSTANCE_PK,
84: INSTANCE_DP,
85: NAME,

Line 118: delete EDW_INSTANCE_LSTG;

114: if g_debug then
115: write_to_log_file_n('In execute_insert_stmt');
116: end if;
117:
118: delete EDW_INSTANCE_LSTG;
119: if g_debug then
120: write_to_log_file_n('Going to execute ');
121: write_to_log_file(g_insert_stmt);
122: end if;

Line 125: write_to_log_file_n('Inserted '||g_number_rows_processed||' rows into EDW_INSTANCE_LSTG');

121: write_to_log_file(g_insert_stmt);
122: end if;
123: execute immediate g_insert_stmt;
124: g_number_rows_processed:=sql%rowcount;
125: write_to_log_file_n('Inserted '||g_number_rows_processed||' rows into EDW_INSTANCE_LSTG');
126: Exception when others then
127: g_status_message:='Error in execute_insert_stmt for Instance Dimension '||sqlerrm||get_time;
128: write_to_log_file_n(g_status_message);
129: g_status:=false;