1 PACKAGE IBY_DISBURSEMENT_COMP_PUB AUTHID CURRENT_USER AS
2 /*$Header: ibydiscs.pls 120.9.12010000.2 2010/03/03 06:34:01 vkarlapu ship $*/
3
4 --
5 -- Declaring Global variables
6 --
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_DISBURSEMENT_COMP_PUB';
8
9 --
10 -- module name used for the application debugging framework
11 --
12 G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_DISBURSEMENT_COMP_PUB';
13
14 -- Lookup Types
15 BANK_CHARGE_BEARER_LOOKUP CONSTANT VARCHAR2(100) := 'IBY_BANK_CHARGE_BEARER';
16 SETTLEMENT_PRIORITY_LOOKUP CONSTANT VARCHAR2(100) := 'IBY_SETTLEMENT_PRIORITY';
17
18 -------------------------------------------------------------------------
19 -- **Defining all Data Structures required by the APIs**
20 -- The following PL/SQL record/table types are defined
21 -- to store the objects (entities) necessary for the APIs.
22 -------------------------------------------------------------------------
23 --
24 -- Generic Record Types
25 --
26
27 -- Input Transaction Record
28 Type Trxn_Attributes_Rec_Type IS Record(
29 Application_Id NUMBER,
30 Payer_Legal_Entity_Id XLE_FIRSTPARTY_INFORMATION_V.legal_entity_id%TYPE,
31 Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
32 Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
33 Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
34 Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
35 Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
36 Pay_Proc_Trxn_Type_Code
37 IBY_TRXN_TYPES_B.pay_proc_trxn_type_code%TYPE,
38 Payment_Currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
39 Payment_Amount IBY_DOCS_PAYABLE_ALL.document_amount%TYPE,
40 Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
41 );
42
43
44 -- Payment Method Record
45 Type Payment_Method_Rec_Type is Record
46 (
47 Payment_Method_Name IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_NAME%TYPE,
48 Payment_Method_Code IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_CODE%TYPE,
49 Bill_Payable_Flag IBY_PAYMENT_METHODS_VL.SUPPORT_BILLS_PAYABLE_FLAG%TYPE,
50 Maturity_Date_Offset IBY_PAYMENT_METHODS_VL.MATURITY_DATE_OFFSET_DAYS%TYPE,
51 DESCRIPTION IBY_PAYMENT_METHODS_VL.DESCRIPTION%TYPE
52 );
53
54 -- Payment Profile Drivers Record
55 Type PPP_Drivers_Rec_Type IS Record(
56 Payment_Method_Code IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
57 Payer_Org_Id IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
58 Payer_Org_Type IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
59 Payment_Currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
60 Int_Bank_Account_Id IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
61 );
62
63 -- Payment Profile Record
64 Type Payment_Profile_Rec_Type is Record
65 (
66 Payment_Profile_Id IBY_PAYMENT_PROFILES.PAYMENT_PROFILE_ID%TYPE,
67 Payment_Profile_Name IBY_PAYMENT_PROFILES.PAYMENT_PROFILE_NAME%TYPE,
68 Processing_Type IBY_PAYMENT_PROFILES.PROCESSING_TYPE%TYPE
69 );
70
71 -- Payment Format Record
72 Type Payment_Format_Rec_Type is Record
73 (
74 Payment_Format_Name IBY_FORMATS_VL.FORMAT_NAME%TYPE,
75 Payment_Format_Code IBY_FORMATS_VL.FORMAT_CODE%TYPE
76 );
77
78
79 -- Payee Bank Account Record
80 Type Payee_BankAccount_Rec_Type is Record(
81 Payee_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
82 Payee_BankAccount_Id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE,
83 Payee_BankAccount_Num IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
84 Currency_Code IBY_EXT_BANK_ACCOUNTS_V.CURRENCY_CODE%TYPE,
85 IBAN IBY_EXT_BANK_ACCOUNTS_V.IBAN_NUMBER%TYPE,
86 Payee_BankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE,
87 Payee_BankNumber IBY_EXT_BANK_ACCOUNTS_V.BANK_NUMBER%TYPE,
88 Payee_BranchName IBY_EXT_BANK_ACCOUNTS_V.BANK_BRANCH_NAME%TYPE,
89 Payee_BranchNumber IBY_EXT_BANK_ACCOUNTS_V.BRANCH_NUMBER%TYPE,
90 Bank_Country IBY_EXT_BANK_ACCOUNTS_V.COUNTRY_CODE%TYPE,
91 Alter_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.ALTERNATE_ACCOUNT_NAME%TYPE,
92 BankAccount_Type IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_TYPE%TYPE,
93 BankAccount_Suffix IBY_EXT_BANK_ACCOUNTS_V.ACCOUNT_SUFFIX%TYPE,
94 BankAccount_Desc IBY_EXT_BANK_ACCOUNTS_V.DESCRIPTION%TYPE,
95 Foreign_PayUse_Flag IBY_EXT_BANK_ACCOUNTS_V.FOREIGN_PAYMENT_USE_FLAG%TYPE,
96 Pay_Factor_Flag IBY_EXT_BANK_ACCOUNTS_V.PAYMENT_FACTOR_FLAG%TYPE,
97 EFT_Swift_Code IBY_EXT_BANK_ACCOUNTS_V.EFT_SWIFT_CODE%TYPE
98 );
99
100
101 -- Payment Reason Record
102 Type Payment_Reason_Rec_Type is Record
103 (
104 Code IBY_PAYMENT_REASONS_VL.payment_reason_code%TYPE,
105 Meaning IBY_PAYMENT_REASONS_VL.meaning%TYPE,
106 Description IBY_PAYMENT_REASONS_VL.description%TYPE,
107 Country IBY_PAYMENT_REASONS_VL.territory_code%TYPE
108 );
109
110 -- Bank Charge Bearer Record
111 Type Bank_Charge_Bearer_Rec_Type is Record(
112 Code VARCHAR2(30),
113 Meaning VARCHAR2(80),
114 Description VARCHAR2(255)
115 );
116
117
118 -- Settlement Priority Record
119 Type Settlement_Priority_Rec_Type is Record(
120 Code VARCHAR2(30),
121 Meaning VARCHAR2(80),
122 Description VARCHAR2(255)
123 );
124
125
126 -- Delivery Channel Record
127 Type Delivery_Channel_Rec_Type is Record
128 (
129 Code IBY_DELIVERY_CHANNELS_VL.delivery_channel_code%TYPE,
130 Meaning IBY_DELIVERY_CHANNELS_VL.meaning%TYPE,
131 Description IBY_DELIVERY_CHANNELS_VL.description%TYPE,
132 Country IBY_DELIVERY_CHANNELS_VL.territory_code%TYPE
133 );
134
135
136 -- Table of Payment Method Records
137 Type Payment_Method_Tab_Type is Table of Payment_Method_Rec_Type INDEX by BINARY_INTEGER;
138
139 -- Table of Payment Profile Records
140 Type Payment_Profile_Tab_Type is Table of Payment_Profile_Rec_Type
141 INDEX by BINARY_INTEGER;
142
143 -- Table of Payment Profile Record Tables
144 -- i.e., Two-dimensional table of payment profiles
145 Type Payment_Profile_2D_Tab_Type IS TABLE OF Payment_Profile_Tab_Type
146 INDEX BY BINARY_INTEGER;
147
148 -- Table of Payment Profile Driver Records
149 Type PPP_Drivers_Tab_Type is Table of PPP_Drivers_Rec_Type
150 INDEX by BINARY_INTEGER;
151
152 -- Table of Payment Format Records
153 Type Payment_Format_Tab_Type is Table of Payment_Format_Rec_Type INDEX by BINARY_INTEGER;
154
155 -- Table of Payee Bank Account Records
156 Type Payee_BankAccount_Tab_Type is Table of Payee_BankAccount_Rec_Type INDEX by BINARY_INTEGER;
157
158 -- Table of Payment Reason Records
159 Type Payment_Reason_Tab_Type is Table of Payment_Reason_Rec_Type INDEX by BINARY_INTEGER;
160
161 -- Table of Delivery Channels Records
162 Type Delivery_Channel_Tab_Type is Table of Delivery_Channel_Rec_Type INDEX by BINARY_INTEGER;
163
164 -- Default Payment Attributes Record
165 Type Default_Pmt_Attrs_Rec_Type is Record(
166 Payment_Method Payment_Method_Rec_Type,
167 Payment_Format Payment_Format_Rec_Type,
168 Payee_BankAccount Payee_BankAccount_Rec_Type,
169 Payment_Reason Payment_Reason_Rec_Type,
170 Delivery_Channel Delivery_Channel_Rec_Type,
171 Bank_Charge_Bearer Bank_Charge_Bearer_Rec_Type,
172 Settlement_Priority Settlement_Priority_Rec_Type,
173 Pay_Alone VARCHAR2(1),
174 payment_reason_comments VARCHAR2(240)
175 );
176
177 -- Payment Field Properties Record
178 Type Applicable_Pmt_Attrs_Rec_Type is Record(
179 Payment_Reason_Comnt_apl_flag IBY_PAYMENT_METHODS_VL.payment_reason_comnt_apl_flag%TYPE,
180 Remittance_Message1_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message1_apl_flag%TYPE,
181 Remittance_Message2_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message2_apl_flag%TYPE,
182 Remittance_Message3_apl_flag IBY_PAYMENT_METHODS_VL.remittance_message3_apl_flag%TYPE,
183
184 Unique_Remittance_apl_flag IBY_PAYMENT_METHODS_VL.unique_remittance_id_apl_flag%TYPE,
185 URI_CheckDigit_apl_flag IBY_PAYMENT_METHODS_VL.uri_check_digit_apl_flag%TYPE,
186 Payment_Format_apl_flag IBY_PAYMENT_METHODS_VL.payment_format_apl_flag%TYPE,
187 Delivery_Channel_apl_flag IBY_PAYMENT_METHODS_VL.delivery_channel_apl_flag%TYPE,
188
189 Bank_Charge_Bearer_apl_flag IBY_PAYMENT_METHODS_VL.bank_charge_bearer_apl_flag%TYPE,
190 Settlement_Priority_apl_flag IBY_PAYMENT_METHODS_VL.settlement_priority_apl_flag%TYPE,
191 Payment_Reason_apl_flag IBY_PAYMENT_METHODS_VL.payment_reason_apl_flag%TYPE,
192 external_bank_acct_apl_flag IBY_PAYMENT_METHODS_VL.external_bank_acct_apl_flag%TYPE,
193 exclusive_pmt_apl_flag IBY_PAYMENT_METHODS_VL.exclusive_pmt_apl_flag%TYPE,
194 Inactive_Date IBY_PAYMENT_METHODS_VL.inactive_date%TYPE
195
196 );
197
198 -- Start of comments
199 -- API name : Get_Appl_Delivery_Channels
200 -- Type : Public
201 -- Pre-reqs : None.
202 -- Function : get the list of applicable Delivery Channels.
203 -- Parameters :
204 -- IN : p_api_version IN NUMBER Required
205 -- p_init_msg_list IN VARCHAR2 Optional
206 -- p_trxn_attributes_rec IN Trxn_Attributes_Rec_Type Required
207 -- OUT : x_return_status OUT VARCHAR2 Required
208 -- x_msg_count OUT NUMBER Required
209 -- x_msg_data OUT VARCHAR2 Required
210 -- x_delivery_channels_tbl OUT Delivery_Channels_Tab_Type Required
211 --
212 -- Version : Current version 1.0
213 -- Previous version None
214 -- Initial version 1.0
215 -- End of comments
216
217 PROCEDURE Get_Appl_Delivery_Channels (
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
220 p_trxn_attributes_rec IN Trxn_Attributes_Rec_Type,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 x_delivery_channels_tbl OUT NOCOPY Delivery_Channel_Tab_Type
225 );
226
227 -- Start of comments
228 -- API name : Get_Applicable_Payee_BankAccts
229 -- Type : Public
230 -- Pre-reqs : None.
231 -- Function : get the list of applicable Payee Bank Accounts.
232 -- Parameters :
233 -- IN : p_api_version IN NUMBER Required
234 -- p_init_msg_list IN VARCHAR2 Optional
235 -- p_trxn_attributes_rec IN Trxn_Attributes_Rec_Type Required
236 -- OUT : x_return_status OUT VARCHAR2 Required
237 -- x_msg_count OUT NUMBER Required
238 -- x_msg_data OUT VARCHAR2 Required
239 -- x_payee_bankaccounts_tbl OUT Payee_BankAccount_Tab_Type Required
240 --
241 -- Version : Current version 1.0
242 -- Previous version None
243 -- Initial version 1.0
244 -- End of comments
245
246 PROCEDURE Get_Applicable_Payee_BankAccts (
247 p_api_version IN NUMBER,
248 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
249 p_trxn_attributes_rec IN Trxn_Attributes_Rec_Type,
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2,
253 x_payee_bankaccounts_tbl OUT NOCOPY Payee_BankAccount_Tab_Type
254 );
255
256 -- Start of comments
257 -- API name : Get_Applicable_Payment_Formats
258 -- Type : Public
259 -- Pre-reqs : None.
260 -- Function : get the list of applicable Delivery Channels.
261 -- Parameters :
262 -- IN : p_api_version IN NUMBER Required
263 -- p_init_msg_list IN VARCHAR2 Optional
264 -- p_trxn_attributes_rec IN Trxn_Attributes_Rec_Type Required
265 -- OUT : x_return_status OUT VARCHAR2 Required
266 -- x_msg_count OUT NUMBER Required
267 -- x_msg_data OUT VARCHAR2 Required
268 -- x_payment_format_tbl OUT Payment_Format_Tab_Type Required
269 --
270 -- Version : Current version 1.0
271 -- Previous version None
272 -- Initial version 1.0
273 -- End of comments
274
275 PROCEDURE Get_Applicable_Payment_Formats(
276 p_api_version IN NUMBER,
277 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE ,
278 x_return_status OUT NOCOPY VARCHAR2 ,
279 x_msg_count OUT NOCOPY NUMBER ,
280 x_msg_data OUT NOCOPY VARCHAR2 ,
281 x_payment_formats_tbl OUT NOCOPY Payment_Format_Tab_Type
282 );
283
284
285 -- Start of comments
286 -- API name : Get_Applicable_Payment_Methods
287 -- Type : Public
288 -- Pre-reqs : None.
289 -- Function : get the list of applicable Payment Methods.
290 -- Parameters :
291 -- IN : p_api_version IN NUMBER Required
292 -- p_init_msg_list IN VARCHAR2 Optional
293 -- p_trxn_attributes_rec IN Trxn_Attributes_Rec_Type Required
294 -- OUT : x_return_status OUT VARCHAR2 Required
295 -- x_msg_count OUT NUMBER Required
296 -- x_msg_data OUT VARCHAR2 Required
297 -- x_payment_methods_tbl OUT PmtMthd_Tab_Type Required
298 --
299 -- Version : Current version 1.0
300 -- Previous version None
301 -- Initial version 1.0
302 -- End of comments
303
304 PROCEDURE Get_Applicable_Payment_Methods (
305 p_api_version IN NUMBER,
306 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
307 p_ignore_payee_prefer IN VARCHAR2,
308 p_trxn_attributes_rec IN Trxn_Attributes_Rec_Type,
309 x_return_status OUT NOCOPY VARCHAR2,
310 x_msg_count OUT NOCOPY NUMBER,
311 x_msg_data OUT NOCOPY VARCHAR2,
312 x_payment_methods_tbl OUT NOCOPY Payment_Method_Tab_Type
313 );
314
315 -- Start of comments
316 -- API name : Get_Applicable_Pmt_Profiles
317 -- Type : Public
318 -- Pre-reqs : None
319 -- Function : Get the list of applicable payment profiles
320 -- based on the given profile drivers
321 -- Parameters :
322 -- IN : p_api_version IN NUMBER Required
323 -- p_init_msg_list IN VARCHAR2 Optional
324 -- p_ppp_drivers_rec IN PPP_Drivers_Rec_Type
325 -- Required
326 -- OUT : x_return_status OUT VARCHAR2 Required
327 -- x_msg_count OUT NUMBER Required
328 -- x_msg_data OUT VARCHAR2 Required
329 -- x_payment_profiles_tbl OUT
330 -- Payment_Profiles_Tab_Type
331 -- Required
332 -- Version : Current version 1.0
333 -- Previous version None
334 -- Initial version 1.0
335 -- End of comments
336
337 PROCEDURE Get_Applicable_Pmt_Profiles(
338 p_api_version IN NUMBER,
339 p_init_msg_list IN VARCHAR2 DEFAULT
340 FND_API.G_FALSE,
341 p_ppp_drivers_rec IN PPP_Drivers_Rec_Type,
342 x_return_status OUT NOCOPY VARCHAR2,
343 x_msg_count OUT NOCOPY NUMBER,
344 x_msg_data OUT NOCOPY VARCHAR2,
345 x_payment_profiles_tbl OUT NOCOPY Payment_Profile_Tab_Type
346 );
347
348 -- Start of comments
349 -- API name : Get_Pmt_Profiles_Intersect
350 -- Type : Public
351 -- Pre-reqs : None
352 -- Function : Get the list of applicable payment profiles
353 -- that are applicable across the given profile
354 -- drivers list.
355 --
356 -- We already have a method to get the payment
357 -- profiles for a single set of profile drivers;
358 -- This method will attempt to get the payment profiles
359 -- for every given set of payment drivers in the list
360 -- and return their intersection.
361 --
362 -- Parameters :
363 -- IN : p_api_version IN NUMBER Required
364 -- p_init_msg_list IN VARCHAR2 Optional
365 -- p_ppp_drivers_tab IN PPP_Drivers_Tab_Type
366 -- Required
367 -- OUT : x_return_status OUT VARCHAR2 Required
368 -- x_msg_count OUT NUMBER Required
369 -- x_msg_data OUT VARCHAR2 Required
370 -- x_payment_profiles_tbl OUT
371 -- Payment_Profiles_Tab_Type
372 -- Required
373 -- Version : Current version 1.0
374 -- Previous version None
375 -- Initial version 1.0
376 -- End of comments
377
378 PROCEDURE Get_Pmt_Profiles_Intersect(
379 p_api_version IN NUMBER,
380 p_init_msg_list IN VARCHAR2 DEFAULT
381 FND_API.G_FALSE,
382 p_ppp_drivers_tab IN PPP_Drivers_Tab_Type,
383 x_return_status OUT NOCOPY VARCHAR2,
384 x_msg_count OUT NOCOPY NUMBER,
385 x_msg_data OUT NOCOPY VARCHAR2,
386 x_payment_profiles_tbl OUT NOCOPY Payment_Profile_Tab_Type
387 );
388
389 -- Start of comments
390 -- API name : Get_Applicable_Payment_Reasons
391 -- Type : Public
392 -- Pre-reqs : None.
393 -- Function : get the list of applicable Payment Reasons.
394 -- Parameters :
395 -- IN : p_api_version IN NUMBER Required
396 -- p_init_msg_list IN VARCHAR2 Optional
397 -- p_trxn_attributes_rec IN Trxn_Attributes_Rec_Type Required
398 -- OUT : x_return_status OUT VARCHAR2 Required
399 -- x_msg_count OUT NUMBER Required
400 -- x_msg_data OUT VARCHAR2 Required
401 -- x_payment_reason_tbl OUT Payment_Reason_Tab_Type Required
402 --
403 -- Version : Current version 1.0
404 -- Previous version None
405 -- Initial version 1.0
406 -- End of comments
407
408 PROCEDURE Get_Applicable_Payment_Reasons(
409 p_api_version IN NUMBER,
410 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE ,
411 p_trxn_attributes_rec IN Trxn_Attributes_Rec_Type,
412 x_return_status OUT NOCOPY VARCHAR2 ,
413 x_msg_count OUT NOCOPY NUMBER ,
414 x_msg_data OUT NOCOPY VARCHAR2 ,
415 x_payment_reason_tbl OUT NOCOPY Payment_Reason_Tab_Type
416 );
417
418
419 -- Start of comments
420 -- API name : Get_Default_Payment_Attributes
421 -- Type : Public
422 -- Pre-reqs : None.
426 -- p_application_id IN NUMBER Required
423 -- Function : get the default values of all Payment attributes.
424 -- Parameters :
425 -- IN : p_api_version IN NUMBER Required
427 -- p_init_msg_list IN VARCHAR2 Optional
428 -- p_ignore_payee_pref IN VARCHAR2 Required
429 -- p_trxn_attributes_rec IN Trxn_Attributes_Rec_Type Required
430 -- OUT : x_return_status OUT VARCHAR2 Required
431 -- x_msg_count OUT NUMBER Required
432 -- x_msg_data OUT VARCHAR2 Required
433 -- x_default_pmt_attrs_rec OUT Default_Pmt_Attrs_Rec_Type Required
434 --
435 -- Version : Current version 1.0
436 -- Previous version None
437 -- Initial version 1.0
438 -- End of comments
439
440 PROCEDURE Get_Default_Payment_Attributes(
441 p_api_version IN NUMBER,
442 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
443 p_ignore_payee_pref IN VARCHAR2,
444 p_trxn_attributes_rec IN Trxn_Attributes_Rec_Type,
445 x_return_status OUT NOCOPY VARCHAR2,
446 x_msg_count OUT NOCOPY NUMBER,
447 x_msg_data OUT NOCOPY VARCHAR2,
448 x_default_pmt_attrs_rec OUT NOCOPY Default_Pmt_Attrs_Rec_Type
449 );
450
451 -- Start of comments
452 -- API name : Get_Default_Payee_Bank_Acc
453 -- Type : Public
454 -- Pre-reqs : None.
455 -- Function : get the list of applicable Payment attributes.
456 -- Parameters :
457 -- IN : p_api_version IN NUMBER Required
458 -- p_init_msg_list IN VARCHAR2 Optional
459 -- p_trxn_attributes_rec IN Trxn_Attributes_Rec_Type Required
460 -- OUT : x_return_status OUT VARCHAR2 Required
461 -- x_msg_count OUT NUMBER Required
462 -- x_msg_data OUT VARCHAR2 Required
463 -- x_payee_bankaccount OUT Payee_BankAccount_Rec_Type Required
464 --
465 -- Version : Current version 1.0
466 -- Previous version None
467 -- Initial version 1.0
468 -- End of comments
469 PROCEDURE Get_Default_Payee_Bank_Acc(
470 p_api_version IN NUMBER,
471 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
472 p_trxn_attributes_rec IN Trxn_Attributes_Rec_Type,
473 x_return_status OUT NOCOPY VARCHAR2,
474 x_msg_count OUT NOCOPY NUMBER,
475 x_msg_data OUT NOCOPY VARCHAR2,
476 x_payee_bankaccount OUT NOCOPY Payee_BankAccount_Rec_Type
477 );
478
479 -- Start of comments
480 -- API name : Get_Payment_Field_Properties
481 -- Type : Public
482 -- Pre-reqs : None.
483 -- Function : get the list of applicable Payment attributes.
484 -- Parameters :
485 -- IN : p_api_version IN NUMBER Required
486 -- p_application_id IN NUMBER Required
487 -- p_init_msg_list IN VARCHAR2 Optional
488 -- p_payment_method_id IN BY_PAYMENT_METHODS_VL.payment_method_id%TYPE Required
489 -- OUT : x_return_status OUT VARCHAR2 Required
490 -- x_msg_count OUT NUMBER Required
491 -- x_msg_data OUT VARCHAR2 Required
492 -- x_Payment_Field_Properties OUT Payment_Field_Properties_Rec_Type Required
493 --
494 -- Version : Current version 1.0
495 -- Previous version None
496 -- Initial version 1.0
497 -- End of comments
498
499 PROCEDURE Get_Payment_Field_Properties (
500 p_api_version IN NUMBER,
501 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
502 p_payment_method_id IN
503 IBY_PAYMENT_METHODS_VL.payment_method_code%TYPE,
504 x_return_status OUT NOCOPY VARCHAR2,
505 x_msg_count OUT NOCOPY NUMBER,
506 x_msg_data OUT NOCOPY VARCHAR2,
507 x_Payment_Field_Properties OUT NOCOPY Applicable_Pmt_Attrs_Rec_Type
508 );
509
510
511 -- Start of comments
512 -- API name : ValidateDocument
513 -- Type : Public
514 -- Pre-reqs : None.
515 -- Function : validates the documents in the global temporary table
516 -- IBY_DOCUMENTS_PAYABLE_GT
517 -- Parameters :
518 -- IN : p_api_version IN NUMBER Required
519 -- p_application_id IN NUMBER Required
520 -- p_init_msg_list IN VARCHAR2 Optional
521 -- p_validation_level IN NUMBER Optional
522 --
523 -- OUT : x_return_status OUT VARCHAR2 Required
524 -- x_msg_count OUT NUMBER Required
525 -- x_msg_data OUT VARCHAR2 Required
526 --
527 --
528 -- Version : Current version 1.0
529 -- Previous version None
530 -- Initial version 1.0
531 -- End of comments
532
533 PROCEDURE Validate_Documents(
534 p_api_version IN NUMBER,
535 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
536 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
537 x_return_status OUT NOCOPY VARCHAR2,
538 x_msg_count OUT NOCOPY NUMBER,
539 x_msg_data OUT NOCOPY VARCHAR2
540 );
541
542
543 -- Start of comments
544 -- API name : Get_Applicable_Payee_Acc_list
545 -- Type : Public
546 -- Pre-reqs : None.
547 -- Function : get the list of all applicable Payee Bank Accounts.
548 -- Parameters :
549 -- IN : p_api_version IN NUMBER Required
550 -- p_init_msg_list IN VARCHAR2 Optional
551 -- p_trxn_attributes_rec IN Trxn_Attributes_Rec_Type Required
552 -- OUT : x_return_status OUT VARCHAR2 Required
553 -- x_msg_count OUT NUMBER Required
554 -- x_msg_data OUT VARCHAR2 Required
555 -- x_payee_bankaccounts_tbl OUT Payee_BankAccount_Tab_Type Required
556 --
557 -- Version : Current version 1.0
558 -- Previous version None
559 -- Initial version 1.0
560 -- End of comments
561
562 PROCEDURE Get_Applicable_Payee_Acc_list (
563 p_api_version IN NUMBER,
564 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
565 p_trxn_attributes_rec IN Trxn_Attributes_Rec_Type,
566 x_return_status OUT NOCOPY VARCHAR2,
567 x_msg_count OUT NOCOPY NUMBER,
568 x_msg_data OUT NOCOPY VARCHAR2,
569 x_payee_bankaccounts_tbl OUT NOCOPY Payee_BankAccount_Tab_Type
570 );
571
572 END IBY_DISBURSEMENT_COMP_PUB;
[Home] [Help]