[Home] [Help]
PACKAGE: APPS.IBY_VALIDATIONSETS_PUB
Source
1 PACKAGE IBY_VALIDATIONSETS_PUB AS
2 /*$Header: ibyvalls.pls 120.18.12010000.1 2008/07/28 05:43:19 appldev ship $*/
3
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,
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.
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,
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
39
40 int_bank_num CE_BANK_BRANCHES_V.bank_number%TYPE,
41 int_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE,
42 int_bank_name_alt CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
43 int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,
44 int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
45 int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
46
47 int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
48 int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,
49 int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
50 int_bank_acc_type CE_BANK_ACCOUNTS.bank_account_type%TYPE,
51 int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,
52 int_bank_assigned_id1 VARCHAR2(240),
53 int_bank_assigned_id2 VARCHAR2(240),
54 int_eft_user_number CE_BANK_ACCOUNTS.eft_user_num%TYPE,
55 int_bank_acc_chk_dgts CE_BANK_ACCOUNTS.check_digits%TYPE,
56 int_eft_req_identifier CE_BANK_ACCOUNTS.
57 eft_requester_identifier%TYPE,
58 int_bank_acc_short_name CE_BANK_ACCOUNTS.short_account_name%TYPE,
59 int_bank_acc_holder_name CE_BANK_ACCOUNTS.account_holder_name%TYPE,
60 int_bank_acc_holder_name_alt
61 CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
62
63 payer_le_name IBY_PP_FIRST_PARTY_V.party_legal_name%TYPE,
64 payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE,
65 payer_phone IBY_PP_FIRST_PARTY_V.party_phone%TYPE,
66
67 ext_bank_num IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
68 ext_bank_name IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
69
70 ext_bank_name_alt CE_BANKS_V.bank_name_alt%TYPE,
71
72 ext_bank_branch_num IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,
73 ext_bank_branch_name IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,
74
75 ext_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
76
77 ext_bank_country IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,
78
79 ext_bank_branch_addr1 CE_BANK_BRANCHES_V.address_line1%TYPE,
80
81 ext_bank_branch_country CE_BANK_BRANCHES_V.country%TYPE,
82
83 ext_bank_acc_num IBY_EXT_BANK_ACCOUNTS_V.
84 bank_account_number%TYPE,
85 ext_bank_acc_name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
86 ext_bank_acc_name_alt IBY_EXT_BANK_ACCOUNTS_V.
87 alternate_account_name%TYPE,
88 ext_bank_acc_type IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
89 ext_bank_acc_iban IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE, -- Payee IBAN
90 ext_bank_acc_chk_dgts IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
91 ext_bank_acc_short_name IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
92 ext_bank_acc_holder_name IBY_EXT_BANK_ACCOUNTS_V.
93 primary_acct_owner_name%TYPE,
94
95 ext_bank_acc_holder_name_alt
96 CE_BANK_ACCOUNTS_V.bank_account_name_alt%TYPE,
97 ext_eft_swift_code IBY_EXT_BANK_ACCOUNTS_INT_V.eft_swift_code%TYPE, -- Payee BIC (added by sodash)
98
99 payee_party_name HZ_PARTIES.party_name%TYPE,
100 payee_party_addr1 HZ_LOCATIONS.address1%TYPE,
101 payee_party_addr2 HZ_LOCATIONS.address2%TYPE,
102 payee_party_addr3 HZ_LOCATIONS.address3%TYPE,
103 payee_party_city HZ_LOCATIONS.city%TYPE,
104
105 /*
106 * Fix for bug 6713003:
107 *
108 * The payee address fields are picked up from three
109 * possible sources: HR_LOCATIONS, PER_ADDRESSES
110 * and HZ_LOCATIONS. Therefore, the field sizes
111 * should be the maximum of the corresponding column
112 * sizes from these three tables.
113 *
114 * Usually, HZ_LOCATIONS field sizes are sufficient.
115 * But for state, county and provice fields, HR_LOCATIONS /
116 * PER_ADDRESSES has larger field sizes.
117 *
118 * Therefore, for these three fields, we use HR_LOCATIONS
119 * for the field sizes.
120 */
121 payee_party_state HR_LOCATIONS.region_2%TYPE,
122 payee_party_province HR_LOCATIONS.region_1%TYPE,
123 payee_party_county HR_LOCATIONS.region_1%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 );
133
134 /*
135 * This record stores the minimum number of fields required
136 * to uniquely identify a doc for the calling app.
137 *
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,
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 );
156
157 TYPE paymentRecType IS RECORD (
158 pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE,
159 pmt_amount IBY_PAYMENTS_ALL.payment_amount%TYPE,
160 pmt_currency IBY_PAYMENTS_ALL.payment_currency_code%TYPE,
161 pmt_delivery_channel_code IBY_PAYMENTS_ALL.delivery_channel_code%TYPE,
162 pmt_payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE, -- Payer Country
163 pmt_detail IBY_PAYMENTS_ALL.payment_details%TYPE,
164 pmt_payment_reason_count NUMBER,
165 int_bank_account_iban IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE, -- Payer IBAN (added by sodash)
166 party_address_line1 IBY_PP_FIRST_PARTY_V.party_address_line1%TYPE, -- Payer Address Line1 (added by sodash)
167 party_address_city IBY_PP_FIRST_PARTY_V.party_address_city%TYPE, -- Payer City (added by sodash)
168 party_address_postal_code IBY_PP_FIRST_PARTY_V.party_address_postal_code%TYPE -- Payer Postal Code (added by sodash)
169 );
170
171 TYPE instructionRecType is RECORD (
172 ins_id IBY_PAY_INSTRUCTIONS_ALL.
173 payment_instruction_id%TYPE,
174 ins_amount NUMBER,
175 ins_document_count NUMBER
176 );
177
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.
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.
191 validation_code_package%TYPE,
192 val_code_entry_point IBY_VALIDATION_SETS_VL.
193 validation_code_entry_point%TYPE,
194 val_assign_id IBY_VAL_ASSIGNMENTS.
195 validation_assignment_id%TYPE,
196 val_assign_entity_type IBY_VAL_ASSIGNMENTS.
197 val_assignment_entity_type%TYPE,
198 val_set_name IBY_VALIDATION_SETS_VL.
199 validation_set_display_name%TYPE
200 );
201
202 --
203 -- Table of validation set records
204 --
205 TYPE valSetTabType IS TABLE OF valSetRecType
206 INDEX BY BINARY_INTEGER;
207
208 --
209 -- Document errors table
210 --
211 TYPE docErrorTabType IS TABLE OF IBY_TRANSACTION_ERRORS%ROWTYPE
212 INDEX BY BINARY_INTEGER;
213
214 --
215 -- Transaction error tokens table
216 --
217
218 TYPE trxnErrTokenTabType IS TABLE OF IBY_TRXN_ERROR_TOKENS%ROWTYPE
219 INDEX BY BINARY_INTEGER;
220
221 --
222 -- Record to hold document ids.
223 --
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.
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.
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.
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.
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.
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.
269 country_code%TYPE,
270 foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.
271 foreign_payment_use_flag%TYPE
272 );
273
274 --
275 -- The document id table
276 --
277 TYPE docPayTabType IS TABLE OF docPayRecType
278 INDEX BY BINARY_INTEGER;
279
280
281 --
282 -- Record to hold document status.
283 --
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.
293 ext_payee_id%TYPE,
294 doc_status IBY_DOCS_PAYABLE_ALL.
295 document_status%TYPE
296 );
297
298 --
299 -- The document status table
300 --
301 TYPE docStatusTabType IS TABLE OF docStatusRecType
302 INDEX BY BINARY_INTEGER;
303
304 --
305 -- System options record
306 --
307 TYPE sysOptionsRecType IS RECORD (
308 rej_level IBY_INTERNAL_PAYERS_ALL.
309 document_rejection_level_code%TYPE
310 );
311
312 --
313 -- System options table
314 --
315 TYPE sysOptionsTabType IS TABLE OF sysOptionsRecType
316 INDEX BY BINARY_INTEGER;
317
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 );
327
328 /*
329 * Table of rejected documents.
330 */
331 TYPE rejectedDocTabType IS TABLE OF rejectedDocRecType
332 INDEX BY BINARY_INTEGER;
333
334 /*
335 * Rejected payment id along with its status.
336 */
337 TYPE rejectedPmtRecType IS RECORD (
338 pmt_id IBY_PAYMENTS_ALL.
339 payment_id%TYPE,
340 pmt_status IBY_PAYMENTS_ALL.
341 payment_status%TYPE
342 );
343
344 /*
345 * Table of rejected payments.
346 */
347 TYPE rejectedPmtTabType IS TABLE OF rejectedPmtRecType
348 INDEX BY BINARY_INTEGER;
349
350 /*
351 * The record structure below is meant to pull up data fields for
352 * character validation. For character validation, all possible fields
353 * that could potentially be sent to the bank need to be picked up;
354 * this will include data related to the document, payer, payee,
355 * payer bank and payee bank (payments have not be created at this
356 * stage and so cannot be picked up).
357 *
358 * Notes:
359 * 1. Fields that are not likely to cause character validation errors
360 * have not be included viz., dates, amounts, flags, lookup codes etc.
361 * 2. If you feel some field is likely to cause char validation error,
362 * then include it to this list.
363 * 3. Document lines are ignored as they are usually not sent to the bank
364 */
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,
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,
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,
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,
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,
406 pmt_reason
407 IBY_PAYMENT_REASONS_VL.format_value%TYPE,
408 ca_doc_line_cd
409 IBY_DOCUMENT_LINES.calling_app_document_line_code%TYPE,
410 line_type
411 IBY_DOCUMENT_LINES.line_type%TYPE,
412 line_name
413 IBY_DOCUMENT_LINES.line_name%TYPE,
414 line_desc
415 IBY_DOCUMENT_LINES.description%TYPE,
416 line_uom
417 IBY_DOCUMENT_LINES.unit_of_measure%TYPE,
418 line_po_num
419 IBY_DOCUMENT_LINES.po_number%TYPE,
420
421 /* PAYER */
422 payer_number
423 IBY_PP_FIRST_PARTY_V.party_number%TYPE,
424 payer_name
425 IBY_PP_FIRST_PARTY_V.party_name%TYPE,
426 payer_legal_name
427 IBY_PP_FIRST_PARTY_V.party_legal_name%TYPE,
428 payer_tax_id
429 IBY_PP_FIRST_PARTY_V.party_tax_id%TYPE,
430 payer_add1
431 IBY_PP_FIRST_PARTY_V.party_address_line1%TYPE,
432 payer_add2
433 IBY_PP_FIRST_PARTY_V.party_address_line2%TYPE,
434 payer_add3
435 IBY_PP_FIRST_PARTY_V.party_address_line3%TYPE,
436 payer_city
437 IBY_PP_FIRST_PARTY_V.party_address_city%TYPE,
438 payer_county
439 IBY_PP_FIRST_PARTY_V.party_address_county%TYPE,
440 payer_state
441 IBY_PP_FIRST_PARTY_V.party_address_state%TYPE,
442 payer_country
443 IBY_PP_FIRST_PARTY_V.party_address_country%TYPE,
444 payer_postcode
445 IBY_PP_FIRST_PARTY_V.party_address_postal_code%TYPE,
446
447 /* PAYER BANK */
448 payer_bank_name
449 CE_BANK_BRANCHES_V.bank_name%TYPE,
450 payer_bank_number
451 CE_BANK_BRANCHES_V.bank_number%TYPE,
452 payer_bank_branch_num
453 CE_BANK_BRANCHES_V.branch_number%TYPE,
454 payer_bank_branch_name
455 CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
456 payer_bank_swift_code
457 CE_BANK_BRANCHES_V.eft_swift_code%TYPE,
458 payer_bank_add1
459 CE_BANK_BRANCHES_V.address_line1%TYPE,
460 payer_bank_add2
461 CE_BANK_BRANCHES_V.address_line2%TYPE,
462 payer_bank_add3
463 CE_BANK_BRANCHES_V.address_line3%TYPE,
464 payer_bank_city
465 CE_BANK_BRANCHES_V.city%TYPE,
466 payer_bank_county
467 CE_BANK_BRANCHES_V.province%TYPE,
468 payer_bank_state
469 CE_BANK_BRANCHES_V.state%TYPE,
470 payer_bank_country
471 CE_BANK_BRANCHES_V.country%TYPE,
472 payer_bank_postcode
473 CE_BANK_BRANCHES_V.zip%TYPE,
474 payer_bank_name_alt
475 CE_BANK_BRANCHES_V.bank_name_alt%TYPE,
476 payer_bank_branch_name_alt
477 CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
478
479 payer_bank_acct_name_alt
480 CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
481 payer_bank_acct_type
482 CE_BANK_ACCOUNTS.bank_account_type%TYPE,
483 payer_bank_assigned_id1
484 VARCHAR2(240),
485 payer_bank_assigned_id2
486 VARCHAR2(240),
487 payer_eft_user_number
488 CE_BANK_ACCOUNTS.eft_user_num%TYPE,
489 payer_eft_req_identifier
490 CE_BANK_ACCOUNTS.eft_requester_identifier%TYPE,
491 payer_bank_acct_short_name
492 CE_BANK_ACCOUNTS.short_account_name%TYPE,
493 payer_bank_acct_hold_name_alt
494 CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
495 payer_bank_acct_holder_name
496 CE_BANK_ACCOUNTS.account_holder_name%TYPE,
497 payer_bank_acct_num
498 CE_BANK_ACCOUNTS.bank_account_num%TYPE,
499 payer_bank_acct_name
500 CE_BANK_ACCOUNTS.bank_account_name%TYPE,
501 payer_bank_acct_iban_num
502 CE_BANK_ACCOUNTS.iban_number%TYPE,
503 payer_bank_acct_checkdigits
504 CE_BANK_ACCOUNTS.check_digits%TYPE,
505
506 /* PAYEE */
507 payee_number
508 HZ_PARTIES.party_number%TYPE,
509 payee_name
510 HZ_PARTIES.party_name%TYPE,
511 payee_tax_id
512 HZ_PARTIES.tax_reference%TYPE,
513 payee_add1
514 HZ_LOCATIONS.address1%TYPE,
515 payee_add2
516 HZ_LOCATIONS.address2%TYPE,
517 payee_add3
518 HZ_LOCATIONS.address3%TYPE,
519 payee_city
520 HZ_LOCATIONS.city%TYPE,
521 payee_county
522 HZ_LOCATIONS.county%TYPE,
523 payee_province
524 HZ_LOCATIONS.province%TYPE,
525 payee_state
526 HZ_LOCATIONS.state%TYPE,
527 payee_country
528 HZ_LOCATIONS.country%TYPE,
529 payee_postcode
530 HZ_LOCATIONS.postal_code%TYPE,
531
532 /* PAYEE BANK */
533 payee_bank_name
534 IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
535 payee_bank_number
536 IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
537 payee_bank_branch_num
538 IBY_EXT_BANK_ACCOUNTS_V.branch_number%TYPE,
539 payee_bank_branch_name
540 IBY_EXT_BANK_ACCOUNTS_V.bank_branch_name%TYPE,
541 payee_bank_acct_holder_name
542 IBY_EXT_BANK_ACCOUNTS_V.primary_acct_owner_name%TYPE,
543 payee_bank_acct_num
544 IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
545 payee_bank_acct_name
546 IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
547 payee_bank_acct_iban_num
548 IBY_EXT_BANK_ACCOUNTS_V.iban_number%TYPE,
549 payee_bank_swift_code
550 IBY_EXT_BANK_ACCOUNTS_V.eft_swift_code%TYPE,
551 payee_bank_acct_checkdigits
552 IBY_EXT_BANK_ACCOUNTS_V.check_digits%TYPE,
553 payee_bank_add1
554 VARCHAR2(240),
555 payee_bank_add2
556 VARCHAR2(240),
557 payee_bank_add3
558 VARCHAR2(240),
559 payee_bank_city
560 VARCHAR2(240),
561 payee_bank_county
562 VARCHAR2(240),
563 payee_bank_state
564 VARCHAR2(240),
565 payee_bank_country
566 VARCHAR2(240),
567 payee_bank_postcode
568 VARCHAR2(240),
569 payee_bank_name_alt
570 VARCHAR2(240),
571 payee_bank_branch_name_alt
572 VARCHAR2(240),
573 payee_bank_country_code
574 IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,
575 payee_bank_account_name_alt
576 IBY_EXT_BANK_ACCOUNTS_V.alternate_account_name%TYPE,
577 payee_bank_account_type
578 IBY_EXT_BANK_ACCOUNTS_V.bank_account_type%TYPE,
579 payee_bank_account_short_name
580 IBY_EXT_BANK_ACCOUNTS_V.short_acct_name%TYPE,
581 payee_bank_acct_hold_name_alt
582 VARCHAR2(240)
583 );
584
585 --
586 -- Record to hold default payment format for each payee.
587 --
588 TYPE payeeFormatRecType IS RECORD (
589 payee_id IBY_EXTERNAL_PAYEES_ALL.
590 ext_payee_id%TYPE,
591 payment_format_cd IBY_EXTERNAL_PAYEES_ALL.
592 payment_format_code%TYPE
593 );
594
595 --
596 -- The payee formats table
597 --
598 TYPE payeeFormatTabType IS TABLE OF payeeFormatRecType
599 INDEX BY BINARY_INTEGER;
600
601 --
602 -- Record to format linked to each profile.
603 --
604 TYPE profileFormatRecType IS RECORD (
605 profile_id IBY_PAYMENT_PROFILES.
606 payment_profile_id%TYPE,
607 payment_format_cd IBY_PAYMENT_PROFILES.
608 payment_format_code%TYPE
609 );
610
611 --
612 -- The profile formats table
613 --
614 TYPE profileFormatTabType IS TABLE OF profileFormatRecType
615 INDEX BY BINARY_INTEGER;
616
617
618 /*--------------------------------------------------------------------
619 | NAME:
620 | initDocumentData
621 |
622 | PURPOSE:
623 | Initializes the document record from Oracle Payment's tables.
624 |
625 | PARAMETERS:
626 | IN
627 |
628 |
629 | OUT
630 |
631 |
632 | RETURNS:
633 |
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
643 /*--------------------------------------------------------------------
644 | NAME:
645 | initCharValData
646 |
647 | PURPOSE:
648 | Initializes the character validation record with data from
649 | Oracle Payment's tables.
650 |
651 | PARAMETERS:
652 | IN
653 |
654 |
655 | OUT
656 |
657 |
658 | RETURNS:
659 |
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 /*--------------------------------------------------------------------
669 | NAME:
670 | initPaymentData
671 |
672 | PURPOSE:
673 | Initializes the document record from Oracle Payment's tables.
674 |
675 | PARAMETERS:
676 | IN
677 |
678 |
679 | OUT
680 |
681 |
682 | RETURNS:
683 |
684 | NOTES:
685 |
686 *---------------------------------------------------------------------*/
687 PROCEDURE initPaymentData(
688 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
689 x_payment_rec IN OUT NOCOPY paymentRecType
690 );
691
692 /*--------------------------------------------------------------------
693 | NAME:
694 | initInstructionData
695 |
696 | PURPOSE:
697 | Initializes the instruction record from Oracle Payment's tables.
698 |
699 | PARAMETERS:
700 | IN
701 |
702 |
703 | OUT
704 |
705 |
706 | RETURNS:
707 |
708 | NOTES:
709 |
710 *---------------------------------------------------------------------*/
711 PROCEDURE initInstructionData (
712 p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%type,
713 x_instruction_rec IN OUT NOCOPY instructionRecType
714 );
715
716 /*--------------------------------------------------------------------
717 | NAME:
718 | applyDocumentValidationSets
719 |
720 | PURPOSE:
721 | Picks up Validation Sets which can be applied and validates
722 | the documents in the payment request accordingly.
723 |
724 |
725 |
726 | PARAMETERS:
727 | IN
728 |
729 |
730 | OUT
731 |
732 |
733 | RETURNS:
734 |
735 | NOTES:
736 |
737 *---------------------------------------------------------------------*/
738
739 PROCEDURE applyDocumentValidationSets(
740 p_pay_service_request_id IN IBY_PAY_SERVICE_REQUESTS.
741 payment_service_request_id%TYPE,
742 p_doc_rejection_level IN IBY_INTERNAL_PAYERS_ALL.
743 document_rejection_level_code%TYPE,
744 p_is_singpay_flag IN BOOLEAN,
745 x_return_status IN OUT NOCOPY VARCHAR2
746 );
747
748 /*--------------------------------------------------------------------
749 | NAME:
750 | performOnlineValidations
751 |
752 | PURPOSE:
753 | Picks up validation sets which can be applied and validates
754 | the given document accordingly.
755 |
756 |
757 |
758 | PARAMETERS:
759 | IN
760 |
761 |
762 | OUT
763 |
764 |
765 | RETURNS:
766 |
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 /*--------------------------------------------------------------------
776 | NAME:
777 | insert_transaction_errors
778 |
779 | PURPOSE:
780 | Inserts the transaction errors into IBY_TRANSACTION_ERRORS
781 | or IBY_TRANSACTION_ERRORS_GT depending upon the online flag.
782 |
783 | PARAMETERS:
784 | IN
785 |
786 |
787 | OUT
788 |
789 |
790 | RETURNS:
791 |
792 | NOTES:
793 |
794 *---------------------------------------------------------------------*/
795 PROCEDURE insert_transaction_errors(
796 p_isOnlineVal IN VARCHAR2,
797 x_docErrorTab IN OUT NOCOPY docErrorTabType,
798 x_trxnErrTokenTab IN OUT NOCOPY trxnErrTokenTabType
799 );
800
801 PROCEDURE insert_transaction_errors(
802 p_isOnlineVal IN VARCHAR2,
803 x_docErrorTab IN OUT NOCOPY docErrorTabType
804 );
805
806 /*--------------------------------------------------------------------
807 | NAME:
808 | insertIntoErrorTable
809 |
810 | PURPOSE:
811 | Inserts the document validation error into PLSQL Table
812 |
813 | PARAMETERS:
814 | IN
815 |
816 |
817 | OUT
818 |
819 |
820 | RETURNS:
821 |
822 | NOTES:
823 |
824 *---------------------------------------------------------------------*/
825 PROCEDURE insertIntoErrorTable(
826 x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
827 x_docErrorTab IN OUT NOCOPY docErrorTabType,
828 x_trxnErrTokenTab IN OUT NOCOPY trxnErrTokenTabType
829 );
830
831 PROCEDURE insertIntoErrorTable(
832 x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
833 x_docErrorTab IN OUT NOCOPY docErrorTabType
834 );
835
836 /*--------------------------------------------------------------------
837 | NAME:
838 | performDBUpdates
839 |
840 | PURPOSE:
841 |
842 |
843 | PARAMETERS:
844 | IN
845 |
846 |
847 | OUT
848 |
849 |
850 | RETURNS:
851 |
852 | NOTES:
853 |
854 *---------------------------------------------------------------------*/
855 PROCEDURE performDBUpdates(
856 p_pay_service_request_id
857 IN IBY_PAY_SERVICE_REQUESTS.
858 payment_service_request_id%type,
859 p_allDocsTab IN docPayTabType,
860 x_errorDocsTab IN OUT NOCOPY docStatusTabType,
861 p_allDocsSuccessFlag IN BOOLEAN,
862 p_allDocsFailedFlag IN BOOLEAN,
863 p_rejectionLevel IN VARCHAR2,
864 x_txnErrorsTab IN OUT NOCOPY docErrorTabType,
865 x_errTokenTab IN OUT NOCOPY trxnErrTokenTabType,
866 x_return_status IN OUT NOCOPY VARCHAR2
867 );
868
869 /*--------------------------------------------------------------------
870 | NAME:
871 | failRelatedDocs
872 |
873 | PURPOSE:
874 |
875 |
876 | PARAMETERS:
877 | IN
878 |
879 |
880 | OUT
881 |
882 |
883 | RETURNS:
884 |
885 | NOTES:
886 |
887 *---------------------------------------------------------------------*/
888 PROCEDURE failRelatedDocs(
889 p_allDocsTab IN docPayTabType,
890 x_failedDocsTab IN OUT NOCOPY docStatusTabType,
891 x_docErrorTab IN OUT NOCOPY docErrorTabType,
892 x_errTokenTab IN OUT NOCOPY trxnErrTokenTabType
893 );
894
895 /*--------------------------------------------------------------------
896 | NAME:
897 | failAllDocsForPayee
898 |
899 | PURPOSE:
900 |
901 |
902 | PARAMETERS:
903 | IN
904 |
905 |
906 | OUT
907 |
908 |
909 | RETURNS:
910 |
911 | NOTES:
912 |
913 *---------------------------------------------------------------------*/
914 PROCEDURE failAllDocsForPayee(
915 p_allDocsTab IN docPayTabType,
916 x_failedDocsTab IN OUT NOCOPY docStatusTabType,
917 x_docErrorTab IN OUT NOCOPY docErrorTabType,
918 x_errTokenTab IN OUT NOCOPY trxnErrTokenTabType
919 );
920
921 /*--------------------------------------------------------------------
922 | NAME:
923 | failAllDocsForRequest
924 |
925 | PURPOSE:
926 |
927 |
928 | PARAMETERS:
929 | IN
930 |
931 |
932 | OUT
933 |
934 |
935 | RETURNS:
936 |
937 | NOTES:
938 |
939 *---------------------------------------------------------------------*/
940 PROCEDURE failAllDocsForRequest(
941 p_allDocsTab IN docPayTabType,
942 x_failedDocsTab IN OUT NOCOPY docStatusTabType,
943 x_docErrorTab IN OUT NOCOPY docErrorTabType,
944 x_errTokenTab IN OUT NOCOPY trxnErrTokenTabType
945 );
946
947 /*--------------------------------------------------------------------
948 | NAME:
949 | evaluateCondition
950 |
951 | PURPOSE:
952 | Function to evaluate a specific condition for a
953 | particular field on the basis of a token. This will
954 | minimize code in the Validation entry point procedures.
955 |
956 | The possible token values are:
957 | EQUALSTO, NOTEQUALSTO, NOTNULL, LENGTH, MAXLENGTH,
958 | MINLENGTH, MIN, MAX, MASK, LIKE, SET, CUSTOM, ASSIGN,
959 | TYPE.
960 |
961 | For token 'CUSTOM', this makes a dynamic PLSQL call to
962 | a procedure specified in the parameter 'p_value'.
963 |
964 | PARAMETERS:
965 | IN
966 |
967 |
968 | OUT
969 |
970 |
971 | RETURNS:
972 |
973 | NOTES:
974 |
975 *---------------------------------------------------------------------*/
976 PROCEDURE evaluateCondition(
977 p_fieldName IN VARCHAR2,
978 p_fieldValue IN VARCHAR2,
979 p_token IN VARCHAR2,
980 p_char_value IN VARCHAR2,
981 p_num_value IN NUMBER,
982 x_valResult OUT NOCOPY BOOLEAN,
983 x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE
984 );
985
986 PROCEDURE getParamValue (
987 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.
988 validation_assignment_id%TYPE,
989 p_validation_set_code IN IBY_VALIDATION_SETS_VL.
990 validation_set_code%TYPE,
991 p_validation_param_code IN IBY_VALIDATION_PARAMS_B.
992 validation_parameter_code%TYPE,
993 p_value OUT NOCOPY VARCHAR2);
994
995 PROCEDURE getDocumentFieldValue (
996 p_field_name IN VARCHAR2,
997 p_document_rec IN documentRecType,
998 p_field_value OUT NOCOPY VARCHAR2);
999
1000 PROCEDURE getPaymentFieldValue (
1001 p_field_name IN VARCHAR2,
1002 p_payment_rec IN paymentRecType,
1003 p_field_value OUT NOCOPY VARCHAR2);
1004
1005 PROCEDURE getInstructionFieldValue (
1006 p_field_name IN VARCHAR2,
1007 p_instruction_rec IN instructionRecType,
1008 p_field_value OUT NOCOPY VARCHAR2);
1009
1010 /*--------------------------------------------------------------------
1011 | NAME:
1012 | getRequestAttributes
1013 |
1014 | PURPOSE:
1015 |
1016 |
1017 |
1018 | PARAMETERS:
1019 | IN
1020 |
1021 | OUT
1022 |
1023 |
1024 | RETURNS:
1025 |
1026 | NOTES:
1027 |
1028 *---------------------------------------------------------------------*/
1029 PROCEDURE getRequestAttributes(
1030 p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
1031 x_caPayReqCd IN OUT NOCOPY
1032 IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
1033 x_caId IN OUT NOCOPY
1034 IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE
1035 );
1036
1037 /*--------------------------------------------------------------------
1038 | NAME:
1039 | raiseBizEvents
1040 |
1041 | PURPOSE:
1042 |
1043 |
1044 |
1045 | PARAMETERS:
1046 | IN
1047 |
1048 | OUT
1049 |
1050 |
1051 | RETURNS:
1052 |
1053 | NOTES:
1054 |
1055 *---------------------------------------------------------------------*/
1056 PROCEDURE raiseBizEvents(
1057 p_payreq_id IN VARCHAR2,
1058 p_cap_payreq_id IN VARCHAR2,
1059 p_cap_id IN NUMBER,
1060 x_allDocsSuccessFlag IN OUT NOCOPY BOOLEAN,
1061 p_rejectionLevel IN VARCHAR2
1062 );
1063
1064 /*--------------------------------------------------------------------
1065 | NAME:
1066 | checkIfDocFailed
1067 |
1068 | PURPOSE:
1069 |
1070 |
1071 |
1072 | PARAMETERS:
1073 | IN
1074 |
1075 | OUT
1076 |
1077 |
1078 | RETURNS:
1079 |
1080 | NOTES:
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
1090 /*--------------------------------------------------------------------
1091 | NAME:
1092 | checkIfAllDocsFailed
1093 |
1094 | PURPOSE:
1095 |
1096 |
1097 |
1098 | PARAMETERS:
1099 | IN
1100 |
1101 | OUT
1102 |
1103 |
1104 | RETURNS:
1105 |
1106 | NOTES:
1107 |
1108 |
1109 *---------------------------------------------------------------------*/
1110 FUNCTION checkIfAllDocsFailed(
1111 p_allDocsTab IN docPayTabType,
1112 p_failedDocsTab IN docStatusTabType
1113 )
1114 RETURN BOOLEAN;
1115
1116 /*--------------------------------------------------------------------
1117 | NAME:
1118 | validateProfileFromProfDrivers
1119 |
1120 | PURPOSE:
1121 |
1122 |
1123 |
1124 | PARAMETERS:
1125 | IN
1126 |
1127 | OUT
1128 |
1129 |
1130 | RETURNS:
1131 |
1132 | NOTES:
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,
1142 p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
1143 )
1144 RETURN BOOLEAN;
1145
1146 /*--------------------------------------------------------------------
1147 | NAME:
1148 | getXMLClob
1149 |
1150 | PURPOSE:
1151 |
1152 |
1153 |
1154 | PARAMETERS:
1155 | IN
1156 |
1157 | OUT
1158 |
1159 |
1160 | RETURNS:
1161 |
1162 | NOTES:
1163 |
1164 |
1165 *---------------------------------------------------------------------*/
1166 FUNCTION getXMLClob(
1167 p_payreq_id IN VARCHAR2
1168 )
1169 RETURN CLOB;
1170
1171 /*--------------------------------------------------------------------
1172 | NAME:
1173 | retrieveErrorMSG
1174 |
1175 | PURPOSE:
1176 | Function to retrieve an error message according to an object
1177 | code and an error message number provided.
1178 |
1179 | PARAMETERS:
1180 | IN
1181 |
1182 |
1183 | OUT
1184 |
1185 |
1186 | RETURNS:
1187 |
1188 | NOTES:
1189 |
1190 *---------------------------------------------------------------------*/
1191 PROCEDURE retrieveErrorMSG (
1192 p_object_code IN fnd_lookups.lookup_code%TYPE,
1193 p_msg_name IN fnd_new_messages.message_name%TYPE,
1194 p_message IN OUT NOCOPY fnd_new_messages.message_text%TYPE
1195 );
1196
1197 /*--------------------------------------------------------------------
1198 | NAME:
1199 | getDocRejLevelSysOption
1200 |
1201 | PURPOSE:
1202 |
1203 |
1204 | PARAMETERS:
1205 | IN
1206 |
1207 |
1208 | OUT
1209 |
1210 |
1211 | RETURNS:
1212 |
1213 | NOTES:
1214 |
1215 *---------------------------------------------------------------------*/
1216 FUNCTION getDocRejLevelSysOption
1217 RETURN VARCHAR2;
1218
1219 /*--------------------------------------------------------------------
1220 | NAME:
1221 | checkProfileFormatCompat
1222 |
1223 | PURPOSE:
1224 |
1225 |
1226 | PARAMETERS:
1227 | IN
1228 |
1229 |
1230 | OUT
1231 |
1232 |
1233 | RETURNS:
1234 |
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
1244 ) RETURN BOOLEAN;
1245
1246 /*--------------------------------------------------------------------
1247 | NAME:
1248 | getRejectedDocs
1249 |
1250 | PURPOSE:
1251 | Performs a database query to get all failed documents for
1252 | the given payment request. These failed documents are put
1253 | into data structure and returned to the caller.
1254 |
1255 |
1256 | PARAMETERS:
1257 | IN
1258 |
1259 | OUT
1260 |
1261 |
1262 | RETURNS:
1263 |
1264 | NOTES:
1265 |
1266 |
1267 *---------------------------------------------------------------------*/
1268 PROCEDURE getRejectedDocs(
1269 p_payreq_id IN VARCHAR2,
1270 x_docIDTab IN OUT NOCOPY IBY_DISBURSE_UI_API_PUB_PKG.docPayIDTab,
1271 x_docStatusTab IN OUT NOCOPY IBY_DISBURSE_UI_API_PUB_PKG.docPayStatusTab
1272 );
1273
1274 END IBY_VALIDATIONSETS_PUB;