DBA Data[Home] [Help]

APPS.IBY_PAYMENT_FORMAT_VAL_PUB dependencies on IBY_TRANSACTION_ERRORS

Line 31: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

27: )IS
28: -- Initialising Payment Record
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

Line 397: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

393: )IS
394:
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,

Line 718: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

714: )IS
715:
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,

Line 1105: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

1101: )IS
1102:
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

Line 1398: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

1394: )IS
1395:
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

Line 1757: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

1753: )IS
1754:
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

Line 2088: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

2084: )IS
2085:
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

Line 2416: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

2412: )IS
2413:
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,

Line 2687: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

2683: )IS
2684:
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,

Line 3051: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

3047: )IS
3048:
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,

Line 3411: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

3407: )IS
3408:
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

Line 3725: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

3721: )IS
3722:
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

Line 4042: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

4038: )IS
4039:
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,

Line 4306: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

4302: )IS
4303:
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,

Line 4646: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

4642: )IS
4643:
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,