APPS.EDW_POA_LN_TYPE_M_C SQL Statements

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

Line: 66

 l_rows_inserted        Number := 0;

Line: 89

   Insert Into EDW_POA_LNTP_LN_TYPE_LSTG@EDW_APPS_TO_WH(
     ALL_FK,
     ALL_FK_KEY,
     ROW_ID,
     LINE_TYPE_DP,
--     DELETION_DATE,
     DESCRIPTION,
     INACTIVE_DATE,
     INSTANCE,
     NAME,
     LINE_TYPE_PK,
     ORDER_TYPE,
     OUTSIDE_OP_FLAG,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     REQUEST_ID,
     OPERATION_CODE,
     ERROR_CODE,
     COLLECTION_STATUS)
   select
     'ALL',
     NULL,  		    -- ALL_FK_KEY,
     NULL,                  -- ROW_ID,
     LINE_TYPE_PK,          -- LINE_TYPE_DP,
--     NULL,		    DELETION_DATE,
     DESCRIPTION,
     INACTIVE_DATE,
     INSTANCE,
     LINE_TYPE_PK,	    --LINE_TYPE_NAME,
     LINE_TYPE_PK,
     ORDER_TYPE,
     OUTSIDE_OP_FLAG,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     NULL,                  --REQUEST_ID,
     NULL,		    --OPERATION_CODE,
     NULL,                  --ERROR_CODE
     'READY'
   from EDW_POA_LN_TYPE_lCV@apps_to_apps
   where last_update_date between l_push_date_range1 and l_push_date_range2
      OR last_update_date is NULL;

Line: 137

   l_rows_inserted := sql%rowcount;

Line: 140

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

Line: 148

   EDW_POA_LN_TYPE_M_C.g_row_count :=EDW_POA_LN_TYPE_M_C.g_row_count +l_rows_inserted;