1 PACKAGE IBY_DISBURSE_SUBMIT_PUB_PKG AUTHID CURRENT_USER AS
2 /*$Header: ibybilds.pls 120.28.12020000.3 2013/02/25 10:15:41 kchavali ship $*/
3
4 TYPE payreq_tbl_type IS TABLE of iby_pay_service_requests.
5 payment_service_request_id%TYPE
6 INDEX BY BINARY_INTEGER;
7
8 --
9 -- These two records store the distinct payment
10 -- functions, and orgs that are present in a
11 -- payment request.
12 --
13 -- The disbursement UI uses the data in this table to
14 -- restrict access to the user (depending upon the
15 -- users' payment function and organization).
16 --
17 --
18 -- Table of distinct access types.
19 --
20 TYPE distinctPmtFxAccessTab IS TABLE OF IBY_PROCESS_FUNCTIONS%ROWTYPE
21 INDEX BY BINARY_INTEGER;
22
23 TYPE distinctOrgAccessTab IS TABLE OF IBY_PROCESS_ORGS%ROWTYPE
24 INDEX BY BINARY_INTEGER;
25
26 -- Bug 5709596
27 -- Table of Payment Process Profiles
28 --
29 TYPE paymentProfilesTabType IS TABLE OF IBY_PAYMENT_PROFILES%ROWTYPE
30 INDEX BY BINARY_INTEGER;
31
32 paymentProfilesTab paymentProfilesTabType;
33
34 --
35 -- Record that stores the default processing attributes derived
36 -- from the payment profile. These processing attributes are
37 -- used in payment instruction creation.
38 --
39 TYPE profileProcessAttribs IS RECORD (
40 processing_type
41 IBY_SYS_PMT_PROFILES_B.processing_type%TYPE,
42 payment_doc_id
43 CE_PAYMENT_DOCUMENTS.payment_document_id%TYPE,
44 printer_name
45 IBY_SYS_PMT_PROFILES_B.default_printer%TYPE,
46 print_now_flag
47 IBY_SYS_PMT_PROFILES_B.print_instruction_immed_flag%TYPE,
48 transmit_now_flag
49 IBY_SYS_PMT_PROFILES_B.transmit_instr_immed_flag%TYPE
50 );
51
52 TYPE t_pay_proc_trxn_type_code IS TABLE OF
53 IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE
54 INDEX BY BINARY_INTEGER;
55
56 TYPE t_calling_app_id IS TABLE OF
57 IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE
58 INDEX BY BINARY_INTEGER;
59 TYPE t_calling_app_doc_ref_number IS TABLE OF
60 IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE
61 INDEX BY BINARY_INTEGER;
62 TYPE t_call_app_pay_srvc_req_cd IS TABLE OF
63 IBY_GEN_DOCS_PAYABLE.call_app_pay_service_req_code%TYPE
64 INDEX BY BINARY_INTEGER;
65 TYPE t_document_payable_id IS TABLE OF
66 IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE
67 INDEX BY BINARY_INTEGER;
68 TYPE t_payment_function IS TABLE OF
69 IBY_DOCS_PAYABLE_ALL.payment_function%TYPE
70 INDEX BY BINARY_INTEGER;
71 TYPE t_payment_date IS TABLE OF
72 IBY_DOCS_PAYABLE_ALL.payment_date%TYPE
73 INDEX BY BINARY_INTEGER;
74 TYPE t_document_date IS TABLE OF
75 IBY_DOCS_PAYABLE_ALL.document_date%TYPE
76 INDEX BY BINARY_INTEGER;
77 TYPE t_document_type IS TABLE OF
78 IBY_DOCS_PAYABLE_ALL.document_type%TYPE
79 INDEX BY BINARY_INTEGER;
80 TYPE t_document_status IS TABLE OF
81 IBY_DOCS_PAYABLE_ALL.document_status%TYPE
82 INDEX BY BINARY_INTEGER;
83 TYPE t_document_currency_code IS TABLE OF
84 IBY_DOCS_PAYABLE_ALL.document_currency_code%TYPE
85 INDEX BY BINARY_INTEGER;
86 TYPE t_document_amount IS TABLE OF
87 IBY_DOCS_PAYABLE_ALL.document_amount%TYPE
88 INDEX BY BINARY_INTEGER;
89 TYPE t_payment_currency_code IS TABLE OF
90 IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE
91 INDEX BY BINARY_INTEGER;
92 TYPE t_payment_amount IS TABLE OF
93 IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE
94 INDEX BY BINARY_INTEGER;
95
96 TYPE t_payment_service_request_id IS TABLE OF
97 IBY_DOCS_PAYABLE_ALL.payment_service_request_id%TYPE
98 INDEX BY BINARY_INTEGER;
99
100 TYPE t_payment_method_code IS TABLE OF
101 IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE
102 INDEX BY BINARY_INTEGER;
103
104 TYPE t_exclusive_payment_flag IS TABLE OF
105 IBY_DOCS_PAYABLE_ALL.exclusive_payment_flag%TYPE
106 INDEX BY BINARY_INTEGER;
107
108 TYPE t_straight_through_flag IS TABLE OF
109 IBY_DOCS_PAYABLE_ALL.straight_through_flag%TYPE
110 INDEX BY BINARY_INTEGER;
111
112 TYPE t_ext_payee_id IS TABLE OF
113 IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE
114 INDEX BY BINARY_INTEGER;
115 TYPE t_payee_party_id IS TABLE OF
116 IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE
117 INDEX BY BINARY_INTEGER;
118 TYPE t_legal_entity_id IS TABLE OF
119 IBY_DOCS_PAYABLE_ALL.legal_entity_id%TYPE
120 INDEX BY BINARY_INTEGER;
121 TYPE t_org_id IS TABLE OF
122 IBY_DOCS_PAYABLE_ALL.org_id%TYPE
123 INDEX BY BINARY_INTEGER;
124
125 TYPE t_allow_removing_document_flag IS TABLE OF
126 IBY_DOCS_PAYABLE_ALL.allow_removing_document_flag%TYPE
127 INDEX BY BINARY_INTEGER;
128
129 TYPE t_created_by IS TABLE OF
130 IBY_DOCS_PAYABLE_ALL.created_by%TYPE
131 INDEX BY BINARY_INTEGER;
132 TYPE t_creation_date IS TABLE OF
133 IBY_DOCS_PAYABLE_ALL.creation_date%TYPE
134 INDEX BY BINARY_INTEGER;
135 TYPE t_last_updated_by IS TABLE OF
136 IBY_DOCS_PAYABLE_ALL.last_updated_by%TYPE
137 INDEX BY BINARY_INTEGER;
138 TYPE t_last_update_date IS TABLE OF
139 IBY_DOCS_PAYABLE_ALL.last_update_date%TYPE
140 INDEX BY BINARY_INTEGER;
141 TYPE t_object_version_number IS TABLE OF
142 IBY_DOCS_PAYABLE_ALL.object_version_number%TYPE
143 INDEX BY BINARY_INTEGER;
144 TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
145 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE
146 INDEX BY BINARY_INTEGER;
147 TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
148 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE
149 INDEX BY BINARY_INTEGER;
150 TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
151 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE
152 INDEX BY BINARY_INTEGER;
153 TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
154 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE
155 INDEX BY BINARY_INTEGER;
156 TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
157 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE
158 INDEX BY BINARY_INTEGER;
159 TYPE t_last_update_login IS TABLE OF
160 IBY_DOCS_PAYABLE_ALL.last_update_login%TYPE
161 INDEX BY BINARY_INTEGER;
162 TYPE t_party_site_id IS TABLE OF
163 IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE
164 INDEX BY BINARY_INTEGER;
165 TYPE t_supplier_site_id IS TABLE OF
166 IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE
167 INDEX BY BINARY_INTEGER;
168 TYPE t_beneficiary_party IS TABLE OF
169 IBY_DOCS_PAYABLE_ALL.beneficiary_party%TYPE
170 INDEX BY BINARY_INTEGER;
171 TYPE t_org_type IS TABLE OF
172 IBY_DOCS_PAYABLE_ALL.org_type%TYPE
173 INDEX BY BINARY_INTEGER;
174 TYPE t_anticipated_value_date IS TABLE OF
175 IBY_DOCS_PAYABLE_ALL.anticipated_value_date%TYPE
176 INDEX BY BINARY_INTEGER;
177 TYPE t_po_number IS TABLE OF
178 IBY_DOCS_PAYABLE_ALL.po_number%TYPE
179 INDEX BY BINARY_INTEGER;
180 TYPE t_document_description IS TABLE OF
181 IBY_DOCS_PAYABLE_ALL.document_description%TYPE
182 INDEX BY BINARY_INTEGER;
183 TYPE t_document_currency_tax_amount IS TABLE OF
184 IBY_DOCS_PAYABLE_ALL.document_currency_tax_amount%TYPE
185 INDEX BY BINARY_INTEGER;
186 TYPE t_document_curr_charge_amount IS TABLE OF
187 IBY_DOCS_PAYABLE_ALL.document_curr_charge_amount%TYPE
188 INDEX BY BINARY_INTEGER;
189 TYPE t_amount_withheld IS TABLE OF
193 IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE
190 IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE
191 INDEX BY BINARY_INTEGER;
192 TYPE t_payment_curr_discount_taken IS TABLE OF
194 INDEX BY BINARY_INTEGER;
195 TYPE t_discount_date IS TABLE OF
196 IBY_DOCS_PAYABLE_ALL.discount_date%TYPE
197 INDEX BY BINARY_INTEGER;
198 TYPE t_payment_due_date IS TABLE OF
199 IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE
200 INDEX BY BINARY_INTEGER;
201 TYPE t_payment_profile_id IS TABLE OF
202 IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE
203 INDEX BY BINARY_INTEGER;
204 TYPE t_payment_id IS TABLE OF
205 IBY_DOCS_PAYABLE_ALL.payment_id%TYPE
206 INDEX BY BINARY_INTEGER;
207 TYPE t_formatting_payment_id IS TABLE OF
208 IBY_DOCS_PAYABLE_ALL.formatting_payment_id%TYPE
209 INDEX BY BINARY_INTEGER;
210 TYPE t_internal_bank_account_id IS TABLE OF
211 IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
212 INDEX BY BINARY_INTEGER;
213 TYPE t_external_bank_account_id IS TABLE OF
214 IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE
215 INDEX BY BINARY_INTEGER;
216 TYPE t_bank_charge_bearer IS TABLE OF
217 IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE
218 INDEX BY BINARY_INTEGER;
219 TYPE t_interest_rate IS TABLE OF
220 IBY_DOCS_PAYABLE_ALL.interest_rate%TYPE
221 INDEX BY BINARY_INTEGER;
222 TYPE t_payment_grouping_number IS TABLE OF
223 IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE
224 INDEX BY BINARY_INTEGER;
225 TYPE t_payment_reason_code IS TABLE OF
226 IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE
227 INDEX BY BINARY_INTEGER;
228 TYPE t_payment_reason_comments IS TABLE OF
229 IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE
230 INDEX BY BINARY_INTEGER;
231 TYPE t_settlement_priority IS TABLE OF
232 IBY_DOCS_PAYABLE_ALL.settlement_priority%TYPE
233 INDEX BY BINARY_INTEGER;
234 TYPE t_remittance_message1 IS TABLE OF
235 IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE
236 INDEX BY BINARY_INTEGER;
237 TYPE t_remittance_message2 IS TABLE OF
238 IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE
239 INDEX BY BINARY_INTEGER;
240 TYPE t_remittance_message3 IS TABLE OF
241 IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE
242 INDEX BY BINARY_INTEGER;
243 TYPE t_unique_remittance_identifier IS TABLE OF
244 IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE
245 INDEX BY BINARY_INTEGER;
246 TYPE t_uri_check_digit IS TABLE OF
247 IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE
248 INDEX BY BINARY_INTEGER;
249 TYPE t_delivery_channel_code IS TABLE OF
250 IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE
251 INDEX BY BINARY_INTEGER;
252 TYPE t_payment_format_code IS TABLE OF
253 IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE
254 INDEX BY BINARY_INTEGER;
255 TYPE t_document_sequence_id IS TABLE OF
256 IBY_DOCS_PAYABLE_ALL.document_sequence_id%TYPE
257 INDEX BY BINARY_INTEGER;
258 TYPE t_document_sequence_value IS TABLE OF
259 IBY_DOCS_PAYABLE_ALL.document_sequence_value%TYPE
260 INDEX BY BINARY_INTEGER;
261 TYPE t_document_category_code IS TABLE OF
262 IBY_DOCS_PAYABLE_ALL.document_category_code%TYPE
263 INDEX BY BINARY_INTEGER;
264 TYPE t_bank_assigned_ref_code IS TABLE OF
265 IBY_DOCS_PAYABLE_ALL.bank_assigned_ref_code%TYPE
266 INDEX BY BINARY_INTEGER;
267 TYPE t_remit_to_location_id IS TABLE OF
268 IBY_DOCS_PAYABLE_ALL.remit_to_location_id%TYPE
269 INDEX BY BINARY_INTEGER;
270 TYPE t_completed_pmts_group_id IS TABLE OF
271 IBY_DOCS_PAYABLE_ALL.completed_pmts_group_id%TYPE
272 INDEX BY BINARY_INTEGER;
273 TYPE t_rejected_docs_group_id IS TABLE OF
274 IBY_DOCS_PAYABLE_ALL.rejected_docs_group_id%TYPE
275 INDEX BY BINARY_INTEGER;
276 TYPE t_attribute_category IS TABLE OF
277 IBY_DOCS_PAYABLE_ALL.attribute_category%TYPE
278 INDEX BY BINARY_INTEGER;
279 TYPE t_attribute1 IS TABLE OF
280 IBY_DOCS_PAYABLE_ALL.attribute1%TYPE
281 INDEX BY BINARY_INTEGER;
282 TYPE t_attribute2 IS TABLE OF
283 IBY_DOCS_PAYABLE_ALL.attribute2%TYPE
284 INDEX BY BINARY_INTEGER;
285 TYPE t_attribute3 IS TABLE OF
286 IBY_DOCS_PAYABLE_ALL.attribute3%TYPE
287 INDEX BY BINARY_INTEGER;
288 TYPE t_attribute4 IS TABLE OF
289 IBY_DOCS_PAYABLE_ALL.attribute4%TYPE
290 INDEX BY BINARY_INTEGER;
291 TYPE t_attribute5 IS TABLE OF
292 IBY_DOCS_PAYABLE_ALL.attribute5%TYPE
293 INDEX BY BINARY_INTEGER;
294 TYPE t_attribute6 IS TABLE OF
295 IBY_DOCS_PAYABLE_ALL.attribute6%TYPE
296 INDEX BY BINARY_INTEGER;
297 TYPE t_attribute7 IS TABLE OF
298 IBY_DOCS_PAYABLE_ALL.attribute7%TYPE
299 INDEX BY BINARY_INTEGER;
300 TYPE t_attribute8 IS TABLE OF
301 IBY_DOCS_PAYABLE_ALL.attribute8%TYPE
302 INDEX BY BINARY_INTEGER;
303 TYPE t_attribute9 IS TABLE OF
304 IBY_DOCS_PAYABLE_ALL.attribute9%TYPE
305 INDEX BY BINARY_INTEGER;
306 TYPE t_attribute10 IS TABLE OF
307 IBY_DOCS_PAYABLE_ALL.attribute10%TYPE
308 INDEX BY BINARY_INTEGER;
309 TYPE t_attribute11 IS TABLE OF
310 IBY_DOCS_PAYABLE_ALL.attribute11%TYPE
311 INDEX BY BINARY_INTEGER;
312 TYPE t_attribute12 IS TABLE OF
313 IBY_DOCS_PAYABLE_ALL.attribute12%TYPE
314 INDEX BY BINARY_INTEGER;
315 TYPE t_attribute13 IS TABLE OF
316 IBY_DOCS_PAYABLE_ALL.attribute13%TYPE
317 INDEX BY BINARY_INTEGER;
318 TYPE t_attribute14 IS TABLE OF
319 IBY_DOCS_PAYABLE_ALL.attribute14%TYPE
320 INDEX BY BINARY_INTEGER;
321 TYPE t_attribute15 IS TABLE OF
322 IBY_DOCS_PAYABLE_ALL.attribute15%TYPE
323 INDEX BY BINARY_INTEGER;
324
325 TYPE t_address_source IS TABLE OF
326 IBY_DOCS_PAYABLE_ALL.address_source%TYPE
327 INDEX BY BINARY_INTEGER;
328 TYPE t_employee_address_code IS TABLE OF
329 IBY_DOCS_PAYABLE_ALL.employee_address_code%TYPE
330 INDEX BY BINARY_INTEGER;
331 TYPE t_employee_payment_flag IS TABLE OF
332 IBY_DOCS_PAYABLE_ALL.employee_payment_flag%TYPE
333 INDEX BY BINARY_INTEGER;
334 TYPE t_employee_person_id IS TABLE OF
335 IBY_DOCS_PAYABLE_ALL.employee_person_id%TYPE
336 INDEX BY BINARY_INTEGER;
337 TYPE t_employee_address_id IS TABLE OF
338 IBY_DOCS_PAYABLE_ALL.employee_address_id%TYPE
339 INDEX BY BINARY_INTEGER;
340
341 TYPE t_bank_instruction1_code IS TABLE OF
342 IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE
343 INDEX BY BINARY_INTEGER;
344 TYPE t_bank_instruction2_code IS TABLE OF
345 IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE
346 INDEX BY BINARY_INTEGER;
347 TYPE t_payment_text_message1 IS TABLE OF
348 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE
349 INDEX BY BINARY_INTEGER;
350 TYPE t_payment_text_message2 IS TABLE OF
351 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE
352 INDEX BY BINARY_INTEGER;
353 TYPE t_payment_text_message3 IS TABLE OF
354 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE
355 INDEX BY BINARY_INTEGER;
356
357 TYPE t_group_by_remittance_message IS TABLE OF
358 IBY_PMT_CREATION_RULES.group_by_remittance_message%TYPE
359 INDEX BY BINARY_INTEGER;
360 TYPE t_group_by_bank_charge_bearer IS TABLE OF
361 IBY_PMT_CREATION_RULES.group_by_bank_charge_bearer%TYPE
362 INDEX BY BINARY_INTEGER;
363 TYPE t_group_by_delivery_channel IS TABLE OF
364 IBY_PMT_CREATION_RULES.group_by_delivery_channel%TYPE
365 INDEX BY BINARY_INTEGER;
366 TYPE t_grp_by_settle_priority_flag IS TABLE OF
367 IBY_PMT_CREATION_RULES.group_by_settle_priority_flag%TYPE
368 INDEX BY BINARY_INTEGER;
369 TYPE t_grp_by_payment_details_flag IS TABLE OF
370 IBY_PMT_CREATION_RULES.group_by_payment_details_flag%TYPE
371 INDEX BY BINARY_INTEGER;
372 TYPE t_payment_details_length_limit IS TABLE OF
373 IBY_PMT_CREATION_RULES.payment_details_length_limit%TYPE
374 INDEX BY BINARY_INTEGER;
375 TYPE t_payment_details_formula IS TABLE OF
376 IBY_PMT_CREATION_RULES.payment_details_formula%TYPE
377 INDEX BY BINARY_INTEGER;
378 TYPE t_group_by_max_documents_flag IS TABLE OF
379 IBY_PMT_CREATION_RULES.group_by_max_documents_flag%TYPE
380 INDEX BY BINARY_INTEGER;
381 TYPE t_max_documents_per_payment IS TABLE OF
382 IBY_PMT_CREATION_RULES.max_documents_per_payment%TYPE
383 INDEX BY BINARY_INTEGER;
384 TYPE t_grp_by_unique_remit_id_flag IS TABLE OF
385 IBY_PMT_CREATION_RULES.group_by_unique_remit_id_flag%TYPE
386 INDEX BY BINARY_INTEGER;
387 TYPE t_group_by_payment_reason IS TABLE OF
388 IBY_PMT_CREATION_RULES.group_by_payment_reason%TYPE
389 INDEX BY BINARY_INTEGER;
390 TYPE t_group_by_due_date_flag IS TABLE OF
391 IBY_PMT_CREATION_RULES.group_by_due_date_flag%TYPE
392 INDEX BY BINARY_INTEGER;
393
394 TYPE t_processing_type IS TABLE OF
395 IBY_PAYMENT_PROFILES.processing_type%TYPE
396 INDEX BY BINARY_INTEGER;
397 TYPE t_declaration_option IS TABLE OF
398 IBY_PAYMENT_PROFILES.declaration_option%TYPE
399 INDEX BY BINARY_INTEGER;
400 TYPE t_dcl_only_foren_curr_pmt_flag IS TABLE OF
401 IBY_PAYMENT_PROFILES.dcl_only_foreign_curr_pmt_flag%TYPE
402 INDEX BY BINARY_INTEGER;
403 TYPE t_dcl_curr_fx_rate_type IS TABLE OF
404 IBY_PAYMENT_PROFILES.declaration_curr_fx_rate_type%TYPE
405 INDEX BY BINARY_INTEGER;
406 TYPE t_declaration_currency_code IS TABLE OF
407 IBY_PAYMENT_PROFILES.declaration_currency_code%TYPE
408 INDEX BY BINARY_INTEGER;
409 TYPE t_declaration_threshold_amount IS TABLE OF
410 IBY_PAYMENT_PROFILES.declaration_threshold_amount%TYPE
411 INDEX BY BINARY_INTEGER;
412
413 TYPE t_maximum_payment_amount IS TABLE OF
414 IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE
415 INDEX BY BINARY_INTEGER;
416 TYPE t_minimum_payment_amount IS TABLE OF
417 IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE
418 INDEX BY BINARY_INTEGER;
419 TYPE t_allow_zero_payments_flag IS TABLE OF
420 IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE
421 INDEX BY BINARY_INTEGER;
422
423 TYPE t_support_bills_payable_flag IS TABLE OF
427 TYPE t_iba_legal_entity_id IS TABLE OF
424 IBY_PAYMENT_METHODS_B.support_bills_payable_flag%TYPE
425 INDEX BY BINARY_INTEGER;
426
428 CE_BANK_ACCOUNTS.account_owner_org_id%TYPE
429 INDEX BY BINARY_INTEGER;
430
431 TYPE t_int_bank_country_code IS TABLE OF
432 CE_BANK_BRANCHES_V.country%TYPE
433 INDEX BY BINARY_INTEGER;
434
435 TYPE t_ext_bank_country_code IS TABLE OF
436 IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE
437 INDEX BY BINARY_INTEGER;
438
439 TYPE t_foreign_pmts_allowed_flag IS TABLE OF
440 IBY_EXT_BANK_ACCOUNTS_V.foreign_payment_use_flag%TYPE
441 INDEX BY BINARY_INTEGER;
442
443 /*TPP-Start*/
444 TYPE t_inv_payee_party_id IS TABLE OF
445 IBY_DOCS_PAYABLE_ALL.inv_payee_party_id%TYPE
446 INDEX BY BINARY_INTEGER;
447 TYPE t_inv_party_site_id IS TABLE OF
448 IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE
449 INDEX BY BINARY_INTEGER;
450 TYPE t_inv_supplier_site_id IS TABLE OF
451 IBY_DOCS_PAYABLE_ALL.inv_supplier_site_id%TYPE
452 INDEX BY BINARY_INTEGER;
453 TYPE t_inv_beneficiary_party IS TABLE OF
454 IBY_DOCS_PAYABLE_ALL.inv_beneficiary_party%TYPE
455 INDEX BY BINARY_INTEGER;
456 TYPE t_ext_inv_payee_id IS TABLE OF
457 IBY_DOCS_PAYABLE_ALL.ext_inv_payee_id%TYPE
458 INDEX BY BINARY_INTEGER;
459 TYPE t_relationship_id IS TABLE OF
460 IBY_DOCS_PAYABLE_ALL.relationship_id%TYPE
461 INDEX BY BINARY_INTEGER;
462 /*TPP-End*/
463
464 /*German Format*/
465 TYPE t_global_attribute_category IS TABLE OF
466 IBY_DOCS_PAYABLE_ALL.global_attribute_category%TYPE
467 INDEX BY BINARY_INTEGER;
468 TYPE t_global_attribute1 IS TABLE OF
469 IBY_DOCS_PAYABLE_ALL.global_attribute1%TYPE
470 INDEX BY BINARY_INTEGER;
471 TYPE t_global_attribute2 IS TABLE OF
472 IBY_DOCS_PAYABLE_ALL.global_attribute2%TYPE
473 INDEX BY BINARY_INTEGER;
474 TYPE t_global_attribute3 IS TABLE OF
475 IBY_DOCS_PAYABLE_ALL.global_attribute3%TYPE
476 INDEX BY BINARY_INTEGER;
477 TYPE t_global_attribute4 IS TABLE OF
478 IBY_DOCS_PAYABLE_ALL.global_attribute4%TYPE
479 INDEX BY BINARY_INTEGER;
480 TYPE t_global_attribute5 IS TABLE OF
481 IBY_DOCS_PAYABLE_ALL.global_attribute5%TYPE
482 INDEX BY BINARY_INTEGER;
483 TYPE t_global_attribute6 IS TABLE OF
484 IBY_DOCS_PAYABLE_ALL.global_attribute6%TYPE
485 INDEX BY BINARY_INTEGER;
486 TYPE t_global_attribute7 IS TABLE OF
487 IBY_DOCS_PAYABLE_ALL.global_attribute7%TYPE
488 INDEX BY BINARY_INTEGER;
489 TYPE t_global_attribute8 IS TABLE OF
490 IBY_DOCS_PAYABLE_ALL.global_attribute8%TYPE
491 INDEX BY BINARY_INTEGER;
492 TYPE t_global_attribute9 IS TABLE OF
493 IBY_DOCS_PAYABLE_ALL.global_attribute9%TYPE
494 INDEX BY BINARY_INTEGER;
495 TYPE t_global_attribute10 IS TABLE OF
496 IBY_DOCS_PAYABLE_ALL.global_attribute10%TYPE
497 INDEX BY BINARY_INTEGER;
498 TYPE t_global_attribute11 IS TABLE OF
499 IBY_DOCS_PAYABLE_ALL.global_attribute11%TYPE
500 INDEX BY BINARY_INTEGER;
501 TYPE t_global_attribute12 IS TABLE OF
502 IBY_DOCS_PAYABLE_ALL.global_attribute12%TYPE
503 INDEX BY BINARY_INTEGER;
504 TYPE t_global_attribute13 IS TABLE OF
505 IBY_DOCS_PAYABLE_ALL.global_attribute13%TYPE
506 INDEX BY BINARY_INTEGER;
507 TYPE t_global_attribute14 IS TABLE OF
508 IBY_DOCS_PAYABLE_ALL.global_attribute14%TYPE
509 INDEX BY BINARY_INTEGER;
510 TYPE t_global_attribute15 IS TABLE OF
511 IBY_DOCS_PAYABLE_ALL.global_attribute15%TYPE
512 INDEX BY BINARY_INTEGER;
513 TYPE t_global_attribute16 IS TABLE OF
514 IBY_DOCS_PAYABLE_ALL.global_attribute16%TYPE
515 INDEX BY BINARY_INTEGER;
516 TYPE t_global_attribute17 IS TABLE OF
517 IBY_DOCS_PAYABLE_ALL.global_attribute17%TYPE
518 INDEX BY BINARY_INTEGER;
519 TYPE t_global_attribute18 IS TABLE OF
520 IBY_DOCS_PAYABLE_ALL.global_attribute18%TYPE
521 INDEX BY BINARY_INTEGER;
522 TYPE t_global_attribute19 IS TABLE OF
523 IBY_DOCS_PAYABLE_ALL.global_attribute19%TYPE
524 INDEX BY BINARY_INTEGER;
525 TYPE t_global_attribute20 IS TABLE OF
526 IBY_DOCS_PAYABLE_ALL.global_attribute20%TYPE
527 INDEX BY BINARY_INTEGER;
528 /*German Format*/
529 TYPE t_affects_rejection_level IS TABLE OF -- AWT Enh 16296267
530 IBY_DOCS_PAYABLE_ALL.affects_rejection_level%TYPE
531 INDEX BY BINARY_INTEGER;
532 TYPE t_dont_pay_flag IS TABLE OF
533 VARCHAR2(1)
534 INDEX BY BINARY_INTEGER;
535
536 TYPE t_dont_pay_reason_code IS TABLE OF
537 VARCHAR2(30)
538 INDEX BY BINARY_INTEGER;
539
540 TYPE t_dont_pay_description IS TABLE OF
541 VARCHAR2(255)
542 INDEX BY BINARY_INTEGER;
543
544
545 TYPE docs_pay_tab_type IS RECORD
546 (
547 pay_proc_trxn_type_code t_pay_proc_trxn_type_code,
548 calling_app_id t_calling_app_id,
549 calling_app_doc_ref_number t_calling_app_doc_ref_number,
550 call_app_pay_service_req_code t_call_app_pay_srvc_req_cd,
551 document_payable_id t_document_payable_id,
552 payment_function t_payment_function,
553 payment_date t_payment_date,
554 document_date t_document_date,
555 document_type t_document_type,
556 document_status t_document_status,
557 document_currency_code t_document_currency_code,
558 document_amount t_document_amount,
559 payment_currency_code t_payment_currency_code,
563 exclusive_payment_flag t_exclusive_payment_flag,
560 payment_amount t_payment_amount,
561 payment_service_request_id t_payment_service_request_id,
562 payment_method_code t_payment_method_code,
564 straight_through_flag t_straight_through_flag,
565 ext_payee_id t_ext_payee_id,
566 payee_party_id t_payee_party_id,
567 legal_entity_id t_legal_entity_id,
568 org_id t_org_id,
569 allow_removing_document_flag t_allow_removing_document_flag,
570 created_by t_created_by,
571 creation_date t_creation_date,
572 last_updated_by t_last_updated_by,
573 last_update_date t_last_update_date,
574 object_version_number t_object_version_number,
575 calling_app_doc_unique_ref1 t_calling_app_doc_unique_ref1,
576 calling_app_doc_unique_ref2 t_calling_app_doc_unique_ref2,
577 calling_app_doc_unique_ref3 t_calling_app_doc_unique_ref3,
578 calling_app_doc_unique_ref4 t_calling_app_doc_unique_ref4,
579 calling_app_doc_unique_ref5 t_calling_app_doc_unique_ref5,
580 last_update_login t_last_update_login,
581 party_site_id t_party_site_id,
582 supplier_site_id t_supplier_site_id,
583 beneficiary_party t_beneficiary_party,
584 org_type t_org_type,
585 anticipated_value_date t_anticipated_value_date,
586 po_number t_po_number,
587 document_description t_document_description,
588 document_currency_tax_amount t_document_currency_tax_amount,
589 document_curr_charge_amount t_document_curr_charge_amount,
590 amount_withheld t_amount_withheld,
591 payment_curr_discount_taken t_payment_curr_discount_taken,
592 discount_date t_discount_date,
593 payment_due_date t_payment_due_date,
594 payment_profile_id t_payment_profile_id,
595 payment_id t_payment_id,
596 formatting_payment_id t_formatting_payment_id,
597 internal_bank_account_id t_internal_bank_account_id,
598 external_bank_account_id t_external_bank_account_id,
599 bank_charge_bearer t_bank_charge_bearer,
600 interest_rate t_interest_rate,
601 payment_grouping_number t_payment_grouping_number,
602 payment_reason_code t_payment_reason_code,
603 payment_reason_comments t_payment_reason_comments,
604 settlement_priority t_settlement_priority,
605 remittance_message1 t_remittance_message1,
606 remittance_message2 t_remittance_message2,
607 remittance_message3 t_remittance_message3,
608 unique_remittance_identifier t_unique_remittance_identifier,
609 uri_check_digit t_uri_check_digit,
610 delivery_channel_code t_delivery_channel_code,
611 payment_format_code t_payment_format_code,
612 document_sequence_id t_document_sequence_id,
613 document_sequence_value t_document_sequence_value,
614 document_category_code t_document_category_code,
615 bank_assigned_ref_code t_bank_assigned_ref_code,
616 remit_to_location_id t_remit_to_location_id,
617 completed_pmts_group_id t_completed_pmts_group_id,
618 rejected_docs_group_id t_rejected_docs_group_id,
619 attribute_category t_attribute_category,
620 attribute1 t_attribute1,
621 attribute2 t_attribute2,
622 attribute3 t_attribute3,
623 attribute4 t_attribute4,
624 attribute5 t_attribute5,
625 attribute6 t_attribute6,
626 attribute7 t_attribute7,
627 attribute8 t_attribute8,
628 attribute9 t_attribute9,
629 attribute10 t_attribute10,
630 attribute11 t_attribute11,
631 attribute12 t_attribute12,
632 attribute13 t_attribute13,
633 attribute14 t_attribute14,
634 attribute15 t_attribute15,
635 address_source t_address_source,
636 employee_address_code t_employee_address_code,
637 employee_payment_flag t_employee_payment_flag,
638 employee_person_id t_employee_person_id,
639 employee_address_id t_employee_address_id,
640 bank_instruction1_code t_bank_instruction1_code,
641 bank_instruction2_code t_bank_instruction2_code,
642 payment_text_message1 t_payment_text_message1,
643 payment_text_message2 t_payment_text_message2,
644 payment_text_message3 t_payment_text_message3,
645 group_by_remittance_message t_group_by_remittance_message,
646 group_by_bank_charge_bearer t_group_by_bank_charge_bearer,
647 group_by_delivery_channel t_group_by_delivery_channel,
651 payment_details_formula t_payment_details_formula,
648 group_by_settle_priority_flag t_grp_by_settle_priority_flag,
649 group_by_payment_details_flag t_grp_by_payment_details_flag,
650 payment_details_length_limit t_payment_details_length_limit,
652 group_by_max_documents_flag t_group_by_max_documents_flag,
653 max_documents_per_payment t_max_documents_per_payment,
654 group_by_unique_remit_id_flag t_grp_by_unique_remit_id_flag,
655 group_by_payment_reason t_group_by_payment_reason,
656 group_by_due_date_flag t_group_by_due_date_flag,
657 processing_type t_processing_type,
658 declaration_option t_declaration_option,
659 dcl_only_foreign_curr_pmt_flag t_dcl_only_foren_curr_pmt_flag,
660 declaration_curr_fx_rate_type t_dcl_curr_fx_rate_type,
661 declaration_currency_code t_declaration_currency_code,
662 declaration_threshold_amount t_declaration_threshold_amount,
663 maximum_payment_amount t_maximum_payment_amount,
664 minimum_payment_amount t_minimum_payment_amount,
665 allow_zero_payments_flag t_allow_zero_payments_flag,
666 support_bills_payable_flag t_support_bills_payable_flag,
667 iba_legal_entity_id t_iba_legal_entity_id,
668 int_bank_country_code t_int_bank_country_code,
669 ext_bank_country_code t_ext_bank_country_code,
670 foreign_pmts_allowed_flag t_foreign_pmts_allowed_flag,
671
672 /*TPP-Start*/
673 inv_payee_party_id t_inv_payee_party_id,
674 inv_party_site_id t_inv_party_site_id,
675 inv_supplier_site_id t_inv_supplier_site_id,
676 inv_beneficiary_party t_inv_beneficiary_party,
677 ext_inv_payee_id t_ext_inv_payee_id,
678 relationship_id t_relationship_id,
679 /*TPP-End*/
680
681 /*German Format*/
682 global_attribute_category t_global_attribute_category,
683 global_attribute1 t_global_attribute1,
684 global_attribute2 t_global_attribute2,
685 global_attribute3 t_global_attribute3,
686 global_attribute4 t_global_attribute4,
687 global_attribute5 t_global_attribute5,
688 global_attribute6 t_global_attribute6,
689 global_attribute7 t_global_attribute7,
690 global_attribute8 t_global_attribute8,
691 global_attribute9 t_global_attribute9,
692 global_attribute10 t_global_attribute10,
693 global_attribute11 t_global_attribute11,
694 global_attribute12 t_global_attribute12,
695 global_attribute13 t_global_attribute13,
696 global_attribute14 t_global_attribute14,
697 global_attribute15 t_global_attribute15,
698 global_attribute16 t_global_attribute16,
699 global_attribute17 t_global_attribute17,
700 global_attribute18 t_global_attribute18,
701 global_attribute19 t_global_attribute19,
702 global_attribute20 t_global_attribute20,
703 /*German Format*/
704 dont_pay_flag t_dont_pay_flag,
705 dont_pay_reason_code t_dont_pay_reason_code,
706 dont_pay_description t_dont_pay_description,
707 affects_rejection_level t_affects_rejection_level --AWT Enhancement 16296267
708 );
709
710 docspayTab docs_pay_tab_type;
711
712 /*--------------------------------------------------------------------
713 | NAME:
714 |
715 | PURPOSE:
716 | This procedure is used to initialize global memory structure
717 | / Destroy the no longer used memory structure
718 |
719 | PARAMETERS:
720 |
721 | NONE
722 |
723 | RETURNS:
724 |
725 | NOTES:
726 |
727 *---------------------------------------------------------------------*/
728 PROCEDURE delete_docspayTab;
729
730 /*--------------------------------------------------------------------
731 | NAME:
732 | submit_payment_process_request
733 |
734 | PURPOSE:
735 | This is the top level procedure of the build program; This
736 | procedure will run as a concurrent program.
737 |
738 | PARAMETERS:
739 |
740 | IN
741 |
742 | p_calling_app_id
743 | The 3-character product code of te calling application
744 |
745 | p_calling_app_payreq_id
746 | Id of the payment service request from the calling app's
747 | point of view. For a given calling app, this id should be
748 | unique; the build program will communicate back to the calling
749 | app using this payment request id.
750 |
751 | p_internal_bank_account_id
752 | The internal bank account to pay from.
753 |
754 | p_payment_profile_id
755 | Payment profile
756 |
757 | p_allow_zero_payments_flag
758 | 'Y' / 'N' flag indicating whether zero value payments are allowed.
759 | If not set, this value will be defaulted to 'N'.
760 |
761 | p_payment_date
762 | The payment date.
763 |
764 | p_anticipated_value_date
765 | The anticipated value date.
766 |
767 | p_maximum_payment_amount
768 | Maximum allowed amount for a single payment. Payments will be
772 | Minimum allowed amount for a single payment. Payments will be
769 | validated against this ceiling.
770 |
771 | p_minimum_payment_amount
773 | validated against this floor.
774 |
775 | p_create_instrs_flag
776 | 'Y' / 'N' flag indicating whether payment instruction creation
777 | should be invoked for this payment service request as soon the
778 | Build Program completes.
779 |
780 | p_args12 - p_args100
781 | These 89 parameters are mandatory for any stored procedure
782 | that is submitted from Oracle Forms as a concurrent request.
783 | (to get the total number of args to the concurrent procedure
784 | to 100).
785 |
786 | OUT
787 |
788 | x_errbuf
789 | x_retcode
790 |
791 | These two are mandatory output paramaters for a concurrent
792 | program. They will store the error message and error code
793 | to indicate a successful/failed run of the concurrent request.
794 |
795 | RETURNS:
796 |
797 | NOTES:
798 |
799 *---------------------------------------------------------------------*/
800 PROCEDURE submit_payment_process_request(
801 x_errbuf OUT NOCOPY VARCHAR2,
802 x_retcode OUT NOCOPY VARCHAR2,
803 p_calling_app_id IN VARCHAR2,
804 p_calling_app_payreq_cd IN VARCHAR2,
805 p_internal_bank_account_id IN VARCHAR2 DEFAULT NULL,
806 p_payment_profile_id IN VARCHAR2 DEFAULT NULL,
807 p_allow_zero_payments_flag IN VARCHAR2 DEFAULT 'N',
808 p_maximum_payment_amount IN VARCHAR2 DEFAULT NULL,
809 p_minimum_payment_amount IN VARCHAR2 DEFAULT NULL,
810 p_document_rejection_level IN VARCHAR2 DEFAULT NULL,
811 p_payment_rejection_level IN VARCHAR2 DEFAULT NULL,
812 p_review_proposed_pmts_flag IN VARCHAR2 DEFAULT 'X',
813 p_create_instrs_flag IN VARCHAR2 DEFAULT 'N',
814 p_payment_document_id IN VARCHAR2 DEFAULT NULL,
815 p_attribute_category IN VARCHAR2 DEFAULT NULL, p_attribute1 IN VARCHAR2 DEFAULT NULL,
816 p_attribute2 IN VARCHAR2 DEFAULT NULL, p_attribute3 IN VARCHAR2 DEFAULT NULL,
817 p_attribute4 IN VARCHAR2 DEFAULT NULL, p_attribute5 IN VARCHAR2 DEFAULT NULL,
818 p_attribute6 IN VARCHAR2 DEFAULT NULL, p_attribute7 IN VARCHAR2 DEFAULT NULL,
819 p_attribute8 IN VARCHAR2 DEFAULT NULL, p_attribute9 IN VARCHAR2 DEFAULT NULL,
820 p_attribute10 IN VARCHAR2 DEFAULT NULL, p_attribute11 IN VARCHAR2 DEFAULT NULL,
821 p_attribute12 IN VARCHAR2 DEFAULT NULL, p_attribute13 IN VARCHAR2 DEFAULT NULL,
822 p_attribute14 IN VARCHAR2 DEFAULT NULL, p_attribute15 IN VARCHAR2 DEFAULT NULL,
823 p_sys_key IN VARCHAR2 DEFAULT NULL, p_arg31 IN VARCHAR2 DEFAULT NULL,
824 p_arg32 IN VARCHAR2 DEFAULT NULL, p_arg33 IN VARCHAR2 DEFAULT NULL,
825 p_arg34 IN VARCHAR2 DEFAULT NULL, p_arg35 IN VARCHAR2 DEFAULT NULL,
826 p_arg36 IN VARCHAR2 DEFAULT NULL, p_arg37 IN VARCHAR2 DEFAULT NULL,
827 p_arg38 IN VARCHAR2 DEFAULT NULL, p_arg39 IN VARCHAR2 DEFAULT NULL,
828 p_arg40 IN VARCHAR2 DEFAULT NULL, p_arg41 IN VARCHAR2 DEFAULT NULL,
829 p_arg42 IN VARCHAR2 DEFAULT NULL, p_arg43 IN VARCHAR2 DEFAULT NULL,
830 p_arg44 IN VARCHAR2 DEFAULT NULL, p_arg45 IN VARCHAR2 DEFAULT NULL,
831 p_arg46 IN VARCHAR2 DEFAULT NULL, p_arg47 IN VARCHAR2 DEFAULT NULL,
832 p_arg48 IN VARCHAR2 DEFAULT NULL, p_arg49 IN VARCHAR2 DEFAULT NULL,
833 p_arg50 IN VARCHAR2 DEFAULT NULL, p_arg51 IN VARCHAR2 DEFAULT NULL,
834 p_arg52 IN VARCHAR2 DEFAULT NULL, p_arg53 IN VARCHAR2 DEFAULT NULL,
835 p_arg54 IN VARCHAR2 DEFAULT NULL, p_arg55 IN VARCHAR2 DEFAULT NULL,
836 p_arg56 IN VARCHAR2 DEFAULT NULL, p_arg57 IN VARCHAR2 DEFAULT NULL,
837 p_arg58 IN VARCHAR2 DEFAULT NULL, p_arg59 IN VARCHAR2 DEFAULT NULL,
838 p_arg60 IN VARCHAR2 DEFAULT NULL, p_arg61 IN VARCHAR2 DEFAULT NULL,
839 p_arg62 IN VARCHAR2 DEFAULT NULL, p_arg63 IN VARCHAR2 DEFAULT NULL,
840 p_arg64 IN VARCHAR2 DEFAULT NULL, p_arg65 IN VARCHAR2 DEFAULT NULL,
841 p_arg66 IN VARCHAR2 DEFAULT NULL, p_arg67 IN VARCHAR2 DEFAULT NULL,
842 p_arg68 IN VARCHAR2 DEFAULT NULL, p_arg69 IN VARCHAR2 DEFAULT NULL,
843 p_arg70 IN VARCHAR2 DEFAULT NULL, p_arg71 IN VARCHAR2 DEFAULT NULL,
844 p_arg72 IN VARCHAR2 DEFAULT NULL, p_arg73 IN VARCHAR2 DEFAULT NULL,
845 p_arg74 IN VARCHAR2 DEFAULT NULL, p_arg75 IN VARCHAR2 DEFAULT NULL,
846 p_arg76 IN VARCHAR2 DEFAULT NULL, p_arg77 IN VARCHAR2 DEFAULT NULL,
847 p_arg78 IN VARCHAR2 DEFAULT NULL, p_arg79 IN VARCHAR2 DEFAULT NULL,
848 p_arg80 IN VARCHAR2 DEFAULT NULL, p_arg81 IN VARCHAR2 DEFAULT NULL,
849 p_arg82 IN VARCHAR2 DEFAULT NULL, p_arg83 IN VARCHAR2 DEFAULT NULL,
850 p_arg84 IN VARCHAR2 DEFAULT NULL, p_arg85 IN VARCHAR2 DEFAULT NULL,
851 p_arg86 IN VARCHAR2 DEFAULT NULL, p_arg87 IN VARCHAR2 DEFAULT NULL,
852 p_arg88 IN VARCHAR2 DEFAULT NULL, p_arg89 IN VARCHAR2 DEFAULT NULL,
853 p_arg90 IN VARCHAR2 DEFAULT NULL, p_arg91 IN VARCHAR2 DEFAULT NULL,
854 p_arg92 IN VARCHAR2 DEFAULT NULL, p_arg93 IN VARCHAR2 DEFAULT NULL,
855 p_arg94 IN VARCHAR2 DEFAULT NULL, p_arg95 IN VARCHAR2 DEFAULT NULL,
856 p_arg96 IN VARCHAR2 DEFAULT NULL, p_arg97 IN VARCHAR2 DEFAULT NULL,
857 p_arg98 IN VARCHAR2 DEFAULT NULL, p_arg99 IN VARCHAR2 DEFAULT NULL,
858 p_arg100 IN VARCHAR2 DEFAULT NULL
859 );
860
861 /*--------------------------------------------------------------------
862 | NAME:
863 | get_payreq_list
864 |
865 | PURPOSE:
866 |
867 |
868 | PARAMETERS:
869 | IN
870 |
871 |
872 | OUT
876 |
873 |
874 |
875 | RETURNS:
877 | NOTES:
878 |
879 *---------------------------------------------------------------------*/
880 FUNCTION get_payreq_list (
881 p_status IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_status%TYPE)
882 RETURN payreq_tbl_type;
883
884 /*--------------------------------------------------------------------
885 | NAME:
886 | get_payreq_status
887 |
888 |
889 | PURPOSE:
890 |
891 |
892 | PARAMETERS:
893 | IN
894 |
895 |
896 | OUT
897 |
898 |
899 | RETURNS:
900 |
901 | NOTES:
902 |
903 *---------------------------------------------------------------------*/
904 FUNCTION get_payreq_status (
905 l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
906 RETURN VARCHAR2;
907
908 /*--------------------------------------------------------------------
909 | NAME:
910 | insert_payreq
911 |
912 |
913 | PURPOSE:
914 |
915 |
916 | PARAMETERS:
917 | IN
918 |
919 |
920 | OUT
921 |
922 |
923 | RETURNS:
924 |
925 | NOTES:
926 |
927 *---------------------------------------------------------------------*/
928 FUNCTION insert_payreq (
929 p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
930 p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
931 call_app_pay_service_req_code%TYPE,
932 p_internal_bank_account_id
933 IN IBY_PAY_SERVICE_REQUESTS.
934 internal_bank_account_id%TYPE,
935 p_payment_profile_id
936 IN IBY_PAY_SERVICE_REQUESTS.
937 payment_profile_id%TYPE,
938 p_allow_zero_payments_flag
939 IN IBY_PAY_SERVICE_REQUESTS.
940 allow_zero_payments_flag%TYPE,
941 p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
942 maximum_payment_amount%TYPE,
943 p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
944 minimum_payment_amount%TYPE,
945 p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
946 document_rejection_level_code%TYPE,
947 p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
948 payment_rejection_level_code%TYPE,
949 p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
950 require_prop_pmts_review_flag%TYPE,
951 p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
952 create_pmt_instructions_flag%TYPE,
953 p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
954 payment_document_id%TYPE,
955 p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
956 attribute_category%TYPE,
957 p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
958 attribute1%TYPE,
959 p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
960 attribute2%TYPE,
961 p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
962 attribute3%TYPE,
963 p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
964 attribute4%TYPE,
965 p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
966 attribute5%TYPE,
967 p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
968 attribute6%TYPE,
969 p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
970 attribute7%TYPE,
971 p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
972 attribute8%TYPE,
973 p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
974 attribute9%TYPE,
975 p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
976 attribute10%TYPE,
977 p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
978 attribute11%TYPE,
979 p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
980 attribute12%TYPE,
981 p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
982 attribute13%TYPE,
983 p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.
984 attribute14%TYPE,
985 p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.
986 attribute15%TYPE
987 )
988 RETURN NUMBER;
989
990 /*--------------------------------------------------------------------
991 | NAME:
992 | getNextPayReqID
993 |
994 | PURPOSE:
995 |
996 |
997 | PARAMETERS:
998 | IN
999 |
1000 |
1001 | OUT
1002 |
1003 |
1004 | RETURNS:
1005 |
1006 | NOTES:
1007 |
1008 *---------------------------------------------------------------------*/
1009 FUNCTION getNextPayReqID
1010 RETURN NUMBER;
1011
1012 /*--------------------------------------------------------------------
1013 | NAME:
1014 | insert_payreq_documents
1015 |
1016 |
1017 | PURPOSE:
1018 |
1019 |
1020 | PARAMETERS:
1021 | IN
1022 |
1023 |
1024 | OUT
1025 |
1026 |
1027 | RETURNS:
1028 |
1029 | NOTES:
1030 |
1031 *---------------------------------------------------------------------*/
1032 FUNCTION insert_payreq_documents (
1033 p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
1034 p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1035 call_app_pay_service_req_code%TYPE,
1036 p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
1037 payment_service_request_id%TYPE
1038 )
1039 RETURN NUMBER;
1040
1041 /*--------------------------------------------------------------------
1042 | NAME:
1043 | getNextDocumentPayableID
1044 |
1045 | PURPOSE:
1046 |
1047 |
1048 | PARAMETERS:
1049 | IN
1050 |
1051 |
1052 | OUT
1053 |
1054 |
1055 | RETURNS:
1056 |
1057 | NOTES:
1058 |
1059 *---------------------------------------------------------------------*/
1060 FUNCTION getNextDocumentPayableID
1061 RETURN NUMBER;
1062
1063 /*--------------------------------------------------------------------
1064 | NAME:
1065 | getNextDocumentPayableLineID
1066 |
1067 | PURPOSE:
1068 |
1069 |
1070 | PARAMETERS:
1071 | IN
1072 |
1073 |
1074 | OUT
1075 |
1076 |
1077 | RETURNS:
1078 |
1079 | NOTES:
1080 |
1081 *---------------------------------------------------------------------*/
1082 FUNCTION getNextDocumentPayableLineID
1083 RETURN NUMBER;
1084
1085 /*--------------------------------------------------------------------
1086 | NAME:
1087 | checkIfDuplicate
1088 |
1089 | PURPOSE:
1090 |
1091 |
1092 | PARAMETERS:
1093 | IN
1094 |
1095 |
1096 | OUT
1097 |
1098 |
1099 | RETURNS:
1100 |
1101 | NOTES:
1102 |
1103 *---------------------------------------------------------------------*/
1104 FUNCTION checkIfDuplicate(
1105 p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
1106 p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1107 call_app_pay_service_req_code%TYPE
1108 )
1109 RETURN NUMBER;
1110
1111 /*--------------------------------------------------------------------
1112 | NAME:
1113 | derivePayeeIdFromContext
1114 |
1115 | PURPOSE:
1116 |
1117 |
1118 | PARAMETERS:
1119 | IN
1120 |
1121 |
1122 | OUT
1123 |
1124 |
1125 | RETURNS:
1126 |
1127 | NOTES:
1128 |
1129 *---------------------------------------------------------------------*/
1130 FUNCTION derivePayeeIdFromContext(
1131 p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1132 p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1133 p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1134 p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1135 p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1136 p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1137 )
1138 RETURN NUMBER;
1139
1140 /*--------------------------------------------------------------------
1141 | NAME:
1142 | deriveExactPayeeIdFromContext
1143 |
1144 | PURPOSE:
1145 |
1146 |
1147 | PARAMETERS:
1148 | IN
1149 |
1150 |
1151 | OUT
1152 |
1153 |
1154 | RETURNS:
1155 |
1156 | NOTES:
1157 |
1158 *---------------------------------------------------------------------*/
1159 FUNCTION deriveExactPayeeIdFromContext(
1160 p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1161 p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1162 p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1163 p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1164 p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1165 p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1166 )
1167 RETURN NUMBER;
1168
1169 /*--------------------------------------------------------------------
1170 | NAME:
1171 | deriveDistinctAccessTypsForReq
1172 |
1173 | PURPOSE:
1174 |
1175 |
1176 | PARAMETERS:
1177 | IN
1178 |
1179 |
1180 | OUT
1181 |
1182 |
1183 | RETURNS:
1184 |
1185 | NOTES:
1186 |
1187 *---------------------------------------------------------------------*/
1188 PROCEDURE deriveDistinctAccessTypsForReq(
1189 p_payreq_id IN IBY_DOCS_PAYABLE_ALL.payment_service_request_id
1190 %TYPE,
1191 p_pmt_function IN IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
1192 p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1193 p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1194 x_pmtFxAccessTypesTab IN OUT NOCOPY distinctPmtFxAccessTab,
1195 x_orgAccessTypesTab IN OUT NOCOPY distinctOrgAccessTab
1196 );
1197
1198 /*--------------------------------------------------------------------
1199 | NAME:
1200 | insertDistinctAccessTypsForReq
1201 |
1202 | PURPOSE:
1203 |
1204 |
1205 | PARAMETERS:
1206 | IN
1207 |
1208 |
1209 | OUT
1210 |
1211 |
1212 | RETURNS:
1213 |
1214 | NOTES:
1215 |
1216 *---------------------------------------------------------------------*/
1217 PROCEDURE insertDistinctAccessTypsForReq(
1218 p_pmtFxAccessTypesTab IN distinctPmtFxAccessTab,
1219 p_orgAccessTypesTab IN distinctOrgAccessTab
1220 );
1221
1222 /*--------------------------------------------------------------------
1223 | NAME:
1224 | set_profile_attribs
1225 |
1226 |
1227 | PURPOSE:
1228 | Sets the attributes of the payment profile structure
1229 |
1230 | PARAMETERS:
1231 | IN
1232 |
1233 |
1234 | OUT
1235 |
1236 |
1237 | RETURNS:
1238 |
1239 | NOTES:
1240 |
1241 *---------------------------------------------------------------------*/
1242 PROCEDURE set_profile_attribs(
1243 p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE
1244 );
1245
1246 /*--------------------------------------------------------------------
1247 | NAME:
1248 | get_profile_process_attribs
1249 |
1250 |
1251 | PURPOSE:
1252 |
1253 |
1254 | PARAMETERS:
1255 | IN
1256 |
1257 |
1258 | OUT
1259 |
1260 |
1261 | RETURNS:
1262 |
1263 | NOTES:
1264 |
1265 *---------------------------------------------------------------------*/
1266 PROCEDURE get_profile_process_attribs(
1267 p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE,
1268 x_profile_attribs IN OUT NOCOPY profileProcessAttribs
1269 );
1270
1271 /*--------------------------------------------------------------------
1272 | NAME:
1273 | checkIfDefaultPmtDocOnProfile
1274 |
1275 | PURPOSE:
1276 |
1277 |
1278 | PARAMETERS:
1279 | IN
1280 |
1281 |
1282 | OUT
1283 |
1284 |
1285 | RETURNS:
1286 |
1287 | NOTES:
1288 |
1289 *---------------------------------------------------------------------*/
1290 PROCEDURE checkIfDefaultPmtDocOnProfile (
1291 p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE,
1292 x_profile_name IN OUT NOCOPY IBY_PAYMENT_PROFILES.system_profile_name%TYPE,
1293 x_return_flag IN OUT NOCOPY BOOLEAN
1294 );
1295
1296 /*--------------------------------------------------------------------
1297 | NAME:
1298 | print_debuginfo
1299 |
1300 | PURPOSE:
1301 |
1302 |
1303 | PARAMETERS:
1304 | IN
1305 |
1306 |
1307 | OUT
1308 |
1309 |
1310 | RETURNS:
1311 |
1312 | NOTES:
1313 |
1314 *---------------------------------------------------------------------*/
1315 PROCEDURE print_debuginfo(
1316 p_module IN VARCHAR2,
1317 p_debug_text IN VARCHAR2,
1318 p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
1319 );
1320
1321 /*--------------------------------------------------------------------
1322 | NAME:
1323 | checkIfPmtsInModifiedStatus
1324 |
1325 |
1326 | PURPOSE:
1327 |
1328 |
1329 | PARAMETERS:
1330 | IN
1331 |
1332 |
1333 | OUT
1334 |
1335 |
1336 | RETURNS:
1337 |
1338 | NOTES:
1339 |
1340 *---------------------------------------------------------------------*/
1341 FUNCTION checkIfPmtsInModifiedStatus(
1342 l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
1343 RETURN BOOLEAN;
1344
1345 /*--------------------------------------------------------------------
1346 | NAME:
1347 | checkIfPmtsInModBankAccStatus
1348 |
1349 |
1350 | PURPOSE:
1351 |
1352 |
1353 | PARAMETERS:
1354 | IN
1355 |
1356 |
1357 | OUT
1358 |
1359 |
1360 | RETURNS:
1361 |
1362 | NOTES:
1363 |
1364 *---------------------------------------------------------------------*/
1365 FUNCTION checkIfPmtsInModBankAccStatus(
1366 l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
1367 RETURN BOOLEAN;
1368
1369 /*--------------------------------------------------------------------
1370 | NAME:
1371 | launchPPRStatusReport
1372 |
1373 | PURPOSE:
1374 |
1375 |
1376 | PARAMETERS:
1377 | IN
1378 |
1379 |
1380 | OUT
1381 |
1382 |
1383 | RETURNS:
1384 |
1385 | NOTES:
1386 |
1387 *---------------------------------------------------------------------*/
1388 PROCEDURE launchPPRStatusReport(
1389 p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
1390 payment_service_request_id%TYPE
1391 );
1392
1393
1394 /*--------------------------------------------------------------------
1395 | NAME:
1396 | update_payreq_status
1397 |
1398 |
1399 | PURPOSE:
1400 |
1401 |
1402 | PARAMETERS:
1403 | IN
1404 |
1405 |
1406 | OUT
1407 |
1408 |
1409 | RETURNS:
1410 |
1411 | NOTES:
1412 |
1413 *---------------------------------------------------------------------*/
1414 PROCEDURE update_payreq_status (
1415 l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
1416 l_payreq_status IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_status%TYPE,
1417 x_return_status IN OUT NOCOPY VARCHAR2);
1418
1419 PROCEDURE print_log(
1420 p_module IN VARCHAR2,
1421 p_debug_text IN VARCHAR2
1422 );
1423
1424 END IBY_DISBURSE_SUBMIT_PUB_PKG;
[Home] [Help]