1 PACKAGE IBY_DISBURSE_SUBMIT_PUB_PKG AS
2 /*$Header: ibybilds.pls 120.22.12010000.3 2008/12/02 20:55:44 pschalla 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
190 IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE
191 INDEX BY BINARY_INTEGER;
192 TYPE t_payment_curr_discount_taken IS TABLE OF
193 IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE
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
365 INDEX BY BINARY_INTEGER;
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
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
424 IBY_PAYMENT_METHODS_B.support_bills_payable_flag%TYPE
425 INDEX BY BINARY_INTEGER;
426
427 TYPE t_iba_legal_entity_id IS TABLE OF
428 CE_BANK_ACCOUNTS.account_owner_org_id%TYPE
429 INDEX BY BINARY_INTEGER;
430
434
431 TYPE t_int_bank_country_code IS TABLE OF
432 CE_BANK_BRANCHES_V.country%TYPE
433 INDEX BY BINARY_INTEGER;
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
465 TYPE docs_pay_tab_type IS RECORD
466 (
467 pay_proc_trxn_type_code t_pay_proc_trxn_type_code,
468 calling_app_id t_calling_app_id,
469 calling_app_doc_ref_number t_calling_app_doc_ref_number,
470 call_app_pay_service_req_code t_call_app_pay_srvc_req_cd,
471 document_payable_id t_document_payable_id,
472 payment_function t_payment_function,
473 payment_date t_payment_date,
474 document_date t_document_date,
475 document_type t_document_type,
476 document_status t_document_status,
477 document_currency_code t_document_currency_code,
478 document_amount t_document_amount,
479 payment_currency_code t_payment_currency_code,
480 payment_amount t_payment_amount,
481 payment_service_request_id t_payment_service_request_id,
482 payment_method_code t_payment_method_code,
483 exclusive_payment_flag t_exclusive_payment_flag,
484 straight_through_flag t_straight_through_flag,
485 ext_payee_id t_ext_payee_id,
486 payee_party_id t_payee_party_id,
487 legal_entity_id t_legal_entity_id,
488 org_id t_org_id,
489 allow_removing_document_flag t_allow_removing_document_flag,
490 created_by t_created_by,
491 creation_date t_creation_date,
492 last_updated_by t_last_updated_by,
493 last_update_date t_last_update_date,
494 object_version_number t_object_version_number,
495 calling_app_doc_unique_ref1 t_calling_app_doc_unique_ref1,
496 calling_app_doc_unique_ref2 t_calling_app_doc_unique_ref2,
497 calling_app_doc_unique_ref3 t_calling_app_doc_unique_ref3,
498 calling_app_doc_unique_ref4 t_calling_app_doc_unique_ref4,
499 calling_app_doc_unique_ref5 t_calling_app_doc_unique_ref5,
500 last_update_login t_last_update_login,
501 party_site_id t_party_site_id,
502 supplier_site_id t_supplier_site_id,
503 beneficiary_party t_beneficiary_party,
504 org_type t_org_type,
505 anticipated_value_date t_anticipated_value_date,
506 po_number t_po_number,
507 document_description t_document_description,
508 document_currency_tax_amount t_document_currency_tax_amount,
509 document_curr_charge_amount t_document_curr_charge_amount,
510 amount_withheld t_amount_withheld,
511 payment_curr_discount_taken t_payment_curr_discount_taken,
512 discount_date t_discount_date,
513 payment_due_date t_payment_due_date,
514 payment_profile_id t_payment_profile_id,
515 payment_id t_payment_id,
516 formatting_payment_id t_formatting_payment_id,
517 internal_bank_account_id t_internal_bank_account_id,
518 external_bank_account_id t_external_bank_account_id,
519 bank_charge_bearer t_bank_charge_bearer,
520 interest_rate t_interest_rate,
521 payment_grouping_number t_payment_grouping_number,
522 payment_reason_code t_payment_reason_code,
523 payment_reason_comments t_payment_reason_comments,
524 settlement_priority t_settlement_priority,
525 remittance_message1 t_remittance_message1,
526 remittance_message2 t_remittance_message2,
527 remittance_message3 t_remittance_message3,
528 unique_remittance_identifier t_unique_remittance_identifier,
529 uri_check_digit t_uri_check_digit,
533 document_sequence_value t_document_sequence_value,
530 delivery_channel_code t_delivery_channel_code,
531 payment_format_code t_payment_format_code,
532 document_sequence_id t_document_sequence_id,
534 document_category_code t_document_category_code,
535 bank_assigned_ref_code t_bank_assigned_ref_code,
536 remit_to_location_id t_remit_to_location_id,
537 completed_pmts_group_id t_completed_pmts_group_id,
538 rejected_docs_group_id t_rejected_docs_group_id,
539 attribute_category t_attribute_category,
540 attribute1 t_attribute1,
541 attribute2 t_attribute2,
542 attribute3 t_attribute3,
543 attribute4 t_attribute4,
544 attribute5 t_attribute5,
545 attribute6 t_attribute6,
546 attribute7 t_attribute7,
547 attribute8 t_attribute8,
548 attribute9 t_attribute9,
549 attribute10 t_attribute10,
550 attribute11 t_attribute11,
551 attribute12 t_attribute12,
552 attribute13 t_attribute13,
553 attribute14 t_attribute14,
554 attribute15 t_attribute15,
555 address_source t_address_source,
556 employee_address_code t_employee_address_code,
557 employee_payment_flag t_employee_payment_flag,
558 employee_person_id t_employee_person_id,
559 employee_address_id t_employee_address_id,
560 bank_instruction1_code t_bank_instruction1_code,
561 bank_instruction2_code t_bank_instruction2_code,
562 payment_text_message1 t_payment_text_message1,
563 payment_text_message2 t_payment_text_message2,
564 payment_text_message3 t_payment_text_message3,
565 group_by_remittance_message t_group_by_remittance_message,
566 group_by_bank_charge_bearer t_group_by_bank_charge_bearer,
567 group_by_delivery_channel t_group_by_delivery_channel,
568 group_by_settle_priority_flag t_grp_by_settle_priority_flag,
569 group_by_payment_details_flag t_grp_by_payment_details_flag,
570 payment_details_length_limit t_payment_details_length_limit,
571 payment_details_formula t_payment_details_formula,
572 group_by_max_documents_flag t_group_by_max_documents_flag,
573 max_documents_per_payment t_max_documents_per_payment,
574 group_by_unique_remit_id_flag t_grp_by_unique_remit_id_flag,
575 group_by_payment_reason t_group_by_payment_reason,
576 group_by_due_date_flag t_group_by_due_date_flag,
577 processing_type t_processing_type,
578 declaration_option t_declaration_option,
579 dcl_only_foreign_curr_pmt_flag t_dcl_only_foren_curr_pmt_flag,
580 declaration_curr_fx_rate_type t_dcl_curr_fx_rate_type,
581 declaration_currency_code t_declaration_currency_code,
582 declaration_threshold_amount t_declaration_threshold_amount,
583 maximum_payment_amount t_maximum_payment_amount,
584 minimum_payment_amount t_minimum_payment_amount,
585 allow_zero_payments_flag t_allow_zero_payments_flag,
586 support_bills_payable_flag t_support_bills_payable_flag,
587 iba_legal_entity_id t_iba_legal_entity_id,
588 int_bank_country_code t_int_bank_country_code,
589 ext_bank_country_code t_ext_bank_country_code,
590 foreign_pmts_allowed_flag t_foreign_pmts_allowed_flag,
591
592 /*TPP-Start*/
593 inv_payee_party_id t_inv_payee_party_id,
594 inv_party_site_id t_inv_party_site_id,
595 inv_supplier_site_id t_inv_supplier_site_id,
596 inv_beneficiary_party t_inv_beneficiary_party,
597 ext_inv_payee_id t_ext_inv_payee_id,
598 relationship_id t_relationship_id
599 /*TPP-End*/
600
601 );
602
603 docspayTab docs_pay_tab_type;
604
605 /*--------------------------------------------------------------------
606 | NAME:
607 |
608 | PURPOSE:
609 | This procedure is used to initialize global memory structure
610 | / Destroy the no longer used memory structure
611 |
612 | PARAMETERS:
613 |
614 | NONE
615 |
616 | RETURNS:
617 |
618 | NOTES:
619 |
620 *---------------------------------------------------------------------*/
621 PROCEDURE delete_docspayTab;
622
623 /*--------------------------------------------------------------------
624 | NAME:
625 | submit_payment_process_request
626 |
627 | PURPOSE:
628 | This is the top level procedure of the build program; This
629 | procedure will run as a concurrent program.
630 |
631 | PARAMETERS:
632 |
633 | IN
634 |
635 | p_calling_app_id
636 | The 3-character product code of te calling application
637 |
638 | p_calling_app_payreq_id
639 | Id of the payment service request from the calling app's
640 | point of view. For a given calling app, this id should be
641 | unique; the build program will communicate back to the calling
642 | app using this payment request id.
643 |
644 | p_internal_bank_account_id
645 | The internal bank account to pay from.
646 |
647 | p_payment_profile_id
648 | Payment profile
649 |
650 | p_allow_zero_payments_flag
651 | 'Y' / 'N' flag indicating whether zero value payments are allowed.
652 | If not set, this value will be defaulted to 'N'.
653 |
654 | p_payment_date
655 | The payment date.
656 |
657 | p_anticipated_value_date
658 | The anticipated value date.
659 |
660 | p_maximum_payment_amount
661 | Maximum allowed amount for a single payment. Payments will be
662 | validated against this ceiling.
663 |
664 | p_minimum_payment_amount
665 | Minimum allowed amount for a single payment. Payments will be
666 | validated against this floor.
667 |
668 | p_create_instrs_flag
669 | 'Y' / 'N' flag indicating whether payment instruction creation
670 | should be invoked for this payment service request as soon the
671 | Build Program completes.
672 |
673 | p_args12 - p_args100
674 | These 89 parameters are mandatory for any stored procedure
675 | that is submitted from Oracle Forms as a concurrent request.
676 | (to get the total number of args to the concurrent procedure
677 | to 100).
678 |
679 | OUT
680 |
681 | x_errbuf
682 | x_retcode
683 |
684 | These two are mandatory output paramaters for a concurrent
685 | program. They will store the error message and error code
686 | to indicate a successful/failed run of the concurrent request.
687 |
688 | RETURNS:
689 |
690 | NOTES:
691 |
692 *---------------------------------------------------------------------*/
693 PROCEDURE submit_payment_process_request(
694 x_errbuf OUT NOCOPY VARCHAR2,
695 x_retcode OUT NOCOPY VARCHAR2,
696 p_calling_app_id IN VARCHAR2,
697 p_calling_app_payreq_cd IN VARCHAR2,
698 p_internal_bank_account_id IN VARCHAR2 DEFAULT NULL,
699 p_payment_profile_id IN VARCHAR2 DEFAULT NULL,
700 p_allow_zero_payments_flag IN VARCHAR2 DEFAULT 'N',
701 p_maximum_payment_amount IN VARCHAR2 DEFAULT NULL,
702 p_minimum_payment_amount IN VARCHAR2 DEFAULT NULL,
703 p_document_rejection_level IN VARCHAR2 DEFAULT NULL,
704 p_payment_rejection_level IN VARCHAR2 DEFAULT NULL,
705 p_review_proposed_pmts_flag IN VARCHAR2 DEFAULT 'X',
706 p_create_instrs_flag IN VARCHAR2 DEFAULT 'N',
707 p_payment_document_id IN VARCHAR2 DEFAULT NULL,
708 p_attribute_category IN VARCHAR2 DEFAULT NULL, p_attribute1 IN VARCHAR2 DEFAULT NULL,
712 p_attribute8 IN VARCHAR2 DEFAULT NULL, p_attribute9 IN VARCHAR2 DEFAULT NULL,
709 p_attribute2 IN VARCHAR2 DEFAULT NULL, p_attribute3 IN VARCHAR2 DEFAULT NULL,
710 p_attribute4 IN VARCHAR2 DEFAULT NULL, p_attribute5 IN VARCHAR2 DEFAULT NULL,
711 p_attribute6 IN VARCHAR2 DEFAULT NULL, p_attribute7 IN VARCHAR2 DEFAULT NULL,
713 p_attribute10 IN VARCHAR2 DEFAULT NULL, p_attribute11 IN VARCHAR2 DEFAULT NULL,
714 p_attribute12 IN VARCHAR2 DEFAULT NULL, p_attribute13 IN VARCHAR2 DEFAULT NULL,
715 p_attribute14 IN VARCHAR2 DEFAULT NULL, p_attribute15 IN VARCHAR2 DEFAULT NULL,
716 p_arg30 IN VARCHAR2 DEFAULT NULL, p_arg31 IN VARCHAR2 DEFAULT NULL,
717 p_arg32 IN VARCHAR2 DEFAULT NULL, p_arg33 IN VARCHAR2 DEFAULT NULL,
718 p_arg34 IN VARCHAR2 DEFAULT NULL, p_arg35 IN VARCHAR2 DEFAULT NULL,
719 p_arg36 IN VARCHAR2 DEFAULT NULL, p_arg37 IN VARCHAR2 DEFAULT NULL,
720 p_arg38 IN VARCHAR2 DEFAULT NULL, p_arg39 IN VARCHAR2 DEFAULT NULL,
721 p_arg40 IN VARCHAR2 DEFAULT NULL, p_arg41 IN VARCHAR2 DEFAULT NULL,
722 p_arg42 IN VARCHAR2 DEFAULT NULL, p_arg43 IN VARCHAR2 DEFAULT NULL,
723 p_arg44 IN VARCHAR2 DEFAULT NULL, p_arg45 IN VARCHAR2 DEFAULT NULL,
724 p_arg46 IN VARCHAR2 DEFAULT NULL, p_arg47 IN VARCHAR2 DEFAULT NULL,
725 p_arg48 IN VARCHAR2 DEFAULT NULL, p_arg49 IN VARCHAR2 DEFAULT NULL,
726 p_arg50 IN VARCHAR2 DEFAULT NULL, p_arg51 IN VARCHAR2 DEFAULT NULL,
727 p_arg52 IN VARCHAR2 DEFAULT NULL, p_arg53 IN VARCHAR2 DEFAULT NULL,
728 p_arg54 IN VARCHAR2 DEFAULT NULL, p_arg55 IN VARCHAR2 DEFAULT NULL,
729 p_arg56 IN VARCHAR2 DEFAULT NULL, p_arg57 IN VARCHAR2 DEFAULT NULL,
730 p_arg58 IN VARCHAR2 DEFAULT NULL, p_arg59 IN VARCHAR2 DEFAULT NULL,
731 p_arg60 IN VARCHAR2 DEFAULT NULL, p_arg61 IN VARCHAR2 DEFAULT NULL,
732 p_arg62 IN VARCHAR2 DEFAULT NULL, p_arg63 IN VARCHAR2 DEFAULT NULL,
733 p_arg64 IN VARCHAR2 DEFAULT NULL, p_arg65 IN VARCHAR2 DEFAULT NULL,
734 p_arg66 IN VARCHAR2 DEFAULT NULL, p_arg67 IN VARCHAR2 DEFAULT NULL,
735 p_arg68 IN VARCHAR2 DEFAULT NULL, p_arg69 IN VARCHAR2 DEFAULT NULL,
736 p_arg70 IN VARCHAR2 DEFAULT NULL, p_arg71 IN VARCHAR2 DEFAULT NULL,
737 p_arg72 IN VARCHAR2 DEFAULT NULL, p_arg73 IN VARCHAR2 DEFAULT NULL,
738 p_arg74 IN VARCHAR2 DEFAULT NULL, p_arg75 IN VARCHAR2 DEFAULT NULL,
739 p_arg76 IN VARCHAR2 DEFAULT NULL, p_arg77 IN VARCHAR2 DEFAULT NULL,
740 p_arg78 IN VARCHAR2 DEFAULT NULL, p_arg79 IN VARCHAR2 DEFAULT NULL,
741 p_arg80 IN VARCHAR2 DEFAULT NULL, p_arg81 IN VARCHAR2 DEFAULT NULL,
742 p_arg82 IN VARCHAR2 DEFAULT NULL, p_arg83 IN VARCHAR2 DEFAULT NULL,
743 p_arg84 IN VARCHAR2 DEFAULT NULL, p_arg85 IN VARCHAR2 DEFAULT NULL,
744 p_arg86 IN VARCHAR2 DEFAULT NULL, p_arg87 IN VARCHAR2 DEFAULT NULL,
745 p_arg88 IN VARCHAR2 DEFAULT NULL, p_arg89 IN VARCHAR2 DEFAULT NULL,
746 p_arg90 IN VARCHAR2 DEFAULT NULL, p_arg91 IN VARCHAR2 DEFAULT NULL,
747 p_arg92 IN VARCHAR2 DEFAULT NULL, p_arg93 IN VARCHAR2 DEFAULT NULL,
748 p_arg94 IN VARCHAR2 DEFAULT NULL, p_arg95 IN VARCHAR2 DEFAULT NULL,
749 p_arg96 IN VARCHAR2 DEFAULT NULL, p_arg97 IN VARCHAR2 DEFAULT NULL,
750 p_arg98 IN VARCHAR2 DEFAULT NULL, p_arg99 IN VARCHAR2 DEFAULT NULL,
751 p_arg100 IN VARCHAR2 DEFAULT NULL
752 );
753
754 /*--------------------------------------------------------------------
755 | NAME:
756 | get_payreq_list
757 |
758 | PURPOSE:
759 |
760 |
761 | PARAMETERS:
762 | IN
763 |
764 |
765 | OUT
766 |
767 |
768 | RETURNS:
769 |
770 | NOTES:
771 |
772 *---------------------------------------------------------------------*/
773 FUNCTION get_payreq_list (
774 p_status IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_status%TYPE)
775 RETURN payreq_tbl_type;
776
777 /*--------------------------------------------------------------------
778 | NAME:
779 | get_payreq_status
780 |
781 |
782 | PURPOSE:
783 |
784 |
785 | PARAMETERS:
786 | IN
787 |
788 |
789 | OUT
790 |
791 |
792 | RETURNS:
793 |
794 | NOTES:
795 |
796 *---------------------------------------------------------------------*/
797 FUNCTION get_payreq_status (
798 l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
799 RETURN VARCHAR2;
800
801 /*--------------------------------------------------------------------
802 | NAME:
803 | insert_payreq
804 |
805 |
806 | PURPOSE:
807 |
808 |
809 | PARAMETERS:
810 | IN
811 |
812 |
813 | OUT
814 |
815 |
816 | RETURNS:
817 |
818 | NOTES:
819 |
820 *---------------------------------------------------------------------*/
821 FUNCTION insert_payreq (
822 p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
823 p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
824 call_app_pay_service_req_code%TYPE,
825 p_internal_bank_account_id
826 IN IBY_PAY_SERVICE_REQUESTS.
827 internal_bank_account_id%TYPE,
828 p_payment_profile_id
829 IN IBY_PAY_SERVICE_REQUESTS.
830 payment_profile_id%TYPE,
831 p_allow_zero_payments_flag
835 maximum_payment_amount%TYPE,
832 IN IBY_PAY_SERVICE_REQUESTS.
833 allow_zero_payments_flag%TYPE,
834 p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
836 p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
837 minimum_payment_amount%TYPE,
838 p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
839 document_rejection_level_code%TYPE,
840 p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
841 payment_rejection_level_code%TYPE,
842 p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
843 require_prop_pmts_review_flag%TYPE,
844 p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
845 create_pmt_instructions_flag%TYPE,
846 p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
847 payment_document_id%TYPE,
848 p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
849 attribute_category%TYPE,
850 p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
851 attribute1%TYPE,
852 p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
853 attribute2%TYPE,
854 p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
855 attribute3%TYPE,
856 p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
857 attribute4%TYPE,
858 p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
859 attribute5%TYPE,
860 p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
861 attribute6%TYPE,
862 p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
863 attribute7%TYPE,
864 p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
865 attribute8%TYPE,
866 p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
867 attribute9%TYPE,
868 p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
869 attribute10%TYPE,
870 p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
871 attribute11%TYPE,
872 p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
873 attribute12%TYPE,
874 p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
875 attribute13%TYPE,
876 p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.
877 attribute14%TYPE,
878 p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.
879 attribute15%TYPE
880 )
881 RETURN NUMBER;
882
883 /*--------------------------------------------------------------------
884 | NAME:
885 | getNextPayReqID
886 |
887 | PURPOSE:
888 |
889 |
890 | PARAMETERS:
891 | IN
892 |
893 |
894 | OUT
895 |
896 |
897 | RETURNS:
898 |
899 | NOTES:
900 |
901 *---------------------------------------------------------------------*/
902 FUNCTION getNextPayReqID
903 RETURN NUMBER;
904
905 /*--------------------------------------------------------------------
906 | NAME:
907 | insert_payreq_documents
908 |
909 |
910 | PURPOSE:
911 |
912 |
913 | PARAMETERS:
914 | IN
915 |
916 |
917 | OUT
918 |
919 |
920 | RETURNS:
921 |
922 | NOTES:
923 |
924 *---------------------------------------------------------------------*/
925 FUNCTION insert_payreq_documents (
926 p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
927 p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
928 call_app_pay_service_req_code%TYPE,
929 p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
930 payment_service_request_id%TYPE
931 )
932 RETURN NUMBER;
933
934 /*--------------------------------------------------------------------
935 | NAME:
936 | getNextDocumentPayableID
937 |
938 | PURPOSE:
939 |
940 |
941 | PARAMETERS:
942 | IN
943 |
944 |
945 | OUT
946 |
947 |
948 | RETURNS:
949 |
950 | NOTES:
951 |
952 *---------------------------------------------------------------------*/
953 FUNCTION getNextDocumentPayableID
954 RETURN NUMBER;
955
956 /*--------------------------------------------------------------------
957 | NAME:
958 | getNextDocumentPayableLineID
959 |
960 | PURPOSE:
961 |
962 |
963 | PARAMETERS:
964 | IN
965 |
966 |
967 | OUT
968 |
969 |
970 | RETURNS:
971 |
972 | NOTES:
973 |
974 *---------------------------------------------------------------------*/
975 FUNCTION getNextDocumentPayableLineID
979 | NAME:
976 RETURN NUMBER;
977
978 /*--------------------------------------------------------------------
980 | checkIfDuplicate
981 |
982 | PURPOSE:
983 |
984 |
985 | PARAMETERS:
986 | IN
987 |
988 |
989 | OUT
990 |
991 |
992 | RETURNS:
993 |
994 | NOTES:
995 |
996 *---------------------------------------------------------------------*/
997 FUNCTION checkIfDuplicate(
998 p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
999 p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1000 call_app_pay_service_req_code%TYPE
1001 )
1002 RETURN NUMBER;
1003
1004 /*--------------------------------------------------------------------
1005 | NAME:
1006 | derivePayeeIdFromContext
1007 |
1008 | PURPOSE:
1009 |
1010 |
1011 | PARAMETERS:
1012 | IN
1013 |
1014 |
1015 | OUT
1016 |
1017 |
1018 | RETURNS:
1019 |
1020 | NOTES:
1021 |
1022 *---------------------------------------------------------------------*/
1023 FUNCTION derivePayeeIdFromContext(
1024 p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1025 p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1026 p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1027 p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1028 p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1029 p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1030 )
1031 RETURN NUMBER;
1032
1033 /*--------------------------------------------------------------------
1034 | NAME:
1035 | deriveExactPayeeIdFromContext
1036 |
1037 | PURPOSE:
1038 |
1039 |
1040 | PARAMETERS:
1041 | IN
1042 |
1043 |
1044 | OUT
1045 |
1046 |
1047 | RETURNS:
1048 |
1049 | NOTES:
1050 |
1051 *---------------------------------------------------------------------*/
1052 FUNCTION deriveExactPayeeIdFromContext(
1053 p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1054 p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1055 p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1056 p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1057 p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1058 p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1059 )
1060 RETURN NUMBER;
1061
1062 /*--------------------------------------------------------------------
1063 | NAME:
1064 | deriveDistinctAccessTypsForReq
1065 |
1066 | PURPOSE:
1067 |
1068 |
1069 | PARAMETERS:
1070 | IN
1071 |
1072 |
1073 | OUT
1074 |
1075 |
1076 | RETURNS:
1077 |
1078 | NOTES:
1079 |
1080 *---------------------------------------------------------------------*/
1081 PROCEDURE deriveDistinctAccessTypsForReq(
1082 p_payreq_id IN IBY_DOCS_PAYABLE_ALL.payment_service_request_id
1083 %TYPE,
1084 p_pmt_function IN IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
1085 p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1086 p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1087 x_pmtFxAccessTypesTab IN OUT NOCOPY distinctPmtFxAccessTab,
1088 x_orgAccessTypesTab IN OUT NOCOPY distinctOrgAccessTab
1089 );
1090
1091 /*--------------------------------------------------------------------
1092 | NAME:
1093 | insertDistinctAccessTypsForReq
1094 |
1095 | PURPOSE:
1096 |
1097 |
1098 | PARAMETERS:
1099 | IN
1100 |
1101 |
1102 | OUT
1103 |
1104 |
1105 | RETURNS:
1106 |
1107 | NOTES:
1108 |
1109 *---------------------------------------------------------------------*/
1110 PROCEDURE insertDistinctAccessTypsForReq(
1111 p_pmtFxAccessTypesTab IN distinctPmtFxAccessTab,
1112 p_orgAccessTypesTab IN distinctOrgAccessTab
1113 );
1114
1115 /*--------------------------------------------------------------------
1116 | NAME:
1117 | set_profile_attribs
1118 |
1119 |
1120 | PURPOSE:
1121 | Sets the attributes of the payment profile structure
1122 |
1123 | PARAMETERS:
1124 | IN
1125 |
1126 |
1127 | OUT
1128 |
1129 |
1130 | RETURNS:
1131 |
1132 | NOTES:
1133 |
1134 *---------------------------------------------------------------------*/
1135 PROCEDURE set_profile_attribs(
1136 p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE
1137 );
1138
1139 /*--------------------------------------------------------------------
1140 | NAME:
1141 | get_profile_process_attribs
1142 |
1143 |
1144 | PURPOSE:
1145 |
1146 |
1147 | PARAMETERS:
1148 | IN
1149 |
1150 |
1151 | OUT
1152 |
1153 |
1154 | RETURNS:
1155 |
1156 | NOTES:
1157 |
1158 *---------------------------------------------------------------------*/
1159 PROCEDURE get_profile_process_attribs(
1160 p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE,
1161 x_profile_attribs IN OUT NOCOPY profileProcessAttribs
1162 );
1163
1164 /*--------------------------------------------------------------------
1165 | NAME:
1166 | checkIfDefaultPmtDocOnProfile
1167 |
1168 | PURPOSE:
1169 |
1170 |
1171 | PARAMETERS:
1172 | IN
1173 |
1174 |
1175 | OUT
1176 |
1177 |
1178 | RETURNS:
1179 |
1180 | NOTES:
1181 |
1182 *---------------------------------------------------------------------*/
1183 PROCEDURE checkIfDefaultPmtDocOnProfile (
1184 p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE,
1185 x_profile_name IN OUT NOCOPY IBY_PAYMENT_PROFILES.system_profile_name%TYPE,
1186 x_return_flag IN OUT NOCOPY BOOLEAN
1187 );
1188
1189 /*--------------------------------------------------------------------
1190 | NAME:
1191 | print_debuginfo
1192 |
1193 | PURPOSE:
1194 |
1195 |
1196 | PARAMETERS:
1197 | IN
1198 |
1199 |
1200 | OUT
1201 |
1202 |
1203 | RETURNS:
1204 |
1205 | NOTES:
1206 |
1207 *---------------------------------------------------------------------*/
1208 PROCEDURE print_debuginfo(
1209 p_module IN VARCHAR2,
1210 p_debug_text IN VARCHAR2,
1211 p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
1212 );
1213
1214 /*--------------------------------------------------------------------
1215 | NAME:
1216 | checkIfPmtsInModifiedStatus
1217 |
1218 |
1219 | PURPOSE:
1220 |
1221 |
1222 | PARAMETERS:
1223 | IN
1224 |
1225 |
1226 | OUT
1227 |
1228 |
1229 | RETURNS:
1230 |
1231 | NOTES:
1232 |
1233 *---------------------------------------------------------------------*/
1234 FUNCTION checkIfPmtsInModifiedStatus(
1235 l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
1236 RETURN BOOLEAN;
1237
1238 /*--------------------------------------------------------------------
1239 | NAME:
1240 | checkIfPmtsInModBankAccStatus
1241 |
1242 |
1243 | PURPOSE:
1244 |
1245 |
1246 | PARAMETERS:
1247 | IN
1248 |
1249 |
1250 | OUT
1251 |
1252 |
1253 | RETURNS:
1254 |
1255 | NOTES:
1256 |
1257 *---------------------------------------------------------------------*/
1258 FUNCTION checkIfPmtsInModBankAccStatus(
1259 l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
1260 RETURN BOOLEAN;
1261
1262 /*--------------------------------------------------------------------
1263 | NAME:
1264 | launchPPRStatusReport
1265 |
1266 | PURPOSE:
1267 |
1268 |
1269 | PARAMETERS:
1270 | IN
1271 |
1272 |
1273 | OUT
1274 |
1275 |
1276 | RETURNS:
1277 |
1278 | NOTES:
1279 |
1280 *---------------------------------------------------------------------*/
1281 PROCEDURE launchPPRStatusReport(
1282 p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
1283 payment_service_request_id%TYPE
1284 );
1285
1286 END IBY_DISBURSE_SUBMIT_PUB_PKG;