APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on IBY_XML_BATCH_FCI_1_0_V

Line 437: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'call to iby_xml_batch_fci_1_0_v START' || ':TimeStamp:' ||systimestamp);

433: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt start, TimeStamp:' ||systimestamp);
434: Insert_Into_Gt(p_txn_id);
435: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'Call to Insert_Into_Gt end, TimeStamp:' ||systimestamp);
436:
437: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'call to iby_xml_batch_fci_1_0_v START' || ':TimeStamp:' ||systimestamp);
438: --Bug# 13640788
439: -- Removed Optimizer hints as per the pef team sugestion
440: SELECT
441: XMLType.getClobVal(instruction)

Line 443: FROM iby_xml_batch_fci_1_0_v

439: -- Removed Optimizer hints as per the pef team sugestion
440: SELECT
441: XMLType.getClobVal(instruction)
442: INTO x_extract_doc
443: FROM iby_xml_batch_fci_1_0_v
444: WHERE mbatchid=p_txn_id
445: AND rownum=1;
446: ELSE
447: SELECT

Line 454: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'call to iby_xml_batch_fci_1_0_v END' || ':TimeStamp:' ||systimestamp);

450: FROM iby_xml_online_fci_1_0_v
451: WHERE trxnmid=p_txn_id
452: AND rownum=1;
453: END IF;
454: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'call to iby_xml_batch_fci_1_0_v END' || ':TimeStamp:' ||systimestamp);
455:
456: -- clears out data from global temporary table
457: COMMIT;
458: