eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.IBY_BUILD_INSTRUCTIONS_PUB_PKG

Source


1 PACKAGE IBY_BUILD_INSTRUCTIONS_PUB_PKG AUTHID CURRENT_USER AS
2 /*$Header: ibypayis.pls 120.16.12020000.3 2013/02/14 11:54:25 jnallam ship $*/
3 
4 /*--------------------------------------------------------------------
5  | NAME:
6  |     build_pmt_instructions
7  |
8  | PURPOSE:
9  |     This is the top level procedure of the payment instruction
10  |     creation program; This procedure will run as a concurrent program.
11  |
12  | PARAMETERS:
13  |     IN
14  |
15  |     p_calling_app_id
16  |         The 3-character product code of the calling application
17  |
18  |     p_calling_app_payreq_cd
19  |         Id of the payment service request from the calling app's
20  |         point of view. For a given calling app, this id should be
21  |         unique; the build program will communicate back to the calling
22  |         app using this payment request id.
23  |
24  |    p_internal_bank_account_id
25  |        The internal bank account to pay from.
26  |
27  |    p_payment_profile_id
28  |        Payment profile
29  |
30  |    p_allow_zero_payments_flag
31  |        'Y' / 'N' flag indicating whether zero value payments are allowed.
32  |        If not set, this value will be defaulted to 'Y'.
33  |
34  |    p_payment_date
35  |        The payment date.
36  |
37  |    p_anticipated_value_date
38  |        The anticipated value date.
39  |
40  |     p_args10 - p_args100
41  |         These 91 parameters are mandatory for any stored procedure
42  |         that is submitted from Oracle Forms as a concurrent request
43  |         (to get the total number of args to the concurrent procedure
44  |          to 100).
45  |
46  |     OUT
47  |
48  |     x_errbuf
49  |     x_retcode
50  |
51  |         These two are mandatory output paramaters for a concurrent
52  |         program. They will store the error message and error code
53  |         to indicate a successful/failed run of the concurrent request.
54  |
55  | RETURNS:
56  |
57  | NOTES:
58  |
59  *---------------------------------------------------------------------*/
60  PROCEDURE build_pmt_instructions(
61      x_errbuf                     OUT NOCOPY VARCHAR2,
62      x_retcode                    OUT NOCOPY VARCHAR2,
63 
64      /*-- processing criteria --*/
65      p_processing_type            IN         VARCHAR2,
66      p_payment_profile_id         IN         VARCHAR2 DEFAULT NULL, /* dummy */
67      p_pmt_document_id            IN         VARCHAR2 DEFAULT NULL,
68      p_internal_bank_account_id   IN         VARCHAR2 DEFAULT NULL,
69      p_print_now_flag             IN         VARCHAR2 DEFAULT NULL,
70      p_printer_name               IN         VARCHAR2 DEFAULT NULL,
71      p_payment_currency           IN         VARCHAR2 DEFAULT NULL,
72      p_transmit_now_flag          IN         VARCHAR2 DEFAULT NULL,
73 
74      /*-- user/admin assigned criteria --*/
75      p_admin_assigned_ref         IN         VARCHAR2 DEFAULT NULL,
76      p_comments                   IN         VARCHAR2 DEFAULT NULL,
77 
78      /*-- selection criteria --*/
79      p_calling_app_id             IN         VARCHAR2 DEFAULT NULL,
80      p_calling_app_payreq_cd      IN         VARCHAR2 DEFAULT NULL,
81      p_le_id                      IN         VARCHAR2 DEFAULT NULL,
82      p_org_id                     IN         VARCHAR2 DEFAULT NULL,
83      p_org_type                   IN         VARCHAR2 DEFAULT NULL,
84      p_payment_from_date          IN         VARCHAR2 DEFAULT NULL,
85      p_payment_to_date            IN         VARCHAR2 DEFAULT NULL,
86 
87      p_arg19  IN VARCHAR2 DEFAULT NULL,
88      p_arg20  IN VARCHAR2 DEFAULT NULL, p_arg21  IN VARCHAR2 DEFAULT NULL,
89      p_arg22  IN VARCHAR2 DEFAULT NULL, p_arg23  IN VARCHAR2 DEFAULT NULL,
90      p_arg24  IN VARCHAR2 DEFAULT NULL, p_arg25  IN VARCHAR2 DEFAULT NULL,
91      p_arg26  IN VARCHAR2 DEFAULT NULL, p_arg27  IN VARCHAR2 DEFAULT NULL,
92      p_arg28  IN VARCHAR2 DEFAULT NULL, p_arg29  IN VARCHAR2 DEFAULT NULL,
93      p_arg30  IN VARCHAR2 DEFAULT NULL, p_arg31  IN VARCHAR2 DEFAULT NULL,
94      p_arg32  IN VARCHAR2 DEFAULT NULL, p_arg33  IN VARCHAR2 DEFAULT NULL,
95      p_arg34  IN VARCHAR2 DEFAULT NULL, p_arg35  IN VARCHAR2 DEFAULT NULL,
96      p_arg36  IN VARCHAR2 DEFAULT NULL, p_arg37  IN VARCHAR2 DEFAULT NULL,
97      p_arg38  IN VARCHAR2 DEFAULT NULL, p_arg39  IN VARCHAR2 DEFAULT NULL,
98      p_arg40  IN VARCHAR2 DEFAULT NULL, p_arg41  IN VARCHAR2 DEFAULT NULL,
99      p_arg42  IN VARCHAR2 DEFAULT NULL, p_arg43  IN VARCHAR2 DEFAULT NULL,
100      p_arg44  IN VARCHAR2 DEFAULT NULL, p_arg45  IN VARCHAR2 DEFAULT NULL,
101      p_arg46  IN VARCHAR2 DEFAULT NULL, p_arg47  IN VARCHAR2 DEFAULT NULL,
102      p_arg48  IN VARCHAR2 DEFAULT NULL, p_arg49  IN VARCHAR2 DEFAULT NULL,
103      p_arg50  IN VARCHAR2 DEFAULT NULL, p_arg51  IN VARCHAR2 DEFAULT NULL,
104      p_arg52  IN VARCHAR2 DEFAULT NULL, p_arg53  IN VARCHAR2 DEFAULT NULL,
105      p_arg54  IN VARCHAR2 DEFAULT NULL, p_arg55  IN VARCHAR2 DEFAULT NULL,
106      p_arg56  IN VARCHAR2 DEFAULT NULL, p_arg57  IN VARCHAR2 DEFAULT NULL,
107      p_arg58  IN VARCHAR2 DEFAULT NULL, p_arg59  IN VARCHAR2 DEFAULT NULL,
108      p_arg60  IN VARCHAR2 DEFAULT NULL, p_arg61  IN VARCHAR2 DEFAULT NULL,
109      p_arg62  IN VARCHAR2 DEFAULT NULL, p_arg63  IN VARCHAR2 DEFAULT NULL,
110      p_arg64  IN VARCHAR2 DEFAULT NULL, p_arg65  IN VARCHAR2 DEFAULT NULL,
111      p_arg66  IN VARCHAR2 DEFAULT NULL, p_arg67  IN VARCHAR2 DEFAULT NULL,
112      p_arg68  IN VARCHAR2 DEFAULT NULL, p_arg69  IN VARCHAR2 DEFAULT NULL,
113      p_arg70  IN VARCHAR2 DEFAULT NULL, p_arg71  IN VARCHAR2 DEFAULT NULL,
114      p_arg72  IN VARCHAR2 DEFAULT NULL, p_arg73  IN VARCHAR2 DEFAULT NULL,
115      p_arg74  IN VARCHAR2 DEFAULT NULL, p_arg75  IN VARCHAR2 DEFAULT NULL,
116      p_arg76  IN VARCHAR2 DEFAULT NULL, p_arg77  IN VARCHAR2 DEFAULT NULL,
117      p_arg78  IN VARCHAR2 DEFAULT NULL, p_arg79  IN VARCHAR2 DEFAULT NULL,
118      p_arg80  IN VARCHAR2 DEFAULT NULL, p_arg81  IN VARCHAR2 DEFAULT NULL,
119      p_arg82  IN VARCHAR2 DEFAULT NULL, p_arg83  IN VARCHAR2 DEFAULT NULL,
120      p_arg84  IN VARCHAR2 DEFAULT NULL, p_arg85  IN VARCHAR2 DEFAULT NULL,
121      p_arg86  IN VARCHAR2 DEFAULT NULL, p_arg87  IN VARCHAR2 DEFAULT NULL,
122      p_arg88  IN VARCHAR2 DEFAULT NULL, p_arg89  IN VARCHAR2 DEFAULT NULL,
123      p_arg90  IN VARCHAR2 DEFAULT NULL, p_arg91  IN VARCHAR2 DEFAULT NULL,
124      p_arg92  IN VARCHAR2 DEFAULT NULL, p_arg93  IN VARCHAR2 DEFAULT NULL,
125      p_arg94  IN VARCHAR2 DEFAULT NULL, p_arg95  IN VARCHAR2 DEFAULT NULL,
126      p_arg96  IN VARCHAR2 DEFAULT NULL, p_arg97  IN VARCHAR2 DEFAULT NULL,
127      p_arg98  IN VARCHAR2 DEFAULT NULL, p_arg99  IN VARCHAR2 DEFAULT NULL,
128      p_arg100 IN VARCHAR2 DEFAULT NULL
129      );
130 
131 /*--------------------------------------------------------------------
132  | NAME:
133  |     rebuild_pmt_instruction
134  |
135  |
136  | PURPOSE:
137  |
138  |
139  | PARAMETERS:
140  |     IN
141  |
142  |
143  |     OUT
144  |
145  |
146  | RETURNS:
147  |
148  | NOTES:
149  |
150  *---------------------------------------------------------------------*/
151  PROCEDURE rebuild_pmt_instruction(
152      x_errbuf         OUT NOCOPY VARCHAR2,
153      x_retcode        OUT NOCOPY VARCHAR2,
154      p_pmt_instr_id   IN         VARCHAR2,
155      p_sys_key   IN VARCHAR2 DEFAULT NULL, p_arg5   IN VARCHAR2 DEFAULT NULL,
156      p_arg6   IN VARCHAR2 DEFAULT NULL, p_arg7   IN VARCHAR2 DEFAULT NULL,
157      p_arg8   IN VARCHAR2 DEFAULT NULL, p_arg9   IN VARCHAR2 DEFAULT NULL,
158      p_arg10  IN VARCHAR2 DEFAULT NULL, p_arg11  IN VARCHAR2 DEFAULT NULL,
159      p_arg12  IN VARCHAR2 DEFAULT NULL, p_arg13  IN VARCHAR2 DEFAULT NULL,
160      p_arg14  IN VARCHAR2 DEFAULT NULL, p_arg15  IN VARCHAR2 DEFAULT NULL,
161      p_arg16  IN VARCHAR2 DEFAULT NULL, p_arg17  IN VARCHAR2 DEFAULT NULL,
162      p_arg18  IN VARCHAR2 DEFAULT NULL, p_arg19  IN VARCHAR2 DEFAULT NULL,
163      p_arg20  IN VARCHAR2 DEFAULT NULL, p_arg21  IN VARCHAR2 DEFAULT NULL,
164      p_arg22  IN VARCHAR2 DEFAULT NULL, p_arg23  IN VARCHAR2 DEFAULT NULL,
165      p_arg24  IN VARCHAR2 DEFAULT NULL, p_arg25  IN VARCHAR2 DEFAULT NULL,
166      p_arg26  IN VARCHAR2 DEFAULT NULL, p_arg27  IN VARCHAR2 DEFAULT NULL,
167      p_arg28  IN VARCHAR2 DEFAULT NULL, p_arg29  IN VARCHAR2 DEFAULT NULL,
168      p_arg30  IN VARCHAR2 DEFAULT NULL, p_arg31  IN VARCHAR2 DEFAULT NULL,
169      p_arg32  IN VARCHAR2 DEFAULT NULL, p_arg33  IN VARCHAR2 DEFAULT NULL,
170      p_arg34  IN VARCHAR2 DEFAULT NULL, p_arg35  IN VARCHAR2 DEFAULT NULL,
171      p_arg36  IN VARCHAR2 DEFAULT NULL, p_arg37  IN VARCHAR2 DEFAULT NULL,
172      p_arg38  IN VARCHAR2 DEFAULT NULL, p_arg39  IN VARCHAR2 DEFAULT NULL,
173      p_arg40  IN VARCHAR2 DEFAULT NULL, p_arg41  IN VARCHAR2 DEFAULT NULL,
174      p_arg42  IN VARCHAR2 DEFAULT NULL, p_arg43  IN VARCHAR2 DEFAULT NULL,
175      p_arg44  IN VARCHAR2 DEFAULT NULL, p_arg45  IN VARCHAR2 DEFAULT NULL,
176      p_arg46  IN VARCHAR2 DEFAULT NULL, p_arg47  IN VARCHAR2 DEFAULT NULL,
177      p_arg48  IN VARCHAR2 DEFAULT NULL, p_arg49  IN VARCHAR2 DEFAULT NULL,
178      p_arg50  IN VARCHAR2 DEFAULT NULL, p_arg51  IN VARCHAR2 DEFAULT NULL,
179      p_arg52  IN VARCHAR2 DEFAULT NULL, p_arg53  IN VARCHAR2 DEFAULT NULL,
180      p_arg54  IN VARCHAR2 DEFAULT NULL, p_arg55  IN VARCHAR2 DEFAULT NULL,
181      p_arg56  IN VARCHAR2 DEFAULT NULL, p_arg57  IN VARCHAR2 DEFAULT NULL,
182      p_arg58  IN VARCHAR2 DEFAULT NULL, p_arg59  IN VARCHAR2 DEFAULT NULL,
183      p_arg60  IN VARCHAR2 DEFAULT NULL, p_arg61  IN VARCHAR2 DEFAULT NULL,
184      p_arg62  IN VARCHAR2 DEFAULT NULL, p_arg63  IN VARCHAR2 DEFAULT NULL,
185      p_arg64  IN VARCHAR2 DEFAULT NULL, p_arg65  IN VARCHAR2 DEFAULT NULL,
186      p_arg66  IN VARCHAR2 DEFAULT NULL, p_arg67  IN VARCHAR2 DEFAULT NULL,
187      p_arg68  IN VARCHAR2 DEFAULT NULL, p_arg69  IN VARCHAR2 DEFAULT NULL,
188      p_arg70  IN VARCHAR2 DEFAULT NULL, p_arg71  IN VARCHAR2 DEFAULT NULL,
189      p_arg72  IN VARCHAR2 DEFAULT NULL, p_arg73  IN VARCHAR2 DEFAULT NULL,
190      p_arg74  IN VARCHAR2 DEFAULT NULL, p_arg75  IN VARCHAR2 DEFAULT NULL,
191      p_arg76  IN VARCHAR2 DEFAULT NULL, p_arg77  IN VARCHAR2 DEFAULT NULL,
192      p_arg78  IN VARCHAR2 DEFAULT NULL, p_arg79  IN VARCHAR2 DEFAULT NULL,
193      p_arg80  IN VARCHAR2 DEFAULT NULL, p_arg81  IN VARCHAR2 DEFAULT NULL,
194      p_arg82  IN VARCHAR2 DEFAULT NULL, p_arg83  IN VARCHAR2 DEFAULT NULL,
198      p_arg90  IN VARCHAR2 DEFAULT NULL, p_arg91  IN VARCHAR2 DEFAULT NULL,
195      p_arg84  IN VARCHAR2 DEFAULT NULL, p_arg85  IN VARCHAR2 DEFAULT NULL,
196      p_arg86  IN VARCHAR2 DEFAULT NULL, p_arg87  IN VARCHAR2 DEFAULT NULL,
197      p_arg88  IN VARCHAR2 DEFAULT NULL, p_arg89  IN VARCHAR2 DEFAULT NULL,
199      p_arg92  IN VARCHAR2 DEFAULT NULL, p_arg93  IN VARCHAR2 DEFAULT NULL,
200      p_arg94  IN VARCHAR2 DEFAULT NULL, p_arg95  IN VARCHAR2 DEFAULT NULL,
201      p_arg96  IN VARCHAR2 DEFAULT NULL, p_arg97  IN VARCHAR2 DEFAULT NULL,
202      p_arg98  IN VARCHAR2 DEFAULT NULL, p_arg99  IN VARCHAR2 DEFAULT NULL,
203      p_arg100 IN VARCHAR2 DEFAULT NULL
204      );
205 
206 /*--------------------------------------------------------------------
207  | NAME:
208  |     moveInstrToDeferredStatus
209  |
210  |
211  | PURPOSE:
212  |
213  |
214  | PARAMETERS:
215  |     IN
216  |
217  |
218  |     OUT
219  |
220  |
221  | RETURNS:
222  |
223  | NOTES:
224  |
225  *---------------------------------------------------------------------*/
226  PROCEDURE moveInstrToDeferredStatus(
227      p_pmtInstrTab       IN OUT NOCOPY IBY_PAYINSTR_PUB.pmtInstrTabType,
228      p_instr_to_skip     IN IBY_PAY_INSTRUCTIONS_ALL.
229                                 payment_instruction_id%TYPE DEFAULT NULL
230      );
231 
232 /*--------------------------------------------------------------------
233  | NAME:
234  |     get_payreq_id
235  |
236  |
237  | PURPOSE:
238  |
239  |
240  | PARAMETERS:
241  |     IN
242  |
243  |
244  |     OUT
245  |
246  |
247  | RETURNS:
248  |
249  | NOTES:
250  |
251  *---------------------------------------------------------------------*/
252  FUNCTION get_payreq_id (
253      l_ca_id        IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
254      l_ca_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
255                            call_app_pay_service_req_code%TYPE
256      )
257      RETURN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
258 
259 /*--------------------------------------------------------------------
260  | NAME:
261  |     get_paydoc_id
262  |
263  |
264  | PURPOSE:
265  | Introduced in Bug 11059189
266  |
267  | PARAMETERS:
268  |     IN
269  |
270  |
271  |     OUT
272  |
273  |
274  | RETURNS:
275  |
276  | NOTES:
277  |
278  *---------------------------------------------------------------------*/
279  FUNCTION get_paydoc_id (
280      l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
281                            payment_service_request_id%TYPE
282      )
283      RETURN IBY_PAY_SERVICE_REQUESTS.payment_document_id%TYPE;
284 
285  /*--------------------------------------------------------------------
286  | NAME:
287  |     get_int_bank_acct_id
288  |
289  |
290  | PURPOSE:
291  | Introduced in Bug 16041562
292  |
293  | PARAMETERS:
294  |     IN
295  |
296  |
297  |     OUT
298  |
299  |
300  | RETURNS:
301  |
302  | NOTES:
303  |
304  *---------------------------------------------------------------------*/
305  FUNCTION get_int_bank_acct_id (
306      l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
307                            payment_service_request_id%TYPE
308      )
309      RETURN IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE;
310 
311 /*--------------------------------------------------------------------
312  | NAME:
313  |     get_instruction_attributes
314  |
315  |
316  | PURPOSE:
317  |
318  |
319  | PARAMETERS:
320  |     IN
321  |
322  |
323  |     OUT
324  |
325  |
326  | RETURNS:
327  |
328  | NOTES:
329  |
330  *---------------------------------------------------------------------*/
331  FUNCTION get_instruction_attributes(
332      l_pmt_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)
333      RETURN IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;
334 
335 /*--------------------------------------------------------------------
336  | NAME:
337  |     print_debuginfo
338  |
339  | PURPOSE:
340  |
341  |
342  | PARAMETERS:
343  |     IN
344  |
345  |
346  |     OUT
347  |
348  |
349  | RETURNS:
350  |
351  | NOTES:
352  |
353  *---------------------------------------------------------------------*/
354  PROCEDURE print_debuginfo(
355      p_module      IN VARCHAR2,
356      p_debug_text  IN VARCHAR2,
357      p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
358      );
359 
360 /*--------------------------------------------------------------------
361  | NAME:
362  |     build_electronic_instructions
363  |
364  | PURPOSE:
365  |     Concurrent program wrapper for electronic payment instructions.
366  |
367  | PARAMETERS:
368  |     IN
369  |
370  |
371  |     OUT
372  |
373  |
374  | RETURNS:
375  |
376  | NOTES:
377  |
378  *---------------------------------------------------------------------*/
379  PROCEDURE build_electronic_instructions(
380      x_errbuf                     OUT NOCOPY VARCHAR2,
381      x_retcode                    OUT NOCOPY VARCHAR2,
382 
383      /*-- processing criteria --*/
384      p_processing_type            IN         VARCHAR2,
385 
386      /*-- user/admin assigned criteria --*/
387      p_admin_assigned_ref         IN         VARCHAR2 DEFAULT NULL,
388      p_comments                   IN         VARCHAR2 DEFAULT NULL,
389 
390      /*-- selection criteria --*/
391      p_payment_profile_id         IN         VARCHAR2 DEFAULT NULL,
392      p_payment_currency           IN         VARCHAR2 DEFAULT NULL,
393      p_internal_bank_account_id   IN         VARCHAR2 DEFAULT NULL,
394      p_payment_document_id    	  IN         VARCHAR2 DEFAULT NULL, --Bug 11059189
395      p_calling_app_id             IN         VARCHAR2 DEFAULT NULL,
396      p_calling_app_payreq_cd      IN         VARCHAR2 DEFAULT NULL,
397      p_le_id                      IN         VARCHAR2 DEFAULT NULL,
398      p_org_type                   IN         VARCHAR2 DEFAULT NULL,
399      p_org_id                     IN         VARCHAR2 DEFAULT NULL,
400      p_payment_from_date          IN         VARCHAR2 DEFAULT NULL,
401      p_payment_to_date            IN         VARCHAR2 DEFAULT NULL,
402      p_transmit_now_flag          IN         VARCHAR2 DEFAULT NULL,
403      p_sys_key  IN VARCHAR2 DEFAULT NULL, p_arg17  IN VARCHAR2 DEFAULT NULL,
404      p_arg18  IN VARCHAR2 DEFAULT NULL, p_arg19  IN VARCHAR2 DEFAULT NULL,
405      p_arg20  IN VARCHAR2 DEFAULT NULL, p_arg21  IN VARCHAR2 DEFAULT NULL,
406      p_arg22  IN VARCHAR2 DEFAULT NULL, p_arg23  IN VARCHAR2 DEFAULT NULL,
407      p_arg24  IN VARCHAR2 DEFAULT NULL, p_arg25  IN VARCHAR2 DEFAULT NULL,
408      p_arg26  IN VARCHAR2 DEFAULT NULL, p_arg27  IN VARCHAR2 DEFAULT NULL,
409      p_arg28  IN VARCHAR2 DEFAULT NULL, p_arg29  IN VARCHAR2 DEFAULT NULL,
410      p_arg30  IN VARCHAR2 DEFAULT NULL, p_arg31  IN VARCHAR2 DEFAULT NULL,
411      p_arg32  IN VARCHAR2 DEFAULT NULL, p_arg33  IN VARCHAR2 DEFAULT NULL,
412      p_arg34  IN VARCHAR2 DEFAULT NULL, p_arg35  IN VARCHAR2 DEFAULT NULL,
413      p_arg36  IN VARCHAR2 DEFAULT NULL, p_arg37  IN VARCHAR2 DEFAULT NULL,
414      p_arg38  IN VARCHAR2 DEFAULT NULL, p_arg39  IN VARCHAR2 DEFAULT NULL,
415      p_arg40  IN VARCHAR2 DEFAULT NULL, p_arg41  IN VARCHAR2 DEFAULT NULL,
416      p_arg42  IN VARCHAR2 DEFAULT NULL, p_arg43  IN VARCHAR2 DEFAULT NULL,
417      p_arg44  IN VARCHAR2 DEFAULT NULL, p_arg45  IN VARCHAR2 DEFAULT NULL,
418      p_arg46  IN VARCHAR2 DEFAULT NULL, p_arg47  IN VARCHAR2 DEFAULT NULL,
419      p_arg48  IN VARCHAR2 DEFAULT NULL, p_arg49  IN VARCHAR2 DEFAULT NULL,
420      p_arg50  IN VARCHAR2 DEFAULT NULL, p_arg51  IN VARCHAR2 DEFAULT NULL,
421      p_arg52  IN VARCHAR2 DEFAULT NULL, p_arg53  IN VARCHAR2 DEFAULT NULL,
422      p_arg54  IN VARCHAR2 DEFAULT NULL, p_arg55  IN VARCHAR2 DEFAULT NULL,
423      p_arg56  IN VARCHAR2 DEFAULT NULL, p_arg57  IN VARCHAR2 DEFAULT NULL,
424      p_arg58  IN VARCHAR2 DEFAULT NULL, p_arg59  IN VARCHAR2 DEFAULT NULL,
425      p_arg60  IN VARCHAR2 DEFAULT NULL, p_arg61  IN VARCHAR2 DEFAULT NULL,
426      p_arg62  IN VARCHAR2 DEFAULT NULL, p_arg63  IN VARCHAR2 DEFAULT NULL,
427      p_arg64  IN VARCHAR2 DEFAULT NULL, p_arg65  IN VARCHAR2 DEFAULT NULL,
428      p_arg66  IN VARCHAR2 DEFAULT NULL, p_arg67  IN VARCHAR2 DEFAULT NULL,
429      p_arg68  IN VARCHAR2 DEFAULT NULL, p_arg69  IN VARCHAR2 DEFAULT NULL,
430      p_arg70  IN VARCHAR2 DEFAULT NULL, p_arg71  IN VARCHAR2 DEFAULT NULL,
431      p_arg72  IN VARCHAR2 DEFAULT NULL, p_arg73  IN VARCHAR2 DEFAULT NULL,
432      p_arg74  IN VARCHAR2 DEFAULT NULL, p_arg75  IN VARCHAR2 DEFAULT NULL,
433      p_arg76  IN VARCHAR2 DEFAULT NULL, p_arg77  IN VARCHAR2 DEFAULT NULL,
434      p_arg78  IN VARCHAR2 DEFAULT NULL, p_arg79  IN VARCHAR2 DEFAULT NULL,
435      p_arg80  IN VARCHAR2 DEFAULT NULL, p_arg81  IN VARCHAR2 DEFAULT NULL,
436      p_arg82  IN VARCHAR2 DEFAULT NULL, p_arg83  IN VARCHAR2 DEFAULT NULL,
437      p_arg84  IN VARCHAR2 DEFAULT NULL, p_arg85  IN VARCHAR2 DEFAULT NULL,
438      p_arg86  IN VARCHAR2 DEFAULT NULL, p_arg87  IN VARCHAR2 DEFAULT NULL,
439      p_arg88  IN VARCHAR2 DEFAULT NULL, p_arg89  IN VARCHAR2 DEFAULT NULL,
440      p_arg90  IN VARCHAR2 DEFAULT NULL, p_arg91  IN VARCHAR2 DEFAULT NULL,
441      p_arg92  IN VARCHAR2 DEFAULT NULL, p_arg93  IN VARCHAR2 DEFAULT NULL,
442      p_arg94  IN VARCHAR2 DEFAULT NULL, p_arg95  IN VARCHAR2 DEFAULT NULL,
443      p_arg96  IN VARCHAR2 DEFAULT NULL, p_arg97  IN VARCHAR2 DEFAULT NULL,
444      p_arg98  IN VARCHAR2 DEFAULT NULL, p_arg99  IN VARCHAR2 DEFAULT NULL,
445      p_arg100 IN VARCHAR2 DEFAULT NULL
446      );
447 
448 /*--------------------------------------------------------------------
449  | NAME:
450  |     build_printed_instructions
451  |
452  | PURPOSE:
453  |     Concurrent program wrapper for printed payment instructions.
454  |
455  | PARAMETERS:
456  |     IN
457  |
458  |
459  |     OUT
460  |
461  |
462  | RETURNS:
463  |
464  | NOTES:
465  |
466  *---------------------------------------------------------------------*/
467  PROCEDURE build_printed_instructions(
468      x_errbuf                     OUT NOCOPY VARCHAR2,
469      x_retcode                    OUT NOCOPY VARCHAR2,
470 
471      /*-- processing criteria --*/
472      p_processing_type            IN         VARCHAR2,
473 
474      /*-- user/admin assigned criteria --*/
475      p_admin_assigned_ref         IN         VARCHAR2 DEFAULT NULL,
476      p_comments                   IN         VARCHAR2 DEFAULT NULL,
477 
478      /*-- selection criteria --*/
479      p_payment_profile_id         IN         VARCHAR2 DEFAULT NULL,
480      p_payment_currency           IN         VARCHAR2 DEFAULT NULL,
481      p_internal_bank_account_id   IN         VARCHAR2 DEFAULT NULL,
482      p_pmt_document_id            IN         VARCHAR2 DEFAULT NULL,
483      p_calling_app_id             IN         VARCHAR2 DEFAULT NULL,
484      p_calling_app_payreq_cd      IN         VARCHAR2 DEFAULT NULL,
485      p_le_id                      IN         VARCHAR2 DEFAULT NULL,
486      p_org_type                   IN         VARCHAR2 DEFAULT NULL,
487      p_org_id                     IN         VARCHAR2 DEFAULT NULL,
488      p_payment_from_date          IN         VARCHAR2 DEFAULT NULL,
489      p_payment_to_date            IN         VARCHAR2 DEFAULT NULL,
490      p_print_now_flag             IN         VARCHAR2 DEFAULT NULL,
491      p_printer_name               IN         VARCHAR2 DEFAULT NULL,
492 
493      p_sys_key  IN VARCHAR2 DEFAULT NULL, p_arg19  IN VARCHAR2 DEFAULT NULL,
494      p_arg20  IN VARCHAR2 DEFAULT NULL, p_arg21  IN VARCHAR2 DEFAULT NULL,
495      p_arg22  IN VARCHAR2 DEFAULT NULL, p_arg23  IN VARCHAR2 DEFAULT NULL,
496      p_arg24  IN VARCHAR2 DEFAULT NULL, p_arg25  IN VARCHAR2 DEFAULT NULL,
497      p_arg26  IN VARCHAR2 DEFAULT NULL, p_arg27  IN VARCHAR2 DEFAULT NULL,
498      p_arg28  IN VARCHAR2 DEFAULT NULL, p_arg29  IN VARCHAR2 DEFAULT NULL,
499      p_arg30  IN VARCHAR2 DEFAULT NULL, p_arg31  IN VARCHAR2 DEFAULT NULL,
500      p_arg32  IN VARCHAR2 DEFAULT NULL, p_arg33  IN VARCHAR2 DEFAULT NULL,
501      p_arg34  IN VARCHAR2 DEFAULT NULL, p_arg35  IN VARCHAR2 DEFAULT NULL,
502      p_arg36  IN VARCHAR2 DEFAULT NULL, p_arg37  IN VARCHAR2 DEFAULT NULL,
503      p_arg38  IN VARCHAR2 DEFAULT NULL, p_arg39  IN VARCHAR2 DEFAULT NULL,
504      p_arg40  IN VARCHAR2 DEFAULT NULL, p_arg41  IN VARCHAR2 DEFAULT NULL,
505      p_arg42  IN VARCHAR2 DEFAULT NULL, p_arg43  IN VARCHAR2 DEFAULT NULL,
506      p_arg44  IN VARCHAR2 DEFAULT NULL, p_arg45  IN VARCHAR2 DEFAULT NULL,
507      p_arg46  IN VARCHAR2 DEFAULT NULL, p_arg47  IN VARCHAR2 DEFAULT NULL,
508      p_arg48  IN VARCHAR2 DEFAULT NULL, p_arg49  IN VARCHAR2 DEFAULT NULL,
509      p_arg50  IN VARCHAR2 DEFAULT NULL, p_arg51  IN VARCHAR2 DEFAULT NULL,
510      p_arg52  IN VARCHAR2 DEFAULT NULL, p_arg53  IN VARCHAR2 DEFAULT NULL,
511      p_arg54  IN VARCHAR2 DEFAULT NULL, p_arg55  IN VARCHAR2 DEFAULT NULL,
512      p_arg56  IN VARCHAR2 DEFAULT NULL, p_arg57  IN VARCHAR2 DEFAULT NULL,
513      p_arg58  IN VARCHAR2 DEFAULT NULL, p_arg59  IN VARCHAR2 DEFAULT NULL,
514      p_arg60  IN VARCHAR2 DEFAULT NULL, p_arg61  IN VARCHAR2 DEFAULT NULL,
515      p_arg62  IN VARCHAR2 DEFAULT NULL, p_arg63  IN VARCHAR2 DEFAULT NULL,
516      p_arg64  IN VARCHAR2 DEFAULT NULL, p_arg65  IN VARCHAR2 DEFAULT NULL,
517      p_arg66  IN VARCHAR2 DEFAULT NULL, p_arg67  IN VARCHAR2 DEFAULT NULL,
518      p_arg68  IN VARCHAR2 DEFAULT NULL, p_arg69  IN VARCHAR2 DEFAULT NULL,
519      p_arg70  IN VARCHAR2 DEFAULT NULL, p_arg71  IN VARCHAR2 DEFAULT NULL,
520      p_arg72  IN VARCHAR2 DEFAULT NULL, p_arg73  IN VARCHAR2 DEFAULT NULL,
521      p_arg74  IN VARCHAR2 DEFAULT NULL, p_arg75  IN VARCHAR2 DEFAULT NULL,
522      p_arg76  IN VARCHAR2 DEFAULT NULL, p_arg77  IN VARCHAR2 DEFAULT NULL,
523      p_arg78  IN VARCHAR2 DEFAULT NULL, p_arg79  IN VARCHAR2 DEFAULT NULL,
524      p_arg80  IN VARCHAR2 DEFAULT NULL, p_arg81  IN VARCHAR2 DEFAULT NULL,
525      p_arg82  IN VARCHAR2 DEFAULT NULL, p_arg83  IN VARCHAR2 DEFAULT NULL,
526      p_arg84  IN VARCHAR2 DEFAULT NULL, p_arg85  IN VARCHAR2 DEFAULT NULL,
527      p_arg86  IN VARCHAR2 DEFAULT NULL, p_arg87  IN VARCHAR2 DEFAULT NULL,
528      p_arg88  IN VARCHAR2 DEFAULT NULL, p_arg89  IN VARCHAR2 DEFAULT NULL,
529      p_arg90  IN VARCHAR2 DEFAULT NULL, p_arg91  IN VARCHAR2 DEFAULT NULL,
530      p_arg92  IN VARCHAR2 DEFAULT NULL, p_arg93  IN VARCHAR2 DEFAULT NULL,
531      p_arg94  IN VARCHAR2 DEFAULT NULL, p_arg95  IN VARCHAR2 DEFAULT NULL,
532      p_arg96  IN VARCHAR2 DEFAULT NULL, p_arg97  IN VARCHAR2 DEFAULT NULL,
533      p_arg98  IN VARCHAR2 DEFAULT NULL, p_arg99  IN VARCHAR2 DEFAULT NULL,
534      p_arg100 IN VARCHAR2 DEFAULT NULL
535      );
536 
537 
538 END IBY_BUILD_INSTRUCTIONS_PUB_PKG;