APPS.EDW_OPI_OPRN_M_C SQL Statements

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

Line: 13

 l_rows_inserted            Number:=0;

Line: 52

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

Line: 77

    l_rows_inserted NUMBER :=0;

Line: 82

   Insert Into
    EDW_OPI_OPRN_OPRN_LSTG@EDW_APPS_TO_WH(
       OPRN_PK,
       OPRC_FK,
       OPRN_DP,
       NAME,
       OPRN_NAME,
       DESCRIPTION,
       ORGN_CODE,
       DEPARTMENT,
       PROCESS_QTY_UOM,
       USER_ATTRIBUTE1,
       USER_ATTRIBUTE2,
       USER_ATTRIBUTE3,
       USER_ATTRIBUTE4,
       USER_ATTRIBUTE5,
       LAST_UPDATE_DATE,
       CREATION_DATE,
       OPERATION_CODE,
       COLLECTION_STATUS)
   select
	OPRN_PK,
 	OPRC_FK,
	OPRN_DP,
 	NAME,
 	OPRN_NAME,
 	DESCRIPTION,
 	ORGN_CODE,
 	DEPARTMENT,
        PROCESS_QTY_UOM,
   	USER_ATTRIBUTE1,
 	USER_ATTRIBUTE2,
 	USER_ATTRIBUTE3,
 	USER_ATTRIBUTE4,
 	USER_ATTRIBUTE5,
 	LAST_UPDATE_DATE,
 	CREATION_DATE,
    	NULL OPERATION_CODE,
        'READY'
   from EDW_OPI_OPRN_OPRN_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and l_date2;

Line: 123

   l_rows_inserted := sql%rowcount;

Line: 124

   EDW_OPI_OPRN_M_C.g_row_count := EDW_OPI_OPRN_M_C.g_row_count + l_rows_inserted ;

Line: 125

   edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
' rows into the staging table');

Line: 138

    l_rows_inserted NUMBER :=0;

Line: 143

   Insert Into
    EDW_OPI_OPRN_OPRC_LSTG@EDW_APPS_TO_WH(
        ALL_FK,
	OPRC_PK,
	OPRC_DP,
	NAME,
	DESCRIPTION,
	USER_ATTRIBUTE1,
	USER_ATTRIBUTE2,
	USER_ATTRIBUTE3,
	USER_ATTRIBUTE4,
	USER_ATTRIBUTE5,
	LAST_UPDATE_DATE,
	CREATION_DATE,
        OPERATION_CODE,
        COLLECTION_STATUS)
   select
	ALL_FK,
	OPRC_PK,
	OPRC_DP,
	NAME,
	DESCRIPTION,
	USER_ATTRIBUTE1,
	USER_ATTRIBUTE2,
	USER_ATTRIBUTE3,
	USER_ATTRIBUTE4,
	USER_ATTRIBUTE5,
	LAST_UPDATE_DATE,
	CREATION_DATE,
    	NULL OPERATION_CODE,
        'READY'
   from EDW_OPI_OPRN_OPRC_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and l_date2;

Line: 176

   l_rows_inserted := sql%rowcount;

Line: 177

   EDW_OPI_OPRN_M_C.g_row_count := EDW_OPI_OPRN_M_C.g_row_count + l_rows_inserted ;

Line: 178

   edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
' rows into the staging table');