APPS.EDW_INSTANCE_COLLECT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

  make_insert_stmt;

Line: 25

    write_to_log_file_n('Made insert stmt for dimension '||p_dim_name||get_time);

Line: 27

  execute_insert_stmt;

Line: 34

    write_to_log_file_n('Executed insert stmt for dimension '||p_dim_name||get_time);

Line: 36

        rows inserted '||g_number_rows_processed);

Line: 63

  g_insert_stmt :=null;

Line: 76

procedure make_insert_stmt is
begin
 if g_debug then
   write_to_log_file_n('In make_insert_stmt');

Line: 81

 g_insert_stmt:='insert into EDW_INSTANCE_LSTG (
	INSTANCE_CODE,
	INSTANCE_PK,
	INSTANCE_DP,
	NAME,
	ALL_FK,
	DESCRIPTION,
	COLLECTION_STATUS,
	WAREHOUSE_TO_INSTANCE_LINK,
	CREATION_DATE,
	LAST_UPDATE_DATE)
	select
	INSTANCE_CODE,
	INSTANCE_CODE,
	INSTANCE_CODE,
	NAME,
	''ALL'',
	DESCRIPTION,
	''READY'',
	WAREHOUSE_TO_INSTANCE_LINK,
	CREATION_DATE,
	LAST_UPDATE_DATE
	from
	EDW_SOURCE_INSTANCES_VL ';

Line: 107

  g_status_message:='Error in make_insert_stmt for Instance Dimension '||g_dim_name||' '||sqlerrm||get_time;

Line: 112

procedure execute_insert_stmt is
Begin
 if g_debug then
   write_to_log_file_n('In execute_insert_stmt');

Line: 118

 delete EDW_INSTANCE_LSTG;

Line: 121

    write_to_log_file(g_insert_stmt);

Line: 123

 execute immediate  g_insert_stmt;

Line: 125

 write_to_log_file_n('Inserted '||g_number_rows_processed||' rows into EDW_INSTANCE_LSTG');

Line: 127

  g_status_message:='Error in execute_insert_stmt for Instance Dimension '||sqlerrm||get_time;