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,
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.
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.
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.
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.
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.
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.
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.
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.
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,
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: delivery_chn_format_val IBY_DELIVERY_CHANNELS_B.format_value%TYPE,
31: unique_remit_id_code IBY_DOCS_PAYABLE_ALL.
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: delivery_chn_format_val IBY_DELIVERY_CHANNELS_B.format_value%TYPE,
31: unique_remit_id_code IBY_DOCS_PAYABLE_ALL.
32: unique_remittance_identifier%TYPE,
33: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%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: delivery_chn_format_val IBY_DELIVERY_CHANNELS_B.format_value%TYPE,
31: unique_remit_id_code IBY_DOCS_PAYABLE_ALL.
32: unique_remittance_identifier%TYPE,
33: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%TYPE,
34: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,
35: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,
29: delivery_channel_code IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
30: delivery_chn_format_val IBY_DELIVERY_CHANNELS_B.format_value%TYPE,
31: unique_remit_id_code IBY_DOCS_PAYABLE_ALL.
32: unique_remittance_identifier%TYPE,
33: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%TYPE,
34: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,
35: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,
36: REMITTANCE_MESSAGE2 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE2%TYPE,
37: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%TYPE,
30: delivery_chn_format_val IBY_DELIVERY_CHANNELS_B.format_value%TYPE,
31: unique_remit_id_code IBY_DOCS_PAYABLE_ALL.
32: unique_remittance_identifier%TYPE,
33: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%TYPE,
34: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,
35: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,
36: REMITTANCE_MESSAGE2 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE2%TYPE,
37: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%TYPE,
38: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE,
31: unique_remit_id_code IBY_DOCS_PAYABLE_ALL.
32: unique_remittance_identifier%TYPE,
33: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%TYPE,
34: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,
35: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,
36: REMITTANCE_MESSAGE2 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE2%TYPE,
37: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%TYPE,
38: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE,
39: EXTERNAL_BANK_ACCOUNT_ID IBY_DOCS_PAYABLE_ALL.EXTERNAL_BANK_ACCOUNT_ID%TYPE,
32: unique_remittance_identifier%TYPE,
33: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%TYPE,
34: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,
35: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,
36: REMITTANCE_MESSAGE2 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE2%TYPE,
37: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%TYPE,
38: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE,
39: EXTERNAL_BANK_ACCOUNT_ID IBY_DOCS_PAYABLE_ALL.EXTERNAL_BANK_ACCOUNT_ID%TYPE,
40:
33: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%TYPE,
34: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,
35: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,
36: REMITTANCE_MESSAGE2 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE2%TYPE,
37: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%TYPE,
38: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE,
39: EXTERNAL_BANK_ACCOUNT_ID IBY_DOCS_PAYABLE_ALL.EXTERNAL_BANK_ACCOUNT_ID%TYPE,
40:
41:
34: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%TYPE,
35: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,
36: REMITTANCE_MESSAGE2 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE2%TYPE,
37: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%TYPE,
38: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE,
39: EXTERNAL_BANK_ACCOUNT_ID IBY_DOCS_PAYABLE_ALL.EXTERNAL_BANK_ACCOUNT_ID%TYPE,
40:
41:
42: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,
35: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%TYPE,
36: REMITTANCE_MESSAGE2 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE2%TYPE,
37: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%TYPE,
38: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE,
39: EXTERNAL_BANK_ACCOUNT_ID IBY_DOCS_PAYABLE_ALL.EXTERNAL_BANK_ACCOUNT_ID%TYPE,
40:
41:
42: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,
43: int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,
131:
132: payee_party_postal HZ_LOCATIONS.postal_code%TYPE,
133: payee_party_country HZ_LOCATIONS.country%TYPE,
134:
135: bank_charge_bearer IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
136: payment_reason_code IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
137: payment_method_cd IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
138: payment_format_cd IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,
139:
132: payee_party_postal HZ_LOCATIONS.postal_code%TYPE,
133: payee_party_country HZ_LOCATIONS.country%TYPE,
134:
135: bank_charge_bearer IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
136: payment_reason_code IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
137: payment_method_cd IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
138: payment_format_cd IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,
139:
140: /*Start of Bug 9704929*/
133: payee_party_country HZ_LOCATIONS.country%TYPE,
134:
135: bank_charge_bearer IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
136: payment_reason_code IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
137: payment_method_cd IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
138: payment_format_cd IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,
139:
140: /*Start of Bug 9704929*/
141: payee_party_site_name HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE
134:
135: bank_charge_bearer IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
136: payment_reason_code IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
137: payment_method_cd IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
138: payment_format_cd IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,
139:
140: /*Start of Bug 9704929*/
141: payee_party_site_name HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE
142: /*Start of Bug 9704929*/
149: * It will be used in exception situations to inform the calling
150: * app that a particular doc is in error.
151: */
152: TYPE basicDocRecType IS RECORD (
153: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
154: calling_app_doc_id1 IBY_DOCS_PAYABLE_ALL.
155: calling_app_doc_unique_ref1%TYPE,
156: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.
157: calling_app_doc_unique_ref2%TYPE,
150: * app that a particular doc is in error.
151: */
152: TYPE basicDocRecType IS RECORD (
153: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
154: calling_app_doc_id1 IBY_DOCS_PAYABLE_ALL.
155: calling_app_doc_unique_ref1%TYPE,
156: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.
157: calling_app_doc_unique_ref2%TYPE,
158: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.
152: TYPE basicDocRecType IS RECORD (
153: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
154: calling_app_doc_id1 IBY_DOCS_PAYABLE_ALL.
155: calling_app_doc_unique_ref1%TYPE,
156: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.
157: calling_app_doc_unique_ref2%TYPE,
158: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.
159: calling_app_doc_unique_ref3%TYPE,
160: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.
154: calling_app_doc_id1 IBY_DOCS_PAYABLE_ALL.
155: calling_app_doc_unique_ref1%TYPE,
156: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.
157: calling_app_doc_unique_ref2%TYPE,
158: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.
159: calling_app_doc_unique_ref3%TYPE,
160: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.
161: calling_app_doc_unique_ref4%TYPE,
162: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.
156: calling_app_doc_id2 IBY_DOCS_PAYABLE_ALL.
157: calling_app_doc_unique_ref2%TYPE,
158: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.
159: calling_app_doc_unique_ref3%TYPE,
160: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.
161: calling_app_doc_unique_ref4%TYPE,
162: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.
163: calling_app_doc_unique_ref5%TYPE,
164: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
158: calling_app_doc_id3 IBY_DOCS_PAYABLE_ALL.
159: calling_app_doc_unique_ref3%TYPE,
160: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.
161: calling_app_doc_unique_ref4%TYPE,
162: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.
163: calling_app_doc_unique_ref5%TYPE,
164: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
165: document_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE
166: );
160: calling_app_doc_id4 IBY_DOCS_PAYABLE_ALL.
161: calling_app_doc_unique_ref4%TYPE,
162: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.
163: calling_app_doc_unique_ref5%TYPE,
164: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
165: document_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE
166: );
167:
168: TYPE paymentRecType IS RECORD (
161: calling_app_doc_unique_ref4%TYPE,
162: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.
163: calling_app_doc_unique_ref5%TYPE,
164: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
165: document_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE
166: );
167:
168: TYPE paymentRecType IS RECORD (
169: pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE,
192: --
193: -- A record to store the details of the validation set
194: --
195: TYPE valSetRecType IS RECORD (
196: doc_id IBY_DOCS_PAYABLE_ALL.
197: document_payable_id%TYPE,
198: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
199: payment_grouping_number%TYPE,
200: payee_id IBY_DOCS_PAYABLE_ALL.
194: --
195: TYPE valSetRecType IS RECORD (
196: doc_id IBY_DOCS_PAYABLE_ALL.
197: document_payable_id%TYPE,
198: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
199: payment_grouping_number%TYPE,
200: payee_id IBY_DOCS_PAYABLE_ALL.
201: ext_payee_id%TYPE,
202: val_set_code IBY_VALIDATION_SETS_VL.
196: doc_id IBY_DOCS_PAYABLE_ALL.
197: document_payable_id%TYPE,
198: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
199: payment_grouping_number%TYPE,
200: payee_id IBY_DOCS_PAYABLE_ALL.
201: ext_payee_id%TYPE,
202: val_set_code IBY_VALIDATION_SETS_VL.
203: validation_set_code%TYPE,
204: val_code_pkg IBY_VALIDATION_SETS_VL.
251: -- This record will hold a document payable id and it's
252: -- corresponding original document id.
253: --
254: TYPE docPayRecType IS RECORD (
255: doc_id IBY_DOCS_PAYABLE_ALL.
256: document_payable_id%TYPE,
257: ca_doc_id1 IBY_DOCS_PAYABLE_ALL.
258: calling_app_doc_unique_ref1%TYPE,
259: ca_doc_id2 IBY_DOCS_PAYABLE_ALL.
253: --
254: TYPE docPayRecType IS RECORD (
255: doc_id IBY_DOCS_PAYABLE_ALL.
256: document_payable_id%TYPE,
257: ca_doc_id1 IBY_DOCS_PAYABLE_ALL.
258: calling_app_doc_unique_ref1%TYPE,
259: ca_doc_id2 IBY_DOCS_PAYABLE_ALL.
260: calling_app_doc_unique_ref2%TYPE,
261: ca_doc_id3 IBY_DOCS_PAYABLE_ALL.
255: doc_id IBY_DOCS_PAYABLE_ALL.
256: document_payable_id%TYPE,
257: ca_doc_id1 IBY_DOCS_PAYABLE_ALL.
258: calling_app_doc_unique_ref1%TYPE,
259: ca_doc_id2 IBY_DOCS_PAYABLE_ALL.
260: calling_app_doc_unique_ref2%TYPE,
261: ca_doc_id3 IBY_DOCS_PAYABLE_ALL.
262: calling_app_doc_unique_ref3%TYPE,
263: ca_doc_id4 IBY_DOCS_PAYABLE_ALL.
257: ca_doc_id1 IBY_DOCS_PAYABLE_ALL.
258: calling_app_doc_unique_ref1%TYPE,
259: ca_doc_id2 IBY_DOCS_PAYABLE_ALL.
260: calling_app_doc_unique_ref2%TYPE,
261: ca_doc_id3 IBY_DOCS_PAYABLE_ALL.
262: calling_app_doc_unique_ref3%TYPE,
263: ca_doc_id4 IBY_DOCS_PAYABLE_ALL.
264: calling_app_doc_unique_ref4%TYPE,
265: ca_doc_id5 IBY_DOCS_PAYABLE_ALL.
259: ca_doc_id2 IBY_DOCS_PAYABLE_ALL.
260: calling_app_doc_unique_ref2%TYPE,
261: ca_doc_id3 IBY_DOCS_PAYABLE_ALL.
262: calling_app_doc_unique_ref3%TYPE,
263: ca_doc_id4 IBY_DOCS_PAYABLE_ALL.
264: calling_app_doc_unique_ref4%TYPE,
265: ca_doc_id5 IBY_DOCS_PAYABLE_ALL.
266: calling_app_doc_unique_ref5%TYPE,
267: ca_doc_ref_num IBY_DOCS_PAYABLE_ALL.
261: ca_doc_id3 IBY_DOCS_PAYABLE_ALL.
262: calling_app_doc_unique_ref3%TYPE,
263: ca_doc_id4 IBY_DOCS_PAYABLE_ALL.
264: calling_app_doc_unique_ref4%TYPE,
265: ca_doc_id5 IBY_DOCS_PAYABLE_ALL.
266: calling_app_doc_unique_ref5%TYPE,
267: ca_doc_ref_num IBY_DOCS_PAYABLE_ALL.
268: calling_app_doc_ref_number%TYPE,
269: ca_id IBY_DOCS_PAYABLE_ALL.
263: ca_doc_id4 IBY_DOCS_PAYABLE_ALL.
264: calling_app_doc_unique_ref4%TYPE,
265: ca_doc_id5 IBY_DOCS_PAYABLE_ALL.
266: calling_app_doc_unique_ref5%TYPE,
267: ca_doc_ref_num IBY_DOCS_PAYABLE_ALL.
268: calling_app_doc_ref_number%TYPE,
269: ca_id IBY_DOCS_PAYABLE_ALL.
270: calling_app_id%TYPE,
271: pp_tt_cd IBY_DOCS_PAYABLE_ALL.
265: ca_doc_id5 IBY_DOCS_PAYABLE_ALL.
266: calling_app_doc_unique_ref5%TYPE,
267: ca_doc_ref_num IBY_DOCS_PAYABLE_ALL.
268: calling_app_doc_ref_number%TYPE,
269: ca_id IBY_DOCS_PAYABLE_ALL.
270: calling_app_id%TYPE,
271: pp_tt_cd IBY_DOCS_PAYABLE_ALL.
272: pay_proc_trxn_type_code%TYPE,
273: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
267: ca_doc_ref_num IBY_DOCS_PAYABLE_ALL.
268: calling_app_doc_ref_number%TYPE,
269: ca_id IBY_DOCS_PAYABLE_ALL.
270: calling_app_id%TYPE,
271: pp_tt_cd IBY_DOCS_PAYABLE_ALL.
272: pay_proc_trxn_type_code%TYPE,
273: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
274: payment_grouping_number%TYPE,
275: payee_id IBY_DOCS_PAYABLE_ALL.
269: ca_id IBY_DOCS_PAYABLE_ALL.
270: calling_app_id%TYPE,
271: pp_tt_cd IBY_DOCS_PAYABLE_ALL.
272: pay_proc_trxn_type_code%TYPE,
273: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
274: payment_grouping_number%TYPE,
275: payee_id IBY_DOCS_PAYABLE_ALL.
276: ext_payee_id%TYPE,
277: profile_id IBY_DOCS_PAYABLE_ALL.
271: pp_tt_cd IBY_DOCS_PAYABLE_ALL.
272: pay_proc_trxn_type_code%TYPE,
273: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
274: payment_grouping_number%TYPE,
275: payee_id IBY_DOCS_PAYABLE_ALL.
276: ext_payee_id%TYPE,
277: profile_id IBY_DOCS_PAYABLE_ALL.
278: payment_profile_id%TYPE,
279: org_id IBY_DOCS_PAYABLE_ALL.
273: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
274: payment_grouping_number%TYPE,
275: payee_id IBY_DOCS_PAYABLE_ALL.
276: ext_payee_id%TYPE,
277: profile_id IBY_DOCS_PAYABLE_ALL.
278: payment_profile_id%TYPE,
279: org_id IBY_DOCS_PAYABLE_ALL.
280: org_id%TYPE,
281: org_type IBY_DOCS_PAYABLE_ALL.
275: payee_id IBY_DOCS_PAYABLE_ALL.
276: ext_payee_id%TYPE,
277: profile_id IBY_DOCS_PAYABLE_ALL.
278: payment_profile_id%TYPE,
279: org_id IBY_DOCS_PAYABLE_ALL.
280: org_id%TYPE,
281: org_type IBY_DOCS_PAYABLE_ALL.
282: org_type%TYPE,
283: pmt_method_cd IBY_DOCS_PAYABLE_ALL.
277: profile_id IBY_DOCS_PAYABLE_ALL.
278: payment_profile_id%TYPE,
279: org_id IBY_DOCS_PAYABLE_ALL.
280: org_id%TYPE,
281: org_type IBY_DOCS_PAYABLE_ALL.
282: org_type%TYPE,
283: pmt_method_cd IBY_DOCS_PAYABLE_ALL.
284: payment_method_code%TYPE,
285: pmt_format_cd IBY_DOCS_PAYABLE_ALL.
279: org_id IBY_DOCS_PAYABLE_ALL.
280: org_id%TYPE,
281: org_type IBY_DOCS_PAYABLE_ALL.
282: org_type%TYPE,
283: pmt_method_cd IBY_DOCS_PAYABLE_ALL.
284: payment_method_code%TYPE,
285: pmt_format_cd IBY_DOCS_PAYABLE_ALL.
286: payment_format_code%TYPE,
287: pmt_curr_code IBY_DOCS_PAYABLE_ALL.
281: org_type IBY_DOCS_PAYABLE_ALL.
282: org_type%TYPE,
283: pmt_method_cd IBY_DOCS_PAYABLE_ALL.
284: payment_method_code%TYPE,
285: pmt_format_cd IBY_DOCS_PAYABLE_ALL.
286: payment_format_code%TYPE,
287: pmt_curr_code IBY_DOCS_PAYABLE_ALL.
288: payment_currency_code%TYPE,
289: int_bank_acct_id IBY_DOCS_PAYABLE_ALL.
283: pmt_method_cd IBY_DOCS_PAYABLE_ALL.
284: payment_method_code%TYPE,
285: pmt_format_cd IBY_DOCS_PAYABLE_ALL.
286: payment_format_code%TYPE,
287: pmt_curr_code IBY_DOCS_PAYABLE_ALL.
288: payment_currency_code%TYPE,
289: int_bank_acct_id IBY_DOCS_PAYABLE_ALL.
290: internal_bank_account_id%TYPE,
291: ext_bank_acct_id IBY_DOCS_PAYABLE_ALL.
285: pmt_format_cd IBY_DOCS_PAYABLE_ALL.
286: payment_format_code%TYPE,
287: pmt_curr_code IBY_DOCS_PAYABLE_ALL.
288: payment_currency_code%TYPE,
289: int_bank_acct_id IBY_DOCS_PAYABLE_ALL.
290: internal_bank_account_id%TYPE,
291: ext_bank_acct_id IBY_DOCS_PAYABLE_ALL.
292: external_bank_account_id%TYPE,
293: pmt_date IBY_DOCS_PAYABLE_ALL.
287: pmt_curr_code IBY_DOCS_PAYABLE_ALL.
288: payment_currency_code%TYPE,
289: int_bank_acct_id IBY_DOCS_PAYABLE_ALL.
290: internal_bank_account_id%TYPE,
291: ext_bank_acct_id IBY_DOCS_PAYABLE_ALL.
292: external_bank_account_id%TYPE,
293: pmt_date IBY_DOCS_PAYABLE_ALL.
294: payment_date%TYPE,
295: payee_party_id IBY_DOCS_PAYABLE_ALL.
289: int_bank_acct_id IBY_DOCS_PAYABLE_ALL.
290: internal_bank_account_id%TYPE,
291: ext_bank_acct_id IBY_DOCS_PAYABLE_ALL.
292: external_bank_account_id%TYPE,
293: pmt_date IBY_DOCS_PAYABLE_ALL.
294: payment_date%TYPE,
295: payee_party_id IBY_DOCS_PAYABLE_ALL.
296: payee_party_id%TYPE,
297: supplier_site_id IBY_DOCS_PAYABLE_ALL.
291: ext_bank_acct_id IBY_DOCS_PAYABLE_ALL.
292: external_bank_account_id%TYPE,
293: pmt_date IBY_DOCS_PAYABLE_ALL.
294: payment_date%TYPE,
295: payee_party_id IBY_DOCS_PAYABLE_ALL.
296: payee_party_id%TYPE,
297: supplier_site_id IBY_DOCS_PAYABLE_ALL.
298: supplier_site_id%TYPE,
299: party_site_id IBY_DOCS_PAYABLE_ALL.
293: pmt_date IBY_DOCS_PAYABLE_ALL.
294: payment_date%TYPE,
295: payee_party_id IBY_DOCS_PAYABLE_ALL.
296: payee_party_id%TYPE,
297: supplier_site_id IBY_DOCS_PAYABLE_ALL.
298: supplier_site_id%TYPE,
299: party_site_id IBY_DOCS_PAYABLE_ALL.
300: party_site_id%TYPE,
301: payment_function IBY_DOCS_PAYABLE_ALL.
295: payee_party_id IBY_DOCS_PAYABLE_ALL.
296: payee_party_id%TYPE,
297: supplier_site_id IBY_DOCS_PAYABLE_ALL.
298: supplier_site_id%TYPE,
299: party_site_id IBY_DOCS_PAYABLE_ALL.
300: party_site_id%TYPE,
301: payment_function IBY_DOCS_PAYABLE_ALL.
302: payment_function%TYPE,
303: affects_rejection_level IBY_DOCS_PAYABLE_ALL.
297: supplier_site_id IBY_DOCS_PAYABLE_ALL.
298: supplier_site_id%TYPE,
299: party_site_id IBY_DOCS_PAYABLE_ALL.
300: party_site_id%TYPE,
301: payment_function IBY_DOCS_PAYABLE_ALL.
302: payment_function%TYPE,
303: affects_rejection_level IBY_DOCS_PAYABLE_ALL.
304: affects_rejection_level%TYPE -- AWT Enh 16296267
305: );
299: party_site_id IBY_DOCS_PAYABLE_ALL.
300: party_site_id%TYPE,
301: payment_function IBY_DOCS_PAYABLE_ALL.
302: payment_function%TYPE,
303: affects_rejection_level IBY_DOCS_PAYABLE_ALL.
304: affects_rejection_level%TYPE -- AWT Enh 16296267
305: );
306:
307: --
317: -- This record will hold a document payable id, its status
318: -- and its corresponding original document id.
319: --
320: TYPE docStatusRecType IS RECORD (
321: doc_id IBY_DOCS_PAYABLE_ALL.
322: document_payable_id%TYPE,
323: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
324: payment_grouping_number%TYPE,
325: payee_id IBY_DOCS_PAYABLE_ALL.
319: --
320: TYPE docStatusRecType IS RECORD (
321: doc_id IBY_DOCS_PAYABLE_ALL.
322: document_payable_id%TYPE,
323: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
324: payment_grouping_number%TYPE,
325: payee_id IBY_DOCS_PAYABLE_ALL.
326: ext_payee_id%TYPE,
327: doc_status IBY_DOCS_PAYABLE_ALL.
321: doc_id IBY_DOCS_PAYABLE_ALL.
322: document_payable_id%TYPE,
323: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
324: payment_grouping_number%TYPE,
325: payee_id IBY_DOCS_PAYABLE_ALL.
326: ext_payee_id%TYPE,
327: doc_status IBY_DOCS_PAYABLE_ALL.
328: document_status%TYPE,
329: ca_doc_ref_num IBY_DOCS_PAYABLE_ALL.
323: pmt_grp_num IBY_DOCS_PAYABLE_ALL.
324: payment_grouping_number%TYPE,
325: payee_id IBY_DOCS_PAYABLE_ALL.
326: ext_payee_id%TYPE,
327: doc_status IBY_DOCS_PAYABLE_ALL.
328: document_status%TYPE,
329: ca_doc_ref_num IBY_DOCS_PAYABLE_ALL.
330: calling_app_doc_ref_number%TYPE
331: );
325: payee_id IBY_DOCS_PAYABLE_ALL.
326: ext_payee_id%TYPE,
327: doc_status IBY_DOCS_PAYABLE_ALL.
328: document_status%TYPE,
329: ca_doc_ref_num IBY_DOCS_PAYABLE_ALL.
330: calling_app_doc_ref_number%TYPE
331: );
332:
333: --
353: /*
354: * Rejected document id along with its status.
355: */
356: TYPE rejectedDocRecType IS RECORD (
357: doc_id IBY_DOCS_PAYABLE_ALL.
358: document_payable_id%TYPE,
359: doc_status IBY_DOCS_PAYABLE_ALL.
360: document_status%TYPE
361: );
355: */
356: TYPE rejectedDocRecType IS RECORD (
357: doc_id IBY_DOCS_PAYABLE_ALL.
358: document_payable_id%TYPE,
359: doc_status IBY_DOCS_PAYABLE_ALL.
360: document_status%TYPE
361: );
362:
363: /*
400: TYPE charValRecType IS RECORD (
401:
402: /* DOCUMENT */
403: document_id
404: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
405: ca_id
406: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
407: calling_app_doc_id1
408: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
402: /* DOCUMENT */
403: document_id
404: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
405: ca_id
406: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
407: calling_app_doc_id1
408: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
409: calling_app_doc_id2
410: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
404: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
405: ca_id
406: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
407: calling_app_doc_id1
408: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
409: calling_app_doc_id2
410: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
411: calling_app_doc_id3
412: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
406: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
407: calling_app_doc_id1
408: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
409: calling_app_doc_id2
410: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
411: calling_app_doc_id3
412: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
413: calling_app_doc_id4
414: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
408: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
409: calling_app_doc_id2
410: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
411: calling_app_doc_id3
412: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
413: calling_app_doc_id4
414: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
415: calling_app_doc_id5
416: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
410: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
411: calling_app_doc_id3
412: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
413: calling_app_doc_id4
414: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
415: calling_app_doc_id5
416: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
417: pay_proc_trxn_type_cd
418: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
412: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
413: calling_app_doc_id4
414: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
415: calling_app_doc_id5
416: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
417: pay_proc_trxn_type_cd
418: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
419: ca_doc_ref_num
420: IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE,
414: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
415: calling_app_doc_id5
416: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
417: pay_proc_trxn_type_cd
418: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
419: ca_doc_ref_num
420: IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE,
421: uri
422: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
416: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
417: pay_proc_trxn_type_cd
418: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
419: ca_doc_ref_num
420: IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE,
421: uri
422: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
423: uri_checkdigit
424: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
418: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
419: ca_doc_ref_num
420: IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE,
421: uri
422: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
423: uri_checkdigit
424: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
425: po_number
426: IBY_DOCS_PAYABLE_ALL.po_number%TYPE,
420: IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE,
421: uri
422: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
423: uri_checkdigit
424: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
425: po_number
426: IBY_DOCS_PAYABLE_ALL.po_number%TYPE,
427: doc_desc
428: IBY_DOCS_PAYABLE_ALL.document_description%TYPE,
422: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
423: uri_checkdigit
424: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
425: po_number
426: IBY_DOCS_PAYABLE_ALL.po_number%TYPE,
427: doc_desc
428: IBY_DOCS_PAYABLE_ALL.document_description%TYPE,
429: bank_ref
430: IBY_DOCS_PAYABLE_ALL.bank_assigned_ref_code%TYPE,
424: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
425: po_number
426: IBY_DOCS_PAYABLE_ALL.po_number%TYPE,
427: doc_desc
428: IBY_DOCS_PAYABLE_ALL.document_description%TYPE,
429: bank_ref
430: IBY_DOCS_PAYABLE_ALL.bank_assigned_ref_code%TYPE,
431: pmt_reason_comments
432: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
426: IBY_DOCS_PAYABLE_ALL.po_number%TYPE,
427: doc_desc
428: IBY_DOCS_PAYABLE_ALL.document_description%TYPE,
429: bank_ref
430: IBY_DOCS_PAYABLE_ALL.bank_assigned_ref_code%TYPE,
431: pmt_reason_comments
432: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
433: remit_msg1
434: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
428: IBY_DOCS_PAYABLE_ALL.document_description%TYPE,
429: bank_ref
430: IBY_DOCS_PAYABLE_ALL.bank_assigned_ref_code%TYPE,
431: pmt_reason_comments
432: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
433: remit_msg1
434: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
435: remit_msg2
436: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
430: IBY_DOCS_PAYABLE_ALL.bank_assigned_ref_code%TYPE,
431: pmt_reason_comments
432: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
433: remit_msg1
434: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
435: remit_msg2
436: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
437: remit_msg3
438: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,
432: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
433: remit_msg1
434: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
435: remit_msg2
436: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
437: remit_msg3
438: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,
439: delv_chnl_code
440: IBY_DELIVERY_CHANNELS_VL.format_value%TYPE,
434: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
435: remit_msg2
436: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
437: remit_msg3
438: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,
439: delv_chnl_code
440: IBY_DELIVERY_CHANNELS_VL.format_value%TYPE,
441: pmt_reason
442: IBY_PAYMENT_REASONS_VL.format_value%TYPE,
673: | NOTES:
674: |
675: *---------------------------------------------------------------------*/
676: PROCEDURE initDocumentData(
677: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
678: x_document_rec IN OUT NOCOPY documentRecType,
679: p_isOnline IN VARCHAR2
680: );
681:
699: | NOTES:
700: |
701: *---------------------------------------------------------------------*/
702: PROCEDURE initCharValData(
703: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
704: x_charval_rec IN OUT NOCOPY charValRecType
705: );
706:
707: /*--------------------------------------------------------------------
806: | NOTES:
807: |
808: *---------------------------------------------------------------------*/
809: PROCEDURE performOnlineValidations(
810: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
811: x_return_status IN OUT NOCOPY NUMBER
812: );
813:
814: /*--------------------------------------------------------------------
1147: |
1148: |
1149: *---------------------------------------------------------------------*/
1150: FUNCTION checkIfDocFailed(
1151: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1152: p_failedDocsTab IN docStatusTabType
1153: )
1154: RETURN BOOLEAN;
1155:
1199: |
1200: |
1201: *---------------------------------------------------------------------*/
1202: FUNCTION validateProfileFromProfDrivers(
1203: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1204: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1205: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1206: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1207: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1200: |
1201: *---------------------------------------------------------------------*/
1202: FUNCTION validateProfileFromProfDrivers(
1203: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1204: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1205: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1206: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1207: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1208: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1201: *---------------------------------------------------------------------*/
1202: FUNCTION validateProfileFromProfDrivers(
1203: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1204: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1205: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1206: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1207: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1208: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1209: )
1202: FUNCTION validateProfileFromProfDrivers(
1203: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1204: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1205: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1206: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1207: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1208: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1209: )
1210: RETURN BOOLEAN;
1203: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1204: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1205: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1206: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1207: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1208: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1209: )
1210: RETURN BOOLEAN;
1211:
1204: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1205: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1206: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1207: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1208: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1209: )
1210: RETURN BOOLEAN;
1211:
1212: /*--------------------------------------------------------------------
1301: | NOTES:
1302: |
1303: *---------------------------------------------------------------------*/
1304: FUNCTION checkProfileFormatCompat(
1305: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1306: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1307: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE
1308: ) RETURN BOOLEAN;
1309:
1302: |
1303: *---------------------------------------------------------------------*/
1304: FUNCTION checkProfileFormatCompat(
1305: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1306: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1307: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE
1308: ) RETURN BOOLEAN;
1309:
1310:
1303: *---------------------------------------------------------------------*/
1304: FUNCTION checkProfileFormatCompat(
1305: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1306: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1307: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE
1308: ) RETURN BOOLEAN;
1309:
1310:
1311: