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: delivery_chn_format_val IBY_DELIVERY_CHANNELS_B.format_value%TYPE,
31: unique_remit_id_code IBY_DOCS_PAYABLE_ALL.

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: 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,

Line 31: unique_remit_id_code IBY_DOCS_PAYABLE_ALL.

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,

Line 33: PAYMENT_REASON_COMMENTS IBY_DOCS_PAYABLE_ALL.PAYMENT_REASON_COMMENTS%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,

Line 34: SETTLEMENT_PRIORITY IBY_DOCS_PAYABLE_ALL.SETTLEMENT_PRIORITY%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,

Line 35: REMITTANCE_MESSAGE1 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE1%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,

Line 36: REMITTANCE_MESSAGE2 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE2%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:

Line 37: REMITTANCE_MESSAGE3 IBY_DOCS_PAYABLE_ALL.REMITTANCE_MESSAGE3%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:
41:

Line 38: URI_CHECK_DIGIT IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%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:
42: int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,

Line 39: EXTERNAL_BANK_ACCOUNT_ID IBY_DOCS_PAYABLE_ALL.EXTERNAL_BANK_ACCOUNT_ID%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,

Line 135: bank_charge_bearer IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%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:

Line 136: payment_reason_code IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,

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*/

Line 137: payment_method_cd IBY_DOCS_PAYABLE_ALL.payment_method_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*/
141: payee_party_site_name HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE

Line 138: payment_format_cd IBY_DOCS_PAYABLE_ALL.payment_format_code%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*/

Line 153: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

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,

Line 154: calling_app_doc_id1 IBY_DOCS_PAYABLE_ALL.

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.

Line 156: calling_app_doc_id2 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.

Line 158: calling_app_doc_id3 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.

Line 160: calling_app_doc_id4 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,

Line 162: calling_app_doc_id5 IBY_DOCS_PAYABLE_ALL.

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: );

Line 164: pay_proc_trxn_type_cd IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%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: );
167:
168: TYPE paymentRecType IS RECORD (

Line 165: document_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE

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,

Line 196: doc_id IBY_DOCS_PAYABLE_ALL.

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.

Line 198: pmt_grp_num 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.

Line 200: payee_id IBY_DOCS_PAYABLE_ALL.

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.

Line 255: doc_id IBY_DOCS_PAYABLE_ALL.

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.

Line 257: ca_doc_id1 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.

Line 259: ca_doc_id2 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.

Line 261: ca_doc_id3 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.

Line 263: ca_doc_id4 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.

Line 265: ca_doc_id5 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.

Line 267: ca_doc_ref_num 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.

Line 269: ca_id 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.

Line 271: pp_tt_cd 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.

Line 273: pmt_grp_num 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.

Line 275: payee_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.

Line 277: profile_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.

Line 279: org_id 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.

Line 281: org_type 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.

Line 283: pmt_method_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.

Line 285: pmt_format_cd 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.

Line 287: pmt_curr_code 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.

Line 289: int_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.

Line 291: ext_bank_acct_id 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.

Line 293: pmt_date 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.

Line 295: payee_party_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.

Line 297: supplier_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.

Line 299: party_site_id 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.

Line 301: payment_function 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: );

Line 303: affects_rejection_level IBY_DOCS_PAYABLE_ALL.

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: --

Line 321: doc_id IBY_DOCS_PAYABLE_ALL.

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.

Line 323: pmt_grp_num 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.

Line 325: payee_id 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.

Line 327: doc_status 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: );

Line 329: ca_doc_ref_num IBY_DOCS_PAYABLE_ALL.

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: --

Line 357: doc_id IBY_DOCS_PAYABLE_ALL.

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: );

Line 359: doc_status IBY_DOCS_PAYABLE_ALL.

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: /*

Line 404: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

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,

Line 406: IBY_DOCS_PAYABLE_ALL.calling_app_id%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,

Line 408: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%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,

Line 410: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%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,

Line 412: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%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,

Line 414: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%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,

Line 416: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%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,

Line 418: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%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,

Line 420: IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%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,

Line 422: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%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,

Line 424: IBY_DOCS_PAYABLE_ALL.uri_check_digit%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,

Line 426: IBY_DOCS_PAYABLE_ALL.po_number%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,

Line 428: IBY_DOCS_PAYABLE_ALL.document_description%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,

Line 430: IBY_DOCS_PAYABLE_ALL.bank_assigned_ref_code%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,

Line 432: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%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,

Line 434: IBY_DOCS_PAYABLE_ALL.remittance_message1%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,

Line 436: IBY_DOCS_PAYABLE_ALL.remittance_message2%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,

Line 438: IBY_DOCS_PAYABLE_ALL.remittance_message3%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,

Line 677: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%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:

Line 703: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,

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: /*--------------------------------------------------------------------

Line 810: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,

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: /*--------------------------------------------------------------------

Line 1151: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

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:

Line 1203: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

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,

Line 1204: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%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

Line 1205: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%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: )

Line 1206: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

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;

Line 1207: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

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:

Line 1208: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_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:
1212: /*--------------------------------------------------------------------

Line 1305: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

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:

Line 1306: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,

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:

Line 1307: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE

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: