APPS.FII_AP_INV_TYPE_M_C SQL Statements

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

Line: 16

 l_rows_inserted            Number:=0;

Line: 86

    l_rows_inserted NUMBER :=0;

Line: 101

l_stmt := 'Insert Into
    EDW_IVTY_INV_LSTG(
    CANCELLED_DATE,
    CREATION_DATE,
    INSTANCE,
    INV_DP,
    INV_ID,
    INV_NAME,
    INV_PK,
    INV_SOURCE,
    INV_TYPE_FK,
    LAST_UPDATE_DATE,
    NAME,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select CANCELLED_DATE,
CREATION_DATE,
substrb(INSTANCE, 1, 40),
substrb(INV_DP, 1, 160),
INV_ID,
substrb(INV_NAME, 1, 30),
substrb(INV_PK, 1, 120),
substrb(INV_SOURCE, 1, 20),
substrb(NVL(INV_TYPE_FK, ''NA_EDW''), 1, 120),
LAST_UPDATE_DATE,
substrb(NAME, 1, 50),
substrb(USER_ATTRIBUTE1, 1, 240),
substrb(USER_ATTRIBUTE2, 1, 240),
substrb(USER_ATTRIBUTE3, 1, 240),
substrb(USER_ATTRIBUTE4, 1, 240),
substrb(USER_ATTRIBUTE5, 1, 240),
    NULL,   /* OPERATION_CODE */
    ''READY''
   from FII_AP_IVTY_INV_LCV
   where last_update_date between :l_date1 and :l_date2'||l_er_stmt;

Line: 149

   l_rows_inserted := sql%rowcount;

Line: 151

   edw_log.debug_line('Inserted '|| l_rows_inserted ||' rows into EDW_IVTY_INV_LSTG table');    -- Added for Merrill Lynch,04-DEC-02

Line: 153

   g_row_count := g_row_count + l_rows_inserted ;

Line: 167

    l_rows_inserted NUMBER :=0;

Line: 182

l_stmt := ' Insert Into
    EDW_IVTY_INV_TYPE_LSTG(
    ALL_FK,
    CREATION_DATE,
    DESCRIPTION,
    INSTANCE,
    INV_TYPE,
    INV_TYPE_DP,
    INV_TYPE_PK,
    LAST_UPDATE_DATE,
    NAME,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select     NVL(ALL_FK, ''NA_EDW''),
CREATION_DATE,
substrb(DESCRIPTION, 1, 50),
substrb(INSTANCE, 1, 40),
substrb(INV_TYPE, 1, 80),
substrb(INV_TYPE_DP, 1, 160),
substrb(INV_TYPE_PK, 1, 120),
LAST_UPDATE_DATE,
substrb(NAME, 1, 50),
substrb(USER_ATTRIBUTE1, 1, 240),
substrb(USER_ATTRIBUTE2, 1, 240),
substrb(USER_ATTRIBUTE3, 1, 240),
substrb(USER_ATTRIBUTE4, 1, 240),
substrb(USER_ATTRIBUTE5, 1, 240),
    NULL,   /* OPERATION_CODE */
    ''READY''
   from FII_AP_IVTY_INV_TYPE_LCV'||l_er_stmt;

Line: 224

   edw_log.debug_line('Inserted '||sql%rowcount||' rows into EDW_IVTY_INV_TYPE_LSTG table');