APPS.IBY_PYO_TRANSACTION dependencies on IBY_PYO_PAYMENT_GT

Line 66: select count(*) into l_pmt_count FROM IBY_PYO_PAYMENT_GT;

62:
63: insert_into_gt(p_payment_instruction_id);
64:
65:
66: select count(*) into l_pmt_count FROM IBY_PYO_PAYMENT_GT;
67: SELECT COUNT(*) into l_doc_count FROM IBY_PYO_INVOICE_GT;
68:
69: IF (l_pmt_count = 0 OR l_doc_count = 0) THEN
70: fnd_file.put_line(fnd_file.log, 'Number of Payments Selected:'||l_pmt_count);

Line 197: INSERT INTO IBY_PYO_PAYMENT_GT(COMMUNICATION_METHOD,

193: ec_debug.push('ECE_AP_TRANSACTION.insert_into_gt');
194: ec_debug.pl (3, 'Fetching Payment data for Instruction',p_payment_instruction_id);
195: fnd_file.put_line(fnd_file.log, 'Calling insert_into_gt :: START ::'||systimestamp);
196:
197: INSERT INTO IBY_PYO_PAYMENT_GT(COMMUNICATION_METHOD,
198: TEST_FLAG,
199: DOCUMENT_ID,
200: DOCUMENT_CODE,
201: BK_TP_TRANSLATOR_CODE,

Line 964: delete from IBY_PYO_PAYMENT_GT;

960: PROCEDURE delete_from_gt IS
961: BEGIN
962: ec_debug.push('ECE_AP_TRANSACTION.delete_from_gt');
963: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: START ::'||systimestamp);
964: delete from IBY_PYO_PAYMENT_GT;
965: delete from IBY_PYO_INVOICE_GT;
966: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: END ::'||systimestamp);
967: ec_debug.pop ( 'ECE_AP_TRANSACTION.delete_from_gt');
968: END delete_from_gt;