DBA Data[Home] [Help]

APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on IBY_AR_DOC_LINES_GT

Line 1426: DELETE FROM IBY_AR_DOC_LINES_GT;

1422:
1423: BEGIN
1424:
1425: DELETE FROM IBY_AR_DOC_HEADER_GT;
1426: DELETE FROM IBY_AR_DOC_LINES_GT;
1427:
1428: Insert_Into_Headers_Gt(p_txn_id);
1429: Insert_Into_Lines_Gt(p_txn_id);
1430:

Line 1609: INSERT INTO IBY_AR_DOC_LINES_GT VALUES l_DocLinesTab(j);

1605: EXIT WHEN l_DocLinesTab.COUNT = 0;
1606:
1607: IF (l_DocLinesTab.COUNT > 0) THEN
1608: FORALL j IN l_DocLinesTab.first..l_DocLinesTab.last
1609: INSERT INTO IBY_AR_DOC_LINES_GT VALUES l_DocLinesTab(j);
1610: END IF;
1611:
1612: END LOOP;
1613: select count(*) into l_count from IBY_AR_DOC_LINES_GT;

Line 1613: select count(*) into l_count from IBY_AR_DOC_LINES_GT;

1609: INSERT INTO IBY_AR_DOC_LINES_GT VALUES l_DocLinesTab(j);
1610: END IF;
1611:
1612: END LOOP;
1613: select count(*) into l_count from IBY_AR_DOC_LINES_GT;
1614: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || ' Number of rows in IBY_AR_DOC_LINES_GT: '||l_count);
1615: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Exit , TimeStamp:' ||systimestamp);
1616:
1617: END Insert_Into_Lines_Gt;

Line 1614: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || ' Number of rows in IBY_AR_DOC_LINES_GT: '||l_count);

1610: END IF;
1611:
1612: END LOOP;
1613: select count(*) into l_count from IBY_AR_DOC_LINES_GT;
1614: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || ' Number of rows in IBY_AR_DOC_LINES_GT: '||l_count);
1615: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Exit , TimeStamp:' ||systimestamp);
1616:
1617: END Insert_Into_Lines_Gt;
1618: