APPS.FII_GL_BOOK_M_C SQL Statements

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

Line: 16

 l_rows_inserted        Number		:=0;

Line: 92

    l_rows_inserted NUMBER :=0;

Line: 99

   Insert Into EDW_GL_BOOK_FA_BOOK_LSTG(
    BOOK_FK,
    BOOK_TYPE_NAME,
    CURRENCY_CODE,
    DELETION_DATE,
    DEPRE_CALANDAR,
    FA_BOOK,
    FA_BOOK_PK,
    INSTANCE,
    NAME,
    PRORATE_CALENDAR,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS,
    CREATION_DATE,
    LAST_UPDATE_DATE
   )
select     NVL(BOOK_FK, 'NA_EDW'),
BOOK_TYPE_NAME,
CURRENCY_CODE,
to_date(NULL), --DELETION_DATE,
DEPRE_CALANDAR,
FA_BOOK,
FA_BOOK_PK,
INSTANCE,
NAME,
PRORATE_CALENDAR,
NULL, --USER_ATTRIBUTE1,
NULL, --USER_ATTRIBUTE2,
NULL, --USER_ATTRIBUTE3,
NULL, --USER_ATTRIBUTE4,
NULL, --USER_ATTRIBUTE5,
NULL, -- OPERATION_CODE
'READY',
trunc(sysdate),
trunc(sysdate)
from FII_GL_BOOK_FA_BOOK_LCV
where last_update_date between l_date1 and l_date2;

Line: 142

   l_rows_inserted := sql%rowcount;

Line: 143

   g_row_count := g_row_count + l_rows_inserted ;

Line: 158

    l_rows_inserted NUMBER :=0;

Line: 166

   Insert Into EDW_GL_BOOK_BOOK_LSTG(
    ACCT_PEIROD_TYPE,
    ALL_FK,
    BOOK_PK,
    CHART_OF_ACCTS_ID,
    CURRENCY_CODE,
    DELETION_DATE,
    GL_BOOK,
    INSTANCE,
    MRC_SOB_TYPE_CODE,
    NAME,
    PERIOD_SET_NAME,
    TRX_CALENDAR,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS,
    CREATION_DATE,
    LAST_UPDATE_DATE
   )
select ACCT_PERIOD_TYPE,
NVL(ALL_FK, 'NA_EDW'),
BOOK_PK,
CHART_OF_ACCTS_ID,
CURRENCY_CODE,
to_date(NULL), -- DELETION_DATE,
GL_BOOK,
INSTANCE,
MRC_SOB_TYPE_CODE,
NAME,
PERIOD_SET_NAME,
TRX_CALENDAR,
NULL, --USER_ATTRIBUTE1,
NULL, --USER_ATTRIBUTE2,
NULL, --USER_ATTRIBUTE3,
NULL, --USER_ATTRIBUTE4,
NULL, --USER_ATTRIBUTE5,
NULL, -- OPERATION_CODE
'READY',
trunc(sysdate),
trunc(sysdate)
from FII_GL_BOOK_BOOK_LCV
where last_update_date between l_date1 and l_date2;