eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_PAYMENT_FORMAT_VAL_PUB dependencies on IBY_DOCS_PAYABLE_ALL

Line 72: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

68: AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
69: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
70: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
71:
72: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
73: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
74: SELECT calling_app_doc_unique_ref2
75: FROM iby_docs_payable_all
76: WHERE

Line 73: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

69: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
70: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
71:
72: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
73: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
74: SELECT calling_app_doc_unique_ref2
75: FROM iby_docs_payable_all
76: WHERE
77: payment_id = p_pmt_id

Line 75: FROM iby_docs_payable_all

71:
72: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
73: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
74: SELECT calling_app_doc_unique_ref2
75: FROM iby_docs_payable_all
76: WHERE
77: payment_id = p_pmt_id
78: AND
79: calling_app_id=200

Line 190: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

186:
187:
188:
189: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
190: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
191:
192: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
193: EXIT WHEN iby_docs_csr%NOTFOUND;
194:

Line 420: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

416: FROM iby_payments_all
417: WHERE payment_instruction_id = p_instruction_id
418: AND payment_status = 'INSTRUCTION_CREATED';
419:
420: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
421: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
422: SELECT calling_app_doc_unique_ref2
423: FROM iby_docs_payable_all
424: WHERE

Line 421: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

417: WHERE payment_instruction_id = p_instruction_id
418: AND payment_status = 'INSTRUCTION_CREATED';
419:
420: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
421: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
422: SELECT calling_app_doc_unique_ref2
423: FROM iby_docs_payable_all
424: WHERE
425: payment_id = p_pmt_id

Line 423: FROM iby_docs_payable_all

419:
420: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
421: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
422: SELECT calling_app_doc_unique_ref2
423: FROM iby_docs_payable_all
424: WHERE
425: payment_id = p_pmt_id
426: AND
427: calling_app_id=200

Line 442: l_invoice_type IBY_DOCS_PAYABLE_ALL.DOCUMENT_TYPE%TYPE;

438:
439: l_format_name VARCHAR2(50);
440: l_error_message VARCHAR2(1000);
441: l_valid NUMBER;
442: l_invoice_type IBY_DOCS_PAYABLE_ALL.DOCUMENT_TYPE%TYPE;
443:
444:
445: BEGIN
446: l_format_name := 'FVBLNCR';

Line 569: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

565:
566:
567:
568: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
569: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
570: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
571: EXIT WHEN iby_docs_csr%NOTFOUND;
572:
573: -- validate internal bank account parameters

Line 589: INTO l_invoice_type FROM IBY_DOCS_PAYABLE_ALL

585: RETURN;
586: END IF;
587:
588: SELECT document_type
589: INTO l_invoice_type FROM IBY_DOCS_PAYABLE_ALL
590: WHERE calling_app_doc_unique_ref2 = l_iby_docs_rec.calling_app_doc_unique_ref2
591: AND payment_id = l_iby_pmt_rec.payment_id
592: AND calling_app_id=200
593: AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');

Line 761: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

757: AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
758: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
759: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
760:
761: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
762: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
763: SELECT calling_app_doc_unique_ref2
764: FROM iby_docs_payable_all
765: WHERE

Line 762: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

758: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
759: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
760:
761: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
762: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
763: SELECT calling_app_doc_unique_ref2
764: FROM iby_docs_payable_all
765: WHERE
766: payment_id = p_pmt_id

Line 764: FROM iby_docs_payable_all

760:
761: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
762: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
763: SELECT calling_app_doc_unique_ref2
764: FROM iby_docs_payable_all
765: WHERE
766: payment_id = p_pmt_id
767: AND
768: calling_app_id=200

Line 891: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

887: END IF;
888:
889:
890: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
891: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
892: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
893: EXIT WHEN iby_docs_csr%NOTFOUND;
894:
895: -- validate internal bank account parameters

Line 1128: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

1124: FROM iby_payments_all
1125: WHERE
1126: payment_instruction_id = p_instruction_id
1127: AND payment_status = 'INSTRUCTION_CREATED';
1128: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1129: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1130: SELECT calling_app_doc_unique_ref2
1131: FROM iby_docs_payable_all
1132: WHERE

Line 1129: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

1125: WHERE
1126: payment_instruction_id = p_instruction_id
1127: AND payment_status = 'INSTRUCTION_CREATED';
1128: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1129: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1130: SELECT calling_app_doc_unique_ref2
1131: FROM iby_docs_payable_all
1132: WHERE
1133: payment_id = p_pmt_id

Line 1131: FROM iby_docs_payable_all

1127: AND payment_status = 'INSTRUCTION_CREATED';
1128: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1129: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1130: SELECT calling_app_doc_unique_ref2
1131: FROM iby_docs_payable_all
1132: WHERE
1133: payment_id = p_pmt_id
1134: AND
1135: calling_app_id=200

Line 1272: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

1268: END IF;
1269:
1270:
1271: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
1272: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
1273: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
1274: EXIT WHEN iby_docs_csr%NOTFOUND;
1275:
1276:

Line 1440: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

1436: AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
1437: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
1438: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
1439:
1440: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1441: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1442: SELECT calling_app_doc_unique_ref2
1443: FROM iby_docs_payable_all
1444: WHERE

Line 1441: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

1437: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
1438: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
1439:
1440: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1441: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1442: SELECT calling_app_doc_unique_ref2
1443: FROM iby_docs_payable_all
1444: WHERE
1445: payment_id = p_pmt_id

Line 1443: FROM iby_docs_payable_all

1439:
1440: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1441: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1442: SELECT calling_app_doc_unique_ref2
1443: FROM iby_docs_payable_all
1444: WHERE
1445: payment_id = p_pmt_id
1446: AND
1447: calling_app_id=200

Line 1570: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

1566: RETURN;
1567: END IF;
1568:
1569: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
1570: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
1571: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
1572: EXIT WHEN iby_docs_csr%NOTFOUND;
1573:
1574:

Line 1799: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

1795: AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
1796: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
1797: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
1798:
1799: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1800: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1801: SELECT calling_app_doc_unique_ref2
1802: FROM iby_docs_payable_all
1803: WHERE

Line 1800: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

1796: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
1797: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
1798:
1799: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1800: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1801: SELECT calling_app_doc_unique_ref2
1802: FROM iby_docs_payable_all
1803: WHERE
1804: payment_id = p_pmt_id

Line 1802: FROM iby_docs_payable_all

1798:
1799: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1800: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1801: SELECT calling_app_doc_unique_ref2
1802: FROM iby_docs_payable_all
1803: WHERE
1804: payment_id = p_pmt_id
1805: AND
1806: calling_app_id=200

Line 1899: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

1895: END IF;
1896:
1897:
1898: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
1899: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
1900: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
1901: EXIT WHEN iby_docs_csr%NOTFOUND;
1902:
1903: -- validate internal bank account parameters

Line 2130: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

2126: AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
2127: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
2128: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
2129:
2130: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2131: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2132: SELECT calling_app_doc_unique_ref2
2133: FROM iby_docs_payable_all
2134: WHERE

Line 2131: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

2127: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
2128: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
2129:
2130: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2131: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2132: SELECT calling_app_doc_unique_ref2
2133: FROM iby_docs_payable_all
2134: WHERE
2135: payment_id = p_pmt_id

Line 2133: FROM iby_docs_payable_all

2129:
2130: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2131: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2132: SELECT calling_app_doc_unique_ref2
2133: FROM iby_docs_payable_all
2134: WHERE
2135: payment_id = p_pmt_id
2136: AND
2137: calling_app_id=200

Line 2229: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

2225:
2226:
2227:
2228: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
2229: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
2230: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
2231: EXIT WHEN iby_docs_csr%NOTFOUND;
2232:
2233: -- validate internal bank account parameters

Line 2438: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

2434: FROM iby_payments_all
2435: WHERE payment_instruction_id = p_instruction_id
2436: AND payment_status = 'INSTRUCTION_CREATED';
2437:
2438: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2439: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2440: SELECT calling_app_doc_unique_ref2
2441: FROM iby_docs_payable_all
2442: WHERE

Line 2439: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

2435: WHERE payment_instruction_id = p_instruction_id
2436: AND payment_status = 'INSTRUCTION_CREATED';
2437:
2438: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2439: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2440: SELECT calling_app_doc_unique_ref2
2441: FROM iby_docs_payable_all
2442: WHERE
2443: payment_id = p_pmt_id

Line 2441: FROM iby_docs_payable_all

2437:
2438: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2439: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2440: SELECT calling_app_doc_unique_ref2
2441: FROM iby_docs_payable_all
2442: WHERE
2443: payment_id = p_pmt_id
2444: AND
2445: calling_app_id=200

Line 2460: l_invoice_type IBY_DOCS_PAYABLE_ALL.DOCUMENT_TYPE%TYPE;

2456:
2457: l_format_name VARCHAR2(50);
2458: l_error_message VARCHAR2(1000);
2459: l_valid NUMBER;
2460: l_invoice_type IBY_DOCS_PAYABLE_ALL.DOCUMENT_TYPE%TYPE;
2461:
2462: BEGIN
2463: l_format_name := 'FVTIACHB';
2464: x_result:=g_SUCCESS;

Line 2568: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

2564:
2565:
2566:
2567: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
2568: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
2569: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
2570: EXIT WHEN iby_docs_csr%NOTFOUND;
2571:
2572: -- validate internal bank account parameters

Line 2590: INTO l_invoice_type FROM IBY_DOCS_PAYABLE_ALL

2586: END IF;
2587:
2588:
2589: SELECT document_type
2590: INTO l_invoice_type FROM IBY_DOCS_PAYABLE_ALL
2591: WHERE calling_app_doc_unique_ref2 = l_iby_docs_rec.calling_app_doc_unique_ref2
2592: AND payment_id = l_iby_pmt_rec.payment_id
2593: AND calling_app_id=200
2594: AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');

Line 2730: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

2726: AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
2727: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
2728: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
2729:
2730: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2731: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2732: SELECT calling_app_doc_unique_ref2
2733: FROM iby_docs_payable_all
2734: WHERE

Line 2731: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

2727: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
2728: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
2729:
2730: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2731: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2732: SELECT calling_app_doc_unique_ref2
2733: FROM iby_docs_payable_all
2734: WHERE
2735: payment_id = p_pmt_id

Line 2733: FROM iby_docs_payable_all

2729:
2730: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2731: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2732: SELECT calling_app_doc_unique_ref2
2733: FROM iby_docs_payable_all
2734: WHERE
2735: payment_id = p_pmt_id
2736: AND
2737: calling_app_id=200

Line 2844: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

2840: END IF;
2841:
2842:
2843: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
2844: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
2845: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
2846: EXIT WHEN iby_docs_csr%NOTFOUND;
2847:
2848: -- validate internal bank account parameters

Line 3094: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

3090: AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
3091: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
3092: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
3093:
3094: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3095: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3096: SELECT calling_app_doc_unique_ref2
3097: FROM iby_docs_payable_all
3098: WHERE

Line 3095: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

3091: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
3092: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
3093:
3094: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3095: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3096: SELECT calling_app_doc_unique_ref2
3097: FROM iby_docs_payable_all
3098: WHERE
3099: payment_id = p_pmt_id

Line 3097: FROM iby_docs_payable_all

3093:
3094: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3095: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3096: SELECT calling_app_doc_unique_ref2
3097: FROM iby_docs_payable_all
3098: WHERE
3099: payment_id = p_pmt_id
3100: AND
3101: calling_app_id=200

Line 3209: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

3205: END IF;
3206:
3207:
3208: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
3209: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
3210: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
3211: EXIT WHEN iby_docs_csr%NOTFOUND;
3212:
3213: -- validate internal bank account parameters

Line 3453: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

3449: AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
3450: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
3451: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
3452:
3453: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3454: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3455: SELECT calling_app_doc_unique_ref2
3456: FROM iby_docs_payable_all
3457: WHERE

Line 3454: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

3450: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
3451: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
3452:
3453: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3454: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3455: SELECT calling_app_doc_unique_ref2
3456: FROM iby_docs_payable_all
3457: WHERE
3458: payment_id = p_pmt_id

Line 3456: FROM iby_docs_payable_all

3452:
3453: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3454: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3455: SELECT calling_app_doc_unique_ref2
3456: FROM iby_docs_payable_all
3457: WHERE
3458: payment_id = p_pmt_id
3459: AND
3460: calling_app_id=200

Line 3522: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

3518: EXIT WHEN iby_pmt_csr%NOTFOUND;
3519:
3520:
3521: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
3522: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
3523: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
3524: EXIT WHEN iby_docs_csr%NOTFOUND;
3525:
3526: -- validate internal bank account parameters

Line 3767: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

3763: AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
3764: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
3765: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
3766:
3767: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3768: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3769: SELECT calling_app_doc_unique_ref2
3770: FROM iby_docs_payable_all
3771: WHERE

Line 3768: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

3764: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
3765: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
3766:
3767: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3768: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3769: SELECT calling_app_doc_unique_ref2
3770: FROM iby_docs_payable_all
3771: WHERE
3772: payment_id = p_pmt_id

Line 3770: FROM iby_docs_payable_all

3766:
3767: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3768: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3769: SELECT calling_app_doc_unique_ref2
3770: FROM iby_docs_payable_all
3771: WHERE
3772: payment_id = p_pmt_id
3773: AND
3774: calling_app_id=200

Line 3835: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

3831: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
3832: EXIT WHEN iby_pmt_csr%NOTFOUND;
3833:
3834: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
3835: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
3836: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
3837: EXIT WHEN iby_docs_csr%NOTFOUND;
3838:
3839: -- validate internal bank account parameters

Line 4066: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

4062: FROM iby_payments_all
4063: WHERE payment_instruction_id = p_instruction_id
4064: AND payment_status = 'INSTRUCTION_CREATED';
4065:
4066: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4067: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
4068: SELECT calling_app_doc_unique_ref2
4069: FROM iby_docs_payable_all
4070: WHERE

Line 4067: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

4063: WHERE payment_instruction_id = p_instruction_id
4064: AND payment_status = 'INSTRUCTION_CREATED';
4065:
4066: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4067: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
4068: SELECT calling_app_doc_unique_ref2
4069: FROM iby_docs_payable_all
4070: WHERE
4071: payment_id = p_pmt_id

Line 4069: FROM iby_docs_payable_all

4065:
4066: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4067: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
4068: SELECT calling_app_doc_unique_ref2
4069: FROM iby_docs_payable_all
4070: WHERE
4071: payment_id = p_pmt_id
4072: AND
4073: calling_app_id=200

Line 4089: l_invoice_type IBY_DOCS_PAYABLE_ALL.DOCUMENT_TYPE%TYPE;

4085:
4086: l_format_name VARCHAR2(50);
4087: l_error_message VARCHAR2(1000);
4088: l_valid NUMBER;
4089: l_invoice_type IBY_DOCS_PAYABLE_ALL.DOCUMENT_TYPE%TYPE;
4090:
4091: BEGIN
4092: l_format_name := 'FVSPNCR';
4093: x_result:=g_SUCCESS;

Line 4168: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

4164:
4165:
4166:
4167: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
4168: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
4169: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
4170: EXIT WHEN iby_docs_csr%NOTFOUND;
4171:
4172:

Line 4192: INTO l_invoice_type FROM IBY_DOCS_PAYABLE_ALL

4188:
4189:
4190:
4191: SELECT document_type
4192: INTO l_invoice_type FROM IBY_DOCS_PAYABLE_ALL
4193: WHERE calling_app_doc_unique_ref2 = l_iby_docs_rec.calling_app_doc_unique_ref2
4194: AND payment_id = l_iby_pmt_rec.payment_id
4195: AND calling_app_id=200
4196: AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');

Line 4349: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

4345: AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
4346: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
4347: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
4348:
4349: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4350: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
4351: SELECT calling_app_doc_unique_ref2
4352: FROM iby_docs_payable_all
4353: WHERE

Line 4350: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

4346: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
4347: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
4348:
4349: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4350: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
4351: SELECT calling_app_doc_unique_ref2
4352: FROM iby_docs_payable_all
4353: WHERE
4354: payment_id = p_pmt_id

Line 4352: FROM iby_docs_payable_all

4348:
4349: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4350: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
4351: SELECT calling_app_doc_unique_ref2
4352: FROM iby_docs_payable_all
4353: WHERE
4354: payment_id = p_pmt_id
4355: AND
4356: calling_app_id=200

Line 4432: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

4428: END IF;
4429:
4430:
4431: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
4432: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
4433: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
4434: EXIT WHEN iby_docs_csr%NOTFOUND;
4435:
4436: -- validate internal bank account parameters

Line 4689: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

4685: AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
4686: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
4687: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
4688:
4689: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4690: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
4691: SELECT calling_app_doc_unique_ref2
4692: FROM iby_docs_payable_all
4693: WHERE

Line 4690: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

4686: AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
4687: AND baes.sec_subkey_id = baek.sec_subkey_id(+);
4688:
4689: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4690: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
4691: SELECT calling_app_doc_unique_ref2
4692: FROM iby_docs_payable_all
4693: WHERE
4694: payment_id = p_pmt_id

Line 4692: FROM iby_docs_payable_all

4688:
4689: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4690: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
4691: SELECT calling_app_doc_unique_ref2
4692: FROM iby_docs_payable_all
4693: WHERE
4694: payment_id = p_pmt_id
4695: AND
4696: calling_app_id=200

Line 4772: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

4768: END IF;
4769:
4770:
4771: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
4772: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
4773: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
4774: EXIT WHEN iby_docs_csr%NOTFOUND;
4775:
4776: -- validate internal bank account parameters