[Home] [Help]
36: FROM iby_pay_instructions_all
37: WHERE
38: payment_instruction_id = p_instruction_id;
39:
40: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
41: -- Pick up Tax Payer Id/SSN from here -- Bug 5468203
42: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
43: SELECT payment_id,
44: payee_party_id,
50: ext_bank_account_name,
51: ext_bank_account_number,
52: ext_branch_number,
53: ext_bank_account_type
54: FROM iby_payments_all
55: WHERE
56: payment_instruction_id = p_instruction_id;
57:
58: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
151: RETURN;
152: END IF;
153:
154: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
155: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
156:
157: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
158: EXIT WHEN iby_pmt_csr%NOTFOUND;
159:
387: payment_reason_code
388: FROM iby_pay_instructions_all
389: WHERE
390: payment_instruction_id = p_instruction_id;
391: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
392: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
393: SELECT payment_id,
394: payee_party_id,
395: payee_le_registration_num,
397: payment_amount,
398: internal_bank_account_id,
399: int_bank_account_name,
400: int_bank_acct_agency_loc_code
401: FROM iby_payments_all
402: WHERE payment_instruction_id = p_instruction_id;
403:
404: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
405: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
482: END IF;
483:
484:
485: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
486: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
487: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
488: EXIT WHEN iby_pmt_csr%NOTFOUND;
489:
490: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
700: FROM iby_pay_instructions_all
701: WHERE
702: payment_instruction_id = p_instruction_id;
703:
704: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
705: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
706: SELECT payment_id,
707: payment_instruction_id,
708: payee_party_id,
715: ext_bank_account_name,
716: ext_bank_account_number,
717: ext_branch_number,
718: ext_bank_account_type
719: FROM iby_payments_all
720: WHERE
721: payment_instruction_id = p_instruction_id;
722:
723: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
814:
815:
816: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
817:
818: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
819: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
820: EXIT WHEN iby_pmt_csr%NOTFOUND;
821:
822: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
1071: FROM iby_pay_instructions_all
1072: WHERE
1073: payment_instruction_id = p_instruction_id;
1074:
1075: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
1076: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1077: SELECT payment_id,
1078: payment_instruction_id,
1079: payee_party_id,
1081: payment_amount,
1082: internal_bank_account_id,
1083: int_bank_account_name,
1084: int_bank_acct_agency_loc_code
1085: FROM iby_payments_all
1086: WHERE
1087: payment_instruction_id = p_instruction_id;
1088: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1089: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1179: RETURN;
1180: END IF;
1181:
1182: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
1183: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
1184: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
1185: EXIT WHEN iby_pmt_csr%NOTFOUND;
1186:
1187: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
1364: FROM iby_pay_instructions_all
1365: WHERE
1366: payment_instruction_id = p_instruction_id;
1367:
1368: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
1369: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1370: SELECT payment_id,
1371: payment_instruction_id,
1372: payee_party_id,
1379: ext_bank_account_name,
1380: ext_bank_account_number,
1381: ext_branch_number,
1382: ext_bank_account_type
1383: FROM iby_payments_all
1384: WHERE
1385: payment_instruction_id = p_instruction_id;
1386:
1387: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1464: RETURN;
1465: END IF;
1466:
1467: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
1468: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
1469: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
1470: EXIT WHEN iby_pmt_csr%NOTFOUND;
1471:
1472: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
1707: FROM iby_pay_instructions_all
1708: WHERE
1709: payment_instruction_id = p_instruction_id;
1710:
1711: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
1712: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1713: SELECT payment_id,
1714: payment_instruction_id,
1715: payee_party_id,
1722: ext_bank_account_name,
1723: ext_bank_account_number,
1724: ext_branch_number,
1725: ext_bank_account_type
1726: FROM iby_payments_all
1727: WHERE
1728: payment_instruction_id = p_instruction_id;
1729:
1730: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1791: END IF;
1792:
1793:
1794: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
1795: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
1796: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
1797: EXIT WHEN iby_pmt_csr%NOTFOUND;
1798:
1799:
2023: FROM iby_pay_instructions_all
2024: WHERE
2025: payment_instruction_id = p_instruction_id;
2026:
2027: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
2028: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2029: SELECT payment_id,
2030: payment_instruction_id,
2031: payee_party_id,
2038: ext_bank_account_name,
2039: ext_bank_account_number,
2040: ext_branch_number,
2041: ext_bank_account_type
2042: FROM iby_payments_all
2043: WHERE
2044: payment_instruction_id = p_instruction_id;
2045:
2046: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2107: END IF;
2108:
2109:
2110: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
2111: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
2112: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
2113: EXIT WHEN iby_pmt_csr%NOTFOUND;
2114:
2115: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
2337: FROM iby_pay_instructions_all
2338: WHERE
2339: payment_instruction_id = p_instruction_id;
2340:
2341: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
2342: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2343: SELECT payment_id,
2344: payment_instruction_id,
2345: payment_amount,
2345: payment_amount,
2346: internal_bank_account_id,
2347: int_bank_account_name,
2348: int_bank_acct_agency_loc_code
2349: FROM iby_payments_all
2350: WHERE payment_instruction_id = p_instruction_id;
2351:
2352: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2353: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2412: RETURN;
2413: END IF;
2414:
2415: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
2416: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
2417: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
2418: EXIT WHEN iby_pmt_csr%NOTFOUND;
2419:
2420: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
2598: FROM iby_pay_instructions_all
2599: WHERE
2600: payment_instruction_id = p_instruction_id;
2601:
2602: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
2603: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2604: SELECT payment_id,
2605: payee_party_id,
2606: payee_le_registration_num,
2613: ext_bank_account_name,
2614: ext_bank_account_number,
2615: ext_branch_number,
2616: ext_bank_account_type
2617: FROM iby_payments_all
2618: WHERE
2619: payment_instruction_id = p_instruction_id;
2620:
2621: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2681: RETURN;
2682: END IF;
2683:
2684: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
2685: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
2686: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
2687: EXIT WHEN iby_pmt_csr%NOTFOUND;
2688:
2689: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,
2947: FROM iby_pay_instructions_all
2948: WHERE
2949: payment_instruction_id = p_instruction_id;
2950:
2951: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
2952: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2953: SELECT payment_id,
2954: payment_instruction_id,
2955: payee_party_id,
2962: ext_bank_account_name,
2963: ext_bank_account_number,
2964: ext_branch_number,
2965: ext_bank_account_type
2966: FROM iby_payments_all
2967: WHERE
2968: payment_instruction_id = p_instruction_id;
2969:
2970: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3032: END IF;
3033:
3034:
3035: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
3036: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
3037: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
3038: EXIT WHEN iby_pmt_csr%NOTFOUND;
3039:
3040:
3291: FROM iby_pay_instructions_all
3292: WHERE
3293: payment_instruction_id = p_instruction_id;
3294:
3295: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
3296: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3297: SELECT payment_id,
3298: payment_instruction_id,
3299: payee_party_id,
3306: ext_bank_account_name,
3307: ext_bank_account_number,
3308: ext_branch_number,
3309: ext_bank_account_type
3310: FROM iby_payments_all
3311: WHERE
3312: payment_instruction_id = p_instruction_id;
3313:
3314: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3374: RETURN;
3375: END IF;
3376:
3377: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
3378: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
3379: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
3380: EXIT WHEN iby_pmt_csr%NOTFOUND;
3381:
3382:
3590: FROM iby_pay_instructions_all
3591: WHERE
3592: payment_instruction_id = p_instruction_id;
3593:
3594: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
3595: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3596: SELECT payment_id,
3597: payment_instruction_id,
3598: payee_party_id,
3605: ext_bank_account_name,
3606: ext_bank_account_number,
3607: ext_branch_number,
3608: ext_bank_account_type
3609: FROM iby_payments_all
3610: WHERE
3611: payment_instruction_id = p_instruction_id;
3612:
3613: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3673: RETURN;
3674: END IF;
3675:
3676: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
3677: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
3678: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
3679: EXIT WHEN iby_pmt_csr%NOTFOUND;
3680:
3681: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
3893: FROM iby_pay_instructions_all
3894: WHERE
3895: payment_instruction_id = p_instruction_id;
3896:
3897: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
3898: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3899: SELECT payment_id,
3900: payment_instruction_id,
3901: payee_party_id,
3903: payment_amount,
3904: internal_bank_account_id,
3905: int_bank_account_name,
3906: int_bank_acct_agency_loc_code
3907: FROM iby_payments_all
3908: WHERE payment_instruction_id = p_instruction_id;
3909:
3910: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3911: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3970: RETURN;
3971: END IF;
3972:
3973: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
3974: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
3975: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
3976: EXIT WHEN iby_pmt_csr%NOTFOUND;
3977:
3978: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level
4146: FROM iby_pay_instructions_all
4147: WHERE
4148: payment_instruction_id = p_instruction_id;
4149:
4150: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
4151: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4152: SELECT payment_id,
4153: payment_instruction_id,
4154: payee_party_id,
4161: ext_bank_account_name,
4162: ext_bank_account_number,
4163: ext_branch_number,
4164: ext_bank_account_type
4165: FROM iby_payments_all
4166: WHERE
4167: payment_instruction_id = p_instruction_id;
4168:
4169: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4228: RETURN;
4229: END IF;
4230:
4231: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
4232: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
4233: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
4234: EXIT WHEN iby_pmt_csr%NOTFOUND;
4235:
4236: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level
4471: FROM iby_pay_instructions_all
4472: WHERE
4473: payment_instruction_id = p_instruction_id;
4474:
4475: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
4476: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4477: SELECT payment_id,
4478: payment_instruction_id,
4479: payee_party_id,
4486: ext_bank_account_name,
4487: ext_bank_account_number,
4488: ext_branch_number,
4489: ext_bank_account_type
4490: FROM iby_payments_all
4491: WHERE
4492: payment_instruction_id = p_instruction_id;
4493:
4494: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4553: RETURN;
4554: END IF;
4555:
4556: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
4557: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
4558: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
4559: EXIT WHEN iby_pmt_csr%NOTFOUND;
4560:
4561: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level