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 382: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

378: )IS
379:
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,

Line 694: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

690: )IS
691:
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,

Line 1066: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

1062: )IS
1063:
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

Line 1359: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

1355: )IS
1356:
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

Line 1702: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

1698: )IS
1699:
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

Line 2018: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

2014: )IS
2015:
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

Line 2331: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

2327: )IS
2328:
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,

Line 2592: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

2588: )IS
2589:
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,

Line 2941: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

2937: )IS
2938:
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,

Line 3286: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

3282: )IS
3283:
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

Line 3585: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

3581: )IS
3582:
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

Line 3887: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

3883: )IS
3884:
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,

Line 4140: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

4136: )IS
4137:
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,

Line 4465: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;

4461: )IS
4462:
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,