APPS.EDW_FLEX_PUSH_C SQL Statements

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

Line: 18

 l_rows_inserted            Number:=0;

Line: 39

	stmt:= 'SELECT dim_name from edw_dimensions_md_v@'|| l_target_link ||
		' where dim_long_name = :longname';

Line: 94

   edw_log.put_line('Total rows inserted for '||g_dimension||' : '||g_row_count);

Line: 119

    insertStmt varchar2(3000) := null;

Line: 136

	stmt := 'Insert Into EDW_FLEX_DIM'||
   		g_index||'_L'||p_level||'_LSTG@' || l_target_link || '(
    		 NAME,  INSTANCE, '||
    		' L'||p_level||'_FK, L'||p_level||'_PK, '||
            ' LAST_UPDATE_DATE, CREATION_DATE, DESCRIPTION, OPERATION_CODE, COLLECTION_STATUS)
   		select ACTUAL_VALUE, INSTANCE,
    		NVL(L'||p_level||'_FK, ''NA_EDW'') L'||p_level||'_fk, L'||p_level||'_PK, ';

Line: 143

        stmt := stmt || '  last_update_date, ';

Line: 148

    	stmt := stmt ||' where NVL(last_update_date, to_date('''||
         to_char(p_from_date,'MM/DD/YYYY HH24:MI:SS')||''','''|| 'MM/DD/YYYY HH24:MI:SS'||''''||')+1/864000)  between :p_from_date and :p_to_date';

Line: 151

	edw_log.put_line('Insert statement is : '|| stmt);

Line: 164

	edw_log.put_line('Inserted '||l_dummy||  ' rows into the staging table');