DBA Data[Home] [Help]

APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on IBY_AR_DOC_HEADER_GT

Line 1425: DELETE FROM IBY_AR_DOC_HEADER_GT;

1421: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Insert_Into_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);

Line 1527: INSERT INTO IBY_AR_DOC_HEADER_GT VALUES l_DocHeadersTab(j);

1523: EXIT WHEN l_DocHeadersTab.COUNT = 0;
1524:
1525: IF (l_DocHeadersTab.COUNT > 0) THEN
1526: FORALL j IN l_DocHeadersTab.first..l_DocHeadersTab.last
1527: INSERT INTO IBY_AR_DOC_HEADER_GT VALUES l_DocHeadersTab(j);
1528: END IF;
1529:
1530: END LOOP;
1531: select count(*) into l_count from IBY_AR_DOC_HEADER_GT;

Line 1531: select count(*) into l_count from IBY_AR_DOC_HEADER_GT;

1527: INSERT INTO IBY_AR_DOC_HEADER_GT VALUES l_DocHeadersTab(j);
1528: END IF;
1529:
1530: END LOOP;
1531: select count(*) into l_count from IBY_AR_DOC_HEADER_GT;
1532: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || ' Number of rows in IBY_AR_DOC_HEADER_GT: '||l_count);
1533: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Exit , TimeStamp:' ||systimestamp);
1534:
1535: END Insert_Into_Headers_Gt;

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

1528: END IF;
1529:
1530: END LOOP;
1531: select count(*) into l_count from IBY_AR_DOC_HEADER_GT;
1532: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || ' Number of rows in IBY_AR_DOC_HEADER_GT: '||l_count);
1533: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Exit , TimeStamp:' ||systimestamp);
1534:
1535: END Insert_Into_Headers_Gt;
1536: