[Home] [Help]
PACKAGE: APPS.IBY_BUILD_INSTRUCTIONS_PUB_PKG
Source
1 PACKAGE IBY_BUILD_INSTRUCTIONS_PUB_PKG AS
2 /*$Header: ibypayis.pls 120.13.12010000.1 2008/07/28 05:41:32 appldev 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_arg4 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,
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,
198 p_arg90 IN VARCHAR2 DEFAULT NULL, p_arg91 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_instruction_attributes
262 |
263 |
264 | PURPOSE:
265 |
266 |
267 | PARAMETERS:
268 | IN
269 |
270 |
271 | OUT
272 |
273 |
274 | RETURNS:
275 |
276 | NOTES:
277 |
278 *---------------------------------------------------------------------*/
279 FUNCTION get_instruction_attributes(
280 l_pmt_instr_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)
281 RETURN IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE;
282
283 /*--------------------------------------------------------------------
284 | NAME:
285 | print_debuginfo
286 |
287 | PURPOSE:
288 |
289 |
290 | PARAMETERS:
291 | IN
292 |
293 |
294 | OUT
295 |
296 |
297 | RETURNS:
298 |
299 | NOTES:
300 |
301 *---------------------------------------------------------------------*/
302 PROCEDURE print_debuginfo(
303 p_module IN VARCHAR2,
304 p_debug_text IN VARCHAR2,
305 p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
306 );
307
308 /*--------------------------------------------------------------------
309 | NAME:
310 | build_electronic_instructions
311 |
312 | PURPOSE:
313 | Concurrent program wrapper for electronic payment instructions.
314 |
315 | PARAMETERS:
316 | IN
317 |
318 |
319 | OUT
320 |
321 |
322 | RETURNS:
323 |
324 | NOTES:
325 |
326 *---------------------------------------------------------------------*/
327 PROCEDURE build_electronic_instructions(
328 x_errbuf OUT NOCOPY VARCHAR2,
329 x_retcode OUT NOCOPY VARCHAR2,
330
331 /*-- processing criteria --*/
332 p_processing_type IN VARCHAR2,
333
334 /*-- user/admin assigned criteria --*/
335 p_admin_assigned_ref IN VARCHAR2 DEFAULT NULL,
336 p_comments IN VARCHAR2 DEFAULT NULL,
337
338 /*-- selection criteria --*/
339 p_payment_profile_id IN VARCHAR2 DEFAULT NULL,
340 p_payment_currency IN VARCHAR2 DEFAULT NULL,
341 p_internal_bank_account_id IN VARCHAR2 DEFAULT NULL,
345 p_org_type IN VARCHAR2 DEFAULT NULL,
342 p_calling_app_id IN VARCHAR2 DEFAULT NULL,
343 p_calling_app_payreq_cd IN VARCHAR2 DEFAULT NULL,
344 p_le_id IN VARCHAR2 DEFAULT NULL,
346 p_org_id IN VARCHAR2 DEFAULT NULL,
347 p_payment_from_date IN VARCHAR2 DEFAULT NULL,
348 p_payment_to_date IN VARCHAR2 DEFAULT NULL,
349 p_transmit_now_flag IN VARCHAR2 DEFAULT NULL,
350
351 p_arg16 IN VARCHAR2 DEFAULT NULL, p_arg17 IN VARCHAR2 DEFAULT NULL,
352 p_arg18 IN VARCHAR2 DEFAULT NULL, p_arg19 IN VARCHAR2 DEFAULT NULL,
353 p_arg20 IN VARCHAR2 DEFAULT NULL, p_arg21 IN VARCHAR2 DEFAULT NULL,
354 p_arg22 IN VARCHAR2 DEFAULT NULL, p_arg23 IN VARCHAR2 DEFAULT NULL,
355 p_arg24 IN VARCHAR2 DEFAULT NULL, p_arg25 IN VARCHAR2 DEFAULT NULL,
356 p_arg26 IN VARCHAR2 DEFAULT NULL, p_arg27 IN VARCHAR2 DEFAULT NULL,
357 p_arg28 IN VARCHAR2 DEFAULT NULL, p_arg29 IN VARCHAR2 DEFAULT NULL,
358 p_arg30 IN VARCHAR2 DEFAULT NULL, p_arg31 IN VARCHAR2 DEFAULT NULL,
359 p_arg32 IN VARCHAR2 DEFAULT NULL, p_arg33 IN VARCHAR2 DEFAULT NULL,
360 p_arg34 IN VARCHAR2 DEFAULT NULL, p_arg35 IN VARCHAR2 DEFAULT NULL,
361 p_arg36 IN VARCHAR2 DEFAULT NULL, p_arg37 IN VARCHAR2 DEFAULT NULL,
362 p_arg38 IN VARCHAR2 DEFAULT NULL, p_arg39 IN VARCHAR2 DEFAULT NULL,
363 p_arg40 IN VARCHAR2 DEFAULT NULL, p_arg41 IN VARCHAR2 DEFAULT NULL,
364 p_arg42 IN VARCHAR2 DEFAULT NULL, p_arg43 IN VARCHAR2 DEFAULT NULL,
365 p_arg44 IN VARCHAR2 DEFAULT NULL, p_arg45 IN VARCHAR2 DEFAULT NULL,
366 p_arg46 IN VARCHAR2 DEFAULT NULL, p_arg47 IN VARCHAR2 DEFAULT NULL,
367 p_arg48 IN VARCHAR2 DEFAULT NULL, p_arg49 IN VARCHAR2 DEFAULT NULL,
368 p_arg50 IN VARCHAR2 DEFAULT NULL, p_arg51 IN VARCHAR2 DEFAULT NULL,
369 p_arg52 IN VARCHAR2 DEFAULT NULL, p_arg53 IN VARCHAR2 DEFAULT NULL,
370 p_arg54 IN VARCHAR2 DEFAULT NULL, p_arg55 IN VARCHAR2 DEFAULT NULL,
371 p_arg56 IN VARCHAR2 DEFAULT NULL, p_arg57 IN VARCHAR2 DEFAULT NULL,
372 p_arg58 IN VARCHAR2 DEFAULT NULL, p_arg59 IN VARCHAR2 DEFAULT NULL,
373 p_arg60 IN VARCHAR2 DEFAULT NULL, p_arg61 IN VARCHAR2 DEFAULT NULL,
374 p_arg62 IN VARCHAR2 DEFAULT NULL, p_arg63 IN VARCHAR2 DEFAULT NULL,
375 p_arg64 IN VARCHAR2 DEFAULT NULL, p_arg65 IN VARCHAR2 DEFAULT NULL,
376 p_arg66 IN VARCHAR2 DEFAULT NULL, p_arg67 IN VARCHAR2 DEFAULT NULL,
377 p_arg68 IN VARCHAR2 DEFAULT NULL, p_arg69 IN VARCHAR2 DEFAULT NULL,
378 p_arg70 IN VARCHAR2 DEFAULT NULL, p_arg71 IN VARCHAR2 DEFAULT NULL,
379 p_arg72 IN VARCHAR2 DEFAULT NULL, p_arg73 IN VARCHAR2 DEFAULT NULL,
380 p_arg74 IN VARCHAR2 DEFAULT NULL, p_arg75 IN VARCHAR2 DEFAULT NULL,
381 p_arg76 IN VARCHAR2 DEFAULT NULL, p_arg77 IN VARCHAR2 DEFAULT NULL,
382 p_arg78 IN VARCHAR2 DEFAULT NULL, p_arg79 IN VARCHAR2 DEFAULT NULL,
383 p_arg80 IN VARCHAR2 DEFAULT NULL, p_arg81 IN VARCHAR2 DEFAULT NULL,
384 p_arg82 IN VARCHAR2 DEFAULT NULL, p_arg83 IN VARCHAR2 DEFAULT NULL,
385 p_arg84 IN VARCHAR2 DEFAULT NULL, p_arg85 IN VARCHAR2 DEFAULT NULL,
386 p_arg86 IN VARCHAR2 DEFAULT NULL, p_arg87 IN VARCHAR2 DEFAULT NULL,
387 p_arg88 IN VARCHAR2 DEFAULT NULL, p_arg89 IN VARCHAR2 DEFAULT NULL,
388 p_arg90 IN VARCHAR2 DEFAULT NULL, p_arg91 IN VARCHAR2 DEFAULT NULL,
389 p_arg92 IN VARCHAR2 DEFAULT NULL, p_arg93 IN VARCHAR2 DEFAULT NULL,
390 p_arg94 IN VARCHAR2 DEFAULT NULL, p_arg95 IN VARCHAR2 DEFAULT NULL,
391 p_arg96 IN VARCHAR2 DEFAULT NULL, p_arg97 IN VARCHAR2 DEFAULT NULL,
392 p_arg98 IN VARCHAR2 DEFAULT NULL, p_arg99 IN VARCHAR2 DEFAULT NULL,
393 p_arg100 IN VARCHAR2 DEFAULT NULL
394 );
395
396 /*--------------------------------------------------------------------
397 | NAME:
398 | build_printed_instructions
399 |
400 | PURPOSE:
401 | Concurrent program wrapper for printed payment instructions.
402 |
403 | PARAMETERS:
404 | IN
405 |
406 |
407 | OUT
408 |
409 |
410 | RETURNS:
411 |
412 | NOTES:
413 |
414 *---------------------------------------------------------------------*/
415 PROCEDURE build_printed_instructions(
416 x_errbuf OUT NOCOPY VARCHAR2,
417 x_retcode OUT NOCOPY VARCHAR2,
418
419 /*-- processing criteria --*/
420 p_processing_type IN VARCHAR2,
421
422 /*-- user/admin assigned criteria --*/
423 p_admin_assigned_ref IN VARCHAR2 DEFAULT NULL,
424 p_comments IN VARCHAR2 DEFAULT NULL,
425
426 /*-- selection criteria --*/
427 p_payment_profile_id IN VARCHAR2 DEFAULT NULL,
428 p_payment_currency IN VARCHAR2 DEFAULT NULL,
429 p_internal_bank_account_id IN VARCHAR2 DEFAULT NULL,
430 p_pmt_document_id IN VARCHAR2 DEFAULT NULL,
431 p_calling_app_id IN VARCHAR2 DEFAULT NULL,
432 p_calling_app_payreq_cd IN VARCHAR2 DEFAULT NULL,
433 p_le_id IN VARCHAR2 DEFAULT NULL,
434 p_org_type IN VARCHAR2 DEFAULT NULL,
435 p_org_id IN VARCHAR2 DEFAULT NULL,
436 p_payment_from_date IN VARCHAR2 DEFAULT NULL,
437 p_payment_to_date IN VARCHAR2 DEFAULT NULL,
438 p_print_now_flag IN VARCHAR2 DEFAULT NULL,
442 p_arg20 IN VARCHAR2 DEFAULT NULL, p_arg21 IN VARCHAR2 DEFAULT NULL,
439 p_printer_name IN VARCHAR2 DEFAULT NULL,
440
441 p_arg18 IN VARCHAR2 DEFAULT NULL, p_arg19 IN VARCHAR2 DEFAULT NULL,
443 p_arg22 IN VARCHAR2 DEFAULT NULL, p_arg23 IN VARCHAR2 DEFAULT NULL,
444 p_arg24 IN VARCHAR2 DEFAULT NULL, p_arg25 IN VARCHAR2 DEFAULT NULL,
445 p_arg26 IN VARCHAR2 DEFAULT NULL, p_arg27 IN VARCHAR2 DEFAULT NULL,
446 p_arg28 IN VARCHAR2 DEFAULT NULL, p_arg29 IN VARCHAR2 DEFAULT NULL,
447 p_arg30 IN VARCHAR2 DEFAULT NULL, p_arg31 IN VARCHAR2 DEFAULT NULL,
448 p_arg32 IN VARCHAR2 DEFAULT NULL, p_arg33 IN VARCHAR2 DEFAULT NULL,
449 p_arg34 IN VARCHAR2 DEFAULT NULL, p_arg35 IN VARCHAR2 DEFAULT NULL,
450 p_arg36 IN VARCHAR2 DEFAULT NULL, p_arg37 IN VARCHAR2 DEFAULT NULL,
451 p_arg38 IN VARCHAR2 DEFAULT NULL, p_arg39 IN VARCHAR2 DEFAULT NULL,
452 p_arg40 IN VARCHAR2 DEFAULT NULL, p_arg41 IN VARCHAR2 DEFAULT NULL,
453 p_arg42 IN VARCHAR2 DEFAULT NULL, p_arg43 IN VARCHAR2 DEFAULT NULL,
454 p_arg44 IN VARCHAR2 DEFAULT NULL, p_arg45 IN VARCHAR2 DEFAULT NULL,
455 p_arg46 IN VARCHAR2 DEFAULT NULL, p_arg47 IN VARCHAR2 DEFAULT NULL,
456 p_arg48 IN VARCHAR2 DEFAULT NULL, p_arg49 IN VARCHAR2 DEFAULT NULL,
457 p_arg50 IN VARCHAR2 DEFAULT NULL, p_arg51 IN VARCHAR2 DEFAULT NULL,
458 p_arg52 IN VARCHAR2 DEFAULT NULL, p_arg53 IN VARCHAR2 DEFAULT NULL,
459 p_arg54 IN VARCHAR2 DEFAULT NULL, p_arg55 IN VARCHAR2 DEFAULT NULL,
460 p_arg56 IN VARCHAR2 DEFAULT NULL, p_arg57 IN VARCHAR2 DEFAULT NULL,
461 p_arg58 IN VARCHAR2 DEFAULT NULL, p_arg59 IN VARCHAR2 DEFAULT NULL,
462 p_arg60 IN VARCHAR2 DEFAULT NULL, p_arg61 IN VARCHAR2 DEFAULT NULL,
463 p_arg62 IN VARCHAR2 DEFAULT NULL, p_arg63 IN VARCHAR2 DEFAULT NULL,
464 p_arg64 IN VARCHAR2 DEFAULT NULL, p_arg65 IN VARCHAR2 DEFAULT NULL,
465 p_arg66 IN VARCHAR2 DEFAULT NULL, p_arg67 IN VARCHAR2 DEFAULT NULL,
466 p_arg68 IN VARCHAR2 DEFAULT NULL, p_arg69 IN VARCHAR2 DEFAULT NULL,
467 p_arg70 IN VARCHAR2 DEFAULT NULL, p_arg71 IN VARCHAR2 DEFAULT NULL,
468 p_arg72 IN VARCHAR2 DEFAULT NULL, p_arg73 IN VARCHAR2 DEFAULT NULL,
469 p_arg74 IN VARCHAR2 DEFAULT NULL, p_arg75 IN VARCHAR2 DEFAULT NULL,
470 p_arg76 IN VARCHAR2 DEFAULT NULL, p_arg77 IN VARCHAR2 DEFAULT NULL,
471 p_arg78 IN VARCHAR2 DEFAULT NULL, p_arg79 IN VARCHAR2 DEFAULT NULL,
472 p_arg80 IN VARCHAR2 DEFAULT NULL, p_arg81 IN VARCHAR2 DEFAULT NULL,
473 p_arg82 IN VARCHAR2 DEFAULT NULL, p_arg83 IN VARCHAR2 DEFAULT NULL,
474 p_arg84 IN VARCHAR2 DEFAULT NULL, p_arg85 IN VARCHAR2 DEFAULT NULL,
475 p_arg86 IN VARCHAR2 DEFAULT NULL, p_arg87 IN VARCHAR2 DEFAULT NULL,
476 p_arg88 IN VARCHAR2 DEFAULT NULL, p_arg89 IN VARCHAR2 DEFAULT NULL,
477 p_arg90 IN VARCHAR2 DEFAULT NULL, p_arg91 IN VARCHAR2 DEFAULT NULL,
478 p_arg92 IN VARCHAR2 DEFAULT NULL, p_arg93 IN VARCHAR2 DEFAULT NULL,
479 p_arg94 IN VARCHAR2 DEFAULT NULL, p_arg95 IN VARCHAR2 DEFAULT NULL,
480 p_arg96 IN VARCHAR2 DEFAULT NULL, p_arg97 IN VARCHAR2 DEFAULT NULL,
481 p_arg98 IN VARCHAR2 DEFAULT NULL, p_arg99 IN VARCHAR2 DEFAULT NULL,
482 p_arg100 IN VARCHAR2 DEFAULT NULL
483 );
484
485
486 END IBY_BUILD_INSTRUCTIONS_PUB_PKG;