[Home] [Help]
PACKAGE: APPS.IBY_PAYGROUP_PUB
Source
1 PACKAGE iby_paygroup_pub AUTHID CURRENT_USER AS
2 /*$Header: ibypaygs.pls 120.49.12020000.2 2013/02/25 10:36:11 kchavali ship $*/
3
4 --
5 -- This record corresponds to a row in the IBY_PAYMENTS_ALL table.
6 -- A PLSQL table of these records are created after applying
7 -- grouping rules and this table is used in bulk inserting
8 -- these payments into the IBY_PAYMENTS_ALL table
9 --
10 -- The record docsInPaymentRecType holds the documents
11 -- corresponding to this payment.
12 --
13 --
14 -- This PLSQL table corresponds to IBY_PAYMENTS_ALL and it
15 -- will be used in bulk updating the IBY_PAYMENTS_ALL table.
16 --
17 --TYPE paymentTabType IS TABLE OF paymentRecType
18 -- INDEX BY BINARY_INTEGER;
19 TYPE paymentTabType IS TABLE OF IBY_PAYMENTS_ALL%ROWTYPE
20 INDEX BY BINARY_INTEGER;
21
22 --
23 -- This PLSQL record of tables corresponds to IBY_PAYMENTS_ALL and it
24 -- will be used in bulk updating the IBY_PAYMENTS_ALL table.
25 --
26 TYPE t_payment_id IS TABLE OF
27 IBY_PAYMENTS_ALL.payment_id%TYPE
28 INDEX BY BINARY_INTEGER;
29 TYPE t_payment_method_code IS TABLE OF
30 IBY_PAYMENTS_ALL.payment_method_code%TYPE
31 INDEX BY BINARY_INTEGER;
32 TYPE t_payment_service_request_id IS TABLE OF
33 IBY_PAYMENTS_ALL.payment_service_request_id%TYPE
34 INDEX BY BINARY_INTEGER;
35 TYPE t_process_type IS TABLE OF
36 IBY_PAYMENTS_ALL.process_type%TYPE
37 INDEX BY BINARY_INTEGER;
38 TYPE t_payment_status IS TABLE OF
39 IBY_PAYMENTS_ALL.payment_status%TYPE
40 INDEX BY BINARY_INTEGER;
41 TYPE t_payments_complete_flag IS TABLE OF
42 IBY_PAYMENTS_ALL.payments_complete_flag%TYPE
43 INDEX BY BINARY_INTEGER;
44 TYPE t_payment_function IS TABLE OF
45 IBY_PAYMENTS_ALL.payment_function%TYPE
46 INDEX BY BINARY_INTEGER;
47 TYPE t_payment_amount IS TABLE OF
48 IBY_PAYMENTS_ALL.payment_amount%TYPE
49 INDEX BY BINARY_INTEGER;
50 TYPE t_payment_currency_code IS TABLE OF
51 IBY_PAYMENTS_ALL.payment_currency_code%TYPE
52 INDEX BY BINARY_INTEGER;
53 TYPE t_bill_payable_flag IS TABLE OF
54 IBY_PAYMENTS_ALL.bill_payable_flag%TYPE
55 INDEX BY BINARY_INTEGER;
56 TYPE t_exclusive_payment_flag IS TABLE OF
57 IBY_PAYMENTS_ALL.exclusive_payment_flag%TYPE
58 INDEX BY BINARY_INTEGER;
59 TYPE t_sep_remit_advice_req_flag IS TABLE OF
60 IBY_PAYMENTS_ALL.separate_remit_advice_req_flag%TYPE
61 INDEX BY BINARY_INTEGER;
62 TYPE t_internal_bank_account_id IS TABLE OF
63 IBY_PAYMENTS_ALL.internal_bank_account_id%TYPE
64 INDEX BY BINARY_INTEGER;
65 TYPE t_org_id IS TABLE OF
66 IBY_PAYMENTS_ALL.org_id%TYPE
67 INDEX BY BINARY_INTEGER;
68 TYPE t_org_type IS TABLE OF
69 IBY_PAYMENTS_ALL.org_type%TYPE
70 INDEX BY BINARY_INTEGER;
71 TYPE t_legal_entity_id IS TABLE OF
72 IBY_PAYMENTS_ALL.legal_entity_id%TYPE
73 INDEX BY BINARY_INTEGER;
74 TYPE t_declare_payment_flag IS TABLE OF
75 IBY_PAYMENTS_ALL.declare_payment_flag%TYPE
76 INDEX BY BINARY_INTEGER;
77 TYPE t_delivery_channel_code IS TABLE OF
78 IBY_PAYMENTS_ALL.delivery_channel_code%TYPE
79 INDEX BY BINARY_INTEGER;
80 TYPE t_ext_payee_id IS TABLE OF
81 IBY_PAYMENTS_ALL.ext_payee_id%TYPE
82 INDEX BY BINARY_INTEGER;
83 TYPE t_payment_instruction_id IS TABLE OF
84 IBY_PAYMENTS_ALL.payment_instruction_id%TYPE
85 INDEX BY BINARY_INTEGER;
86 TYPE t_payment_profile_id IS TABLE OF
87 IBY_PAYMENTS_ALL.payment_profile_id%TYPE
88 INDEX BY BINARY_INTEGER;
89 TYPE t_pregrouped_payment_flag IS TABLE OF
90 IBY_PAYMENTS_ALL.pregrouped_payment_flag%TYPE
91 INDEX BY BINARY_INTEGER;
92 TYPE t_stop_confirmed_flag IS TABLE OF
93 IBY_PAYMENTS_ALL.stop_confirmed_flag%TYPE
94 INDEX BY BINARY_INTEGER;
95 TYPE t_stop_released_flag IS TABLE OF
96 IBY_PAYMENTS_ALL.stop_released_flag%TYPE
97 INDEX BY BINARY_INTEGER;
98 TYPE t_stop_request_placed_flag IS TABLE OF
99 IBY_PAYMENTS_ALL.stop_request_placed_flag%TYPE
100 INDEX BY BINARY_INTEGER;
101 TYPE t_created_by IS TABLE OF
102 IBY_PAYMENTS_ALL.created_by%TYPE
103 INDEX BY BINARY_INTEGER;
104 TYPE t_creation_date IS TABLE OF
105 IBY_PAYMENTS_ALL.creation_date%TYPE
106 INDEX BY BINARY_INTEGER;
107 TYPE t_last_updated_by IS TABLE OF
108 IBY_PAYMENTS_ALL.last_updated_by%TYPE
109 INDEX BY BINARY_INTEGER;
110 TYPE t_last_update_login IS TABLE OF
111 IBY_PAYMENTS_ALL.last_update_login%TYPE
112 INDEX BY BINARY_INTEGER;
113 TYPE t_last_update_date IS TABLE OF
114 IBY_PAYMENTS_ALL.last_update_date%TYPE
115 INDEX BY BINARY_INTEGER;
116 TYPE t_object_version_number IS TABLE OF
117 IBY_PAYMENTS_ALL.object_version_number%TYPE
118 INDEX BY BINARY_INTEGER;
119 TYPE t_payee_party_id IS TABLE OF
120 IBY_PAYMENTS_ALL.payee_party_id%TYPE
121 INDEX BY BINARY_INTEGER;
122 TYPE t_party_site_id IS TABLE OF
123 IBY_PAYMENTS_ALL.party_site_id%TYPE
124 INDEX BY BINARY_INTEGER;
125 TYPE t_supplier_site_id IS TABLE OF
126 IBY_PAYMENTS_ALL.supplier_site_id%TYPE
127 INDEX BY BINARY_INTEGER;
128 TYPE t_payment_reason_code IS TABLE OF
129 IBY_PAYMENTS_ALL.payment_reason_code%TYPE
130 INDEX BY BINARY_INTEGER;
131 TYPE t_payment_reason_comments IS TABLE OF
132 IBY_PAYMENTS_ALL.payment_reason_comments%TYPE
133 INDEX BY BINARY_INTEGER;
134 TYPE t_payment_date IS TABLE OF
135 IBY_PAYMENTS_ALL.payment_date%TYPE
136 INDEX BY BINARY_INTEGER;
137 TYPE t_anticipated_value_date IS TABLE OF
138 IBY_PAYMENTS_ALL.anticipated_value_date%TYPE
139 INDEX BY BINARY_INTEGER;
140 TYPE t_declaration_amount IS TABLE OF
141 IBY_PAYMENTS_ALL.declaration_amount%TYPE
142 INDEX BY BINARY_INTEGER;
143 TYPE t_declaration_currency_code IS TABLE OF
144 IBY_PAYMENTS_ALL.declaration_currency_code%TYPE
145 INDEX BY BINARY_INTEGER;
146 TYPE t_discount_amount_taken IS TABLE OF
147 IBY_PAYMENTS_ALL.discount_amount_taken%TYPE
148 INDEX BY BINARY_INTEGER;
149 TYPE t_payment_details IS TABLE OF
150 IBY_PAYMENTS_ALL.payment_details%TYPE
151 INDEX BY BINARY_INTEGER;
152 TYPE t_bank_charge_bearer IS TABLE OF
153 IBY_PAYMENTS_ALL.bank_charge_bearer%TYPE
154 INDEX BY BINARY_INTEGER;
155 TYPE t_bank_charge_amount IS TABLE OF
156 IBY_PAYMENTS_ALL.bank_charge_amount%TYPE
157 INDEX BY BINARY_INTEGER;
158 TYPE t_settlement_priority IS TABLE OF
159 IBY_PAYMENTS_ALL.settlement_priority%TYPE
160 INDEX BY BINARY_INTEGER;
161 TYPE t_remittance_message1 IS TABLE OF
162 IBY_PAYMENTS_ALL.remittance_message1%TYPE
163 INDEX BY BINARY_INTEGER;
164 TYPE t_remittance_message2 IS TABLE OF
165 IBY_PAYMENTS_ALL.remittance_message2%TYPE
166 INDEX BY BINARY_INTEGER;
167 TYPE t_remittance_message3 IS TABLE OF
168 IBY_PAYMENTS_ALL.remittance_message3%TYPE
169 INDEX BY BINARY_INTEGER;
170 TYPE t_payment_reference_number IS TABLE OF
171 IBY_PAYMENTS_ALL.payment_reference_number%TYPE
172 INDEX BY BINARY_INTEGER;
173 TYPE t_paper_document_number IS TABLE OF
174 IBY_PAYMENTS_ALL.paper_document_number%TYPE
175 INDEX BY BINARY_INTEGER;
176 TYPE t_bank_assigned_ref_code IS TABLE OF
177 IBY_PAYMENTS_ALL.bank_assigned_ref_code%TYPE
178 INDEX BY BINARY_INTEGER;
179 TYPE t_external_bank_account_id IS TABLE OF
180 IBY_PAYMENTS_ALL.external_bank_account_id%TYPE
181 INDEX BY BINARY_INTEGER;
182 TYPE t_unique_remittance_identifier IS TABLE OF
183 IBY_PAYMENTS_ALL.unique_remittance_identifier%TYPE
184 INDEX BY BINARY_INTEGER;
185 TYPE t_uri_check_digit IS TABLE OF
186 IBY_PAYMENTS_ALL.uri_check_digit%TYPE
187 INDEX BY BINARY_INTEGER;
188 TYPE t_bank_instruction1_code IS TABLE OF
189 IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE
190 INDEX BY BINARY_INTEGER;
191 TYPE t_bank_instruction2_code IS TABLE OF
192 IBY_PAYMENTS_ALL.bank_instruction2_code%TYPE
193 INDEX BY BINARY_INTEGER;
194 TYPE t_bank_instruction_details IS TABLE OF
195 IBY_PAYMENTS_ALL.bank_instruction_details%TYPE
196 INDEX BY BINARY_INTEGER;
197 TYPE t_payment_text_message1 IS TABLE OF
198 IBY_PAYMENTS_ALL.payment_text_message1%TYPE
199 INDEX BY BINARY_INTEGER;
200 TYPE t_payment_text_message2 IS TABLE OF
201 IBY_PAYMENTS_ALL.payment_text_message2%TYPE
202 INDEX BY BINARY_INTEGER;
203 TYPE t_payment_text_message3 IS TABLE OF
204 IBY_PAYMENTS_ALL.payment_text_message3%TYPE
205 INDEX BY BINARY_INTEGER;
206 TYPE t_maturity_date IS TABLE OF
207 IBY_PAYMENTS_ALL.maturity_date%TYPE
208 INDEX BY BINARY_INTEGER;
209 TYPE t_payment_due_date IS TABLE OF
210 IBY_PAYMENTS_ALL.payment_due_date%TYPE
211 INDEX BY BINARY_INTEGER;
212 TYPE t_document_category_code IS TABLE OF
213 IBY_PAYMENTS_ALL.document_category_code%TYPE
214 INDEX BY BINARY_INTEGER;
215 TYPE t_document_sequence_id IS TABLE OF
216 IBY_PAYMENTS_ALL.document_sequence_id%TYPE
217 INDEX BY BINARY_INTEGER;
218 TYPE t_document_sequence_value IS TABLE OF
219 IBY_PAYMENTS_ALL.document_sequence_value%TYPE
220 INDEX BY BINARY_INTEGER;
221 TYPE t_beneficiary_party IS TABLE OF
222 IBY_PAYMENTS_ALL.beneficiary_party%TYPE
223 INDEX BY BINARY_INTEGER;
224 TYPE t_stop_confirmed_by IS TABLE OF
225 IBY_PAYMENTS_ALL.stop_confirmed_by%TYPE
226 INDEX BY BINARY_INTEGER;
227 TYPE t_stop_confirm_date IS TABLE OF
228 IBY_PAYMENTS_ALL.stop_confirm_date%TYPE
229 INDEX BY BINARY_INTEGER;
230 TYPE t_stop_confirm_reason IS TABLE OF
231 IBY_PAYMENTS_ALL.stop_confirm_reason%TYPE
232 INDEX BY BINARY_INTEGER;
233 TYPE t_stop_confirm_reference IS TABLE OF
234 IBY_PAYMENTS_ALL.stop_confirm_reference%TYPE
235 INDEX BY BINARY_INTEGER;
236 TYPE t_stop_released_by IS TABLE OF
237 IBY_PAYMENTS_ALL.stop_released_by%TYPE
238 INDEX BY BINARY_INTEGER;
239 TYPE t_stop_release_date IS TABLE OF
240 IBY_PAYMENTS_ALL.stop_release_date%TYPE
241 INDEX BY BINARY_INTEGER;
242 TYPE t_stop_release_reason IS TABLE OF
243 IBY_PAYMENTS_ALL.stop_release_reason%TYPE
244 INDEX BY BINARY_INTEGER;
245 TYPE t_stop_release_reference IS TABLE OF
246 IBY_PAYMENTS_ALL.stop_release_reference%TYPE
247 INDEX BY BINARY_INTEGER;
248 TYPE t_stop_request_date IS TABLE OF
249 IBY_PAYMENTS_ALL.stop_request_date%TYPE
250 INDEX BY BINARY_INTEGER;
251 TYPE t_stop_request_placed_by IS TABLE OF
252 IBY_PAYMENTS_ALL.stop_request_placed_by%TYPE
253 INDEX BY BINARY_INTEGER;
254 TYPE t_stop_request_reason IS TABLE OF
255 IBY_PAYMENTS_ALL.stop_request_reason%TYPE
256 INDEX BY BINARY_INTEGER;
257 TYPE t_stop_request_reference IS TABLE OF
258 IBY_PAYMENTS_ALL.stop_request_reference%TYPE
259 INDEX BY BINARY_INTEGER;
260 TYPE t_voided_by IS TABLE OF
261 IBY_PAYMENTS_ALL.voided_by%TYPE
262 INDEX BY BINARY_INTEGER;
263 TYPE t_void_date IS TABLE OF
264 IBY_PAYMENTS_ALL.void_date%TYPE
265 INDEX BY BINARY_INTEGER;
266 TYPE t_void_reason IS TABLE OF
267 IBY_PAYMENTS_ALL.void_reason%TYPE
268 INDEX BY BINARY_INTEGER;
269 TYPE t_remit_to_location_id IS TABLE OF
270 IBY_PAYMENTS_ALL.remit_to_location_id%TYPE
271 INDEX BY BINARY_INTEGER;
272 TYPE t_completed_pmts_group_id IS TABLE OF
273 IBY_PAYMENTS_ALL.completed_pmts_group_id%TYPE
274 INDEX BY BINARY_INTEGER;
275 TYPE t_attribute_category IS TABLE OF
276 IBY_PAYMENTS_ALL.attribute_category%TYPE
277 INDEX BY BINARY_INTEGER;
278 TYPE t_attribute1 IS TABLE OF
279 IBY_PAYMENTS_ALL.attribute1%TYPE
280 INDEX BY BINARY_INTEGER;
281 TYPE t_attribute2 IS TABLE OF
282 IBY_PAYMENTS_ALL.attribute2%TYPE
283 INDEX BY BINARY_INTEGER;
284 TYPE t_attribute3 IS TABLE OF
285 IBY_PAYMENTS_ALL.attribute3%TYPE
286 INDEX BY BINARY_INTEGER;
287 TYPE t_attribute4 IS TABLE OF
288 IBY_PAYMENTS_ALL.attribute4%TYPE
289 INDEX BY BINARY_INTEGER;
290 TYPE t_attribute5 IS TABLE OF
291 IBY_PAYMENTS_ALL.attribute5%TYPE
292 INDEX BY BINARY_INTEGER;
293 TYPE t_attribute6 IS TABLE OF
294 IBY_PAYMENTS_ALL.attribute6%TYPE
295 INDEX BY BINARY_INTEGER;
296 TYPE t_attribute7 IS TABLE OF
297 IBY_PAYMENTS_ALL.attribute7%TYPE
298 INDEX BY BINARY_INTEGER;
299 TYPE t_attribute8 IS TABLE OF
300 IBY_PAYMENTS_ALL.attribute8%TYPE
301 INDEX BY BINARY_INTEGER;
302 TYPE t_attribute9 IS TABLE OF
303 IBY_PAYMENTS_ALL.attribute9%TYPE
304 INDEX BY BINARY_INTEGER;
305 TYPE t_attribute10 IS TABLE OF
306 IBY_PAYMENTS_ALL.attribute10%TYPE
307 INDEX BY BINARY_INTEGER;
308 TYPE t_attribute11 IS TABLE OF
309 IBY_PAYMENTS_ALL.attribute11%TYPE
310 INDEX BY BINARY_INTEGER;
311 TYPE t_attribute12 IS TABLE OF
312 IBY_PAYMENTS_ALL.attribute12%TYPE
313 INDEX BY BINARY_INTEGER;
314 TYPE t_attribute13 IS TABLE OF
315 IBY_PAYMENTS_ALL.attribute13%TYPE
316 INDEX BY BINARY_INTEGER;
317 TYPE t_attribute14 IS TABLE OF
318 IBY_PAYMENTS_ALL.attribute14%TYPE
319 INDEX BY BINARY_INTEGER;
320 TYPE t_attribute15 IS TABLE OF
321 IBY_PAYMENTS_ALL.attribute15%TYPE
322 INDEX BY BINARY_INTEGER;
323 TYPE t_ext_branch_number IS TABLE OF
324 IBY_PAYMENTS_ALL.ext_branch_number%TYPE
325 INDEX BY BINARY_INTEGER;
326 TYPE t_ext_bank_number IS TABLE OF
327 IBY_PAYMENTS_ALL.ext_bank_number%TYPE
328 INDEX BY BINARY_INTEGER;
329 TYPE t_ext_bank_account_name IS TABLE OF
330 IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE
331 INDEX BY BINARY_INTEGER;
332 TYPE t_ext_bank_account_number IS TABLE OF
333 IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE
334 INDEX BY BINARY_INTEGER;
335 TYPE t_ext_bank_account_type IS TABLE OF
336 IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE
337 INDEX BY BINARY_INTEGER;
338 TYPE t_ext_bank_account_iban_number IS TABLE OF
339 IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE
340 INDEX BY BINARY_INTEGER;
341 TYPE t_payee_name IS TABLE OF
342 IBY_PAYMENTS_ALL.payee_name%TYPE
343 INDEX BY BINARY_INTEGER;
344 TYPE t_payee_address1 IS TABLE OF
345 IBY_PAYMENTS_ALL.payee_address1%TYPE
346 INDEX BY BINARY_INTEGER;
347 TYPE t_payee_address2 IS TABLE OF
348 IBY_PAYMENTS_ALL.payee_address2%TYPE
349 INDEX BY BINARY_INTEGER;
350 TYPE t_payee_address3 IS TABLE OF
351 IBY_PAYMENTS_ALL.payee_address3%TYPE
352 INDEX BY BINARY_INTEGER;
353 TYPE t_payee_address4 IS TABLE OF
354 IBY_PAYMENTS_ALL.payee_address4%TYPE
355 INDEX BY BINARY_INTEGER;
356 TYPE t_payee_city IS TABLE OF
357 IBY_PAYMENTS_ALL.payee_city%TYPE
358 INDEX BY BINARY_INTEGER;
359 TYPE t_payee_postal_code IS TABLE OF
360 IBY_PAYMENTS_ALL.payee_postal_code%TYPE
361 INDEX BY BINARY_INTEGER;
362 TYPE t_payee_state IS TABLE OF
363 IBY_PAYMENTS_ALL.payee_state%TYPE
364 INDEX BY BINARY_INTEGER;
365 TYPE t_payee_province IS TABLE OF
366 IBY_PAYMENTS_ALL.payee_province%TYPE
367 INDEX BY BINARY_INTEGER;
368 TYPE t_payee_county IS TABLE OF
369 IBY_PAYMENTS_ALL.payee_county%TYPE
370 INDEX BY BINARY_INTEGER;
371 TYPE t_payee_country IS TABLE OF
372 IBY_PAYMENTS_ALL.payee_country%TYPE
373 INDEX BY BINARY_INTEGER;
374 TYPE t_remit_advice_delivery_method IS TABLE OF
375 IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE
376 INDEX BY BINARY_INTEGER;
377 TYPE t_remit_advice_email IS TABLE OF
378 IBY_PAYMENTS_ALL.remit_advice_email%TYPE
379 INDEX BY BINARY_INTEGER;
380 TYPE t_remit_advice_fax IS TABLE OF
381 IBY_PAYMENTS_ALL.remit_advice_fax%TYPE
382 INDEX BY BINARY_INTEGER;
383
384
385 /*TPP-Start*/
386 TYPE t_ext_inv_payee_id IS TABLE OF
387 IBY_PAYMENTS_ALL.ext_inv_payee_id%TYPE
388 INDEX BY BINARY_INTEGER;
389 TYPE t_inv_payee_party_id IS TABLE OF
390 IBY_PAYMENTS_ALL.inv_payee_party_id%TYPE
391 INDEX BY BINARY_INTEGER;
392 TYPE t_inv_party_site_id IS TABLE OF
393 IBY_PAYMENTS_ALL.inv_party_site_id%TYPE
394 INDEX BY BINARY_INTEGER;
395 TYPE t_inv_supplier_site_id IS TABLE OF
396 IBY_PAYMENTS_ALL.inv_supplier_site_id%TYPE
397 INDEX BY BINARY_INTEGER;
398 TYPE t_inv_beneficiary_party IS TABLE OF
399 IBY_PAYMENTS_ALL.inv_beneficiary_party%TYPE
400 INDEX BY BINARY_INTEGER;
401 TYPE t_inv_payee_name IS TABLE OF
402 IBY_PAYMENTS_ALL.inv_payee_name%TYPE
403 INDEX BY BINARY_INTEGER;
404 TYPE t_inv_payee_address1 IS TABLE OF
405 IBY_PAYMENTS_ALL.inv_payee_address1%TYPE
406 INDEX BY BINARY_INTEGER;
407 TYPE t_inv_payee_address2 IS TABLE OF
408 IBY_PAYMENTS_ALL.inv_payee_address2%TYPE
409 INDEX BY BINARY_INTEGER;
410 TYPE t_inv_payee_address3 IS TABLE OF
411 IBY_PAYMENTS_ALL.inv_payee_address3%TYPE
412 INDEX BY BINARY_INTEGER;
413 TYPE t_inv_payee_address4 IS TABLE OF
414 IBY_PAYMENTS_ALL.inv_payee_address4%TYPE
415 INDEX BY BINARY_INTEGER;
416 TYPE t_inv_payee_city IS TABLE OF
417 IBY_PAYMENTS_ALL.inv_payee_city%TYPE
418 INDEX BY BINARY_INTEGER;
419 TYPE t_inv_payee_postal_code IS TABLE OF
420 IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE
421 INDEX BY BINARY_INTEGER;
422 TYPE t_inv_payee_state IS TABLE OF
423 IBY_PAYMENTS_ALL.inv_payee_state%TYPE
424 INDEX BY BINARY_INTEGER;
425 TYPE t_inv_payee_province IS TABLE OF
426 IBY_PAYMENTS_ALL.inv_payee_province%TYPE
427 INDEX BY BINARY_INTEGER;
428 TYPE t_inv_payee_county IS TABLE OF
429 IBY_PAYMENTS_ALL.inv_payee_county%TYPE
430 INDEX BY BINARY_INTEGER;
431 TYPE t_inv_payee_country IS TABLE OF
432 IBY_PAYMENTS_ALL.inv_payee_country%TYPE
433 INDEX BY BINARY_INTEGER;
434 TYPE t_inv_payee_party_name IS TABLE OF
435 IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE
436 INDEX BY BINARY_INTEGER;
437 TYPE t_inv_payee_le_reg_num IS TABLE OF
438 IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE
439 INDEX BY BINARY_INTEGER;
440 TYPE t_inv_payee_tax_reg_num IS TABLE OF
441 IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE
442 INDEX BY BINARY_INTEGER;
443 TYPE t_inv_payee_address_concat IS TABLE OF
444 IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE
445 INDEX BY BINARY_INTEGER;
446 TYPE t_inv_beneficiary_name IS TABLE OF
447 IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE
448 INDEX BY BINARY_INTEGER;
449 TYPE t_inv_payee_party_number IS TABLE OF
450 IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE
451 INDEX BY BINARY_INTEGER;
452 TYPE t_inv_payee_alternate_name IS TABLE OF
453 IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE
454 INDEX BY BINARY_INTEGER;
455 TYPE t_inv_payee_site_alt_name IS TABLE OF
456 IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE
457 INDEX BY BINARY_INTEGER;
458 TYPE t_inv_payee_supplier_number IS TABLE OF
459 IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE
460 INDEX BY BINARY_INTEGER;
461 TYPE t_inv_payee_first_party_ref IS TABLE OF
462 IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE
463 INDEX BY BINARY_INTEGER;
464 TYPE t_ext_acct_ownr_inv_prty_id IS TABLE OF
465 IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE
466 INDEX BY BINARY_INTEGER;
467 TYPE t_ext_bnk_branch_inv_prty_id IS TABLE OF
468 IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE
469 INDEX BY BINARY_INTEGER;
470 TYPE t_ext_acct_ownr_inv_prty_nme IS TABLE OF
471 IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE
472 INDEX BY BINARY_INTEGER;
473 TYPE t_inv_payee_party_attr_cat IS TABLE OF
474 IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE
475 INDEX BY BINARY_INTEGER;
476 TYPE t_inv_payee_supplier_attr_cat IS TABLE OF
477 IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE
478 INDEX BY BINARY_INTEGER;
479 TYPE t_inv_payee_site_attr_cat IS TABLE OF
480 IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE
481 INDEX BY BINARY_INTEGER;
482 TYPE t_inv_payee_supplier_site_name IS TABLE OF
483 IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE
484 INDEX BY BINARY_INTEGER;
485 TYPE t_inv_payee_spp_site_alt_name IS TABLE OF
486 IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE
487 INDEX BY BINARY_INTEGER;
488 TYPE t_inv_payee_supplier_id IS TABLE OF
489 IBY_PAYMENTS_ALL.inv_payee_supplier_id%TYPE
490 INDEX BY BINARY_INTEGER;
491 /*TPP-End*/
492
493 /*
494 * (Stealth) Fix for bug 5475920:
495 *
496 * Ensure that employee related fields are populated in the
497 * payment record.
498 */
499 TYPE t_address_source IS TABLE OF
500 IBY_PAYMENTS_ALL.address_source%TYPE
501 INDEX BY BINARY_INTEGER;
502
503 TYPE t_employee_address_code IS TABLE OF
504 IBY_PAYMENTS_ALL.employee_address_code%TYPE
505 INDEX BY BINARY_INTEGER;
506
507 TYPE t_employee_person_id IS TABLE OF
508 IBY_PAYMENTS_ALL.employee_person_id%TYPE
509 INDEX BY BINARY_INTEGER;
510
511 TYPE t_employee_address_id IS TABLE OF
512 IBY_PAYMENTS_ALL.employee_address_id%TYPE
513 INDEX BY BINARY_INTEGER;
514
515 TYPE t_employee_payment_flag IS TABLE OF
516 IBY_PAYMENTS_ALL.employee_payment_flag%TYPE
517 INDEX BY BINARY_INTEGER;
518
519 TYPE t_calling_app_id IS TABLE OF
520 IBY_HOOK_PAYMENTS_T.calling_app_id%TYPE
521 INDEX BY BINARY_INTEGER;
522
523 TYPE t_call_app_pay_service_req_cd IS TABLE OF
524 IBY_HOOK_PAYMENTS_T.call_app_pay_service_req_code%TYPE
525 INDEX BY BINARY_INTEGER;
526
527 TYPE t_dont_pay_flg IS TABLE OF
528 IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
529 INDEX BY BINARY_INTEGER;
530
531 TYPE t_dont_pay_reason_cd IS TABLE OF
532 IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
533 INDEX BY BINARY_INTEGER;
534
535 TYPE t_dont_pay_desc IS TABLE OF
536 IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
537 INDEX BY BINARY_INTEGER;
538
539
540 TYPE t_remit_advice_req_flg IS TABLE OF
541 IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
542 INDEX BY BINARY_INTEGER;
543
544 TYPE t_payer_party_number IS TABLE OF
545 IBY_PAYMENTS_ALL.PAYER_PARTY_NUMBER%TYPE
546 INDEX BY BINARY_INTEGER;
547
548 TYPE t_payer_party_site_name IS TABLE OF
549 IBY_PAYMENTS_ALL.PAYER_PARTY_SITE_NAME%TYPE
550 INDEX BY BINARY_INTEGER;
551
552 TYPE t_payer_legal_entity_name IS TABLE OF
553 IBY_PAYMENTS_ALL.PAYER_LEGAL_ENTITY_NAME%TYPE
554 INDEX BY BINARY_INTEGER;
555
556 TYPE t_payer_tax_registration_num IS TABLE OF
557 IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM%TYPE
558 INDEX BY BINARY_INTEGER;
559
560 TYPE t_payer_le_registration_num IS TABLE OF
561 IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM%TYPE
562 INDEX BY BINARY_INTEGER;
563
564 TYPE t_payer_party_id IS TABLE OF
565 IBY_PAYMENTS_ALL.PAYER_PARTY_ID%TYPE
566 INDEX BY BINARY_INTEGER;
567
568 TYPE t_payer_location_id IS TABLE OF
569 IBY_PAYMENTS_ALL.PAYER_LOCATION_ID%TYPE
570 INDEX BY BINARY_INTEGER;
571
572 TYPE t_payer_party_attr_category IS TABLE OF
573 IBY_PAYMENTS_ALL.PAYER_PARTY_ATTR_CATEGORY%TYPE
574 INDEX BY BINARY_INTEGER;
575
576 TYPE t_payer_le_attr_category IS TABLE OF
577 IBY_PAYMENTS_ALL.PAYER_LE_ATTR_CATEGORY%TYPE
578 INDEX BY BINARY_INTEGER;
579
580 TYPE t_payer_abbr_agency_code IS TABLE OF
581 IBY_PAYMENTS_ALL.PAYER_ABBREVIATED_AGENCY_CODE%TYPE
582 INDEX BY BINARY_INTEGER;
583
584 TYPE t_payer_federal_us_employer_id IS TABLE OF
585 IBY_PAYMENTS_ALL.PAYER_FEDERAL_US_EMPLOYER_ID%TYPE
586 INDEX BY BINARY_INTEGER;
587
588
589
590 TYPE t_int_bank_name IS TABLE OF
591 IBY_PAYMENTS_ALL.INT_BANK_NAME%TYPE
592 INDEX BY BINARY_INTEGER;
593
594 TYPE t_int_bank_number IS TABLE OF
595 IBY_PAYMENTS_ALL.INT_BANK_NUMBER%TYPE
596 INDEX BY BINARY_INTEGER;
597
598 TYPE t_int_bank_branch_number IS TABLE OF
599 IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NUMBER%TYPE
600 INDEX BY BINARY_INTEGER;
601
602 TYPE t_int_bank_branch_name IS TABLE OF
603 IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NAME%TYPE
604 INDEX BY BINARY_INTEGER;
605
606 TYPE t_int_eft_swift_code IS TABLE OF
607 IBY_PAYMENTS_ALL.INT_EFT_SWIFT_CODE%TYPE
608 INDEX BY BINARY_INTEGER;
609
610 TYPE t_int_bank_account_number IS TABLE OF
611 IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUMBER%TYPE
612 INDEX BY BINARY_INTEGER;
613
614 TYPE t_int_bank_account_name IS TABLE OF
615 IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NAME%TYPE
616 INDEX BY BINARY_INTEGER;
617
618
619 TYPE t_int_bank_account_iban IS TABLE OF
620 IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_IBAN%TYPE
621 INDEX BY BINARY_INTEGER;
622
623
624 TYPE t_int_bank_acct_ag_loc_code IS TABLE OF
625 IBY_PAYMENTS_ALL.INT_BANK_ACCT_AGENCY_LOC_CODE%TYPE
626 INDEX BY BINARY_INTEGER;
627
628
629 TYPE t_int_bank_branch_party_id IS TABLE OF
630 IBY_PAYMENTS_ALL.INT_BANK_BRANCH_PARTY_ID%TYPE
631 INDEX BY BINARY_INTEGER;
632
633
634 TYPE t_int_bank_alt_name IS TABLE OF
635 IBY_PAYMENTS_ALL.INT_BANK_ALT_NAME%TYPE
636 INDEX BY BINARY_INTEGER;
637
638
639 TYPE t_int_bank_branch_alt_name IS TABLE OF
640 IBY_PAYMENTS_ALL.INT_BANK_BRANCH_ALT_NAME%TYPE
641 INDEX BY BINARY_INTEGER;
642
643
644 TYPE t_int_bank_account_alt_name IS TABLE OF
645 IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_ALT_NAME%TYPE
646 INDEX BY BINARY_INTEGER;
647
648
649 TYPE t_int_bank_account_num_elec IS TABLE OF
650 IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUM_ELEC%TYPE
651 INDEX BY BINARY_INTEGER;
652
653
654 TYPE t_int_bank_branch_location_id IS TABLE OF
655 IBY_PAYMENTS_ALL.INT_BANK_BRANCH_LOCATION_ID%TYPE
656 INDEX BY BINARY_INTEGER;
657
658 TYPE t_int_bank_branch_eft_user_num IS TABLE OF
659 IBY_PAYMENTS_ALL.INT_BANK_BRANCH_EFT_USER_NUM%TYPE
660 INDEX BY BINARY_INTEGER;
661
662 TYPE t_int_bank_branch_rfc_id IS TABLE OF
663 IBY_PAYMENTS_ALL.INT_BANK_BRANCH_RFC_IDENTIFIER%TYPE
664 INDEX BY BINARY_INTEGER;
665
666 TYPE t_payee_site_alt_name IS TABLE OF
667 IBY_PAYMENTS_ALL.PAYEE_SITE_ALTERNATE_NAME%TYPE
668 INDEX BY BINARY_INTEGER;
669
670 TYPE t_payee_supplier_number IS TABLE OF
671 IBY_PAYMENTS_ALL.PAYEE_SUPPLIER_NUMBER%TYPE
672 INDEX BY BINARY_INTEGER;
673
674
675 TYPE t_payee_first_party_ref IS TABLE OF
676 IBY_PAYMENTS_ALL.PAYEE_FIRST_PARTY_REFERENCE%TYPE
677 INDEX BY BINARY_INTEGER;
678
679 TYPE t_payee_supp_attr_categ IS TABLE OF
680 IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE
681 INDEX BY BINARY_INTEGER;
682
683 TYPE t_payee_supplier_id IS TABLE OF
684 IBY_PAYMENTS_ALL.payee_supplier_id%TYPE
685 INDEX BY BINARY_INTEGER;
686
687 TYPE t_payee_tax_reg_num IS TABLE OF
688 IBY_PAYMENTS_ALL.payee_tax_registration_num%TYPE
689 INDEX BY BINARY_INTEGER;
690
691
692 TYPE t_payee_le_reg_num IS TABLE OF
693 IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE
694 INDEX BY BINARY_INTEGER;
695
696
697
698 TYPE t_payee_spplr_site_attr_categ IS TABLE OF
699 IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE
700 INDEX BY BINARY_INTEGER;
701
702 TYPE t_payee_supplier_site_name IS TABLE OF
703 IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE
704 INDEX BY BINARY_INTEGER;
705
706 TYPE t_payee_party_site_name IS TABLE OF
707 IBY_PAYMENTS_ALL.payee_party_site_name%TYPE
708 INDEX BY BINARY_INTEGER;
709
710 TYPE t_ext_bank_name IS TABLE OF
711 IBY_PAYMENTS_ALL.ext_bank_name%TYPE
712 INDEX BY BINARY_INTEGER;
713
714 TYPE t_ext_bank_branch_name IS TABLE OF
715 IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE
716 INDEX BY BINARY_INTEGER;
717
718 TYPE t_ext_eft_swift_code IS TABLE OF
719 IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE
720 INDEX BY BINARY_INTEGER;
721
722 TYPE t_ext_bnk_acct_factor_flag IS TABLE OF
723 IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE
724 INDEX BY BINARY_INTEGER;
725
726 TYPE t_ext_bank_acct_owner_party_id IS TABLE OF
727 IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE
728 INDEX BY BINARY_INTEGER;
729
730
731 TYPE t_ext_bank_branch_party_id IS TABLE OF
732 IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE
733 INDEX BY BINARY_INTEGER;
734
735 TYPE t_ext_bank_alt_name IS TABLE OF
736 IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE
737 INDEX BY BINARY_INTEGER;
738
739 TYPE t_ext_bank_branch_alt_name IS TABLE OF
740 IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE
741 INDEX BY BINARY_INTEGER;
742
743 TYPE t_ext_bank_account_alt_name IS TABLE OF
744 IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE
745 INDEX BY BINARY_INTEGER;
746
747 TYPE t_ext_bank_account_num_elec IS TABLE OF
748 IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE
749 INDEX BY BINARY_INTEGER;
750
751 TYPE t_ext_bank_branch_location_id IS TABLE OF
752 IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE
753 INDEX BY BINARY_INTEGER;
754
755 TYPE t_ext_acct_owner_party_name IS TABLE OF
756 IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_name%TYPE
757 INDEX BY BINARY_INTEGER;
758
759
760
761 TYPE t_payee_address_concat IS TABLE OF
762 IBY_PAYMENTS_ALL.payee_address_concat%TYPE
763 INDEX BY BINARY_INTEGER;
764
765 TYPE t_declaration_exch_rate_type IS TABLE OF
766 IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE
767 INDEX BY BINARY_INTEGER;
768
769
770 TYPE t_declaration_format IS TABLE OF
771 IBY_PAYMENTS_ALL.declaration_format%TYPE
772 INDEX BY BINARY_INTEGER;
773
774
775 TYPE t_bank_instr1_format_value IS TABLE OF
776 IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE
777 INDEX BY BINARY_INTEGER;
778
779
780 TYPE t_bank_instr2_format_value IS TABLE OF
781 IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE
782 INDEX BY BINARY_INTEGER;
783
784
785 TYPE t_payment_profile_acct_name IS TABLE OF
786 IBY_PAYMENTS_ALL.payment_profile_acct_name%TYPE
787 INDEX BY BINARY_INTEGER;
788
789
790 TYPE t_payment_profile_sys_name IS TABLE OF
791 IBY_PAYMENTS_ALL.payment_profile_sys_name%TYPE
792 INDEX BY BINARY_INTEGER;
793
794
795 TYPE t_payment_reason_format_value IS TABLE OF
796 IBY_PAYMENTS_ALL.payment_reason_format_value%TYPE
797 INDEX BY BINARY_INTEGER;
798
799 TYPE t_payment_process_request_name IS TABLE OF
800 IBY_PAYMENTS_ALL.payment_process_request_name%TYPE
801 INDEX BY BINARY_INTEGER;
802
803 TYPE t_org_name IS TABLE OF
804 IBY_PAYMENTS_ALL.org_name%TYPE
805 INDEX BY BINARY_INTEGER;
806
807 TYPE t_del_channel_format_value IS TABLE OF
808 IBY_PAYMENTS_ALL.DELIVERY_CHANNEL_FORMAT_VALUE%TYPE
809 INDEX BY BINARY_INTEGER;
810
811
812 TYPE t_source_product IS TABLE OF
813 IBY_PAYMENTS_ALL.source_product%TYPE
814 INDEX BY BINARY_INTEGER;
815
816 TYPE t_payee_party_number IS TABLE OF
817 IBY_PAYMENTS_ALL.payee_party_number%TYPE
818 INDEX BY BINARY_INTEGER;
819
820 TYPE t_payee_party_name IS TABLE OF
821 IBY_PAYMENTS_ALL.payee_party_name%TYPE
822 INDEX BY BINARY_INTEGER;
823
824 TYPE t_payee_alt_name IS TABLE OF
825 IBY_PAYMENTS_ALL.PAYEE_ALTERNATE_NAME%TYPE
826 INDEX BY BINARY_INTEGER;
827
828 TYPE t_payee_party_atr_cat IS TABLE OF
829 IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE
830 INDEX BY BINARY_INTEGER;
831
832 TYPE t_payee_addressee IS TABLE OF -- not to be used on B-o-B for ATT
833 IBY_PAYMENTS_ALL.payee_addressee%TYPE
834 INDEX BY BINARY_INTEGER;
835
836 TYPE t_affects_rejection_level IS TABLE OF
837 IBY_PAYMENTS_ALL.affects_rejection_level%TYPE
838 INDEX BY BINARY_INTEGER;
839
840
841 TYPE payment_tab_type IS RECORD
842 (
843 payment_id t_payment_id,
844 payment_method_code t_payment_method_code,
845 payment_service_request_id t_payment_service_request_id,
846 process_type t_process_type,
847 payment_status t_payment_status,
848 payments_complete_flag t_payments_complete_flag,
849 payment_function t_payment_function,
850 payment_amount t_payment_amount,
851 payment_currency_code t_payment_currency_code,
852 bill_payable_flag t_bill_payable_flag,
853 exclusive_payment_flag t_exclusive_payment_flag,
854 sep_remit_advice_req_flag t_sep_remit_advice_req_flag,
855 internal_bank_account_id t_internal_bank_account_id,
856 org_id t_org_id,
857 org_type t_org_type,
858 legal_entity_id t_legal_entity_id,
859 declare_payment_flag t_declare_payment_flag,
860 delivery_channel_code t_delivery_channel_code,
861 ext_payee_id t_ext_payee_id,
862 payment_instruction_id t_payment_instruction_id,
863 payment_profile_id t_payment_profile_id,
864 pregrouped_payment_flag t_pregrouped_payment_flag,
865 stop_confirmed_flag t_stop_confirmed_flag,
866 stop_released_flag t_stop_released_flag,
867 stop_request_placed_flag t_stop_request_placed_flag,
868 created_by t_created_by,
869 creation_date t_creation_date,
870 last_updated_by t_last_updated_by,
871 last_update_login t_last_update_login,
872 last_update_date t_last_update_date,
873 object_version_number t_object_version_number,
874 payee_party_id t_payee_party_id,
875 party_site_id t_party_site_id,
876 supplier_site_id t_supplier_site_id,
877 payment_reason_code t_payment_reason_code,
878 payment_reason_comments t_payment_reason_comments,
879 payment_date t_payment_date,
880 anticipated_value_date t_anticipated_value_date,
881 declaration_amount t_declaration_amount,
882 declaration_currency_code t_declaration_currency_code,
883 discount_amount_taken t_discount_amount_taken,
884 payment_details t_payment_details,
885 bank_charge_bearer t_bank_charge_bearer,
886 bank_charge_amount t_bank_charge_amount,
887 settlement_priority t_settlement_priority,
888 remittance_message1 t_remittance_message1,
889 remittance_message2 t_remittance_message2,
890 remittance_message3 t_remittance_message3,
891 payment_reference_number t_payment_reference_number,
892 paper_document_number t_paper_document_number,
893 bank_assigned_ref_code t_bank_assigned_ref_code,
894 external_bank_account_id t_external_bank_account_id,
895 unique_remittance_identifier t_unique_remittance_identifier,
896 uri_check_digit t_uri_check_digit,
897 bank_instruction1_code t_bank_instruction1_code,
898 bank_instruction2_code t_bank_instruction2_code,
899 bank_instruction_details t_bank_instruction_details,
900 payment_text_message1 t_payment_text_message1,
901 payment_text_message2 t_payment_text_message2,
902 payment_text_message3 t_payment_text_message3,
903 maturity_date t_maturity_date,
904 payment_due_date t_payment_due_date,
905 document_category_code t_document_category_code,
906 document_sequence_id t_document_sequence_id,
907 document_sequence_value t_document_sequence_value,
908 beneficiary_party t_beneficiary_party,
909 stop_confirmed_by t_stop_confirmed_by,
910 stop_confirm_date t_stop_confirm_date,
911 stop_confirm_reason t_stop_confirm_reason,
912 stop_confirm_reference t_stop_confirm_reference,
913 stop_released_by t_stop_released_by,
914 stop_release_date t_stop_release_date,
915 stop_release_reason t_stop_release_reason,
916 stop_release_reference t_stop_release_reference,
917 stop_request_date t_stop_request_date,
918 stop_request_placed_by t_stop_request_placed_by,
919 stop_request_reason t_stop_request_reason,
920 stop_request_reference t_stop_request_reference,
921 voided_by t_voided_by,
922 void_date t_void_date,
923 void_reason t_void_reason,
924 remit_to_location_id t_remit_to_location_id,
925 completed_pmts_group_id t_completed_pmts_group_id,
926 attribute_category t_attribute_category,
927 attribute1 t_attribute1,
928 attribute2 t_attribute2,
929 attribute3 t_attribute3,
930 attribute4 t_attribute4,
931 attribute5 t_attribute5,
932 attribute6 t_attribute6,
933 attribute7 t_attribute7,
934 attribute8 t_attribute8,
935 attribute9 t_attribute9,
936 attribute10 t_attribute10,
937 attribute11 t_attribute11,
938 attribute12 t_attribute12,
939 attribute13 t_attribute13,
940 attribute14 t_attribute14,
941 attribute15 t_attribute15,
942 ext_branch_number t_ext_branch_number,
943 ext_bank_number t_ext_bank_number,
944 ext_bank_account_name t_ext_bank_account_name,
945 ext_bank_account_number t_ext_bank_account_number,
946 ext_bank_account_type t_ext_bank_account_type,
947 ext_bank_account_iban_number t_ext_bank_account_iban_number,
948 payee_name t_payee_name,
949 payee_address1 t_payee_address1,
950 payee_address2 t_payee_address2,
951 payee_address3 t_payee_address3,
952 payee_address4 t_payee_address4,
953 payee_city t_payee_city,
954 payee_postal_code t_payee_postal_code,
955 payee_state t_payee_state,
956 payee_province t_payee_province,
957 payee_county t_payee_county,
958 payee_country t_payee_country,
959 remit_advice_delivery_method t_remit_advice_delivery_method,
960 remit_advice_email t_remit_advice_email,
961 remit_advice_fax t_remit_advice_fax,
962 address_source t_address_source,
963 employee_address_code t_employee_address_code,
964 employee_person_id t_employee_person_id,
965 employee_address_id t_employee_address_id,
966 employee_payment_flag t_employee_payment_flag,
967 calling_app_id t_calling_app_id,
968 call_app_pay_service_req_cd t_call_app_pay_service_req_cd,
969 dont_pay_flg t_dont_pay_flg,
970 dont_pay_reason_cd t_dont_pay_reason_cd,
971 dont_pay_desc t_dont_pay_desc,
972 /*TPP-Start*/
973 ext_inv_payee_id t_ext_inv_payee_id ,
974 inv_payee_party_id t_inv_payee_party_id ,
975 inv_party_site_id t_inv_party_site_id ,
976 inv_supplier_site_id t_inv_supplier_site_id ,
977 inv_beneficiary_party t_inv_beneficiary_party ,
978 inv_payee_name t_inv_payee_name ,
979 inv_payee_address1 t_inv_payee_address1 ,
980 inv_payee_address2 t_inv_payee_address2 ,
981 inv_payee_address3 t_inv_payee_address3 ,
982 inv_payee_address4 t_inv_payee_address4 ,
983 inv_payee_city t_inv_payee_city ,
984 inv_payee_postal_code t_inv_payee_postal_code ,
985 inv_payee_state t_inv_payee_state ,
986 inv_payee_province t_inv_payee_province ,
987 inv_payee_county t_inv_payee_county ,
988 inv_payee_country t_inv_payee_country ,
989 inv_payee_party_name t_inv_payee_party_name ,
990 inv_payee_le_reg_num t_inv_payee_le_reg_num,
991 inv_payee_tax_reg_num t_inv_payee_tax_reg_num,
992 inv_payee_address_concat t_inv_payee_address_concat ,
993 inv_beneficiary_name t_inv_beneficiary_name ,
994 inv_payee_party_number t_inv_payee_party_number ,
995 inv_payee_alternate_name t_inv_payee_alternate_name ,
996 inv_payee_site_alt_name t_inv_payee_site_alt_name,
997 inv_payee_supplier_number t_inv_payee_supplier_number ,
998 inv_payee_first_party_ref t_inv_payee_first_party_ref,
999 ext_bnk_acct_ownr_inv_prty_id t_ext_acct_ownr_inv_prty_id,
1000 ext_bnk_branch_inv_prty_id t_ext_bnk_branch_inv_prty_id,
1001 ext_bnk_acct_ownr_inv_prty_nme t_ext_acct_ownr_inv_prty_nme,
1002 inv_payee_party_attr_cat t_inv_payee_party_attr_cat,
1003 inv_payee_supplier_attr_cat t_inv_payee_supplier_attr_cat,
1004 inv_payee_spplr_site_attr_cat t_inv_payee_site_attr_cat,
1005 inv_payee_supplier_site_name t_inv_payee_supplier_site_name,
1006 inv_payee_spplr_site_alt_name t_inv_payee_spp_site_alt_name,
1007 inv_payee_supplier_id t_inv_payee_supplier_id
1008 /*TPP-End*/
1009
1010 );
1011
1012 paymentTab payment_tab_type;
1013 --pmtTable payment_tab_type;
1014
1015
1016
1017 TYPE pmtTable_type IS RECORD
1018 (
1019 payment_id t_payment_id,
1020 payment_method_code t_payment_method_code,
1021 payment_service_request_id t_payment_service_request_id,
1022 process_type t_process_type,
1023 payment_status t_payment_status,
1024 payments_complete_flag t_payments_complete_flag,
1025 payment_function t_payment_function,
1026 payment_amount t_payment_amount,
1027 payment_currency_code t_payment_currency_code,
1028 bill_payable_flag t_bill_payable_flag,
1029 exclusive_payment_flag t_exclusive_payment_flag,
1030 sep_remit_advice_req_flag t_sep_remit_advice_req_flag,
1031 internal_bank_account_id t_internal_bank_account_id,
1032 org_id t_org_id,
1033 org_type t_org_type,
1034 legal_entity_id t_legal_entity_id,
1035 declare_payment_flag t_declare_payment_flag,
1036 delivery_channel_code t_delivery_channel_code,
1037 ext_payee_id t_ext_payee_id,
1038 payment_instruction_id t_payment_instruction_id,
1039 payment_profile_id t_payment_profile_id,
1040 pregrouped_payment_flag t_pregrouped_payment_flag,
1041 stop_confirmed_flag t_stop_confirmed_flag,
1042 stop_released_flag t_stop_released_flag,
1043 stop_request_placed_flag t_stop_request_placed_flag,
1044 created_by t_created_by,
1045 creation_date t_creation_date,
1046 last_updated_by t_last_updated_by,
1047 last_update_login t_last_update_login,
1048 last_update_date t_last_update_date,
1049 object_version_number t_object_version_number,
1050 payee_party_id t_payee_party_id,
1051 party_site_id t_party_site_id,
1052 supplier_site_id t_supplier_site_id,
1053 payment_reason_code t_payment_reason_code,
1054 payment_reason_comments t_payment_reason_comments,
1055 payment_date t_payment_date,
1056 anticipated_value_date t_anticipated_value_date,
1057 declaration_amount t_declaration_amount,
1058 declaration_currency_code t_declaration_currency_code,
1059 discount_amount_taken t_discount_amount_taken,
1060 payment_details t_payment_details,
1061 bank_charge_bearer t_bank_charge_bearer,
1062 bank_charge_amount t_bank_charge_amount,
1063 settlement_priority t_settlement_priority,
1064 remittance_message1 t_remittance_message1,
1065 remittance_message2 t_remittance_message2,
1066 remittance_message3 t_remittance_message3,
1067 payment_reference_number t_payment_reference_number,
1068 paper_document_number t_paper_document_number,
1069 bank_assigned_ref_code t_bank_assigned_ref_code,
1070 external_bank_account_id t_external_bank_account_id,
1071 unique_remittance_identifier t_unique_remittance_identifier,
1072 uri_check_digit t_uri_check_digit,
1073 bank_instruction1_code t_bank_instruction1_code,
1074 bank_instruction2_code t_bank_instruction2_code,
1075 bank_instruction_details t_bank_instruction_details,
1076 payment_text_message1 t_payment_text_message1,
1077 payment_text_message2 t_payment_text_message2,
1078 payment_text_message3 t_payment_text_message3,
1079 maturity_date t_maturity_date,
1080 payment_due_date t_payment_due_date,
1081 document_category_code t_document_category_code,
1082 document_sequence_id t_document_sequence_id,
1083 document_sequence_value t_document_sequence_value,
1084 beneficiary_party t_beneficiary_party,
1085 stop_confirmed_by t_stop_confirmed_by,
1086 stop_confirm_date t_stop_confirm_date,
1087 stop_confirm_reason t_stop_confirm_reason,
1088 stop_confirm_reference t_stop_confirm_reference,
1089 stop_released_by t_stop_released_by,
1090 stop_release_date t_stop_release_date,
1091 stop_release_reason t_stop_release_reason,
1092 stop_release_reference t_stop_release_reference,
1093 stop_request_date t_stop_request_date,
1094 stop_request_placed_by t_stop_request_placed_by,
1095 stop_request_reason t_stop_request_reason,
1096 stop_request_reference t_stop_request_reference,
1097 voided_by t_voided_by,
1098 void_date t_void_date,
1099 void_reason t_void_reason,
1100 remit_to_location_id t_remit_to_location_id,
1101 completed_pmts_group_id t_completed_pmts_group_id,
1102 attribute_category t_attribute_category,
1103 attribute1 t_attribute1,
1104 attribute2 t_attribute2,
1105 attribute3 t_attribute3,
1106 attribute4 t_attribute4,
1107 attribute5 t_attribute5,
1108 attribute6 t_attribute6,
1109 attribute7 t_attribute7,
1110 attribute8 t_attribute8,
1111 attribute9 t_attribute9,
1112 attribute10 t_attribute10,
1113 attribute11 t_attribute11,
1114 attribute12 t_attribute12,
1115 attribute13 t_attribute13,
1116 attribute14 t_attribute14,
1117 attribute15 t_attribute15,
1118 ext_branch_number t_ext_branch_number,
1119 ext_bank_number t_ext_bank_number,
1120 ext_bank_account_name t_ext_bank_account_name,
1121 ext_bank_account_number t_ext_bank_account_number,
1122 ext_bank_account_type t_ext_bank_account_type,
1123 ext_bank_account_iban_number t_ext_bank_account_iban_number,
1124 payee_party_number t_payee_party_number,
1125 payee_party_name t_payee_party_name,
1126
1127 payee_name t_payee_name,
1128 payee_alt_name t_payee_alt_name,
1129 payee_address1 t_payee_address1,
1130 payee_address2 t_payee_address2,
1131 payee_address3 t_payee_address3,
1132 payee_address4 t_payee_address4,
1133 payee_city t_payee_city,
1134 payee_postal_code t_payee_postal_code,
1135 payee_state t_payee_state,
1136 payee_province t_payee_province,
1137 payee_county t_payee_county,
1138 payee_country t_payee_country,
1139 -- separate_remit_advice_req_flag t_remit_advice_req_flg,
1140 remit_advice_delivery_method t_remit_advice_delivery_method,
1141 remit_advice_email t_remit_advice_email,
1142 remit_advice_fax t_remit_advice_fax,
1143 address_source t_address_source,
1144 employee_address_code t_employee_address_code,
1145 employee_person_id t_employee_person_id,
1146 employee_address_id t_employee_address_id,
1147 employee_payment_flag t_employee_payment_flag,
1148 payer_party_number t_payer_party_number,
1149 payer_party_site_name t_payer_party_site_name,
1150 payer_legal_entity_name t_payer_legal_entity_name,
1151 payer_tax_registration_num t_payer_tax_registration_num,
1152 payer_le_registration_num t_payer_le_registration_num,
1153 payer_party_id t_payer_party_id,
1154 payer_location_id t_payer_location_id,
1155 payer_party_attr_category t_payer_party_attr_category,
1156 payer_le_attr_category t_payer_le_attr_category,
1157 payer_abbreviated_agency_code t_payer_abbr_agency_code,
1158 payer_federal_us_employer_id t_payer_federal_us_employer_id,
1159 int_bank_name t_int_bank_name,
1160 int_bank_number t_int_bank_number,
1161 int_bank_branch_number t_int_bank_branch_number,
1162 int_bank_branch_name t_int_bank_branch_name,
1163 int_eft_swift_code t_int_eft_swift_code,
1164 int_bank_account_number t_int_bank_account_number,
1165 int_bank_account_name t_int_bank_account_name,
1166 int_bank_account_iban t_int_bank_account_iban,
1167 int_bank_acct_agency_loc_code t_int_bank_acct_ag_loc_code,
1168 int_bank_branch_party_id t_int_bank_branch_party_id,
1169 int_bank_alt_name t_int_bank_alt_name,
1170 int_bank_branch_alt_name t_int_bank_branch_alt_name,
1171 int_bank_account_alt_name t_int_bank_account_alt_name,
1172 int_bank_account_num_elec t_int_bank_account_num_elec,
1173 int_bank_branch_location_id t_int_bank_branch_location_id,
1174 int_bank_branch_eft_user_num t_int_bank_branch_eft_user_num,
1175 int_bank_branch_rfc_identifier t_int_bank_branch_rfc_id,
1176
1177 payee_site_alternate_name t_payee_site_alt_name,
1178 payee_supplier_number t_payee_supplier_number,
1179 payee_first_party_reference t_payee_first_party_ref,
1180 payee_supplier_attr_category t_payee_supp_attr_categ,
1181 payee_addressee t_payee_addressee,
1182 payee_supplier_id t_payee_supplier_id,
1183 payee_tax_registration_num t_payee_tax_reg_num,
1184 payee_le_registration_num t_payee_le_reg_num,
1185
1186 payee_spplr_site_attr_category t_payee_spplr_site_attr_categ,
1187 payee_supplier_site_name t_payee_supplier_site_name,
1188 payee_party_site_name t_payee_party_site_name,
1189 payee_party_atr_cat t_payee_party_atr_cat,
1190 beneficiary_name t_inv_beneficiary_name,
1191 ext_bank_name t_ext_bank_name,
1192 ext_bank_branch_name t_ext_bank_branch_name,
1193 ext_eft_swift_code t_ext_eft_swift_code,
1194 ext_bank_acct_pmt_factor_flag t_ext_bnk_acct_factor_flag,
1195 ext_bank_acct_owner_party_id t_ext_bank_acct_owner_party_id,
1196 ext_bank_branch_party_id t_ext_bank_branch_party_id,
1197 ext_bank_alt_name t_ext_bank_alt_name,
1198 ext_bank_branch_alt_name t_ext_bank_branch_alt_name,
1199 ext_bank_account_alt_name t_ext_bank_account_alt_name,
1200 ext_bank_account_num_elec t_ext_bank_account_num_elec,
1201 ext_bank_branch_location_id t_ext_bank_branch_location_id,
1202 ext_bank_acct_owner_party_name t_ext_acct_owner_party_name,
1203 payee_address_concat t_payee_address_concat,
1204
1205 declaration_exch_rate_type t_declaration_exch_rate_type,
1206 declaration_format t_declaration_format,
1207 bank_instruction1_format_value t_bank_instr1_format_value,
1208 bank_instruction2_format_value t_bank_instr2_format_value,
1209 payment_profile_acct_name t_payment_profile_acct_name,
1210 payment_profile_sys_name t_payment_profile_sys_name,
1211 payment_reason_format_value t_payment_reason_format_value,
1212 delivery_channel_format_value t_del_channel_format_value,
1213 payment_process_request_name t_payment_process_request_name,
1214 source_product t_source_product,
1215 org_name t_org_name,
1216 calling_app_id t_calling_app_id,
1217 call_app_pay_service_req_cd t_call_app_pay_service_req_cd,
1218 dont_pay_flg t_dont_pay_flg,
1219 dont_pay_reason_cd t_dont_pay_reason_cd,
1220 dont_pay_desc t_dont_pay_desc,
1221 /*TPP-Start*/
1222 ext_inv_payee_id t_ext_inv_payee_id ,
1223 inv_payee_party_id t_inv_payee_party_id ,
1224 inv_party_site_id t_inv_party_site_id ,
1225 inv_supplier_site_id t_inv_supplier_site_id ,
1226 inv_beneficiary_party t_inv_beneficiary_party ,
1227 inv_payee_name t_inv_payee_name ,
1228 inv_payee_address1 t_inv_payee_address1 ,
1229 inv_payee_address2 t_inv_payee_address2 ,
1230 inv_payee_address3 t_inv_payee_address3 ,
1231 inv_payee_address4 t_inv_payee_address4 ,
1232 inv_payee_city t_inv_payee_city ,
1233 inv_payee_postal_code t_inv_payee_postal_code ,
1234 inv_payee_state t_inv_payee_state ,
1235 inv_payee_province t_inv_payee_province ,
1236 inv_payee_county t_inv_payee_county ,
1237 inv_payee_country t_inv_payee_country ,
1238 inv_payee_party_name t_inv_payee_party_name ,
1239 inv_payee_le_reg_num t_inv_payee_le_reg_num,
1240 inv_payee_tax_reg_num t_inv_payee_tax_reg_num,
1241 inv_payee_address_concat t_inv_payee_address_concat ,
1242 inv_beneficiary_name t_inv_beneficiary_name ,
1243 inv_payee_party_number t_inv_payee_party_number ,
1244 inv_payee_alternate_name t_inv_payee_alternate_name ,
1245 inv_payee_site_alt_name t_inv_payee_site_alt_name,
1246 inv_payee_supplier_number t_inv_payee_supplier_number ,
1247 inv_payee_first_party_ref t_inv_payee_first_party_ref,
1248 ext_bnk_acct_ownr_inv_prty_id t_ext_acct_ownr_inv_prty_id,
1249 ext_bnk_branch_inv_prty_id t_ext_bnk_branch_inv_prty_id,
1250 ext_bnk_acct_ownr_inv_prty_nme t_ext_acct_ownr_inv_prty_nme,
1251 inv_payee_party_attr_cat t_inv_payee_party_attr_cat,
1252 inv_payee_supplier_attr_cat t_inv_payee_supplier_attr_cat,
1253 inv_payee_spplr_site_attr_cat t_inv_payee_site_attr_cat,
1254 inv_payee_supplier_site_name t_inv_payee_supplier_site_name,
1255 inv_payee_spplr_site_alt_name t_inv_payee_spp_site_alt_name,
1256 inv_payee_supplier_id t_inv_payee_supplier_id,
1257 /*TPP-End*/
1258 affects_rejection_level t_affects_rejection_level --AWT Enh 16296267
1259 );
1260
1261 pmtTable pmtTable_type;
1262
1263
1264
1265
1266
1267 TYPE commonAttributesTabType IS RECORD
1268 (
1269 due_date_common_flag VARCHAR2(1),
1270 delv_chnl_common_flag VARCHAR2(1),
1271 uri_common_flag VARCHAR2(1),
1272 prev_pmt_due_date IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1273 curr_pmt_due_date IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1274 prev_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1275 curr_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1276 prev_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1277 curr_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1278 prev_uri_checkdigits IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1279 curr_uri_checkdigits IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE
1280
1281 );
1282
1283 TYPE failDocsOfPaymentRecType IS RECORD
1284 (
1285 payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,
1286 document_payable_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1287 document_status IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
1288 calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1289 calling_app_doc_unique_ref1 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1290 calling_app_doc_unique_ref2 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1291 calling_app_doc_unique_ref3 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1292 calling_app_doc_unique_ref4 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1293 calling_app_doc_unique_ref5 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1294 pay_proc_trxn_type_code IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1295 document_amount IBY_DOCS_PAYABLE_ALL.document_amount%TYPE,
1296 payment_grouping_number IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE
1297
1298 );
1299
1300 TYPE failDocsOfPaymentTabType IS TABLE OF failDocsOfPaymentRecType
1301 INDEX BY BINARY_INTEGER;
1302
1303 TYPE failDocsRecType IS RECORD
1304 (
1305 document_payable_id IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE,
1306 document_amount IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE,
1307 amount_withheld IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE,
1308 dont_pay_flag IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
1309 );
1310
1311 TYPE failDocsTabType IS TABLE OF failDocsRecType
1312 INDEX BY BINARY_INTEGER;
1313
1314 --
1315 -- Record to format linked to each profile.
1316 --
1317 TYPE profileFormatRecType IS RECORD (
1318 profile_id IBY_PAYMENT_PROFILES.
1319 payment_profile_id%TYPE,
1320 payment_format_cd IBY_PAYMENT_PROFILES.
1321 payment_format_code%TYPE,
1322 bepid IBY_PAYMENT_PROFILES.
1323 bepid%TYPE,
1324 transmit_protocol_cd IBY_PAYMENT_PROFILES.
1325 transmit_protocol_code%TYPE
1326 );
1327
1328 --
1329 -- The profile formats table
1330 --
1331 TYPE profileFormatTabType IS TABLE OF profileFormatRecType
1332 INDEX BY BINARY_INTEGER;
1333
1334 /* holds list of format linked to each profile */
1335 l_profile_format_tab profileFormatTabType;
1336
1337
1338 TYPE internalBankAcctType IS RECORD (
1339 internal_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE,
1340 bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE,
1341 country CE_BANK_BRANCHES_V.country%TYPE,
1342 allow_zero_pmt_flag CE_BANK_ACCOUNTS.zero_amount_allowed%TYPE
1343 );
1344 --
1345 TYPE internalBankAcctTabType IS TABLE OF internalBankAcctType
1346 INDEX BY VARCHAR2(2000);
1347
1348 int_bank_acct_tbl internalBankAcctTabType;
1349
1350
1351 -- Get Employee Full Name from HR tables
1352 FUNCTION Get_Employee_Full_Name(p_person_id IN NUMBER, p_party_id IN NUMBER,p_party_name IN VARCHAR2)
1353 RETURN VARCHAR2;
1354
1355
1356 /*--------------------------------------------------------------------
1357 | NAME:
1358 |
1359 | PURPOSE:
1360 | This procedure is used to initialize global memory structure
1361 | / Destroy the no longer used memory structure
1362 |
1363 | PARAMETERS:
1364 |
1365 | NONE
1366 |
1367 | RETURNS:
1368 |
1369 | NOTES:
1370 |
1371 *---------------------------------------------------------------------*/
1372 PROCEDURE delete_paymentTab;
1373
1374
1375 /*--------------------------------------------------------------------
1376 | NAME:
1377 |
1378 | PURPOSE:
1379 | This procedure is used to free up the memory used by
1380 | global memory structure [pmtTable]
1381 |
1382 | PARAMETERS:
1383 |
1384 | NONE
1385 |
1386 | RETURNS:
1387 |
1388 | NOTES:
1389 |
1390 *---------------------------------------------------------------------*/
1391 PROCEDURE delete_pmtTable;
1392
1393 --
1394 -- This data structure will be populated with the data
1395 -- from paymentRecType record. This record will only store
1396 -- success payments whereas paymentRecType can store both
1397 -- successful and failed payments. A table hookPaymentRecType
1398 -- records will be passed to the calling application via a
1399 -- hook / callout. The calling application can adjust the
1400 -- payment amount (and it's constituent document amounts)
1401 -- for purposes like bank charge calculation, tax withholding etc.
1402 --
1403 -- The record hookDocsInPaymentRecType holds the documents
1404 -- corresponding to this payment.
1405 --
1406 --
1407 -- Table of successful payments to be passed to the
1408 -- calling application via hook.
1409 --
1410 TYPE hookPaymentTabType IS TABLE OF IBY_HOOK_PAYMENTS_T%ROWTYPE
1411 INDEX BY BINARY_INTEGER;
1412
1413 --
1414 -- This record needs to be created because of the fact that
1415 -- there is no document id column in IBY_PAYMENTS_ALL table. So
1416 -- we cannot add the document id as a field in the paymentRecType
1417 -- record (adding this field to the record will cause a syntax
1418 -- error during the bulk update).
1419 --
1420 -- Therefore, we need a separate data structure to keep track
1421 -- of the documents that are part of a payment. The docsInPaymentRecType
1422 -- is that data structure. After all the grouping operations are
1423 -- completed, the IBY_DOCS_PAYABLE_ALL table needs to be
1424 -- updated to indicate the PAYMENT_ID for each document that
1425 -- has been put into a payment. The docsInPaymentRecType
1426 -- is used for this update.
1427 --
1428 -- The record paymentRecType holds the payments corresponding
1429 -- to these documents.
1430 --
1431 TYPE docsInPaymentRecType IS RECORD (
1432 payment_id
1433 IBY_PAYMENTS_ALL.payment_id%TYPE,
1434 document_id
1435 IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1436 calling_app_id
1437 IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1438 calling_app_doc_id1
1439 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1440 calling_app_doc_id2
1441 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1442 calling_app_doc_id3
1443 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1444 calling_app_doc_id4
1445 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1446 calling_app_doc_id5
1447 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1448 pay_proc_ttype_cd
1449 IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1450 document_amount
1451 IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
1452 document_currency
1453 IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1454 payment_grp_num
1455 IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
1456 document_status
1457 IBY_DOCS_PAYABLE_ALL.document_status%TYPE := 'PAYMENT_CREATED',
1458 amount_withheld
1459 IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE := 0,
1460 pmt_due_date
1461 IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1462 discount_date
1463 IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
1464 int_bank_acct_id
1465 IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
1466 ext_payee_id
1467 IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1468 payee_id
1469 IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
1470 payee_site_id
1471 IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
1472 supplier_site_id
1473 IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
1474 org_id
1475 IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1476 org_type
1477 IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1478 ext_bank_acct_id
1479 IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
1480 pmt_curr_discount
1481 IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
1482 delivery_channel
1483 IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1484 unique_remit_id
1485 IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1486 uri_ckdigits
1487 IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1488
1489 /*TPP-Start*/
1490 inv_payee_party_id IBY_DOCS_PAYABLE_ALL.inv_payee_party_id%TYPE,
1491 inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,
1492 inv_supplier_site_id IBY_DOCS_PAYABLE_ALL.inv_supplier_site_id%TYPE,
1493 inv_beneficiary_party IBY_DOCS_PAYABLE_ALL.inv_beneficiary_party%TYPE,
1494 ext_inv_payee_id IBY_DOCS_PAYABLE_ALL.ext_inv_payee_id%TYPE,
1495 relationship_id IBY_DOCS_PAYABLE_ALL.relationship_id%TYPE
1496 /*TPP-End*/
1497 );
1498
1499 --
1500 -- Used to update of the IBY_DOCS_PAYABLE_ALL table.
1501 --
1502 TYPE docsInPaymentTabType IS TABLE OF docsInPaymentRecType
1503 INDEX BY BINARY_INTEGER;
1504
1505 --
1506 -- This record stores the count of successful documents
1507 -- for a particular payment. It is useful in situations
1508 -- like remittance advice creation where is is necessary
1509 -- to know how many successful documents exist for a
1510 -- particular payment.
1511 --
1512 TYPE successDocsCountPerPmtRec IS RECORD (
1513 payment_id
1514 IBY_PAYMENTS_ALL.payment_id%TYPE,
1515 success_docs_count
1516 NUMBER(15)
1517 );
1518
1519 --
1520 -- Table of success docs count per payment
1521 --
1522 TYPE successDocsCountPerPmtTab IS TABLE OF successDocsCountPerPmtRec
1523 INDEX BY BINARY_INTEGER;
1524
1525 --
1526 -- A record that stores a payment method code along with it's
1527 -- maturity days offset.
1528 --
1529 TYPE pmtMethodMaturityDaysRec IS RECORD (
1530 pmt_method_cd
1531 IBY_PAYMENT_METHODS_VL.payment_method_code%TYPE,
1532 maturity_offset_days
1533 IBY_PAYMENT_METHODS_VL.maturity_date_offset_days%TYPE
1534 );
1535
1536 --
1537 -- Table of payment methods and their maturity offset days.
1538 --
1539 TYPE pmtMethodMaturityDaysTab IS TABLE OF pmtMethodMaturityDaysRec
1540 INDEX BY BINARY_INTEGER;
1541
1542 --
1543 -- List of documents to be passed to the calling
1544 -- app via hook.
1545 --
1546 -- The record hookPaymentRecType holds the payments
1547 -- corresponding to these documents.
1548 --
1549 -- Table of documents that will be exposed to the hook.
1550 --
1551 TYPE hookDocsInPaymentTabType IS TABLE OF IBY_HOOK_DOCS_IN_PMT_T%ROWTYPE
1552 INDEX BY BINARY_INTEGER;
1553
1554 --
1555 -- The document id table
1556 --
1557 TYPE docPayTabType IS TABLE OF IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE
1558 INDEX BY BINARY_INTEGER;
1559
1560 --
1561 -- This record stores all the document fields that are used in
1562 -- as criteria for grouping a document into a payment. Each
1563 -- of these fields will result in a grouping rule.
1564 --
1565 -- Some of the fields of this record are not used specifically
1566 -- for grouping, but for raising business events etc.
1567 -- e.g., the calling app pay req id
1568 --
1569 -- Some of the grouping criteria are user defined; these are
1570 -- specified in the IBY_PMT_CREATION_RULES table. This record
1571 -- contains placeholder for the user defined grouping fields
1572 -- as well.
1573 --
1574 TYPE paymentGroupCriteriaType IS RECORD (
1575 calling_app_payreq_cd
1576 IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
1577 document_id
1578 IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1579 calling_app_id
1580 IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1581 calling_app_doc_id1
1582 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1583 calling_app_doc_id2
1584 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1585 calling_app_doc_id3
1586 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1587 calling_app_doc_id4
1588 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1589 calling_app_doc_id5
1590 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1591 pay_proc_ttype_cd
1592 IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1593 payment_grp_num
1594 IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
1595 payment_method_cd
1596 IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1597 int_bank_acct_id
1598 IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
1599 ext_bank_acct_id
1600 IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
1601 payment_profile_id
1602 IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1603 org_id
1604 IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1605 org_type
1606 IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1607 payment_function
1608 IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
1609 ext_payee_id
1610 IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1611 payee_party_id
1612 IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
1613 payee_party_site_id
1614 IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
1615 supplier_site_id
1616 IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
1617 remit_loc_id
1618 IBY_DOCS_PAYABLE_ALL.remit_to_location_id%TYPE,
1619 amount_withheld
1620 IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE,
1621 bank_inst1_code
1622 IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
1623 bank_inst2_code
1624 IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE,
1625 pmt_txt_msg1
1626 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE,
1627 pmt_txt_msg2
1628 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE,
1629 pmt_txt_msg3
1630 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE,
1631 payment_currency
1632 IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1633 payment_amount
1634 IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
1635 payment_date
1636 IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
1637 pay_alone_flag
1638 IBY_DOCS_PAYABLE_ALL.exclusive_payment_flag%TYPE,
1639 bank_charge_bearer
1640 IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
1641 delivery_channel
1642 IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1643 settle_priority
1644 IBY_DOCS_PAYABLE_ALL.settlement_priority%TYPE,
1645 supplier_message1
1646 IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
1647 supplier_message2
1648 IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
1649 supplier_message3
1650 IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,
1651 unique_remit_id
1652 IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1653 uri_checkdigit
1654 IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1655 pmt_reason_code
1656 IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
1657 pmt_reason_comments
1658 IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
1659 pmt_due_date
1660 IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1661 discount_date
1662 IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
1663 discount_amount
1664 IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
1665 benef_party
1666 IBY_DOCS_PAYABLE_ALL.beneficiary_party%TYPE,
1667 addr_source
1668 IBY_DOCS_PAYABLE_ALL.address_source%TYPE,
1669 emp_addr_code
1670 IBY_DOCS_PAYABLE_ALL.employee_address_code%TYPE,
1671 emp_person_id
1672 IBY_DOCS_PAYABLE_ALL.employee_person_id%TYPE,
1673 emp_address_id
1674 IBY_DOCS_PAYABLE_ALL.employee_address_id%TYPE,
1675 emp_payment_flag
1676 IBY_DOCS_PAYABLE_ALL.employee_payment_flag%TYPE,
1677 supplier_msg_flag
1678 IBY_PMT_CREATION_RULES.group_by_remittance_message%TYPE,
1679 bnk_chg_bearer_flag
1680 IBY_PMT_CREATION_RULES.group_by_bank_charge_bearer%TYPE,
1681 delv_channel_flag
1682 IBY_PMT_CREATION_RULES.group_by_delivery_channel%TYPE,
1683 settle_priority_flag
1684 IBY_PMT_CREATION_RULES.group_by_settle_priority_flag%TYPE,
1685 pmt_details_flag
1686 IBY_PMT_CREATION_RULES.group_by_payment_details_flag%TYPE,
1687 pmt_details_length
1688 IBY_PMT_CREATION_RULES.payment_details_length_limit%TYPE,
1689 payment_details_formula
1690 IBY_PMT_CREATION_RULES.payment_details_formula%TYPE,
1691 max_documents_flag
1692 IBY_PMT_CREATION_RULES.group_by_max_documents_flag%TYPE,
1693 max_documents_limit
1694 IBY_PMT_CREATION_RULES.max_documents_per_payment%TYPE,
1695 unique_remit_id_flag
1696 IBY_PMT_CREATION_RULES.group_by_unique_remit_id_flag%TYPE,
1697 pmt_reason_flag
1698 IBY_PMT_CREATION_RULES.group_by_payment_reason%TYPE,
1699 pmt_due_date_flag
1700 IBY_PMT_CREATION_RULES.group_by_due_date_flag%TYPE,
1701 processing_type
1702 IBY_PAYMENT_PROFILES.processing_type%TYPE,
1703 decl_option
1704 IBY_PAYMENT_PROFILES.declaration_option%TYPE,
1705 decl_only_fx_flag
1706 IBY_PAYMENT_PROFILES.dcl_only_foreign_curr_pmt_flag%TYPE,
1707 decl_curr_fx_rate_type
1708 IBY_PAYMENT_PROFILES.declaration_curr_fx_rate_type%TYPE,
1709 decl_curr_code
1710 IBY_PAYMENT_PROFILES.declaration_currency_code%TYPE,
1711 decl_threshold_amount
1712 IBY_PAYMENT_PROFILES.declaration_threshold_amount%TYPE,
1713 max_payment_amount
1714 IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,
1715 min_payment_amount
1716 IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,
1717 allow_zero_pmts_flag
1718 IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE,
1719 support_prom_notes_flag
1720 IBY_PAYMENT_METHODS_VL.support_bills_payable_flag%TYPE
1721 );
1722
1723 --
1724 -- Table of payment grouping criteria.
1725 --
1726 TYPE paymentGroupCriteriaTabType IS TABLE OF paymentGroupCriteriaType
1727 INDEX BY BINARY_INTEGER;
1728
1729 --
1730 -- These are payment related criteria that are passed
1731 -- in as part of the payment request. Payments should
1732 -- be validated using these criteria in addition to
1733 -- the usual payment validation rules.
1734 --
1735 TYPE payReqImposedCriteria IS RECORD (
1736 max_pmt_amt_limit
1737 IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,
1738 min_pmt_amt_limit
1739 IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,
1740 allow_zero_pmts_flag
1741 IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE
1742 );
1743
1744 --
1745 -- This record stores one validation set applicable to
1746 -- a particular payment.
1747 --
1748 TYPE paymentValSetsRec IS RECORD (
1749 val_assign_id
1750 IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1751 val_assign_entity_type
1752 IBY_VAL_ASSIGNMENTS.val_assignment_entity_type%TYPE,
1753 val_set_name
1754 IBY_VALIDATION_SETS_VL.validation_set_display_name%TYPE,
1755 val_set_code
1756 IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
1757 val_code_pkg
1758 IBY_VALIDATION_SETS_VL.validation_code_package%TYPE,
1759 val_code_entry_pt
1760 IBY_VALIDATION_SETS_VL.validation_code_entry_point%TYPE
1761 );
1762
1763 --
1764 -- Table of validation sets applicable to a particular payment
1765 --
1766 TYPE paymentValSetsTab IS TABLE OF paymentValSetsRec
1767 INDEX BY BINARY_INTEGER;
1768
1769 TYPE valSetsOuterRecType IS RECORD (
1770 val_set_count NUMBER,
1771 val_sets_tbl paymentValSetsTab
1772 );
1773
1774 --
1775 -- Table of validation set records
1776 --
1777 TYPE valSetsOuterTabType IS TABLE OF valSetsOuterRecType
1778 INDEX BY VARCHAR2(4000);
1779
1780 val_sets_outer_tbl valSetsOuterTabType;
1781
1782
1783
1784 --
1785 -- This record stores some elements of a row from
1786 -- the IBY_REMIT_ADVICE_SETUP table
1787 --
1788 TYPE remitAdviceRec IS RECORD (
1789 payment_profile_cd
1790 IBY_REMIT_ADVICE_SETUP.system_profile_code%TYPE,
1791 doc_count_limit
1792 IBY_REMIT_ADVICE_SETUP.document_count_limit%TYPE,
1793 pmt_details_len_limit
1794 IBY_REMIT_ADVICE_SETUP.payment_details_length_limit%TYPE,
1795 PAYMENT_DETAILS
1796 IBY_PAYMENTS_ALL.PAYMENT_DETAILS%TYPE,
1797 payment_id
1798 IBY_PAYMENTS_ALL.payment_id%TYPE,
1799 DOCUMENT_COUNT
1800 NUMBER
1801 );
1802
1803 --
1804 -- Table of remittance advice records
1805 --
1806 TYPE remitAdviceRecTab IS TABLE OF remitAdviceRec
1807 INDEX BY BINARY_INTEGER;
1808
1809 --
1810 -- System options record
1811 --
1812 TYPE sysOptionsRecType IS RECORD (
1813 rej_level IBY_INTERNAL_PAYERS_ALL.
1814 payment_rejection_level_code%TYPE,
1815 revw_flag IBY_INTERNAL_PAYERS_ALL.
1816 require_prop_pmts_review_flag%TYPE
1817 );
1818
1819 --
1820 -- System options table
1821 --
1822 TYPE sysOptionsTabType IS TABLE OF sysOptionsRecType
1823 INDEX BY BINARY_INTEGER;
1824
1825 --
1826 -- Table of payment ids.
1827 --
1828 TYPE pmtIdsTab IS TABLE OF IBY_PAYMENTS_ALL.payment_id%TYPE
1829 INDEX BY BINARY_INTEGER;
1830
1831 --
1832 -- Internal bank account with its corresponding legal entity id.
1833 --
1834 TYPE bankAccountLERecType IS RECORD (
1835 int_bank_acct_id CE_BANK_ACCOUNTS.bank_account_id%TYPE,
1836 le_id IBY_PAYMENTS_ALL.legal_entity_id%TYPE
1837 );
1838
1839 --
1840 -- Table of internal bank accounts each with its legal entity.
1841 --
1842 TYPE bankAccountLETabType IS TABLE OF bankAccountLERecType
1843 INDEX BY BINARY_INTEGER;
1844
1845 --
1846 -- Stores the denormalized data related to the payer, payee,
1847 -- payer bank and payee bank. This data is stamped onto
1848 -- the payment in IBY_PAYMENTS_ALL table for audit purposes.
1849 --
1850 TYPE paymentAuditRecType IS RECORD (
1851
1852 payment_id -- 01
1853 IBY_PAYMENTS_ALL.payment_id%TYPE,
1854
1855 /* PAYER RELATED */
1856 payer_party_number
1857 IBY_PAYMENTS_ALL.payer_party_number%TYPE,
1858 payer_party_site_name
1859 IBY_PAYMENTS_ALL.payer_party_site_name%TYPE,
1860 payer_legal_name
1861 IBY_PAYMENTS_ALL.payer_legal_entity_name%TYPE,
1862 payer_tax_reg_number
1863 IBY_PAYMENTS_ALL.payer_tax_registration_num%TYPE,
1864 payer_le_reg_number
1865 IBY_PAYMENTS_ALL.payer_le_registration_num%TYPE,
1866 payer_party_id
1867 IBY_PAYMENTS_ALL.payer_party_id%TYPE,
1868 payer_location_id
1869 IBY_PAYMENTS_ALL.payer_location_id%TYPE,
1870 payer_party_attr_cat
1871 IBY_PAYMENTS_ALL.payer_party_attr_category%TYPE,
1872 payer_le_attr_cat -- 10
1873 IBY_PAYMENTS_ALL.payer_le_attr_category%TYPE,
1874
1875 /* PAYER SPECIAL FIELDS */
1876 payer_abbrev_agency_code
1877 IBY_PAYMENTS_ALL.payer_abbreviated_agency_code%TYPE,
1878 payer_us_employer_id
1879 IBY_PAYMENTS_ALL.payer_federal_us_employer_id%TYPE,
1880
1881 /* PAYER BANK RELATED */
1882 payer_bank_name
1883 IBY_PAYMENTS_ALL.int_bank_name%TYPE,
1884 payer_bank_number
1885 IBY_PAYMENTS_ALL.int_bank_number%TYPE,
1886 payer_bank_branch_number
1887 IBY_PAYMENTS_ALL.int_bank_branch_number%TYPE,
1888 payer_bank_branch_name
1889 IBY_PAYMENTS_ALL.int_bank_branch_name%TYPE,
1890 payer_bank_swift_code
1891 IBY_PAYMENTS_ALL.int_eft_swift_code%TYPE,
1892 payer_bank_acct_num
1893 IBY_PAYMENTS_ALL.int_bank_account_number%TYPE,
1894 payer_bank_acct_name
1895 IBY_PAYMENTS_ALL.int_bank_account_name%TYPE,
1896 payer_bank_acct_iban -- 20
1897 IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE,
1898 payer_bank_agency_loc_code
1899 IBY_PAYMENTS_ALL.int_bank_acct_agency_loc_code%TYPE,
1900 payer_bank_branch_party_id
1901 IBY_PAYMENTS_ALL.int_bank_branch_party_id%TYPE,
1902 payer_bank_alt_name
1903 IBY_PAYMENTS_ALL.int_bank_alt_name%TYPE,
1904 payer_bank_branch_alt_name
1905 IBY_PAYMENTS_ALL.int_bank_branch_alt_name%TYPE,
1906 payer_bank_alt_account_name
1907 IBY_PAYMENTS_ALL.int_bank_account_alt_name%TYPE,
1908 payer_bank_account_num_elec
1909 IBY_PAYMENTS_ALL.int_bank_account_num_elec%TYPE,
1910 payer_bank_branch_location_id
1911 IBY_PAYMENTS_ALL.int_bank_branch_location_id%TYPE,
1912 payer_bank_branch_eft_user_num
1913 IBY_PAYMENTS_ALL.int_bank_branch_eft_user_num%TYPE,
1914
1915
1916 /* PAYEE RELATED */
1917 payee_party_number
1918 IBY_PAYMENTS_ALL.payee_party_number%TYPE,
1919 payee_party_name -- 30
1920 IBY_PAYMENTS_ALL.payee_party_name%TYPE,
1921 payee_name
1922 IBY_PAYMENTS_ALL.payee_name%TYPE,
1923 payee_name_alternate
1924 IBY_PAYMENTS_ALL.payee_alternate_name%TYPE,
1925 payee_add_line_1
1926 IBY_PAYMENTS_ALL.payee_address1%TYPE,
1927 payee_add_line_2
1928 IBY_PAYMENTS_ALL.payee_address2%TYPE,
1929 payee_add_line_3
1930 IBY_PAYMENTS_ALL.payee_address3%TYPE,
1931 payee_add_line_4
1932 IBY_PAYMENTS_ALL.payee_address4%TYPE,
1933 payee_city
1934 IBY_PAYMENTS_ALL.payee_city%TYPE,
1935 payee_county
1936 IBY_PAYMENTS_ALL.payee_county%TYPE,
1937 payee_province
1938 IBY_PAYMENTS_ALL.payee_province%TYPE,
1939 payee_state -- 40
1940 IBY_PAYMENTS_ALL.payee_state%TYPE,
1941 payee_country
1942 IBY_PAYMENTS_ALL.payee_country%TYPE,
1943 payee_postal_code
1944 IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
1945 payee_address_concat
1946 IBY_PAYMENTS_ALL.payee_address_concat%TYPE,
1947 beneficiary_name
1948 IBY_PAYMENTS_ALL.beneficiary_name%TYPE,
1949 payee_party_attr_cat
1950 IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
1951 payee_supplier_site_attr_cat
1952 IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE,
1953 payee_supplier_site_name
1954 IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
1955 payee_party_site_name
1956 IBY_PAYMENTS_ALL.payee_party_site_name%TYPE,
1957 payee_addressee
1958 IBY_PAYMENTS_ALL.payee_addressee%TYPE,
1959
1960 /* VENDOR RELATED */
1961 payee_site_name_alternate
1962 IBY_PAYMENTS_ALL.payee_site_alternate_name%TYPE,
1963 payee_supplier_number
1964 IBY_PAYMENTS_ALL.payee_supplier_number%TYPE,
1965 payee_first_party_ref -- 50
1966 IBY_PAYMENTS_ALL.payee_first_party_reference%TYPE,
1967 payee_supplier_attr_cat
1968 IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
1969 payee_supplier_id
1970 IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
1971
1972 /* PAYEE SPECIAL FIELDS */
1973 payee_tax_reg_number
1974 IBY_PAYMENTS_ALL.payee_tax_registration_num%TYPE,
1975 payee_le_reg_number
1976 IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE,
1977
1978 /* PAYEE BANK RELATED */
1979 payee_bank_name
1980 IBY_PAYMENTS_ALL.ext_bank_name%TYPE,
1981 payee_bank_number
1982 IBY_PAYMENTS_ALL.ext_bank_number%TYPE,
1983 payee_bank_branch_number
1984 IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
1985 payee_bank_branch_name
1986 IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
1987 payee_bank_acct_number
1988 IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
1989 payee_bank_acct_name -- 60
1990 IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
1991 payee_bank_acct_iban
1992 IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
1993 payee_bank_swift_code
1994 IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
1995 payee_bank_acct_type
1996 IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
1997 payee_bank_payment_factor_flag
1998 IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
1999 payee_bank_owner_party_id
2000 IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
2001 payee_bank_branch_party_id
2002 IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
2003 payee_bank_name_alt
2004 IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
2005 payee_bank_branch_name_alt
2006 IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
2007 payee_bank_alt_account_name
2008 IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
2009 payee_bank_electronic_acct_num -- 70
2010 IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
2011 payee_bank_branch_location_id
2012 IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE,
2013 payee_bank_acct_owner_name
2014 IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_name%TYPE,
2015
2016
2017 /* REMITTANCE ADVICE RELATED */
2018 remit_advice_delivery_method
2019 IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE,
2020 remit_advice_email
2021 IBY_PAYMENTS_ALL.remit_advice_email%TYPE,
2022 remit_advice_fax
2023 IBY_PAYMENTS_ALL.remit_advice_fax%TYPE,
2024
2025 /*
2026 * Fix for bug 5522421:
2027 *
2028 * sra_delivery_method is the same as
2029 * remit_advice_delivery_method and is
2030 * being obsoleted.
2031 */
2032 --remit_advice_delv_method
2033 -- IBY_PAYMENTS_ALL.sra_delivery_method%TYPE,
2034
2035 /* DELIVERY CHANNEL RELATED */
2036 delivery_channel_format
2037 IBY_PAYMENTS_ALL.delivery_channel_format_value%TYPE,
2038
2039 /* DECLARATION REPORT RELATED */
2040 decl_curr_fx_rate_type
2041 IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE,
2042 declaration_format
2043 IBY_PAYMENTS_ALL.declaration_format%TYPE,
2044
2045 /* PROFILE RELATED */
2046 payment_acct_profile_name -- 80
2047 IBY_PAYMENTS_ALL.payment_profile_acct_name%TYPE,
2048 payment_sys_profile_name
2049 IBY_PAYMENTS_ALL.payment_profile_sys_name%TYPE,
2050
2051 /* PAYMENT REASON */
2052 payment_reason_format
2053 IBY_PAYMENTS_ALL.payment_reason_format_value%TYPE,
2054
2055 /* BANK INSTRUCTION */
2056 bank_instr1_format
2057 IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE,
2058 bank_instr2_format
2059 IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE,
2060
2061 /* ORG */
2062 org_name
2063 IBY_PAYMENTS_ALL.org_name%TYPE,
2064
2065 /* RFC */
2066 payer_bank_branch_rfc_id
2067 IBY_PAYMENTS_ALL.int_bank_branch_rfc_identifier%TYPE,
2068
2069 /* REQUEST */
2070 ppr_name
2071 IBY_PAYMENTS_ALL.payment_process_request_name%TYPE,
2072 source_product -- 88
2073 IBY_PAYMENTS_ALL.source_product%TYPE,
2074 /*TPP-Start*/
2075
2076 inv_payee_name
2077 IBY_PAYMENTS_ALL.inv_payee_name%TYPE,
2078 inv_payee_address1
2079 IBY_PAYMENTS_ALL.inv_payee_address1%TYPE,
2080 inv_payee_address2
2081 IBY_PAYMENTS_ALL.inv_payee_address2%TYPE,
2082 inv_payee_address3
2083 IBY_PAYMENTS_ALL.inv_payee_address3%TYPE,
2084 inv_payee_address4
2085 IBY_PAYMENTS_ALL.inv_payee_address4%TYPE,
2086 inv_payee_city
2087 IBY_PAYMENTS_ALL.inv_payee_city%TYPE,
2088 inv_payee_postal_code
2089 IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE,
2090 inv_payee_state
2091 IBY_PAYMENTS_ALL.inv_payee_state%TYPE,
2092 inv_payee_province
2093 IBY_PAYMENTS_ALL.inv_payee_province%TYPE,
2094 inv_payee_county
2095 IBY_PAYMENTS_ALL.inv_payee_county%TYPE,
2096 inv_payee_country
2097 IBY_PAYMENTS_ALL.inv_payee_country%TYPE,
2098 inv_payee_party_name
2099 IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE,
2100 inv_payee_le_reg_num
2101 IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE,
2102 inv_payee_tax_reg_num
2103 IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE,
2104 inv_payee_address_concat
2105 IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE,
2106 inv_beneficiary_name
2107 IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE,
2108 inv_payee_party_number
2109 IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE,
2110 inv_payee_alternate_name
2111 IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE,
2112 inv_payee_site_alt_name
2113 IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE,
2114 inv_payee_supplier_number
2115 IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE,
2116 inv_payee_first_party_ref
2117 IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE,
2118 ext_bnk_acct_ownr_inv_prty_id
2119 IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE,
2120 ext_bnk_branch_inv_prty_id
2121 IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE,
2122 ext_bnk_acct_ownr_inv_prty_nme
2123 IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE,
2124 inv_payee_party_attr_cat
2125 IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE,
2126 inv_payee_supplier_attr_cat
2127 IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE,
2128 inv_payee_spplr_site_attr_cat
2129 IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE,
2130 inv_payee_supplier_site_name
2131 IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE,
2132 inv_payee_spplr_site_alt_name
2133 IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE,
2134 inv_payee_supplier_id
2135 IBY_PAYMENTS_ALL.inv_payee_supplier_id%TYPE
2136 /*TPP-End*/
2137
2138 );
2139
2140 --
2141 -- Table of internal bank accounts each with its legal entity.
2142 --
2143 TYPE paymentAuditTabType IS TABLE OF paymentAuditRecType
2144 INDEX BY BINARY_INTEGER;
2145
2146 --
2147 -- Central bank reporting record
2148 --
2149 TYPE centralBankReportRecType IS RECORD (
2150 payment_id IBY_PAYMENTS_ALL.
2151 payment_id%TYPE,
2152 decl_option IBY_PAYMENT_PROFILES.
2153 declaration_option%TYPE,
2154 decl_only_fx_flag IBY_PAYMENT_PROFILES.
2155 dcl_only_foreign_curr_pmt_flag%TYPE,
2156 decl_curr_fx_rate_type IBY_PAYMENT_PROFILES.
2157 declaration_curr_fx_rate_type%TYPE,
2158 decl_curr_code IBY_PAYMENT_PROFILES.
2159 declaration_currency_code%TYPE,
2160 decl_threshold_amount IBY_PAYMENT_PROFILES.
2161 declaration_threshold_amount%TYPE
2162 );
2163
2164 --
2165 -- Central bank reporting table
2166 --
2167 TYPE centralBankReportTabType IS TABLE OF centralBankReportRecType
2168 INDEX BY BINARY_INTEGER;
2169
2170 /*--------------------------------------------------------------------
2171 | NAME:
2172 | createPayments
2173 |
2174 | PURPOSE:
2175 |
2176 |
2177 |
2178 | PARAMETERS:
2179 | IN
2180 |
2181 |
2182 | OUT
2183 |
2184 |
2185 | RETURNS:
2186 |
2187 | NOTES:
2188 |
2189 *---------------------------------------------------------------------*/
2190 PROCEDURE createPayments(
2191 p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
2192 payment_service_request_id%TYPE,
2193 p_pmt_rejection_level IN IBY_INTERNAL_PAYERS_ALL.
2194 payment_rejection_level_code%TYPE,
2195 p_review_proposed_pmts_flag IN IBY_INTERNAL_PAYERS_ALL.
2196 require_prop_pmts_review_flag%TYPE,
2197 p_override_complete_point IN VARCHAR2,
2198 p_bill_payable_flag IN VARCHAR2,
2199 p_maturity_date IN DATE,
2200 p_calling_procedure IN VARCHAR2,
2201 x_return_status IN OUT NOCOPY VARCHAR2
2202 );
2203
2204 /*--------------------------------------------------------------------
2205 | NAME:
2206 | performDocumentGrouping
2207 |
2208 | PURPOSE:
2209 |
2210 |
2211 |
2212 | PARAMETERS:
2213 | IN
2214 |
2215 |
2216 | OUT
2217 |
2218 |
2219 | RETURNS:
2220 |
2221 | NOTES: Mark for Removal after Dependencies Checking
2222 |
2223 *---------------------------------------------------------------------*/
2224 PROCEDURE performDocumentGrouping(
2225 p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
2226 payment_service_request_id%TYPE,
2227 x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
2228 x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
2229 docsInPaymentTabType,
2230 x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2231 calling_app_id%TYPE,
2232 x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2233 call_app_pay_service_req_code
2234 %TYPE,
2235 x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
2236 payReqImposedCriteria
2237 -- ,x_cbrTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
2238 -- centralBankReportTabType
2239 );
2240
2241 /*--------------------------------------------------------------------
2242 | NAME:
2243 | performDocumentGrouping
2244 |
2245 | PURPOSE:
2246 |
2247 |
2248 |
2249 | PARAMETERS:
2250 | IN
2251 |
2252 |
2253 | OUT
2254 |
2255 |
2256 | RETURNS:
2257 |
2258 | NOTES:
2259 |
2260 *---------------------------------------------------------------------*/
2261 PROCEDURE performDocumentGrouping(
2262 p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
2263 payment_service_request_id%TYPE,
2264 -- x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
2265 x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2266 calling_app_id%TYPE,
2267 x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2268 call_app_pay_service_req_code
2269 %TYPE,
2270 x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
2271 payReqImposedCriteria
2272 -- ,x_cbrTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
2273 -- centralBankReportTabType
2274 );
2275
2276 /*--------------------------------------------------------------------
2277 | NAME:
2278 | insertDocIntoPayment
2279 |
2280 | PURPOSE:
2281 |
2282 |
2283 | PARAMETERS:
2284 | IN
2285 |
2286 |
2287 | OUT
2288 |
2289 |
2290 | RETURNS:
2291 |
2292 | NOTES: Mark for Removal after Dependencies Checking
2293 |
2294 *---------------------------------------------------------------------*/
2295 PROCEDURE insertDocIntoPayment(
2296 x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
2297 x_paymentTab IN OUT NOCOPY paymentTabType,
2298 p_calcDocInfo IN VARCHAR2,
2299 p_newPaymentFlag IN BOOLEAN,
2300 x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
2301 x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
2302 x_docsInPmtRec IN OUT NOCOPY docsInPaymentRecType,
2303 x_docsInPmtCount IN OUT NOCOPY NUMBER
2304 );
2305 /*--------------------------------------------------------------------
2306 | NAME:
2307 | insertDocIntoPayment
2308 |
2309 | PURPOSE:
2310 |
2311 |
2312 | PARAMETERS:
2313 | IN
2314 |
2315 |
2316 | OUT
2317 |
2318 |
2319 | RETURNS:
2320 |
2321 | NOTES: Mark for Removal after Dependencies Checking
2322 |
2323 *---------------------------------------------------------------------*/
2324 PROCEDURE insertDocIntoPayment(
2325 x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
2326 x_paymentTab IN OUT NOCOPY paymentTabType,
2327 p_calcDocInfo IN VARCHAR2,
2328 p_newPaymentFlag IN BOOLEAN,
2329 x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
2330 x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
2331 x_docsInPmtRec IN OUT NOCOPY docsInPaymentRecType,
2332 x_docsInPmtCount IN OUT NOCOPY NUMBER,
2333 x_commonAttributes IN OUT NOCOPY commonAttributesTabType
2334 );
2335
2336
2337 /*--------------------------------------------------------------------
2338 | NAME:
2339 | insertDocIntoPayment
2340 |
2341 | PURPOSE:
2342 |
2343 |
2344 | PARAMETERS:
2345 | IN
2346 |
2347 |
2348 | OUT
2349 |
2350 |
2351 | RETURNS:
2352 |
2353 | NOTES:
2354 |
2355 *---------------------------------------------------------------------*/
2356 PROCEDURE insertDocIntoPayment(
2357 x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
2358 -- x_paymentTab IN OUT NOCOPY paymentTabType,
2359 p_calcDocInfo IN VARCHAR2,
2360 p_newPaymentFlag IN BOOLEAN,
2361 x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
2362 x_docsInPmtCount IN OUT NOCOPY NUMBER,
2363 x_commonAttributes IN OUT NOCOPY commonAttributesTabType,
2364 p_trx_line_index IN BINARY_INTEGER
2365 );
2366
2367
2368
2369 /*--------------------------------------------------------------------
2370 | NAME:
2371 | insertPayments
2372 |
2373 | PURPOSE:
2374 |
2375 |
2376 |
2377 | PARAMETERS:
2378 | IN
2379 |
2380 |
2381 | OUT
2382 |
2383 |
2384 | RETURNS:
2385 |
2386 | NOTES:
2387 |
2388 *---------------------------------------------------------------------*/
2389 PROCEDURE insertPayments(
2390 p_paymentTab IN paymentTabType
2391 );
2392
2393 /*--------------------------------------------------------------------
2394 | NAME:
2395 | insertPayments
2396 |
2397 | PURPOSE:
2398 |
2399 |
2400 |
2401 | PARAMETERS:
2402 | IN
2403 |
2404 |
2405 | OUT
2406 |
2407 |
2408 | RETURNS:
2409 |
2410 | NOTES:
2411 |
2412 *---------------------------------------------------------------------*/
2413 PROCEDURE insertPayments;
2414
2415 /*--------------------------------------------------------------------
2416 | NAME:
2417 | updatePayments
2418 |
2419 | PURPOSE:
2420 | Performs an update of all created payments from PLSQL
2421 | table into IBY_PAYMENTS_ALL table.
2422 |
2423 | The created payments have already been inserted into
2424 | IBY_PAYMENTS_ALL after grouping. So we only need to update
2425 | certain fields of the payment that have been changed
2426 | after the grouping was performed.
2427 |
2428 | PARAMETERS:
2429 | IN
2430 |
2431 |
2432 | OUT
2433 |
2434 |
2435 | RETURNS:
2436 |
2437 | NOTES:
2438 |
2439 *---------------------------------------------------------------------*/
2440 PROCEDURE updatePayments(
2441 p_paymentTab IN paymentTabType
2442 );
2443
2444 /*--------------------------------------------------------------------
2445 | NAME:
2446 | getNextPaymentID
2447 |
2448 | PURPOSE:
2449 |
2450 |
2451 |
2452 | PARAMETERS:
2453 | IN
2454 |
2455 |
2456 | OUT
2457 |
2458 |
2459 | RETURNS:
2460 |
2461 | NOTES:
2462 |
2463 *---------------------------------------------------------------------*/
2464 PROCEDURE getNextPaymentID(
2465 x_paymentID IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE
2466 );
2467
2468 /*--------------------------------------------------------------------
2469 | NAME:
2470 | updateDocsWithPaymentID
2471 |
2472 | PURPOSE:
2473 |
2474 |
2475 |
2476 | PARAMETERS:
2477 | IN
2478 |
2479 |
2480 | OUT
2481 |
2482 |
2483 | RETURNS:
2484 |
2485 | NOTES: Mark for Removal after Dependencies Checking
2486 |
2487 *---------------------------------------------------------------------*/
2488 PROCEDURE updateDocsWithPaymentID(
2489 p_docsInPmtTab IN docsInPaymentTabType
2490 );
2491
2492
2493 /*--------------------------------------------------------------------
2494 | NAME:
2495 | updateDocsWithPaymentID
2496 |
2497 | PURPOSE:
2498 |
2499 |
2500 |
2501 | PARAMETERS:
2502 | IN
2503 |
2504 |
2505 | OUT
2506 |
2507 |
2508 | RETURNS:
2509 |
2510 | NOTES:
2511 |
2512 *---------------------------------------------------------------------*/
2513 PROCEDURE updateDocsWithPaymentID;
2514
2515
2516
2517
2518 /*--------------------------------------------------------------------
2519 | NAME:
2520 | updatePayments
2521 |
2522 | PURPOSE:
2523 |
2524 |
2525 |
2526 | PARAMETERS:
2527 | IN
2528 |
2529 |
2530 | OUT
2531 |
2532 |
2533 | RETURNS:
2534 |
2535 | NOTES:
2536 |
2537 *---------------------------------------------------------------------*/
2538 PROCEDURE updatePayments;
2539
2540
2541 /*--------------------------------------------------------------------
2542 | NAME:
2543 | performDBUpdates
2544 |
2545 | PURPOSE:
2546 | This is the top level method that is called by the
2547 | payment creation program to:
2548 | 1. insert payments to DB
2549 | 2. update documents with payment id
2550 | 3. update status of payment request
2551 |
2552 | This method will read the 'rejection level' system option
2553 | and do updates accordingly.
2554 |
2555 | PARAMETERS:
2556 | IN
2557 |
2558 |
2559 | OUT
2560 |
2561 |
2562 | RETURNS:
2563 |
2564 | NOTES: Mark for Removal after Dependencies Checking
2565 |
2566 *---------------------------------------------------------------------*/
2567 PROCEDURE performDBUpdates(
2568 p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
2569 payment_service_request_id%type,
2570 p_rej_level IN VARCHAR2,
2571 p_review_pmts_flag IN VARCHAR2,
2572 x_paymentTab IN OUT NOCOPY paymentTabType,
2573 x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
2574 x_allPmtsSuccessFlag IN OUT NOCOPY BOOLEAN,
2575 x_allPmtsFailedFlag IN OUT NOCOPY BOOLEAN,
2576 x_return_status IN OUT NOCOPY VARCHAR2,
2577 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
2578 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
2579 trxnErrTokenTabType
2580 );
2581
2582 /*--------------------------------------------------------------------
2583 | NAME:
2584 | performDBUpdates
2585 |
2586 | PURPOSE:
2587 | This is the top level method that is called by the
2588 | payment creation program to:
2589 | 1. insert payments to DB
2590 | 2. update documents with payment id
2591 | 3. update status of payment request
2592 |
2593 | This method will read the 'rejection level' system option
2594 | and do updates accordingly.
2595 |
2596 | PARAMETERS:
2597 | IN
2598 |
2599 |
2600 | OUT
2601 |
2602 |
2603 | RETURNS:
2604 |
2605 | NOTES:
2606 |
2607 *---------------------------------------------------------------------*/
2608 PROCEDURE performDBUpdates(
2609 p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
2610 payment_service_request_id%type,
2611 p_rej_level IN VARCHAR2,
2612 p_review_pmts_flag IN VARCHAR2,
2613 -- x_paymentTab IN OUT NOCOPY paymentTabType,
2614 -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
2615 x_allPmtsSuccessFlag IN OUT NOCOPY BOOLEAN,
2616 x_allPmtsFailedFlag IN OUT NOCOPY BOOLEAN,
2617 x_return_status IN OUT NOCOPY VARCHAR2,
2618 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
2619 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
2620 trxnErrTokenTabType
2621 );
2622
2623 /*--------------------------------------------------------------------
2624 | NAME:
2625 | performCentralBankReporting
2626 |
2627 | PURPOSE:
2628 |
2629 |
2630 |
2631 | PARAMETERS:
2632 | IN
2633 |
2634 |
2635 | OUT
2636 |
2637 |
2638 | RETURNS:
2639 |
2640 | NOTES: Mark for Removal after Dependencies Checking
2641 |
2642 *---------------------------------------------------------------------*/
2643 PROCEDURE performCentralBankReporting(
2644 x_paymentTab IN OUT NOCOPY paymentTabType,
2645 x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType
2646 -- ,p_cbrTab IN centralBankReportTabType
2647 );
2648
2649
2650 /*--------------------------------------------------------------------
2651 | NAME:
2652 | performCentralBankReporting
2653 |
2654 | PURPOSE:
2655 |
2656 |
2657 |
2658 | PARAMETERS:
2659 | IN
2660 |
2661 |
2662 | OUT
2663 |
2664 |
2665 | RETURNS:
2666 |
2667 | NOTES:
2668 |
2669 *---------------------------------------------------------------------*/
2670 PROCEDURE performCentralBankReporting(
2671 l_trx_cbr_index IN BINARY_INTEGER
2672 -- x_paymentTab IN OUT NOCOPY paymentTabType
2673 -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType
2674 -- ,p_cbrTab IN centralBankReportTabType
2675 );
2676
2677 /*--------------------------------------------------------------------
2678 | NAME:
2679 | flagSeparateRemitAdvicePmts
2680 |
2681 | PURPOSE:
2682 |
2683 |
2684 |
2685 | PARAMETERS:
2686 | IN
2687 |
2688 |
2689 | OUT
2690 |
2691 |
2692 | RETURNS:
2693 |
2694 | NOTES: Mark for Removal after Dependencies Checking
2695 |
2696 *---------------------------------------------------------------------*/
2697 PROCEDURE flagSeparateRemitAdvicePmts(
2698 x_paymentTab IN OUT NOCOPY paymentTabType,
2699 p_docsInPmtTab IN docsInPaymentTabType
2700 );
2701
2702 /*--------------------------------------------------------------------
2703 | NAME:
2704 | flagSeparateRemitAdvicePmts
2705 |
2706 | PURPOSE:
2707 |
2708 |
2709 |
2710 | PARAMETERS:
2711 | IN
2712 |
2713 |
2714 | OUT
2715 |
2716 |
2717 | RETURNS:
2718 |
2719 | NOTES:
2720 |
2721 *---------------------------------------------------------------------*/
2722 PROCEDURE flagSeparateRemitAdvicePmts(
2723 l_ca_payreq_cd IN VARCHAR2,
2724 ppr_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE
2725 -- x_paymentTab IN OUT NOCOPY paymentTabType
2726 -- p_docsInPmtTab IN docsInPaymentTabType
2727 );
2728
2729 /*--------------------------------------------------------------------
2730 | NAME:
2731 | getNumSuccessDocsPerPayment
2732 |
2733 | PURPOSE:
2734 |
2735 |
2736 |
2737 | PARAMETERS:
2738 | IN
2739 |
2740 |
2741 | OUT
2742 |
2743 |
2744 | RETURNS:
2745 |
2746 | NOTES: Mark for Removal after Dependencies Checking
2747 |
2748 *---------------------------------------------------------------------*/
2749 PROCEDURE getNumSuccessDocsPerPayment(
2750 x_paymentTab IN OUT NOCOPY paymentTabType,
2751 p_docsInPmtTab IN docsInPaymentTabType,
2752 x_successDocCountTab IN OUT NOCOPY successDocsCountPerPmtTab
2753 );
2754
2755 /*--------------------------------------------------------------------
2756 | NAME:
2757 | getNumSuccessDocsPerPayment
2758 |
2759 | PURPOSE:
2760 |
2761 |
2762 |
2763 | PARAMETERS:
2764 | IN
2765 |
2766 |
2767 | OUT
2768 |
2769 |
2770 | RETURNS:
2771 |
2772 | NOTES:
2773 |
2774 *---------------------------------------------------------------------*/
2775 PROCEDURE getNumSuccessDocsPerPayment(
2776 x_paymentTab IN OUT NOCOPY paymentTabType,
2777 -- p_docsInPmtTab IN docsInPaymentTabType,
2778 x_successDocCountTab IN OUT NOCOPY successDocsCountPerPmtTab
2779 );
2780
2781 /*--------------------------------------------------------------------
2782 | NAME:
2783 | getFxAmount()
2784 |
2785 | PURPOSE:
2786 | Calls GL API to get converted amount in foreign currency.
2787 |
2788 |
2789 | PARAMETERS:
2790 | IN
2791 |
2792 |
2793 | OUT
2794 |
2795 |
2796 | RETURNS:
2797 |
2798 | NOTES:
2799 |
2800 *---------------------------------------------------------------------*/
2801 FUNCTION getFxAmount(
2802 p_source_currency IN VARCHAR2,
2803 p_target_currency IN VARCHAR2,
2804 p_exch_rate_date IN DATE,
2805 p_exch_rate_type IN VARCHAR2,
2806 p_source_amount IN NUMBER
2807 )
2808 RETURN NUMBER;
2809
2810 /*
2811 * This pragma is needed because the GL API enforces it.
2812 */
2813 PRAGMA RESTRICT_REFERENCES(getFxAmount, WNDS, WNPS, RNPS);
2814
2815 /*--------------------------------------------------------------------
2816 | NAME:
2817 | performPaymentValidations
2818 |
2819 | PURPOSE:
2820 |
2821 |
2822 |
2823 | PARAMETERS:
2824 | IN
2825 |
2826 |
2827 | OUT
2828 |
2829 |
2830 | RETURNS:
2831 |
2832 | NOTES:
2833 |
2834 *---------------------------------------------------------------------*/
2835 PROCEDURE performPaymentValidations(
2836 p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
2837 payment_service_request_id%TYPE,
2838 x_paymentTab IN OUT NOCOPY paymentTabType,
2839 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
2840 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
2841 );
2842
2843 /*--------------------------------------------------------------------
2844 | NAME:
2845 | performPreHookProcess
2846 |
2847 | PURPOSE:
2848 |
2849 |
2850 |
2851 | PARAMETERS:
2852 | IN
2853 |
2854 | OUT
2855 |
2856 |
2857 | RETURNS:
2858 |
2859 | NOTES: Mark for Removal after Dependencies Checking
2860 |
2861 *---------------------------------------------------------------------*/
2862 PROCEDURE performPreHookProcess(
2863 p_cap_payreq_cd IN VARCHAR2,
2864 p_cap_id IN NUMBER,
2865 x_paymentTab IN OUT NOCOPY paymentTabType,
2866 x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
2867 x_hookPaymentTab IN OUT NOCOPY hookPaymentTabType,
2868 x_hookDocsInPmtTab IN OUT NOCOPY hookDocsInPaymentTabType
2869 );
2870
2871 /*--------------------------------------------------------------------
2872 | NAME:
2873 | performPreHookProcess
2874 |
2875 | PURPOSE:
2876 |
2877 |
2878 |
2879 | PARAMETERS:
2880 | IN
2881 |
2882 | OUT
2883 |
2884 |
2885 | RETURNS:
2886 |
2887 | NOTES:
2888 |
2889 *---------------------------------------------------------------------*/
2890 PROCEDURE performPreHookProcess(
2891 p_cap_payreq_cd IN VARCHAR2,
2892 p_ppr_id IN NUMBER,
2893 l_prehook_cnt OUT NOCOPY NUMBER,
2894 p_cap_id IN NUMBER
2895 -- x_paymentTab IN OUT NOCOPY paymentTabType,
2896 -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
2897 -- x_hookPaymentTab IN OUT NOCOPY hookPaymentTabType
2898 );
2899
2900 /*--------------------------------------------------------------------
2901 | NAME:
2902 | performPostHookProcess
2903 |
2904 | PURPOSE:
2905 |
2906 |
2907 |
2908 | PARAMETERS:
2909 | IN
2910 |
2911 | OUT
2912 |
2913 |
2914 | RETURNS:
2915 |
2916 | NOTES: Mark for Removal after Dependencies Checking
2917 |
2918 *---------------------------------------------------------------------*/
2919 PROCEDURE performPostHookProcess(
2920 x_paymentTab IN OUT NOCOPY paymentTabType,
2921 x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
2922 x_hookPaymentTab IN OUT NOCOPY hookPaymentTabType,
2923 x_hookDocsInPmtTab IN OUT NOCOPY hookDocsInPaymentTabType,
2924 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
2925 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
2926 trxnErrTokenTabType
2927 );
2928
2929 /*--------------------------------------------------------------------
2930 | NAME:
2931 | performPostHookProcess
2932 |
2933 | PURPOSE:
2934 |
2935 |
2936 |
2937 | PARAMETERS:
2938 | IN
2939 |
2940 | OUT
2941 |
2942 |
2943 | RETURNS:
2944 |
2945 | NOTES:
2946 |
2947 *---------------------------------------------------------------------*/
2948 PROCEDURE performPostHookProcess(
2949 -- x_paymentTab IN OUT NOCOPY paymentTabType,
2950 -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
2951 -- x_hookPaymentTab IN OUT NOCOPY hookPaymentTabType,
2952 -- x_hookDocsInPmtTab IN OUT NOCOPY hookDocsInPaymentTabType,
2953 p_cap_payreq_cd IN VARCHAR2,
2954 l_prehook_count IN NUMBER,
2955 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
2956 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
2957 trxnErrTokenTabType
2958 );
2959 /*--------------------------------------------------------------------
2960 | NAME:
2961 | adjustSisterDocsAndPmts
2962 |
2963 | PURPOSE:
2964 |
2965 |
2966 |
2967 | PARAMETERS:
2968 | IN
2969 |
2970 | OUT
2971 |
2972 |
2973 | RETURNS:
2974 |
2975 | NOTES: Mark for Removal after Dependencies Checking
2976 |
2977 *---------------------------------------------------------------------*/
2978 PROCEDURE adjustSisterDocsAndPmts(
2979 x_paymentTab IN OUT NOCOPY paymentTabType,
2980 x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
2981 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
2982 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
2983 trxnErrTokenTabType
2984 );
2985
2986 /*--------------------------------------------------------------------
2987 | NAME:
2988 | adjustSisterDocsAndPmts
2989 |
2990 | PURPOSE:
2991 |
2992 |
2993 |
2994 | PARAMETERS:
2995 | IN
2996 |
2997 | OUT
2998 |
2999 |
3000 | RETURNS:
3001 |
3002 | NOTES:
3003 |
3004 *---------------------------------------------------------------------*/
3005 PROCEDURE adjustSisterDocsAndPmts(
3006 -- x_paymentTab IN OUT NOCOPY paymentTabType,
3007 -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
3008 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3009 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
3010 trxnErrTokenTabType
3011 );
3012
3013
3014 PROCEDURE adjustSisterDocsAndPmtsPost(
3015 -- x_paymentTab IN OUT NOCOPY paymentTabType,
3016 -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
3017 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3018 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3019 );
3020
3021
3022
3023 /*--------------------------------------------------------------------
3024 | NAME:
3025 | handleJapaneseBankCharges
3026 |
3027 | PURPOSE:
3028 |
3029 |
3030 |
3031 | PARAMETERS:
3032 | IN
3033 |
3034 | OUT
3035 |
3036 |
3037 | RETURNS:
3038 |
3039 | NOTES: Mark for Removal after Dependencies Checking
3040 |
3041 *---------------------------------------------------------------------*/
3042 PROCEDURE handleJapaneseBankCharges(
3043 p_cap_payreq_cd IN VARCHAR2,
3044 p_cap_id IN NUMBER,
3045 x_paymentTab IN OUT NOCOPY paymentTabType,
3046 x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
3047 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3048 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
3049 trxnErrTokenTabType
3050 );
3051
3052 /*--------------------------------------------------------------------
3053 | NAME:
3054 | handleJapaneseBankCharges
3055 |
3056 | PURPOSE:
3057 |
3058 |
3059 |
3060 | PARAMETERS:
3061 | IN
3062 |
3063 | OUT
3064 |
3065 |
3066 | RETURNS:
3067 |
3068 | NOTES:
3069 |
3070 *---------------------------------------------------------------------*/
3071 PROCEDURE handleJapaneseBankCharges(
3072 p_cap_payreq_cd IN VARCHAR2,
3073 p_ppr_id IN NUMBER,
3074 p_cap_id IN NUMBER,
3075 -- x_paymentTab IN OUT NOCOPY paymentTabType,
3076 -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
3077 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3078 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
3079 trxnErrTokenTabType
3080 );
3081
3082 /*--------------------------------------------------------------------
3083 | NAME:
3084 | performExtendedWitholding
3085 |
3086 | PURPOSE:
3087 |
3088 |
3089 |
3090 | PARAMETERS:
3091 | IN
3092 |
3093 | OUT
3094 |
3095 |
3096 | RETURNS:
3097 |
3098 | NOTES: Mark for Removal after Dependencies Checking
3099 |
3100 *---------------------------------------------------------------------*/
3101 PROCEDURE performExtendedWitholding(
3102 p_cap_payreq_cd IN VARCHAR2,
3103 p_cap_id IN NUMBER,
3104 x_paymentTab IN OUT NOCOPY paymentTabType,
3105 x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
3106 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3107 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
3108 trxnErrTokenTabType
3109 );
3110
3111 /*--------------------------------------------------------------------
3112 | NAME:
3113 | performExtendedWitholding
3114 |
3115 | PURPOSE:
3116 |
3117 |
3118 |
3119 | PARAMETERS:
3120 | IN
3121 |
3122 | OUT
3123 |
3124 |
3125 | RETURNS:
3126 |
3127 | NOTES:
3128 |
3129 *---------------------------------------------------------------------*/
3130 PROCEDURE performExtendedWitholding(
3131 p_cap_payreq_cd IN VARCHAR2,
3132 p_ppr_id IN NUMBER,
3133 p_cap_id IN NUMBER,
3134 -- x_paymentTab IN OUT NOCOPY paymentTabType,
3135 -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
3136 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3137 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
3138 trxnErrTokenTabType
3139 );
3140
3141 /*--------------------------------------------------------------------
3142 | NAME:
3143 | getDocDetails
3144 |
3145 | PURPOSE:
3146 |
3147 |
3148 | PARAMETERS:
3149 | IN
3150 |
3151 |
3152 | OUT
3153 |
3154 |
3155 | RETURNS:
3156 |
3157 | NOTES:
3158 |
3159 *---------------------------------------------------------------------*/
3160 FUNCTION getDocDetails(
3161 p_documentID In NUMBER,
3162 p_pmtDetailsFormula IN VARCHAR2
3163 )
3164 RETURN VARCHAR2;
3165
3166 /*--------------------------------------------------------------------
3167 | NAME:
3168 | callHook
3169 |
3170 | PURPOSE:
3171 |
3172 |
3173 |
3174 | PARAMETERS:
3175 | IN
3176 |
3177 | OUT
3178 |
3179 |
3180 | RETURNS:
3181 |
3182 | NOTES:
3183 |
3184 *---------------------------------------------------------------------*/
3185 PROCEDURE callHook(
3186 p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
3187 payment_service_request_id%type
3188 );
3189
3190 /*--------------------------------------------------------------------
3191 | NAME:
3192 | getAdjustedPaymentData
3193 |
3194 | PURPOSE:
3195 |
3196 |
3197 | PARAMETERS:
3198 | IN
3199 |
3200 | OUT
3201 |
3202 |
3203 | RETURNS:
3204 |
3205 | NOTES: Mark for Removal after Dependencies Checking
3206 |
3207 *---------------------------------------------------------------------*/
3208 PROCEDURE getAdjustedPaymentData(
3209 x_hookPaymentTab IN OUT NOCOPY hookPaymentTabType,
3210 x_hookDocsInPmtTab IN OUT NOCOPY hookDocsInPaymentTabType
3211 );
3212
3213
3214 /*--------------------------------------------------------------------
3215 | NAME:
3216 | getAdjustedPaymentData
3217 |
3218 | PURPOSE:
3219 |
3220 |
3221 | PARAMETERS:
3222 | IN
3223 |
3224 | OUT
3225 |
3226 |
3227 | RETURNS:
3228 |
3229 | NOTES:
3230 |
3231 *---------------------------------------------------------------------*/
3232 PROCEDURE getAdjustedPaymentData(
3233 x_hookPaymentTab IN OUT NOCOPY hookPaymentTabType
3234 -- x_hookDocsInPmtTab IN OUT NOCOPY hookDocsInPaymentTabType
3235 );
3236
3237
3238 /*--------------------------------------------------------------------
3239 | NAME:
3240 | performPayReqBasedValidations
3241 |
3242 | PURPOSE:
3243 |
3244 |
3245 |
3246 | PARAMETERS:
3247 | IN
3248 |
3249 | OUT
3250 |
3251 |
3252 | RETURNS:
3253 |
3254 | NOTES:
3255 |
3256 *---------------------------------------------------------------------*/
3257 PROCEDURE performPayReqBasedValidations(
3258 p_payReqCriteria IN payReqImposedCriteria,
3259 -- x_paymentTab IN OUT NOCOPY paymentTabType,
3260 p_trx_pmt_line_index IN BINARY_INTEGER,
3261 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3262 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3263 );
3264
3265 /*--------------------------------------------------------------------
3266 | NAME:
3267 | performPmtGrpNumberValidation
3268 |
3269 | PURPOSE:
3270 |
3271 |
3272 |
3273 | PARAMETERS:
3274 | IN
3275 |
3276 | OUT
3277 |
3278 |
3279 | RETURNS:
3280 |
3281 | NOTES:
3282 |
3283 *---------------------------------------------------------------------*/
3284 PROCEDURE performPmtGrpNumberValidation(
3285 x_paymentTab IN OUT NOCOPY paymentTabType,
3286 x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
3287 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3288 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3289 );
3290
3291 /*--------------------------------------------------------------------
3292 | NAME:
3293 | failDocsOfPayment
3294 |
3295 | PURPOSE:
3296 | For a given payment id, this method sets all the documents of
3297 | that payment to 'failed' status in the PLSQL table of documents.
3298 |
3299 | PARAMETERS:
3300 | IN
3301 |
3302 | OUT
3303 |
3304 |
3305 | RETURNS:
3306 |
3307 | NOTES: Mark for Removal after Dependencies Checking
3308 |
3309 *---------------------------------------------------------------------*/
3310 PROCEDURE failDocsOfPayment(
3311 p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
3312 p_docStatus IN IBY_DOCS_PAYABLE_ALL.
3313 document_status%TYPE,
3314 x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
3315 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3316 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3317 );
3318
3319 /*--------------------------------------------------------------------
3320 | NAME:
3321 | failDocsOfPayment
3322 |
3323 | PURPOSE:
3324 | For a given payment id, this method sets all the documents of
3325 | that payment to 'failed' status in the PLSQL table of documents.
3326 |
3327 | PARAMETERS:
3328 | IN
3329 |
3330 | OUT
3331 |
3332 |
3333 | RETURNS:
3334 |
3335 | NOTES:
3336 |
3337 *---------------------------------------------------------------------*/
3338 PROCEDURE failDocsOfPayment(
3339 p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
3340 p_docStatus IN IBY_DOCS_PAYABLE_ALL.
3341 document_status%TYPE,
3342 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3343 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3344 );
3345
3346
3347 /*--------------------------------------------------------------------
3348 | NAME:
3349 | applyPaymentValidationSets
3350 |
3351 | PURPOSE:
3352 |
3353 |
3354 |
3355 | PARAMETERS:
3356 | IN
3357 |
3358 | OUT
3359 |
3360 |
3361 | RETURNS:
3362 |
3363 | NOTES:
3364 |
3365 *---------------------------------------------------------------------*/
3366 PROCEDURE applyPaymentValidationSets(
3367 p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
3368 payment_service_request_id%TYPE,
3369 --x_paymentTab IN OUT NOCOPY paymentTabType,
3370 l_trx_valid_index IN BINARY_INTEGER,
3371 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3372 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3373 );
3374
3375 /*--------------------------------------------------------------------
3376 | NAME:
3377 | raiseBizEvents
3378 |
3379 | PURPOSE:
3380 |
3381 |
3382 |
3383 | PARAMETERS:
3384 | IN
3385 |
3386 | OUT
3387 |
3388 |
3389 | RETURNS:
3390 |
3391 | NOTES:
3392 |
3393 *---------------------------------------------------------------------*/
3394 PROCEDURE raiseBizEvents(
3395 p_payreq_id IN VARCHAR2,
3396 p_cap_payreq_cd IN VARCHAR2,
3397 p_cap_id IN NUMBER,
3398 p_rej_level IN VARCHAR2,
3399 p_review_pmts_flag IN VARCHAR2,
3400 p_allPmtsSuccessFlag IN BOOLEAN,
3401 p_allPmtsFailedFlag IN BOOLEAN
3402 );
3403
3404 /*--------------------------------------------------------------------
3405 | NAME:
3406 | getXMLClob
3407 |
3408 | PURPOSE:
3409 |
3410 |
3411 |
3412 | PARAMETERS:
3413 | IN
3414 |
3415 | OUT
3416 |
3417 |
3418 | RETURNS:
3419 |
3420 | NOTES:
3421 |
3422 *---------------------------------------------------------------------*/
3423 FUNCTION getXMLClob(
3424 p_payreq_id IN VARCHAR2
3425 )
3426 RETURN CLOB;
3427
3428 /*--------------------------------------------------------------------
3429 | NAME:
3430 | getRejectedDocs
3431 |
3432 | PURPOSE:
3433 | Performs a database query to get all failed documents which
3434 | are part of payments created for the given payment request.
3435 | These failed documents are put into data structure and
3436 | returned to the caller.
3437 |
3438 |
3439 | PARAMETERS:
3440 | IN
3441 |
3442 | OUT
3443 |
3444 |
3445 | RETURNS:
3446 |
3447 | NOTES:
3448 |
3449 |
3450 *---------------------------------------------------------------------*/
3451 PROCEDURE getRejectedDocs(
3452 p_payreq_id IN VARCHAR2,
3453 x_docIDTab IN OUT NOCOPY IBY_DISBURSE_UI_API_PUB_PKG.docPayIDTab,
3454 x_docStatusTab IN OUT NOCOPY IBY_DISBURSE_UI_API_PUB_PKG.docPayStatusTab
3455 );
3456
3457 /*--------------------------------------------------------------------
3458 | NAME:
3459 | checkIfPmtAlreadyFailed
3460 |
3461 | PURPOSE:
3462 |
3463 |
3464 |
3465 | PARAMETERS:
3466 | IN
3467 |
3468 | OUT
3469 |
3470 |
3471 | RETURNS:
3472 |
3473 | NOTES:
3474 |
3475 *---------------------------------------------------------------------*/
3476 FUNCTION checkIfPmtAlreadyFailed(
3477 p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
3478 p_paymentTab IN paymentTabType
3479 )
3480 RETURN BOOLEAN;
3481
3482 /*--------------------------------------------------------------------
3483 | NAME:
3484 | checkIfPmtAlreadyAdded
3485 |
3486 | PURPOSE:
3487 | Checks if a payment has already been added to the list of
3488 | negative amount payments that qualify for credit memo adjustment.
3489 | If yes, this method returns TRUE; else, it return FALSE.
3490 |
3491 | PARAMETERS:
3492 | IN
3493 |
3494 | OUT
3495 |
3496 |
3497 | RETURNS:
3498 |
3499 | NOTES:
3500 |
3501 *---------------------------------------------------------------------*/
3502 FUNCTION checkIfPmtAlreadyAdded(
3503 p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
3504 p_paymentTab IN pmtIdsTab
3505 )
3506 RETURN BOOLEAN;
3507
3508 /*--------------------------------------------------------------------
3509 | NAME:
3510 | performCreditMemoHandling
3511 |
3512 | PURPOSE:
3513 |
3514 |
3515 |
3516 | PARAMETERS:
3517 | IN
3518 |
3519 | OUT
3520 |
3521 |
3522 | RETURNS:
3523 |
3524 | NOTES:
3525 |
3526 *---------------------------------------------------------------------*/
3527 PROCEDURE performCreditMemoHandling(
3528 x_paymentTab IN OUT NOCOPY paymentTabType,
3529 x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType
3530 );
3531
3532
3533 /*--------------------------------------------------------------------
3534 | NAME:
3535 | adjustCreditMemosWithinPmt
3536 |
3537 | PURPOSE:
3538 |
3539 |
3540 |
3541 | PARAMETERS:
3542 | IN
3543 |
3544 | OUT
3545 |
3546 |
3547 | RETURNS:
3548 |
3549 | NOTES:
3550 |
3551 *---------------------------------------------------------------------*/
3552 PROCEDURE adjustCreditMemosWithinPmt(
3553 p_qualifyingPmtsTab IN pmtIdsTab,
3554 x_paymentTab IN OUT NOCOPY paymentTabType,
3555 x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType
3556 );
3557
3558 /*--------------------------------------------------------------------
3559 | NAME:
3560 | performMaturityDateCalculation
3561 |
3562 | PURPOSE:
3563 |
3564 |
3565 |
3566 | PARAMETERS:
3567 | IN
3568 |
3569 | OUT
3570 |
3571 |
3572 | RETURNS:
3573 |
3574 | NOTES: Mark for Removal after Dependencies Checking
3575 |
3576 *---------------------------------------------------------------------*/
3577 PROCEDURE performMaturityDateCalculation(
3578 x_paymentTab IN OUT NOCOPY paymentTabType,
3579 p_docsInPmtTab IN docsInPaymentTabType
3580 );
3581
3582
3583
3584 /*--------------------------------------------------------------------
3585 | NAME:
3586 | performMaturityDateCalculation
3587 |
3588 | PURPOSE:
3589 |
3590 |
3591 |
3592 | PARAMETERS:
3593 | IN
3594 |
3595 | OUT
3596 |
3597 |
3598 | RETURNS:
3599 |
3600 | NOTES:
3601 |
3602 *---------------------------------------------------------------------*/
3603 PROCEDURE performMaturityDateCalculation(
3604 p_trx_mat_index IN BINARY_INTEGER
3605 );
3606
3607
3608
3609
3610 /*--------------------------------------------------------------------
3611 | NAME:
3612 | loadPmtMethodMaturityDays
3613 |
3614 | PURPOSE:
3615 |
3616 |
3617 |
3618 | PARAMETERS:
3619 | IN
3620 |
3621 | OUT
3622 |
3623 |
3624 | RETURNS:
3625 |
3626 | NOTES: Mark for Removal after Dependencies Checking
3627 |
3628 *---------------------------------------------------------------------*/
3629 PROCEDURE loadPmtMethodMaturityDays(
3630 x_maturityDaysTab IN OUT NOCOPY pmtMethodMaturityDaysTab
3631 );
3632
3633 /*--------------------------------------------------------------------
3634 | NAME:
3635 | getMaturityDaysForPmtMethod
3636 |
3637 | PURPOSE:
3638 |
3639 |
3640 |
3641 | PARAMETERS:
3642 | IN
3643 |
3644 | OUT
3645 |
3646 |
3647 | RETURNS:
3648 |
3649 | NOTES: Mark for Removal after Dependencies Checking
3650 |
3651 *---------------------------------------------------------------------*/
3652 FUNCTION getMaturityDaysForPmtMethod(
3653 p_pmt_method_code IN IBY_PAYMENTS_ALL.payment_method_code%TYPE,
3654 p_maturityDaysTab IN pmtMethodMaturityDaysTab
3655 ) RETURN NUMBER;
3656
3657 /*--------------------------------------------------------------------
3658 | NAME:
3659 | getMaturityDaysForPmtMethod
3660 |
3661 | PURPOSE:
3662 |
3663 |
3664 |
3665 | PARAMETERS:
3666 | IN
3667 |
3668 | OUT
3669 |
3670 |
3671 | RETURNS:
3672 |
3673 | NOTES:
3674 |
3675 *---------------------------------------------------------------------*/
3676 FUNCTION getMaturityDaysForPmtMethod(
3677 p_pmt_method_code IN IBY_PAYMENTS_ALL.payment_method_code%TYPE
3678 ) RETURN NUMBER;
3679
3680 /*--------------------------------------------------------------------
3681 | NAME:
3682 | refreshDocAndPmtAmounts
3683 |
3684 | PURPOSE:
3685 |
3686 |
3687 |
3688 | PARAMETERS:
3689 | IN
3690 |
3691 | OUT
3692 |
3693 |
3694 | RETURNS:
3695 |
3696 | NOTES:
3697 |
3698 *---------------------------------------------------------------------*/
3699 PROCEDURE refreshDocAndPmtAmounts(
3700 p_adjustedPmtId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
3701 p_adjustedNegDocsTab IN docsInPaymentTabType,
3702 x_paymentTab IN OUT NOCOPY paymentTabType,
3703 x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType
3704 );
3705
3706 /*--------------------------------------------------------------------
3707 | NAME:
3708 | getListOfQualifyingNegPmts
3709 |
3710 | PURPOSE:
3711 |
3712 |
3713 |
3714 | PARAMETERS:
3715 | IN
3716 |
3717 | OUT
3718 |
3719 |
3720 | RETURNS:
3721 |
3722 | NOTES:
3723 |
3724 *---------------------------------------------------------------------*/
3725 PROCEDURE getListOfQualifyingNegPmts(
3726 x_negPmtsTab IN OUT NOCOPY pmtIdsTab,
3727 p_paymentTab IN paymentTabType,
3728 p_docsInPmtTab IN docsInPaymentTabType
3729 );
3730
3731 /*--------------------------------------------------------------------
3732 | NAME:
3733 | dummyGLAPI
3734 |
3735 | PURPOSE:
3736 |
3737 |
3738 |
3739 | PARAMETERS:
3740 | IN
3741 |
3742 | OUT
3743 |
3744 |
3745 | RETURNS:
3746 |
3747 | NOTES:
3748 |
3749 *---------------------------------------------------------------------*/
3750 PROCEDURE dummyGLAPI(
3751 p_exch_date IN DATE,
3752 p_source_amount IN NUMBER,
3753 p_source_curr IN VARCHAR2,
3754 p_decl_curr IN VARCHAR2,
3755 p_decl_fx_rate_type IN VARCHAR2,
3756 x_decl_amount OUT NOCOPY NUMBER);
3757
3758 /*--------------------------------------------------------------------
3759 | NAME:
3760 | dummy_paymentsAdjustHook
3761 |
3762 | PURPOSE:
3763 |
3764 |
3765 |
3766 | PARAMETERS:
3767 | IN
3768 |
3769 | OUT
3770 |
3771 |
3772 | RETURNS:
3773 |
3774 | NOTES:
3775 |
3776 *---------------------------------------------------------------------*/
3777 PROCEDURE dummy_paymentsAdjustHook(
3778 x_paymentTab IN OUT NOCOPY hookPaymentTabType,
3779 x_docsInPmtTab IN OUT NOCOPY hookDocsInPaymentTabType
3780 );
3781
3782 /*--------------------------------------------------------------------
3783 | NAME:
3784 | dummy_ruleFunction
3785 |
3786 | PURPOSE:
3787 | Dummy method; to be used for testing purposes.
3788 |
3789 |
3790 | PARAMETERS:
3791 | IN
3792 |
3793 | OUT
3794 |
3795 |
3796 | RETURNS:
3797 |
3798 | NOTES:
3799 |
3800 *---------------------------------------------------------------------*/
3801 FUNCTION dummy_ruleFunction(
3802 p_subscription IN RAW,
3803 p_event IN OUT NOCOPY WF_EVENT_T
3804 )
3805 RETURN VARCHAR2;
3806
3807 /*--------------------------------------------------------------------
3808 | NAME:
3809 | printDocsInPmtTab
3810 |
3811 | PURPOSE:
3812 |
3813 |
3814 |
3815 | PARAMETERS:
3816 | IN
3817 |
3818 | OUT
3819 |
3820 |
3821 | RETURNS:
3822 |
3823 | NOTES:
3824 |
3825 *---------------------------------------------------------------------*/
3826 PROCEDURE printDocsInPmtTab(
3827 p_docsInPmtTab IN docsInPaymentTabType
3828 );
3829
3830 /*--------------------------------------------------------------------
3831 | NAME:
3832 | getPmtRejLevelSysOption
3833 |
3834 | PURPOSE:
3835 | Gets the payment rejection level system option.
3836 |
3837 | The handling of payment validation failures is dependent
3838 | upon the rejection level setting.
3839 |
3840 | PARAMETERS:
3841 | IN
3842 |
3843 |
3844 | OUT
3845 |
3846 |
3847 | RETURNS:
3848 |
3849 | NOTES:
3850 |
3851 *---------------------------------------------------------------------*/
3852 FUNCTION getPmtRejLevelSysOption RETURN VARCHAR2;
3853
3854 /*--------------------------------------------------------------------
3855 | NAME:
3856 | getReviewPmtsSysOption
3857 |
3858 | PURPOSE:
3859 | Gets the review payment flag system option.
3860 |
3861 | PARAMETERS:
3862 | IN
3863 |
3864 |
3865 | OUT
3866 |
3867 |
3868 | RETURNS:
3869 |
3870 | NOTES:
3871 |
3872 *---------------------------------------------------------------------*/
3873 FUNCTION getReviewPmtsSysOption RETURN VARCHAR2;
3874
3875 /*--------------------------------------------------------------------
3876 | NAME:
3877 | populateLEsOnPmts
3878 |
3879 | PURPOSE:
3880 |
3881 |
3882 | PARAMETERS:
3883 | IN
3884 |
3885 |
3886 | OUT
3887 |
3888 |
3889 | RETURNS:
3890 |
3891 | NOTES:
3892 |
3893 *---------------------------------------------------------------------*/
3894 PROCEDURE populateLEsOnPmts(
3895 x_paymentTab IN OUT NOCOPY paymentTabType,
3896 p_bankAccountLEs IN bankAccountLETabType
3897 );
3898
3899 /*--------------------------------------------------------------------
3900 | NAME:
3901 | initializePmts
3902 |
3903 | PURPOSE:
3904 |
3905 |
3906 | PARAMETERS:
3907 | IN
3908 |
3909 |
3910 | OUT
3911 |
3912 |
3913 | RETURNS:
3914 |
3915 | NOTES:
3916 |
3917 *---------------------------------------------------------------------*/
3918 PROCEDURE initializePmts(
3919 x_paymentTab IN OUT NOCOPY paymentTabType
3920 );
3921
3922 /*--------------------------------------------------------------------
3923 | NAME:
3924 | get_payreq_status
3925 |
3926 |
3927 | PURPOSE:
3928 |
3929 |
3930 | PARAMETERS:
3931 | IN
3932 |
3933 |
3934 | OUT
3935 |
3936 |
3937 | RETURNS:
3938 |
3939 | NOTES:
3940 |
3941 *---------------------------------------------------------------------*/
3942 FUNCTION get_payreq_status (
3943 l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
3944 RETURN VARCHAR2;
3945
3946 /*--------------------------------------------------------------------
3947 | NAME:
3948 | rebuildPayments
3949 |
3950 | PURPOSE:
3951 |
3952 |
3953 |
3954 | PARAMETERS:
3955 | IN
3956 |
3957 |
3958 | OUT
3959 |
3960 |
3961 | RETURNS:
3962 |
3963 | NOTES: Mark for Removal after Dependencies Checking
3964 |
3965 *---------------------------------------------------------------------*/
3966 PROCEDURE rebuildPayments(
3967 p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
3968 payment_service_request_id%TYPE,
3969 x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
3970 x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
3971 docsInPaymentTabType,
3972 x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
3973 calling_app_id%TYPE,
3974 x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
3975 call_app_pay_service_req_code
3976 %TYPE,
3977 x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
3978 payReqImposedCriteria
3979 -- ,x_cbrTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
3980 -- centralBankReportTabType
3981 );
3982
3983 /*--------------------------------------------------------------------
3984 | NAME:
3985 | rebuildPayments
3986 |
3987 | PURPOSE:
3988 |
3989 |
3990 |
3991 | PARAMETERS:
3992 | IN
3993 |
3994 |
3995 | OUT
3996 |
3997 |
3998 | RETURNS:
3999 |
4000 | NOTES:
4001 |
4002 *---------------------------------------------------------------------*/
4003 PROCEDURE rebuildPayments(
4004 p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
4005 payment_service_request_id%TYPE,
4006 x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
4007 -- x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
4008 -- docsInPaymentTabType,
4009 x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
4010 calling_app_id%TYPE,
4011 x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
4012 call_app_pay_service_req_code
4013 %TYPE,
4014 x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
4015 payReqImposedCriteria
4016 -- ,x_cbrTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
4017 -- centralBankReportTabType
4018 );
4019
4020
4021 /*--------------------------------------------------------------------
4022 | NAME:
4023 | auditPaymentData
4024 |
4025 | PURPOSE:
4026 |
4027 |
4028 |
4029 | PARAMETERS:
4030 | IN
4031 |
4032 |
4033 | OUT
4034 |
4035 |
4036 | RETURNS:
4037 |
4038 | NOTES:
4039 |
4040 *---------------------------------------------------------------------*/
4041 PROCEDURE auditPaymentData(
4042 l_trx_audit_index IN BINARY_INTEGER
4043 );
4044
4045 /*--------------------------------------------------------------------
4046 | NAME:
4047 | insertAuditData
4048 |
4049 | PURPOSE:
4050 |
4051 |
4052 | PARAMETERS:
4053 | IN
4054 |
4055 |
4056 | OUT
4057 |
4058 |
4059 | RETURNS:
4060 |
4061 | NOTES:
4062 |
4063 *---------------------------------------------------------------------*/
4064 PROCEDURE insertAuditData(
4065 p_auditPmtTab IN paymentAuditTabType
4066 );
4067
4068 /*--------------------------------------------------------------------
4069 | NAME:
4070 | sweepCommonPmtAttributes
4071 |
4072 | PURPOSE:
4073 |
4074 |
4075 | PARAMETERS:
4076 | IN
4077 |
4078 |
4079 | OUT
4080 |
4081 |
4082 | RETURNS:
4083 |
4084 | NOTES:
4085 |
4086 *---------------------------------------------------------------------*/
4087 PROCEDURE sweepCommonPmtAttributes (
4088 x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
4089 x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType
4090 );
4091
4092 /*--------------------------------------------------------------------
4093 | NAME:
4094 | GET_PAYER_INFO
4095 |
4096 | PURPOSE:
4097 |
4098 |
4099 |
4100 | PARAMETERS:
4101 | IN
4102 |
4103 |
4104 | OUT
4105 |
4106 |
4107 | RETURNS:
4108 |
4109 | NOTES:
4110 |
4111 |
4112 |
4113 *---------------------------------------------------------------------*/
4114 PROCEDURE GET_PAYER_INFO(
4115 l_trx_payer_index IN BINARY_INTEGER
4116 );
4117
4118
4119
4120 /*--------------------------------------------------------------------
4121 | NAME:
4122 | GET_PAYER_ACCT_INFO
4123 |
4124 | PURPOSE:
4125 |
4126 |
4127 |
4128 | PARAMETERS:
4129 | IN
4130 |
4131 |
4132 | OUT
4133 |
4134 |
4135 | RETURNS:
4136 |
4137 | NOTES:
4138 |
4139 |
4140 |
4141 *---------------------------------------------------------------------*/
4142 PROCEDURE GET_PAYER_ACCT_INFO(
4143 l_trx_acct_index IN BINARY_INTEGER
4144 );
4145
4146
4147 /*--------------------------------------------------------------------
4148 | NAME:
4149 | GET_VENDOR_INFO
4150 |
4151 | PURPOSE:
4152 |
4153 |
4154 |
4155 | PARAMETERS:
4156 | IN
4157 |
4158 |
4159 | OUT
4160 |
4161 |
4162 | RETURNS:
4163 |
4164 | NOTES:
4165 |
4166 |
4167 |
4168 *---------------------------------------------------------------------*/
4169 PROCEDURE GET_VENDOR_INFO(
4170 l_trx_vend_index IN BINARY_INTEGER
4171 );
4172
4173 PROCEDURE GET_PAYEE(
4174 l_trx_payee_index IN BINARY_INTEGER
4175 );
4176
4177 /*--------------------------------------------------------------------
4178 | NAME:
4179 | GET_PAYEE_SITE_INFO
4180 |
4181 | PURPOSE:
4182 |
4183 |
4184 |
4185 | PARAMETERS:
4186 | IN
4187 |
4188 |
4189 | OUT
4190 |
4191 |
4192 | RETURNS:
4193 |
4194 | NOTES:
4195 |
4196 |
4197 |
4198 *---------------------------------------------------------------------*/
4199 PROCEDURE GET_PAYEE_SITE_INFO(
4200 l_trx_payee_index IN BINARY_INTEGER
4201 );
4202
4203
4204
4205 /*--------------------------------------------------------------------
4206 | NAME:
4207 | GET_PAYEE_ADDR_INFO
4208 |
4209 | PURPOSE:
4210 |
4211 |
4212 |
4213 | PARAMETERS:
4214 | IN
4215 |
4216 |
4217 | OUT
4218 |
4219 |
4220 | RETURNS:
4221 |
4222 | NOTES:
4223 |
4224 |
4225 |
4226 *---------------------------------------------------------------------*/
4227 PROCEDURE GET_PAYEE_ADDR_INFO(
4228 l_trx_paye_adr_index IN BINARY_INTEGER
4229 );
4230
4231 /*--------------------------------------------------------------------
4232 | NAME:
4233 | GET_PAYEE_BANK_INFO
4234 |
4235 | PURPOSE:
4236 |
4237 |
4238 |
4239 | PARAMETERS:
4240 | IN
4241 |
4242 |
4243 | OUT
4244 |
4245 |
4246 | RETURNS:
4247 |
4248 | NOTES:
4249 |
4250 |
4251 |
4252 *---------------------------------------------------------------------*/
4253 PROCEDURE GET_PAYEE_BANK_INFO(
4254 l_trx_payee_bnk_index IN BINARY_INTEGER
4255 );
4256
4257
4258 PROCEDURE GET_REMITTANCE_INFO(
4259 l_trx_acct_index IN BINARY_INTEGER
4260 );
4261
4262
4263 PROCEDURE GET_PPR_INFO(
4264 l_trx_ppr_index IN BINARY_INTEGER
4265 );
4266
4267 PROCEDURE GET_DELIVERY_INFO(
4268 l_trx_delv_index IN BINARY_INTEGER
4269 );
4270
4271 PROCEDURE GET_ORG_INFO(
4272 l_trx_org_index IN BINARY_INTEGER
4273 );
4274
4275 PROCEDURE GET_PMTREASON_INFO(
4276 l_trx_pmtr_index IN BINARY_INTEGER
4277 );
4278
4279
4280
4281 PROCEDURE populatepmtTable(
4282 ppr_id IN IBY_PAYMENTS_ALL.PAYMENT_SERVICE_REQUEST_ID%type
4283 );
4284
4285 /*--------------------------------------------------------------------
4286 | NAME:
4287 | negativePmtAmountCheck
4288 |
4289 | PURPOSE: Validation to check that payment amount is not a negative
4290 |value
4291 |
4292 | PARAMETERS:
4293 | IN
4294 |
4295 |
4296 | OUT
4297 |
4298 |
4299 | RETURNS:
4300 |
4301 | NOTES: Added for the bug 7344352
4302 |
4303 *---------------------------------------------------------------------*/
4304 PROCEDURE negativePmtAmountCheck(
4305 p_trx_pmt_line_index IN BINARY_INTEGER,
4306 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
4307 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
4308 );
4309
4310 /*--------------------------------------------------------------------
4311 | NAME:
4312 | initialize_pmt_table
4313 |
4314 | PURPOSE:
4315 |
4316 |
4317 | PARAMETERS:
4318 | IN
4319 |
4320 |
4321 | OUT
4322 |
4323 |
4324 | RETURNS:
4325 |
4326 | NOTES:
4327 |
4328 *---------------------------------------------------------------------*/
4329
4330 PROCEDURE initialize_pmt_table(l_trx_pmt_index IN BINARY_INTEGER);
4331
4332 END IBY_PAYGROUP_PUB;