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_PAY_INSTRUCTIONS_ALL

Line 24: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%type,

20: PROCEDURE FVBLCCDP
21: (
22: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
23: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
24: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%type,
25: p_is_online_val IN VARCHAR2,
26: x_result OUT NOCOPY NUMBER
27: )IS
28: -- Initialising Payment Record

Line 33: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

29: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
30: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
31: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
32:
33: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
34: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
35: SELECT org_id
36: FROM iby_pay_instructions_all
37: WHERE

Line 34: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

30: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
31: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
32:
33: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
34: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
35: SELECT org_id
36: FROM iby_pay_instructions_all
37: WHERE
38: payment_instruction_id = p_instruction_id;

Line 36: FROM iby_pay_instructions_all

32:
33: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
34: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
35: SELECT org_id
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

Line 42: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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,
45: payee_le_registration_num,
46: internal_bank_account_id,

Line 375: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

371: PROCEDURE FVBLNCR
372: (
373: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
374: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
375: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
376: p_is_online_val IN VARCHAR2,
377: x_result OUT NOCOPY NUMBER
378: )IS
379:

Line 384: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

380: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
381: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
382: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
383:
384: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
385: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
386: SELECT org_id,
387: payment_reason_code
388: FROM iby_pay_instructions_all

Line 385: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

381: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
382: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
383:
384: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
385: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
386: SELECT org_id,
387: payment_reason_code
388: FROM iby_pay_instructions_all
389: WHERE

Line 388: FROM iby_pay_instructions_all

384: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
385: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
386: SELECT org_id,
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

Line 392: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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,
396: payment_instruction_id,

Line 687: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

683:
684: PROCEDURE FVBLPPDP(
685: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
686: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
687: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
688: p_is_online_val IN VARCHAR2,
689: x_result OUT NOCOPY NUMBER
690: )IS
691:

Line 696: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

692: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
693: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
694: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
695:
696: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
697: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
698: SELECT org_id,
699: payment_reason_code
700: FROM iby_pay_instructions_all

Line 697: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

693: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
694: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
695:
696: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
697: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
698: SELECT org_id,
699: payment_reason_code
700: FROM iby_pay_instructions_all
701: WHERE

Line 700: FROM iby_pay_instructions_all

696: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
697: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
698: SELECT org_id,
699: payment_reason_code
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

Line 705: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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,
709: payee_le_registration_num,

Line 1059: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

1055: PROCEDURE FVBLSLTR
1056: (
1057: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1058: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
1059: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
1060: p_is_online_val IN VARCHAR2,
1061: x_result OUT NOCOPY NUMBER
1062: )IS
1063:

Line 1068: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

1064: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1065: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1066: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1067:
1068: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1069: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1070: SELECT org_id,payment_reason_code
1071: FROM iby_pay_instructions_all
1072: WHERE

Line 1069: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

1065: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1066: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1067:
1068: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1069: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1070: SELECT org_id,payment_reason_code
1071: FROM iby_pay_instructions_all
1072: WHERE
1073: payment_instruction_id = p_instruction_id;

Line 1071: FROM iby_pay_instructions_all

1067:
1068: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1069: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1070: SELECT org_id,payment_reason_code
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

Line 1076: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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,
1080: payee_le_registration_num,

Line 1352: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

1348: PROCEDURE FVTICTX
1349: (
1350: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1351: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
1352: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
1353: p_is_online_val IN VARCHAR2,
1354: x_result OUT NOCOPY NUMBER
1355: )IS
1356:

Line 1361: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

1357: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1358: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1359: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1360:
1361: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1362: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1363: SELECT org_id
1364: FROM iby_pay_instructions_all
1365: WHERE

Line 1362: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

1358: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1359: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1360:
1361: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1362: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1363: SELECT org_id
1364: FROM iby_pay_instructions_all
1365: WHERE
1366: payment_instruction_id = p_instruction_id;

Line 1364: FROM iby_pay_instructions_all

1360:
1361: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1362: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1363: SELECT org_id
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

Line 1369: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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,
1373: payee_le_registration_num,

Line 1695: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

1691: PROCEDURE FVTPCCD
1692: (
1693: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1694: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
1695: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
1696: p_is_online_val IN VARCHAR2,
1697: x_result OUT NOCOPY NUMBER
1698: )IS
1699:

Line 1704: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

1700: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1701: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1702: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1703:
1704: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1705: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1706: SELECT org_id
1707: FROM iby_pay_instructions_all
1708: WHERE

Line 1705: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

1701: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1702: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1703:
1704: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1705: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1706: SELECT org_id
1707: FROM iby_pay_instructions_all
1708: WHERE
1709: payment_instruction_id = p_instruction_id;

Line 1707: FROM iby_pay_instructions_all

1703:
1704: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1705: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1706: SELECT org_id
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

Line 1712: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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,
1716: payee_le_registration_num,

Line 2011: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

2007: PROCEDURE FVTIACHP
2008: (
2009: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2010: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
2011: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
2012: p_is_online_val IN VARCHAR2,
2013: x_result OUT NOCOPY NUMBER
2014: )IS
2015:

Line 2020: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

2016: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2017: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2018: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2019:
2020: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2021: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2022: SELECT org_id
2023: FROM iby_pay_instructions_all
2024: WHERE

Line 2021: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

2017: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2018: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2019:
2020: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2021: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2022: SELECT org_id
2023: FROM iby_pay_instructions_all
2024: WHERE
2025: payment_instruction_id = p_instruction_id;

Line 2023: FROM iby_pay_instructions_all

2019:
2020: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2021: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2022: SELECT org_id
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

Line 2028: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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,
2032: payee_le_registration_num,

Line 2324: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

2320: PROCEDURE FVTIACHB
2321: (
2322: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2323: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
2324: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
2325: p_is_online_val IN VARCHAR2,
2326: x_result OUT NOCOPY NUMBER
2327: )IS
2328:

Line 2333: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

2329: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2330: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2331: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2332:
2333: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2334: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2335: SELECT org_id,
2336: payment_reason_code
2337: FROM iby_pay_instructions_all

Line 2334: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

2330: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2331: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2332:
2333: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2334: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2335: SELECT org_id,
2336: payment_reason_code
2337: FROM iby_pay_instructions_all
2338: WHERE

Line 2337: FROM iby_pay_instructions_all

2333: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2334: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2335: SELECT org_id,
2336: payment_reason_code
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

Line 2342: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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,
2346: internal_bank_account_id,

Line 2585: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

2581: PROCEDURE FVTPPPD
2582: (
2583: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2584: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
2585: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
2586: p_is_online_val IN VARCHAR2,
2587: x_result OUT NOCOPY NUMBER
2588: )IS
2589:

Line 2594: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

2590: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2591: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2592: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2593:
2594: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2595: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2596: SELECT org_id,
2597: payment_reason_code
2598: FROM iby_pay_instructions_all

Line 2595: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

2591: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2592: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2593:
2594: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2595: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2596: SELECT org_id,
2597: payment_reason_code
2598: FROM iby_pay_instructions_all
2599: WHERE

Line 2598: FROM iby_pay_instructions_all

2594: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2595: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2596: SELECT org_id,
2597: payment_reason_code
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

Line 2603: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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,
2607: payment_instruction_id,

Line 2934: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

2930: PROCEDURE FVTPPPDP
2931: (
2932: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2933: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
2934: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
2935: p_is_online_val IN VARCHAR2,
2936: x_result OUT NOCOPY NUMBER
2937: )IS
2938:

Line 2943: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

2939: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2940: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2941: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2942:
2943: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2944: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2945: SELECT org_id,
2946: payment_reason_code
2947: FROM iby_pay_instructions_all

Line 2944: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

2940: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2941: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2942:
2943: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2944: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2945: SELECT org_id,
2946: payment_reason_code
2947: FROM iby_pay_instructions_all
2948: WHERE

Line 2947: FROM iby_pay_instructions_all

2943: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2944: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2945: SELECT org_id,
2946: payment_reason_code
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

Line 2952: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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,
2956: payee_le_registration_num,

Line 3279: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

3275: PROCEDURE FVSPCCD
3276: (
3277: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3278: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
3279: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
3280: p_is_online_val IN VARCHAR2,
3281: x_result OUT NOCOPY NUMBER
3282: )IS
3283:

Line 3288: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

3284: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3285: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3286: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3287:
3288: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3289: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3290: SELECT org_id
3291: FROM iby_pay_instructions_all
3292: WHERE

Line 3289: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

3285: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3286: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3287:
3288: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3289: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3290: SELECT org_id
3291: FROM iby_pay_instructions_all
3292: WHERE
3293: payment_instruction_id = p_instruction_id;

Line 3291: FROM iby_pay_instructions_all

3287:
3288: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3289: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3290: SELECT org_id
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

Line 3296: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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,
3300: payee_le_registration_num,

Line 3578: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

3574: PROCEDURE FVSPCCDP
3575: (
3576: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3577: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
3578: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
3579: p_is_online_val IN VARCHAR2,
3580: x_result OUT NOCOPY NUMBER
3581: )IS
3582:

Line 3587: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

3583: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3584: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3585: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3586:
3587: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3588: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3589: SELECT org_id
3590: FROM iby_pay_instructions_all
3591: WHERE

Line 3588: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

3584: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3585: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3586:
3587: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3588: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3589: SELECT org_id
3590: FROM iby_pay_instructions_all
3591: WHERE
3592: payment_instruction_id = p_instruction_id;

Line 3590: FROM iby_pay_instructions_all

3586:
3587: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3588: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3589: SELECT org_id
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

Line 3595: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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,
3599: payee_le_registration_num,

Line 3880: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

3876: PROCEDURE FVSPNCR
3877: (
3878: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3879: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
3880: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
3881: p_is_online_val IN VARCHAR2,
3882: x_result OUT NOCOPY NUMBER
3883: )IS
3884:

Line 3889: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

3885: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3886: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3887: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3888:
3889: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3890: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3891: SELECT org_id,
3892: payment_reason_code
3893: FROM iby_pay_instructions_all

Line 3890: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

3886: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3887: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3888:
3889: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3890: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3891: SELECT org_id,
3892: payment_reason_code
3893: FROM iby_pay_instructions_all
3894: WHERE

Line 3893: FROM iby_pay_instructions_all

3889: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3890: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3891: SELECT org_id,
3892: payment_reason_code
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

Line 3898: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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,
3902: payee_le_registration_num,

Line 4133: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

4129: PROCEDURE FVSPPPD
4130: (
4131: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4132: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
4133: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
4134: p_is_online_val IN VARCHAR2,
4135: x_result OUT NOCOPY NUMBER
4136: )IS
4137:

Line 4142: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

4138: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
4139: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4140: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4141:
4142: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4143: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4144: SELECT org_id,
4145: payment_reason_code
4146: FROM iby_pay_instructions_all

Line 4143: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

4139: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4140: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4141:
4142: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4143: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4144: SELECT org_id,
4145: payment_reason_code
4146: FROM iby_pay_instructions_all
4147: WHERE

Line 4146: FROM iby_pay_instructions_all

4142: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4143: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4144: SELECT org_id,
4145: payment_reason_code
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

Line 4151: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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,
4155: payee_le_registration_num,

Line 4458: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

4454: PROCEDURE FVSPPPDP
4455: (
4456: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4457: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
4458: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
4459: p_is_online_val IN VARCHAR2,
4460: x_result OUT NOCOPY NUMBER
4461: )IS
4462:

Line 4467: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

4463: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
4464: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4465: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4466:
4467: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4468: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4469: SELECT org_id,
4470: payment_reason_code
4471: FROM iby_pay_instructions_all

Line 4468: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

4464: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4465: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4466:
4467: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4468: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4469: SELECT org_id,
4470: payment_reason_code
4471: FROM iby_pay_instructions_all
4472: WHERE

Line 4471: FROM iby_pay_instructions_all

4467: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4468: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4469: SELECT org_id,
4470: payment_reason_code
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

Line 4476: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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,
4480: payee_le_registration_num,