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_VALIDATIONSETS_PUB dependencies on IBY_DOCS_PAYABLE_ALL

Line 8: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

4: --
5: -- Contains all document level fields which need to be validated
6: --
7: TYPE documentRecType IS RECORD (
8: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
9: calling_app_doc_id1 IBY_DOCS_PAYABLE_ALL.
10: calling_app_doc_unique_ref1%TYPE,
11: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.
12: calling_app_doc_unique_ref2%TYPE,

Line 9: calling_app_doc_id1 IBY_DOCS_PAYABLE_ALL.

5: -- Contains all document level fields which need to be validated
6: --
7: TYPE documentRecType IS RECORD (
8: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
9: calling_app_doc_id1 IBY_DOCS_PAYABLE_ALL.
10: calling_app_doc_unique_ref1%TYPE,
11: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.
12: calling_app_doc_unique_ref2%TYPE,
13: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.

Line 11: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.

7: TYPE documentRecType IS RECORD (
8: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
9: calling_app_doc_id1 IBY_DOCS_PAYABLE_ALL.
10: calling_app_doc_unique_ref1%TYPE,
11: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.
12: calling_app_doc_unique_ref2%TYPE,
13: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.
14: calling_app_doc_unique_ref3%TYPE,
15: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.

Line 13: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.

9: calling_app_doc_id1 IBY_DOCS_PAYABLE_ALL.
10: calling_app_doc_unique_ref1%TYPE,
11: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.
12: calling_app_doc_unique_ref2%TYPE,
13: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.
14: calling_app_doc_unique_ref3%TYPE,
15: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.
16: calling_app_doc_unique_ref4%TYPE,
17: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.

Line 15: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.

11: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.
12: calling_app_doc_unique_ref2%TYPE,
13: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.
14: calling_app_doc_unique_ref3%TYPE,
15: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.
16: calling_app_doc_unique_ref4%TYPE,
17: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.
18: calling_app_doc_unique_ref5%TYPE,
19: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.

Line 17: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.

13: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.
14: calling_app_doc_unique_ref3%TYPE,
15: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.
16: calling_app_doc_unique_ref4%TYPE,
17: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.
18: calling_app_doc_unique_ref5%TYPE,
19: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.
20: pay_proc_trxn_type_code%TYPE,
21: document_id IBY_DOCS_PAYABLE_ALL.

Line 19: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.

15: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.
16: calling_app_doc_unique_ref4%TYPE,
17: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.
18: calling_app_doc_unique_ref5%TYPE,
19: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.
20: pay_proc_trxn_type_code%TYPE,
21: document_id IBY_DOCS_PAYABLE_ALL.
22: document_payable_id%TYPE,
23: document_amount IBY_DOCS_PAYABLE_ALL.

Line 21: document_id IBY_DOCS_PAYABLE_ALL.

17: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.
18: calling_app_doc_unique_ref5%TYPE,
19: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.
20: pay_proc_trxn_type_code%TYPE,
21: document_id IBY_DOCS_PAYABLE_ALL.
22: document_payable_id%TYPE,
23: document_amount IBY_DOCS_PAYABLE_ALL.
24: document_amount%TYPE,
25: document_pay_currency IBY_DOCS_PAYABLE_ALL.

Line 23: document_amount IBY_DOCS_PAYABLE_ALL.

19: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.
20: pay_proc_trxn_type_code%TYPE,
21: document_id IBY_DOCS_PAYABLE_ALL.
22: document_payable_id%TYPE,
23: document_amount IBY_DOCS_PAYABLE_ALL.
24: document_amount%TYPE,
25: document_pay_currency IBY_DOCS_PAYABLE_ALL.
26: payment_currency_code%TYPE,
27: exclusive_payment_flag IBY_DOCS_PAYABLE_ALL.

Line 25: document_pay_currency IBY_DOCS_PAYABLE_ALL.

21: document_id IBY_DOCS_PAYABLE_ALL.
22: document_payable_id%TYPE,
23: document_amount IBY_DOCS_PAYABLE_ALL.
24: document_amount%TYPE,
25: document_pay_currency IBY_DOCS_PAYABLE_ALL.
26: payment_currency_code%TYPE,
27: exclusive_payment_flag IBY_DOCS_PAYABLE_ALL.
28: exclusive_payment_flag%TYPE := 'N',
29: delivery_channel_code IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,

Line 27: exclusive_payment_flag IBY_DOCS_PAYABLE_ALL.

23: document_amount IBY_DOCS_PAYABLE_ALL.
24: document_amount%TYPE,
25: document_pay_currency IBY_DOCS_PAYABLE_ALL.
26: payment_currency_code%TYPE,
27: exclusive_payment_flag IBY_DOCS_PAYABLE_ALL.
28: exclusive_payment_flag%TYPE := 'N',
29: delivery_channel_code IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
30: unique_remit_id_code IBY_DOCS_PAYABLE_ALL.
31: unique_remittance_identifier%TYPE,

Line 29: delivery_channel_code IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,

25: document_pay_currency IBY_DOCS_PAYABLE_ALL.
26: payment_currency_code%TYPE,
27: exclusive_payment_flag IBY_DOCS_PAYABLE_ALL.
28: exclusive_payment_flag%TYPE := 'N',
29: delivery_channel_code IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
30: unique_remit_id_code IBY_DOCS_PAYABLE_ALL.
31: unique_remittance_identifier%TYPE,
32: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%TYPE,
33: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,

Line 30: unique_remit_id_code IBY_DOCS_PAYABLE_ALL.

26: payment_currency_code%TYPE,
27: exclusive_payment_flag IBY_DOCS_PAYABLE_ALL.
28: exclusive_payment_flag%TYPE := 'N',
29: delivery_channel_code IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
30: unique_remit_id_code IBY_DOCS_PAYABLE_ALL.
31: unique_remittance_identifier%TYPE,
32: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%TYPE,
33: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,
34: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,

Line 32: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%TYPE,

28: exclusive_payment_flag%TYPE := 'N',
29: delivery_channel_code IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
30: unique_remit_id_code IBY_DOCS_PAYABLE_ALL.
31: unique_remittance_identifier%TYPE,
32: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%TYPE,
33: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,
34: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,
35: REMITTANCE_MESSAGE2 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE2%TYPE,
36: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%TYPE,

Line 33: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,

29: delivery_channel_code IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
30: unique_remit_id_code IBY_DOCS_PAYABLE_ALL.
31: unique_remittance_identifier%TYPE,
32: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%TYPE,
33: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,
34: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,
35: REMITTANCE_MESSAGE2 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE2%TYPE,
36: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%TYPE,
37: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE,

Line 34: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,

30: unique_remit_id_code IBY_DOCS_PAYABLE_ALL.
31: unique_remittance_identifier%TYPE,
32: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%TYPE,
33: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,
34: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,
35: REMITTANCE_MESSAGE2 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE2%TYPE,
36: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%TYPE,
37: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE,
38:

Line 35: REMITTANCE_MESSAGE2 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE2%TYPE,

31: unique_remittance_identifier%TYPE,
32: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%TYPE,
33: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,
34: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,
35: REMITTANCE_MESSAGE2 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE2%TYPE,
36: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%TYPE,
37: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE,
38:
39:

Line 36: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%TYPE,

32: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%TYPE,
33: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,
34: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,
35: REMITTANCE_MESSAGE2 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE2%TYPE,
36: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%TYPE,
37: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE,
38:
39:
40: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,

Line 37: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE,

33: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,
34: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,
35: REMITTANCE_MESSAGE2 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE2%TYPE,
36: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%TYPE,
37: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE,
38:
39:
40: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,
41: int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,

Line 128: bank_charge_bearer IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,

124:
125: payee_party_postal HZ_LOCATIONS.postal_code%TYPE,
126: payee_party_country HZ_LOCATIONS.country%TYPE,
127:
128: bank_charge_bearer IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
129: payment_reason_code IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
130: payment_method_cd IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
131: payment_format_cd IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE
132: );

Line 129: payment_reason_code IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,

125: payee_party_postal HZ_LOCATIONS.postal_code%TYPE,
126: payee_party_country HZ_LOCATIONS.country%TYPE,
127:
128: bank_charge_bearer IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
129: payment_reason_code IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
130: payment_method_cd IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
131: payment_format_cd IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE
132: );
133:

Line 130: payment_method_cd IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

126: payee_party_country HZ_LOCATIONS.country%TYPE,
127:
128: bank_charge_bearer IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
129: payment_reason_code IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
130: payment_method_cd IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
131: payment_format_cd IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE
132: );
133:
134: /*

Line 131: payment_format_cd IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE

127:
128: bank_charge_bearer IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
129: payment_reason_code IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
130: payment_method_cd IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
131: payment_format_cd IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE
132: );
133:
134: /*
135: * This record stores the minimum number of fields required

Line 142: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

138: * It will be used in exception situations to inform the calling
139: * app that a particular doc is in error.
140: */
141: TYPE basicDocRecType IS RECORD (
142: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
143: calling_app_doc_id1 IBY_DOCS_PAYABLE_ALL.
144: calling_app_doc_unique_ref1%TYPE,
145: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.
146: calling_app_doc_unique_ref2%TYPE,

Line 143: calling_app_doc_id1 IBY_DOCS_PAYABLE_ALL.

139: * app that a particular doc is in error.
140: */
141: TYPE basicDocRecType IS RECORD (
142: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
143: calling_app_doc_id1 IBY_DOCS_PAYABLE_ALL.
144: calling_app_doc_unique_ref1%TYPE,
145: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.
146: calling_app_doc_unique_ref2%TYPE,
147: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.

Line 145: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.

141: TYPE basicDocRecType IS RECORD (
142: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
143: calling_app_doc_id1 IBY_DOCS_PAYABLE_ALL.
144: calling_app_doc_unique_ref1%TYPE,
145: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.
146: calling_app_doc_unique_ref2%TYPE,
147: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.
148: calling_app_doc_unique_ref3%TYPE,
149: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.

Line 147: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.

143: calling_app_doc_id1 IBY_DOCS_PAYABLE_ALL.
144: calling_app_doc_unique_ref1%TYPE,
145: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.
146: calling_app_doc_unique_ref2%TYPE,
147: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.
148: calling_app_doc_unique_ref3%TYPE,
149: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.
150: calling_app_doc_unique_ref4%TYPE,
151: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.

Line 149: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.

145: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.
146: calling_app_doc_unique_ref2%TYPE,
147: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.
148: calling_app_doc_unique_ref3%TYPE,
149: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.
150: calling_app_doc_unique_ref4%TYPE,
151: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.
152: calling_app_doc_unique_ref5%TYPE,
153: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

Line 151: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.

147: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.
148: calling_app_doc_unique_ref3%TYPE,
149: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.
150: calling_app_doc_unique_ref4%TYPE,
151: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.
152: calling_app_doc_unique_ref5%TYPE,
153: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
154: document_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE
155: );

Line 153: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

149: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.
150: calling_app_doc_unique_ref4%TYPE,
151: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.
152: calling_app_doc_unique_ref5%TYPE,
153: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
154: document_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE
155: );
156:
157: TYPE paymentRecType IS RECORD (

Line 154: document_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE

150: calling_app_doc_unique_ref4%TYPE,
151: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.
152: calling_app_doc_unique_ref5%TYPE,
153: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
154: document_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE
155: );
156:
157: TYPE paymentRecType IS RECORD (
158: pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE,

Line 182: doc_id IBY_DOCS_PAYABLE_ALL.

178: --
179: -- A record to store the details of the validation set
180: --
181: TYPE valSetRecType IS RECORD (
182: doc_id IBY_DOCS_PAYABLE_ALL.
183: document_payable_id%TYPE,
184: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
185: payment_grouping_number%TYPE,
186: payee_id IBY_DOCS_PAYABLE_ALL.

Line 184: pmt_grp_num IBY_DOCS_PAYABLE_ALL.

180: --
181: TYPE valSetRecType IS RECORD (
182: doc_id IBY_DOCS_PAYABLE_ALL.
183: document_payable_id%TYPE,
184: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
185: payment_grouping_number%TYPE,
186: payee_id IBY_DOCS_PAYABLE_ALL.
187: ext_payee_id%TYPE,
188: val_set_code IBY_VALIDATION_SETS_VL.

Line 186: payee_id IBY_DOCS_PAYABLE_ALL.

182: doc_id IBY_DOCS_PAYABLE_ALL.
183: document_payable_id%TYPE,
184: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
185: payment_grouping_number%TYPE,
186: payee_id IBY_DOCS_PAYABLE_ALL.
187: ext_payee_id%TYPE,
188: val_set_code IBY_VALIDATION_SETS_VL.
189: validation_set_code%TYPE,
190: val_code_pkg IBY_VALIDATION_SETS_VL.

Line 228: doc_id IBY_DOCS_PAYABLE_ALL.

224: -- This record will hold a document payable id and it's
225: -- corresponding original document id.
226: --
227: TYPE docPayRecType IS RECORD (
228: doc_id IBY_DOCS_PAYABLE_ALL.
229: document_payable_id%TYPE,
230: ca_doc_id1 IBY_DOCS_PAYABLE_ALL.
231: calling_app_doc_unique_ref1%TYPE,
232: ca_doc_id2 IBY_DOCS_PAYABLE_ALL.

Line 230: ca_doc_id1 IBY_DOCS_PAYABLE_ALL.

226: --
227: TYPE docPayRecType IS RECORD (
228: doc_id IBY_DOCS_PAYABLE_ALL.
229: document_payable_id%TYPE,
230: ca_doc_id1 IBY_DOCS_PAYABLE_ALL.
231: calling_app_doc_unique_ref1%TYPE,
232: ca_doc_id2 IBY_DOCS_PAYABLE_ALL.
233: calling_app_doc_unique_ref2%TYPE,
234: ca_doc_id3 IBY_DOCS_PAYABLE_ALL.

Line 232: ca_doc_id2 IBY_DOCS_PAYABLE_ALL.

228: doc_id IBY_DOCS_PAYABLE_ALL.
229: document_payable_id%TYPE,
230: ca_doc_id1 IBY_DOCS_PAYABLE_ALL.
231: calling_app_doc_unique_ref1%TYPE,
232: ca_doc_id2 IBY_DOCS_PAYABLE_ALL.
233: calling_app_doc_unique_ref2%TYPE,
234: ca_doc_id3 IBY_DOCS_PAYABLE_ALL.
235: calling_app_doc_unique_ref3%TYPE,
236: ca_doc_id4 IBY_DOCS_PAYABLE_ALL.

Line 234: ca_doc_id3 IBY_DOCS_PAYABLE_ALL.

230: ca_doc_id1 IBY_DOCS_PAYABLE_ALL.
231: calling_app_doc_unique_ref1%TYPE,
232: ca_doc_id2 IBY_DOCS_PAYABLE_ALL.
233: calling_app_doc_unique_ref2%TYPE,
234: ca_doc_id3 IBY_DOCS_PAYABLE_ALL.
235: calling_app_doc_unique_ref3%TYPE,
236: ca_doc_id4 IBY_DOCS_PAYABLE_ALL.
237: calling_app_doc_unique_ref4%TYPE,
238: ca_doc_id5 IBY_DOCS_PAYABLE_ALL.

Line 236: ca_doc_id4 IBY_DOCS_PAYABLE_ALL.

232: ca_doc_id2 IBY_DOCS_PAYABLE_ALL.
233: calling_app_doc_unique_ref2%TYPE,
234: ca_doc_id3 IBY_DOCS_PAYABLE_ALL.
235: calling_app_doc_unique_ref3%TYPE,
236: ca_doc_id4 IBY_DOCS_PAYABLE_ALL.
237: calling_app_doc_unique_ref4%TYPE,
238: ca_doc_id5 IBY_DOCS_PAYABLE_ALL.
239: calling_app_doc_unique_ref5%TYPE,
240: ca_doc_ref_num IBY_DOCS_PAYABLE_ALL.

Line 238: ca_doc_id5 IBY_DOCS_PAYABLE_ALL.

234: ca_doc_id3 IBY_DOCS_PAYABLE_ALL.
235: calling_app_doc_unique_ref3%TYPE,
236: ca_doc_id4 IBY_DOCS_PAYABLE_ALL.
237: calling_app_doc_unique_ref4%TYPE,
238: ca_doc_id5 IBY_DOCS_PAYABLE_ALL.
239: calling_app_doc_unique_ref5%TYPE,
240: ca_doc_ref_num IBY_DOCS_PAYABLE_ALL.
241: calling_app_doc_ref_number%TYPE,
242: ca_id IBY_DOCS_PAYABLE_ALL.

Line 240: ca_doc_ref_num IBY_DOCS_PAYABLE_ALL.

236: ca_doc_id4 IBY_DOCS_PAYABLE_ALL.
237: calling_app_doc_unique_ref4%TYPE,
238: ca_doc_id5 IBY_DOCS_PAYABLE_ALL.
239: calling_app_doc_unique_ref5%TYPE,
240: ca_doc_ref_num IBY_DOCS_PAYABLE_ALL.
241: calling_app_doc_ref_number%TYPE,
242: ca_id IBY_DOCS_PAYABLE_ALL.
243: calling_app_id%TYPE,
244: pp_tt_cd IBY_DOCS_PAYABLE_ALL.

Line 242: ca_id IBY_DOCS_PAYABLE_ALL.

238: ca_doc_id5 IBY_DOCS_PAYABLE_ALL.
239: calling_app_doc_unique_ref5%TYPE,
240: ca_doc_ref_num IBY_DOCS_PAYABLE_ALL.
241: calling_app_doc_ref_number%TYPE,
242: ca_id IBY_DOCS_PAYABLE_ALL.
243: calling_app_id%TYPE,
244: pp_tt_cd IBY_DOCS_PAYABLE_ALL.
245: pay_proc_trxn_type_code%TYPE,
246: pmt_grp_num IBY_DOCS_PAYABLE_ALL.

Line 244: pp_tt_cd IBY_DOCS_PAYABLE_ALL.

240: ca_doc_ref_num IBY_DOCS_PAYABLE_ALL.
241: calling_app_doc_ref_number%TYPE,
242: ca_id IBY_DOCS_PAYABLE_ALL.
243: calling_app_id%TYPE,
244: pp_tt_cd IBY_DOCS_PAYABLE_ALL.
245: pay_proc_trxn_type_code%TYPE,
246: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
247: payment_grouping_number%TYPE,
248: payee_id IBY_DOCS_PAYABLE_ALL.

Line 246: pmt_grp_num IBY_DOCS_PAYABLE_ALL.

242: ca_id IBY_DOCS_PAYABLE_ALL.
243: calling_app_id%TYPE,
244: pp_tt_cd IBY_DOCS_PAYABLE_ALL.
245: pay_proc_trxn_type_code%TYPE,
246: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
247: payment_grouping_number%TYPE,
248: payee_id IBY_DOCS_PAYABLE_ALL.
249: ext_payee_id%TYPE,
250: profile_id IBY_DOCS_PAYABLE_ALL.

Line 248: payee_id IBY_DOCS_PAYABLE_ALL.

244: pp_tt_cd IBY_DOCS_PAYABLE_ALL.
245: pay_proc_trxn_type_code%TYPE,
246: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
247: payment_grouping_number%TYPE,
248: payee_id IBY_DOCS_PAYABLE_ALL.
249: ext_payee_id%TYPE,
250: profile_id IBY_DOCS_PAYABLE_ALL.
251: payment_profile_id%TYPE,
252: org_id IBY_DOCS_PAYABLE_ALL.

Line 250: profile_id IBY_DOCS_PAYABLE_ALL.

246: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
247: payment_grouping_number%TYPE,
248: payee_id IBY_DOCS_PAYABLE_ALL.
249: ext_payee_id%TYPE,
250: profile_id IBY_DOCS_PAYABLE_ALL.
251: payment_profile_id%TYPE,
252: org_id IBY_DOCS_PAYABLE_ALL.
253: org_id%TYPE,
254: org_type IBY_DOCS_PAYABLE_ALL.

Line 252: org_id IBY_DOCS_PAYABLE_ALL.

248: payee_id IBY_DOCS_PAYABLE_ALL.
249: ext_payee_id%TYPE,
250: profile_id IBY_DOCS_PAYABLE_ALL.
251: payment_profile_id%TYPE,
252: org_id IBY_DOCS_PAYABLE_ALL.
253: org_id%TYPE,
254: org_type IBY_DOCS_PAYABLE_ALL.
255: org_type%TYPE,
256: pmt_method_cd IBY_DOCS_PAYABLE_ALL.

Line 254: org_type IBY_DOCS_PAYABLE_ALL.

250: profile_id IBY_DOCS_PAYABLE_ALL.
251: payment_profile_id%TYPE,
252: org_id IBY_DOCS_PAYABLE_ALL.
253: org_id%TYPE,
254: org_type IBY_DOCS_PAYABLE_ALL.
255: org_type%TYPE,
256: pmt_method_cd IBY_DOCS_PAYABLE_ALL.
257: payment_method_code%TYPE,
258: pmt_format_cd IBY_DOCS_PAYABLE_ALL.

Line 256: pmt_method_cd IBY_DOCS_PAYABLE_ALL.

252: org_id IBY_DOCS_PAYABLE_ALL.
253: org_id%TYPE,
254: org_type IBY_DOCS_PAYABLE_ALL.
255: org_type%TYPE,
256: pmt_method_cd IBY_DOCS_PAYABLE_ALL.
257: payment_method_code%TYPE,
258: pmt_format_cd IBY_DOCS_PAYABLE_ALL.
259: payment_format_code%TYPE,
260: pmt_curr_code IBY_DOCS_PAYABLE_ALL.

Line 258: pmt_format_cd IBY_DOCS_PAYABLE_ALL.

254: org_type IBY_DOCS_PAYABLE_ALL.
255: org_type%TYPE,
256: pmt_method_cd IBY_DOCS_PAYABLE_ALL.
257: payment_method_code%TYPE,
258: pmt_format_cd IBY_DOCS_PAYABLE_ALL.
259: payment_format_code%TYPE,
260: pmt_curr_code IBY_DOCS_PAYABLE_ALL.
261: payment_currency_code%TYPE,
262: int_bank_acct_id IBY_DOCS_PAYABLE_ALL.

Line 260: pmt_curr_code IBY_DOCS_PAYABLE_ALL.

256: pmt_method_cd IBY_DOCS_PAYABLE_ALL.
257: payment_method_code%TYPE,
258: pmt_format_cd IBY_DOCS_PAYABLE_ALL.
259: payment_format_code%TYPE,
260: pmt_curr_code IBY_DOCS_PAYABLE_ALL.
261: payment_currency_code%TYPE,
262: int_bank_acct_id IBY_DOCS_PAYABLE_ALL.
263: internal_bank_account_id%TYPE,
264: pmt_date IBY_DOCS_PAYABLE_ALL.

Line 262: int_bank_acct_id IBY_DOCS_PAYABLE_ALL.

258: pmt_format_cd IBY_DOCS_PAYABLE_ALL.
259: payment_format_code%TYPE,
260: pmt_curr_code IBY_DOCS_PAYABLE_ALL.
261: payment_currency_code%TYPE,
262: int_bank_acct_id IBY_DOCS_PAYABLE_ALL.
263: internal_bank_account_id%TYPE,
264: pmt_date IBY_DOCS_PAYABLE_ALL.
265: payment_date%TYPE,
266: int_bank_country_cd CE_BANK_BRANCHES_V.

Line 264: pmt_date IBY_DOCS_PAYABLE_ALL.

260: pmt_curr_code IBY_DOCS_PAYABLE_ALL.
261: payment_currency_code%TYPE,
262: int_bank_acct_id IBY_DOCS_PAYABLE_ALL.
263: internal_bank_account_id%TYPE,
264: pmt_date IBY_DOCS_PAYABLE_ALL.
265: payment_date%TYPE,
266: int_bank_country_cd CE_BANK_BRANCHES_V.
267: country%TYPE,
268: ext_bank_country_cd IBY_EXT_BANK_ACCOUNTS_V.

Line 288: doc_id IBY_DOCS_PAYABLE_ALL.

284: -- This record will hold a document payable id, its status
285: -- and its corresponding original document id.
286: --
287: TYPE docStatusRecType IS RECORD (
288: doc_id IBY_DOCS_PAYABLE_ALL.
289: document_payable_id%TYPE,
290: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
291: payment_grouping_number%TYPE,
292: payee_id IBY_DOCS_PAYABLE_ALL.

Line 290: pmt_grp_num IBY_DOCS_PAYABLE_ALL.

286: --
287: TYPE docStatusRecType IS RECORD (
288: doc_id IBY_DOCS_PAYABLE_ALL.
289: document_payable_id%TYPE,
290: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
291: payment_grouping_number%TYPE,
292: payee_id IBY_DOCS_PAYABLE_ALL.
293: ext_payee_id%TYPE,
294: doc_status IBY_DOCS_PAYABLE_ALL.

Line 292: payee_id IBY_DOCS_PAYABLE_ALL.

288: doc_id IBY_DOCS_PAYABLE_ALL.
289: document_payable_id%TYPE,
290: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
291: payment_grouping_number%TYPE,
292: payee_id IBY_DOCS_PAYABLE_ALL.
293: ext_payee_id%TYPE,
294: doc_status IBY_DOCS_PAYABLE_ALL.
295: document_status%TYPE
296: );

Line 294: doc_status IBY_DOCS_PAYABLE_ALL.

290: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
291: payment_grouping_number%TYPE,
292: payee_id IBY_DOCS_PAYABLE_ALL.
293: ext_payee_id%TYPE,
294: doc_status IBY_DOCS_PAYABLE_ALL.
295: document_status%TYPE
296: );
297:
298: --

Line 322: doc_id IBY_DOCS_PAYABLE_ALL.

318: /*
319: * Rejected document id along with its status.
320: */
321: TYPE rejectedDocRecType IS RECORD (
322: doc_id IBY_DOCS_PAYABLE_ALL.
323: document_payable_id%TYPE,
324: doc_status IBY_DOCS_PAYABLE_ALL.
325: document_status%TYPE
326: );

Line 324: doc_status IBY_DOCS_PAYABLE_ALL.

320: */
321: TYPE rejectedDocRecType IS RECORD (
322: doc_id IBY_DOCS_PAYABLE_ALL.
323: document_payable_id%TYPE,
324: doc_status IBY_DOCS_PAYABLE_ALL.
325: document_status%TYPE
326: );
327:
328: /*

Line 369: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

365: TYPE charValRecType IS RECORD (
366:
367: /* DOCUMENT */
368: document_id
369: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
370: ca_id
371: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
372: calling_app_doc_id1
373: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,

Line 371: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

367: /* DOCUMENT */
368: document_id
369: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
370: ca_id
371: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
372: calling_app_doc_id1
373: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
374: calling_app_doc_id2
375: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,

Line 373: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,

369: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
370: ca_id
371: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
372: calling_app_doc_id1
373: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
374: calling_app_doc_id2
375: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
376: calling_app_doc_id3
377: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,

Line 375: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,

371: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
372: calling_app_doc_id1
373: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
374: calling_app_doc_id2
375: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
376: calling_app_doc_id3
377: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
378: calling_app_doc_id4
379: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,

Line 377: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,

373: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
374: calling_app_doc_id2
375: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
376: calling_app_doc_id3
377: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
378: calling_app_doc_id4
379: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
380: calling_app_doc_id5
381: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,

Line 379: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,

375: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
376: calling_app_doc_id3
377: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
378: calling_app_doc_id4
379: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
380: calling_app_doc_id5
381: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
382: pay_proc_trxn_type_cd
383: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

Line 381: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,

377: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
378: calling_app_doc_id4
379: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
380: calling_app_doc_id5
381: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
382: pay_proc_trxn_type_cd
383: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
384: ca_doc_ref_num
385: IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE,

Line 383: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

379: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
380: calling_app_doc_id5
381: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
382: pay_proc_trxn_type_cd
383: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
384: ca_doc_ref_num
385: IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE,
386: uri
387: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,

Line 385: IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE,

381: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
382: pay_proc_trxn_type_cd
383: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
384: ca_doc_ref_num
385: IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE,
386: uri
387: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
388: uri_checkdigit
389: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,

Line 387: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,

383: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
384: ca_doc_ref_num
385: IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE,
386: uri
387: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
388: uri_checkdigit
389: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
390: po_number
391: IBY_DOCS_PAYABLE_ALL.po_number%TYPE,

Line 389: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,

385: IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE,
386: uri
387: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
388: uri_checkdigit
389: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
390: po_number
391: IBY_DOCS_PAYABLE_ALL.po_number%TYPE,
392: doc_desc
393: IBY_DOCS_PAYABLE_ALL.document_description%TYPE,

Line 391: IBY_DOCS_PAYABLE_ALL.po_number%TYPE,

387: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
388: uri_checkdigit
389: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
390: po_number
391: IBY_DOCS_PAYABLE_ALL.po_number%TYPE,
392: doc_desc
393: IBY_DOCS_PAYABLE_ALL.document_description%TYPE,
394: bank_ref
395: IBY_DOCS_PAYABLE_ALL.bank_assigned_ref_code%TYPE,

Line 393: IBY_DOCS_PAYABLE_ALL.document_description%TYPE,

389: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
390: po_number
391: IBY_DOCS_PAYABLE_ALL.po_number%TYPE,
392: doc_desc
393: IBY_DOCS_PAYABLE_ALL.document_description%TYPE,
394: bank_ref
395: IBY_DOCS_PAYABLE_ALL.bank_assigned_ref_code%TYPE,
396: pmt_reason_comments
397: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,

Line 395: IBY_DOCS_PAYABLE_ALL.bank_assigned_ref_code%TYPE,

391: IBY_DOCS_PAYABLE_ALL.po_number%TYPE,
392: doc_desc
393: IBY_DOCS_PAYABLE_ALL.document_description%TYPE,
394: bank_ref
395: IBY_DOCS_PAYABLE_ALL.bank_assigned_ref_code%TYPE,
396: pmt_reason_comments
397: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
398: remit_msg1
399: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,

Line 397: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,

393: IBY_DOCS_PAYABLE_ALL.document_description%TYPE,
394: bank_ref
395: IBY_DOCS_PAYABLE_ALL.bank_assigned_ref_code%TYPE,
396: pmt_reason_comments
397: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
398: remit_msg1
399: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
400: remit_msg2
401: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,

Line 399: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,

395: IBY_DOCS_PAYABLE_ALL.bank_assigned_ref_code%TYPE,
396: pmt_reason_comments
397: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
398: remit_msg1
399: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
400: remit_msg2
401: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
402: remit_msg3
403: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,

Line 401: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,

397: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
398: remit_msg1
399: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
400: remit_msg2
401: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
402: remit_msg3
403: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,
404: delv_chnl_code
405: IBY_DELIVERY_CHANNELS_VL.format_value%TYPE,

Line 403: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,

399: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
400: remit_msg2
401: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
402: remit_msg3
403: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,
404: delv_chnl_code
405: IBY_DELIVERY_CHANNELS_VL.format_value%TYPE,
406: pmt_reason
407: IBY_PAYMENT_REASONS_VL.format_value%TYPE,

Line 638: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

634: | NOTES:
635: |
636: *---------------------------------------------------------------------*/
637: PROCEDURE initDocumentData(
638: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
639: x_document_rec IN OUT NOCOPY documentRecType,
640: p_isOnline IN VARCHAR2
641: );
642:

Line 664: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,

660: | NOTES:
661: |
662: *---------------------------------------------------------------------*/
663: PROCEDURE initCharValData(
664: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
665: x_charval_rec IN OUT NOCOPY charValRecType
666: );
667:
668: /*--------------------------------------------------------------------

Line 771: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,

767: | NOTES:
768: |
769: *---------------------------------------------------------------------*/
770: PROCEDURE performOnlineValidations(
771: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
772: x_return_status IN OUT NOCOPY NUMBER
773: );
774:
775: /*--------------------------------------------------------------------

Line 1085: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

1081: |
1082: |
1083: *---------------------------------------------------------------------*/
1084: FUNCTION checkIfDocFailed(
1085: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1086: p_failedDocsTab IN docStatusTabType
1087: )
1088: RETURN BOOLEAN;
1089:

Line 1137: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

1133: |
1134: |
1135: *---------------------------------------------------------------------*/
1136: FUNCTION validateProfileFromProfDrivers(
1137: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1138: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1139: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1140: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1141: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

Line 1138: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

1134: |
1135: *---------------------------------------------------------------------*/
1136: FUNCTION validateProfileFromProfDrivers(
1137: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1138: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1139: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1140: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1141: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1142: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE

Line 1139: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

1135: *---------------------------------------------------------------------*/
1136: FUNCTION validateProfileFromProfDrivers(
1137: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1138: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1139: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1140: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1141: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1142: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1143: )

Line 1140: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

1136: FUNCTION validateProfileFromProfDrivers(
1137: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1138: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1139: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1140: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1141: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1142: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1143: )
1144: RETURN BOOLEAN;

Line 1141: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

1137: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1138: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1139: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1140: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1141: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1142: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1143: )
1144: RETURN BOOLEAN;
1145:

Line 1142: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE

1138: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1139: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1140: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1141: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1142: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1143: )
1144: RETURN BOOLEAN;
1145:
1146: /*--------------------------------------------------------------------

Line 1239: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

1235: | NOTES:
1236: |
1237: *---------------------------------------------------------------------*/
1238: FUNCTION checkProfileFormatCompat(
1239: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1240: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1241: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1242: p_payeeFormatTab IN payeeFormatTabType,
1243: p_profileFormatTab IN profileFormatTabType

Line 1240: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,

1236: |
1237: *---------------------------------------------------------------------*/
1238: FUNCTION checkProfileFormatCompat(
1239: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1240: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1241: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1242: p_payeeFormatTab IN payeeFormatTabType,
1243: p_profileFormatTab IN profileFormatTabType
1244: ) RETURN BOOLEAN;

Line 1241: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

1237: *---------------------------------------------------------------------*/
1238: FUNCTION checkProfileFormatCompat(
1239: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1240: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1241: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1242: p_payeeFormatTab IN payeeFormatTabType,
1243: p_profileFormatTab IN profileFormatTabType
1244: ) RETURN BOOLEAN;
1245: