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 pmts.payment_id,
44: pmts.payee_party_id,
45: pmts.payee_le_registration_num,
46: pmts.internal_bank_account_id,

Line 390: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

386: PROCEDURE FVBLNCR
387: (
388: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
389: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
390: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
391: p_is_online_val IN VARCHAR2,
392: x_result OUT NOCOPY NUMBER
393: )IS
394:

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

395: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
396: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
397: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
398:
399: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
400: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
401: SELECT org_id,
402: payment_reason_code
403: FROM iby_pay_instructions_all

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

396: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
397: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
398:
399: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
400: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
401: SELECT org_id,
402: payment_reason_code
403: FROM iby_pay_instructions_all
404: WHERE

Line 403: FROM iby_pay_instructions_all

399: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
400: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
401: SELECT org_id,
402: payment_reason_code
403: FROM iby_pay_instructions_all
404: WHERE
405: payment_instruction_id = p_instruction_id;
406: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
407: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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

403: FROM iby_pay_instructions_all
404: WHERE
405: payment_instruction_id = p_instruction_id;
406: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
407: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
408: SELECT payment_id,
409: payee_party_id,
410: payee_le_registration_num,
411: payment_instruction_id,

Line 711: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

707:
708: PROCEDURE FVBLPPDP(
709: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
710: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
711: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
712: p_is_online_val IN VARCHAR2,
713: x_result OUT NOCOPY NUMBER
714: )IS
715:

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

716: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
717: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
718: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
719:
720: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
721: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
722: SELECT org_id,
723: payment_reason_code
724: FROM iby_pay_instructions_all

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

717: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
718: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
719:
720: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
721: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
722: SELECT org_id,
723: payment_reason_code
724: FROM iby_pay_instructions_all
725: WHERE

Line 724: FROM iby_pay_instructions_all

720: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
721: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
722: SELECT org_id,
723: payment_reason_code
724: FROM iby_pay_instructions_all
725: WHERE
726: payment_instruction_id = p_instruction_id;
727:
728: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

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

725: WHERE
726: payment_instruction_id = p_instruction_id;
727:
728: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
729: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
730: SELECT pmts.payment_id,
731: pmts.payment_instruction_id,
732: pmts.payee_party_id,
733: pmts.payee_le_registration_num,

Line 1098: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

1094: PROCEDURE FVBLSLTR
1095: (
1096: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1097: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
1098: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
1099: p_is_online_val IN VARCHAR2,
1100: x_result OUT NOCOPY NUMBER
1101: )IS
1102:

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

1103: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1104: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1105: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1106:
1107: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1108: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1109: SELECT org_id,payment_reason_code
1110: FROM iby_pay_instructions_all
1111: WHERE

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

1104: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1105: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1106:
1107: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1108: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1109: SELECT org_id,payment_reason_code
1110: FROM iby_pay_instructions_all
1111: WHERE
1112: payment_instruction_id = p_instruction_id;

Line 1110: FROM iby_pay_instructions_all

1106:
1107: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1108: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1109: SELECT org_id,payment_reason_code
1110: FROM iby_pay_instructions_all
1111: WHERE
1112: payment_instruction_id = p_instruction_id;
1113:
1114: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

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

1111: WHERE
1112: payment_instruction_id = p_instruction_id;
1113:
1114: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
1115: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1116: SELECT payment_id,
1117: payment_instruction_id,
1118: payee_party_id,
1119: payee_le_registration_num,

Line 1391: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

1387: PROCEDURE FVTICTX
1388: (
1389: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1390: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
1391: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
1392: p_is_online_val IN VARCHAR2,
1393: x_result OUT NOCOPY NUMBER
1394: )IS
1395:

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

1396: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1397: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1398: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1399:
1400: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1401: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1402: SELECT org_id
1403: FROM iby_pay_instructions_all
1404: WHERE

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

1397: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1398: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1399:
1400: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1401: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1402: SELECT org_id
1403: FROM iby_pay_instructions_all
1404: WHERE
1405: payment_instruction_id = p_instruction_id;

Line 1403: FROM iby_pay_instructions_all

1399:
1400: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1401: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1402: SELECT org_id
1403: FROM iby_pay_instructions_all
1404: WHERE
1405: payment_instruction_id = p_instruction_id;
1406:
1407: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

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

1404: WHERE
1405: payment_instruction_id = p_instruction_id;
1406:
1407: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
1408: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1409: SELECT pmts.payment_id,
1410: pmts.payment_instruction_id,
1411: pmts.payee_party_id,
1412: pmts.payee_le_registration_num,

Line 1750: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

1746: PROCEDURE FVTPCCD
1747: (
1748: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1749: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
1750: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
1751: p_is_online_val IN VARCHAR2,
1752: x_result OUT NOCOPY NUMBER
1753: )IS
1754:

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

1755: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1756: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1757: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1758:
1759: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1760: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1761: SELECT org_id
1762: FROM iby_pay_instructions_all
1763: WHERE

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

1756: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1757: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1758:
1759: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1760: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1761: SELECT org_id
1762: FROM iby_pay_instructions_all
1763: WHERE
1764: payment_instruction_id = p_instruction_id;

Line 1762: FROM iby_pay_instructions_all

1758:
1759: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1760: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1761: SELECT org_id
1762: FROM iby_pay_instructions_all
1763: WHERE
1764: payment_instruction_id = p_instruction_id;
1765:
1766: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

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

1763: WHERE
1764: payment_instruction_id = p_instruction_id;
1765:
1766: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
1767: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1768: SELECT pmts.payment_id,
1769: pmts.payment_instruction_id,
1770: pmts.payee_party_id,
1771: pmts.payee_le_registration_num,

Line 2081: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

2077: PROCEDURE FVTIACHP
2078: (
2079: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2080: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
2081: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
2082: p_is_online_val IN VARCHAR2,
2083: x_result OUT NOCOPY NUMBER
2084: )IS
2085:

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

2086: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2087: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2088: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2089:
2090: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2091: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2092: SELECT org_id
2093: FROM iby_pay_instructions_all
2094: WHERE

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

2087: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2088: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2089:
2090: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2091: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2092: SELECT org_id
2093: FROM iby_pay_instructions_all
2094: WHERE
2095: payment_instruction_id = p_instruction_id;

Line 2093: FROM iby_pay_instructions_all

2089:
2090: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2091: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2092: SELECT org_id
2093: FROM iby_pay_instructions_all
2094: WHERE
2095: payment_instruction_id = p_instruction_id;
2096:
2097: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

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

2094: WHERE
2095: payment_instruction_id = p_instruction_id;
2096:
2097: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
2098: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2099: SELECT pmts.payment_id,
2100: pmts.payment_instruction_id,
2101: pmts.payee_party_id,
2102: pmts.payee_le_registration_num,

Line 2409: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

2405: PROCEDURE FVTIACHB
2406: (
2407: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2408: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
2409: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
2410: p_is_online_val IN VARCHAR2,
2411: x_result OUT NOCOPY NUMBER
2412: )IS
2413:

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

2414: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2415: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2416: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2417:
2418: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2419: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2420: SELECT org_id,
2421: payment_reason_code
2422: FROM iby_pay_instructions_all

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

2415: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2416: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2417:
2418: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2419: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2420: SELECT org_id,
2421: payment_reason_code
2422: FROM iby_pay_instructions_all
2423: WHERE

Line 2422: FROM iby_pay_instructions_all

2418: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2419: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2420: SELECT org_id,
2421: payment_reason_code
2422: FROM iby_pay_instructions_all
2423: WHERE
2424: payment_instruction_id = p_instruction_id;
2425:
2426: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

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

2423: WHERE
2424: payment_instruction_id = p_instruction_id;
2425:
2426: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
2427: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2428: SELECT payment_id,
2429: payment_instruction_id,
2430: payment_amount,
2431: internal_bank_account_id,

Line 2680: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

2676: PROCEDURE FVTPPPD
2677: (
2678: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
2679: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
2680: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
2681: p_is_online_val IN VARCHAR2,
2682: x_result OUT NOCOPY NUMBER
2683: )IS
2684:

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

2685: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2686: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2687: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2688:
2689: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2690: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2691: SELECT org_id,
2692: payment_reason_code
2693: FROM iby_pay_instructions_all

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

2686: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2687: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2688:
2689: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2690: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2691: SELECT org_id,
2692: payment_reason_code
2693: FROM iby_pay_instructions_all
2694: WHERE

Line 2693: FROM iby_pay_instructions_all

2689: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2690: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2691: SELECT org_id,
2692: payment_reason_code
2693: FROM iby_pay_instructions_all
2694: WHERE
2695: payment_instruction_id = p_instruction_id;
2696:
2697: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

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

2694: WHERE
2695: payment_instruction_id = p_instruction_id;
2696:
2697: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
2698: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2699: SELECT pmts.payment_id,
2700: pmts.payment_instruction_id,
2701: pmts.payee_party_id,
2702: pmts.payee_le_registration_num,

Line 3044: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

3040: PROCEDURE FVTPPPDP
3041: (
3042: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3043: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
3044: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
3045: p_is_online_val IN VARCHAR2,
3046: x_result OUT NOCOPY NUMBER
3047: )IS
3048:

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

3049: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3050: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3051: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3052:
3053: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3054: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3055: SELECT org_id,
3056: payment_reason_code
3057: FROM iby_pay_instructions_all

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

3050: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3051: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3052:
3053: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3054: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3055: SELECT org_id,
3056: payment_reason_code
3057: FROM iby_pay_instructions_all
3058: WHERE

Line 3057: FROM iby_pay_instructions_all

3053: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3054: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3055: SELECT org_id,
3056: payment_reason_code
3057: FROM iby_pay_instructions_all
3058: WHERE
3059: payment_instruction_id = p_instruction_id;
3060:
3061: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

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

3058: WHERE
3059: payment_instruction_id = p_instruction_id;
3060:
3061: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
3062: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3063: SELECT pmts.payment_id,
3064: pmts.payment_instruction_id,
3065: pmts.payee_party_id,
3066: pmts.payee_le_registration_num,

Line 3404: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

3400: PROCEDURE FVSPCCD
3401: (
3402: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3403: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
3404: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
3405: p_is_online_val IN VARCHAR2,
3406: x_result OUT NOCOPY NUMBER
3407: )IS
3408:

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

3409: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3410: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3411: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3412:
3413: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3414: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3415: SELECT org_id
3416: FROM iby_pay_instructions_all
3417: WHERE

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

3410: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3411: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3412:
3413: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3414: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3415: SELECT org_id
3416: FROM iby_pay_instructions_all
3417: WHERE
3418: payment_instruction_id = p_instruction_id;

Line 3416: FROM iby_pay_instructions_all

3412:
3413: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3414: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3415: SELECT org_id
3416: FROM iby_pay_instructions_all
3417: WHERE
3418: payment_instruction_id = p_instruction_id;
3419:
3420: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

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

3417: WHERE
3418: payment_instruction_id = p_instruction_id;
3419:
3420: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
3421: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3422: SELECT pmts.payment_id,
3423: pmts.payment_instruction_id,
3424: pmts.payee_party_id,
3425: pmts.payee_le_registration_num,

Line 3718: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

3714: PROCEDURE FVSPCCDP
3715: (
3716: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
3717: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
3718: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
3719: p_is_online_val IN VARCHAR2,
3720: x_result OUT NOCOPY NUMBER
3721: )IS
3722:

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

3723: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3724: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3725: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3726:
3727: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3728: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3729: SELECT org_id
3730: FROM iby_pay_instructions_all
3731: WHERE

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

3724: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3725: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3726:
3727: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3728: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3729: SELECT org_id
3730: FROM iby_pay_instructions_all
3731: WHERE
3732: payment_instruction_id = p_instruction_id;

Line 3730: FROM iby_pay_instructions_all

3726:
3727: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3728: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3729: SELECT org_id
3730: FROM iby_pay_instructions_all
3731: WHERE
3732: payment_instruction_id = p_instruction_id;
3733:
3734: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

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

3731: WHERE
3732: payment_instruction_id = p_instruction_id;
3733:
3734: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
3735: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3736: SELECT pmts.payment_id,
3737: pmts.payment_instruction_id,
3738: pmts.payee_party_id,
3739: pmts.payee_le_registration_num,

Line 4035: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

4031: PROCEDURE FVSPNCR
4032: (
4033: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4034: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
4035: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
4036: p_is_online_val IN VARCHAR2,
4037: x_result OUT NOCOPY NUMBER
4038: )IS
4039:

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

4040: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
4041: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4042: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4043:
4044: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4045: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4046: SELECT org_id,
4047: payment_reason_code
4048: FROM iby_pay_instructions_all

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

4041: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4042: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4043:
4044: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4045: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4046: SELECT org_id,
4047: payment_reason_code
4048: FROM iby_pay_instructions_all
4049: WHERE

Line 4048: FROM iby_pay_instructions_all

4044: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4045: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4046: SELECT org_id,
4047: payment_reason_code
4048: FROM iby_pay_instructions_all
4049: WHERE
4050: payment_instruction_id = p_instruction_id;
4051:
4052: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

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

4049: WHERE
4050: payment_instruction_id = p_instruction_id;
4051:
4052: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
4053: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4054: SELECT payment_id,
4055: payment_instruction_id,
4056: payee_party_id,
4057: payee_le_registration_num,

Line 4299: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

4295: PROCEDURE FVSPPPD
4296: (
4297: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4298: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
4299: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
4300: p_is_online_val IN VARCHAR2,
4301: x_result OUT NOCOPY NUMBER
4302: )IS
4303:

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

4304: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
4305: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4306: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4307:
4308: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4309: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4310: SELECT org_id,
4311: payment_reason_code
4312: FROM iby_pay_instructions_all

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

4305: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4306: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4307:
4308: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4309: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4310: SELECT org_id,
4311: payment_reason_code
4312: FROM iby_pay_instructions_all
4313: WHERE

Line 4312: FROM iby_pay_instructions_all

4308: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4309: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4310: SELECT org_id,
4311: payment_reason_code
4312: FROM iby_pay_instructions_all
4313: WHERE
4314: payment_instruction_id = p_instruction_id;
4315:
4316: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

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

4313: WHERE
4314: payment_instruction_id = p_instruction_id;
4315:
4316: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
4317: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4318: SELECT pmts.payment_id,
4319: pmts.payment_instruction_id,
4320: pmts.payee_party_id,
4321: pmts.payee_le_registration_num,

Line 4639: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,

4635: PROCEDURE FVSPPPDP
4636: (
4637: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
4638: p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
4639: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
4640: p_is_online_val IN VARCHAR2,
4641: x_result OUT NOCOPY NUMBER
4642: )IS
4643:

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

4644: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
4645: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4646: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4647:
4648: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4649: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4650: SELECT org_id,
4651: payment_reason_code
4652: FROM iby_pay_instructions_all

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

4645: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4646: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4647:
4648: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4649: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4650: SELECT org_id,
4651: payment_reason_code
4652: FROM iby_pay_instructions_all
4653: WHERE

Line 4652: FROM iby_pay_instructions_all

4648: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4649: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4650: SELECT org_id,
4651: payment_reason_code
4652: FROM iby_pay_instructions_all
4653: WHERE
4654: payment_instruction_id = p_instruction_id;
4655:
4656: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

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

4653: WHERE
4654: payment_instruction_id = p_instruction_id;
4655:
4656: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
4657: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4658: SELECT pmts.payment_id,
4659: pmts.payment_instruction_id,
4660: pmts.payee_party_id,
4661: pmts.payee_le_registration_num,