1 PACKAGE IBY_FNDCPT_MLSUTL_PVT AS
2 /* $Header: ibyfcmus.pls 120.12.12010000.1 2008/07/28 05:40:36 appldev ship $ */
3
4 procedure EXTRACT_INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_EXTRACT_ID in NUMBER,
7 X_DATASOURCE_CODE in VARCHAR2,
8 X_GEN_CODE_LANGUAGE in VARCHAR2,
9 X_GEN_CODE_PACKAGE in VARCHAR2,
10 X_GEN_CODE_ENTRY_POINT in VARCHAR2,
11 X_EXTRACT_CODE in VARCHAR2,
12 X_EXTRACT_VERSION in NUMBER,
13 X_OBJECT_VERSION_NUMBER in NUMBER,
14 X_EXTRACT_DESC in VARCHAR2,
15 X_CREATION_DATE in DATE,
16 X_CREATED_BY in NUMBER,
17 X_LAST_UPDATE_DATE in DATE,
18 X_LAST_UPDATED_BY in NUMBER,
19 X_LAST_UPDATE_LOGIN in NUMBER);
20
21 procedure EXTRACT_UPDATE_ROW (
22 X_EXTRACT_ID in NUMBER,
23 X_DATASOURCE_CODE in VARCHAR2,
24 X_GEN_CODE_LANGUAGE in VARCHAR2,
25 X_GEN_CODE_PACKAGE in VARCHAR2,
26 X_GEN_CODE_ENTRY_POINT in VARCHAR2,
27 X_EXTRACT_CODE in VARCHAR2,
28 X_EXTRACT_VERSION in NUMBER,
29 X_OBJECT_VERSION_NUMBER in NUMBER,
30 X_EXTRACT_DESC in VARCHAR2,
31 X_LAST_UPDATE_DATE in DATE,
32 X_LAST_UPDATED_BY in NUMBER,
33 X_LAST_UPDATE_LOGIN in NUMBER
34 );
35
36 procedure EXTRACT_DELETE_ROW (
37 X_EXTRACT_ID in NUMBER
38 );
39
40 procedure EXTRACT_ADD_LANGUAGE;
41
42 procedure EXTRACT_LOAD_ROW (
43 X_EXTRACT_ID in NUMBER,
44 X_DATASOURCE_CODE in VARCHAR2,
45 X_GEN_CODE_LANGUAGE in VARCHAR2,
46 X_GEN_CODE_PACKAGE in VARCHAR2,
47 X_GEN_CODE_ENTRY_POINT in VARCHAR2,
48 X_EXTRACT_CODE in VARCHAR2,
49 X_EXTRACT_VERSION in NUMBER,
50 X_OBJECT_VERSION_NUMBER in NUMBER,
51 X_EXTRACT_DESC in VARCHAR2,
52 X_LAST_UPDATE_DATE in DATE,
53 X_OWNER in VARCHAR2);
54
55 procedure EXTRACT_TRANSLATE_ROW (
56 X_EXTRACT_ID in NUMBER,
57 X_OBJECT_VERSION_NUMBER in NUMBER,
58 X_EXTRACT_DESC in VARCHAR2,
59 X_LAST_UPDATE_DATE in DATE,
60 X_OWNER in VARCHAR2);
61
62
63 -- formats
64
65 procedure FORMAT_INSERT_ROW (
66 X_ROWID in out NOCOPY VARCHAR2,
67 X_FORMAT_CODE in VARCHAR2,
68 X_FORMAT_TYPE_CODE in VARCHAR2,
69 X_FORMAT_TEMPLATE_CODE in VARCHAR2,
70 X_EXTRACT_ID in NUMBER,
71 X_REFERENCE_FORMAT_CODE in VARCHAR2,
72 X_ATTRIBUTE_CATEGORY in VARCHAR2,
73 X_ATTRIBUTE1 in VARCHAR2,
74 X_ATTRIBUTE2 in VARCHAR2,
75 X_ATTRIBUTE3 in VARCHAR2,
76 X_ATTRIBUTE4 in VARCHAR2,
77 X_ATTRIBUTE5 in VARCHAR2,
78 X_ATTRIBUTE6 in VARCHAR2,
79 X_ATTRIBUTE7 in VARCHAR2,
80 X_ATTRIBUTE8 in VARCHAR2,
81 X_ATTRIBUTE9 in VARCHAR2,
82 X_ATTRIBUTE10 in VARCHAR2,
83 X_ATTRIBUTE11 in VARCHAR2,
84 X_ATTRIBUTE12 in VARCHAR2,
85 X_ATTRIBUTE13 in VARCHAR2,
86 X_ATTRIBUTE14 in VARCHAR2,
87 X_ATTRIBUTE15 in VARCHAR2,
88 X_OBJECT_VERSION_NUMBER in NUMBER,
89 X_SEEDED_FLAG in VARCHAR2,
90 X_FORMAT_NAME in VARCHAR2,
91 X_CREATION_DATE in DATE,
92 X_CREATED_BY in NUMBER,
93 X_LAST_UPDATE_DATE in DATE,
94 X_LAST_UPDATED_BY in NUMBER,
95 X_LAST_UPDATE_LOGIN in NUMBER);
96
97 procedure FORMAT_UPDATE_ROW (
98 X_FORMAT_CODE in VARCHAR2,
99 X_FORMAT_TYPE_CODE in VARCHAR2,
100 X_FORMAT_TEMPLATE_CODE in VARCHAR2,
101 X_EXTRACT_ID in NUMBER,
102 X_REFERENCE_FORMAT_CODE in VARCHAR2,
103 X_ATTRIBUTE_CATEGORY in VARCHAR2,
104 X_ATTRIBUTE1 in VARCHAR2,
105 X_ATTRIBUTE2 in VARCHAR2,
106 X_ATTRIBUTE3 in VARCHAR2,
107 X_ATTRIBUTE4 in VARCHAR2,
108 X_ATTRIBUTE5 in VARCHAR2,
109 X_ATTRIBUTE6 in VARCHAR2,
110 X_ATTRIBUTE7 in VARCHAR2,
111 X_ATTRIBUTE8 in VARCHAR2,
112 X_ATTRIBUTE9 in VARCHAR2,
113 X_ATTRIBUTE10 in VARCHAR2,
114 X_ATTRIBUTE11 in VARCHAR2,
115 X_ATTRIBUTE12 in VARCHAR2,
116 X_ATTRIBUTE13 in VARCHAR2,
117 X_ATTRIBUTE14 in VARCHAR2,
118 X_ATTRIBUTE15 in VARCHAR2,
119 X_OBJECT_VERSION_NUMBER in NUMBER,
120 X_SEEDED_FLAG in VARCHAR2,
121 X_FORMAT_NAME in VARCHAR2,
122 X_LAST_UPDATE_DATE in DATE,
123 X_LAST_UPDATED_BY in NUMBER,
124 X_LAST_UPDATE_LOGIN in NUMBER
125 );
126
127 procedure FORMAT_DELETE_ROW (
128 X_FORMAT_CODE in VARCHAR2
129 );
130
131 procedure FORMAT_ADD_LANGUAGE;
132
133 procedure FORMAT_LOAD_ROW (
134 X_FORMAT_CODE in VARCHAR2,
135 X_FORMAT_TYPE_CODE in VARCHAR2,
136 X_FORMAT_TEMPLATE_CODE in VARCHAR2,
137 X_EXTRACT_ID in NUMBER,
138 X_REFERENCE_FORMAT_CODE in VARCHAR2,
139 X_ATTRIBUTE_CATEGORY in VARCHAR2,
140 X_ATTRIBUTE1 in VARCHAR2,
141 X_ATTRIBUTE2 in VARCHAR2,
142 X_ATTRIBUTE3 in VARCHAR2,
143 X_ATTRIBUTE4 in VARCHAR2,
144 X_ATTRIBUTE5 in VARCHAR2,
145 X_ATTRIBUTE6 in VARCHAR2,
146 X_ATTRIBUTE7 in VARCHAR2,
147 X_ATTRIBUTE8 in VARCHAR2,
148 X_ATTRIBUTE9 in VARCHAR2,
149 X_ATTRIBUTE10 in VARCHAR2,
150 X_ATTRIBUTE11 in VARCHAR2,
151 X_ATTRIBUTE12 in VARCHAR2,
152 X_ATTRIBUTE13 in VARCHAR2,
153 X_ATTRIBUTE14 in VARCHAR2,
154 X_ATTRIBUTE15 in VARCHAR2,
155 X_OBJECT_VERSION_NUMBER in NUMBER,
156 X_SEEDED_FLAG in VARCHAR2,
157 X_FORMAT_NAME in VARCHAR2,
158 X_LAST_UPDATE_DATE in DATE,
159 X_OWNER in VARCHAR2);
160
161 procedure FORMAT_TRANSLATE_ROW (
162 X_FORMAT_CODE in VARCHAR2,
163 X_OBJECT_VERSION_NUMBER in NUMBER,
164 X_FORMAT_NAME in VARCHAR2,
165 X_LAST_UPDATE_DATE in DATE,
166 X_OWNER in VARCHAR2);
167
168
169 -- account options
170
171 procedure BEP_OPT_INSERT_ROW (
172 X_ROWID in out NOCOPY VARCHAR2,
173 X_BEPID in NUMBER,
174 X_ACCOUNT_OPTION_CODE in VARCHAR2,
175 X_ACCOUNT_OPTION_DATATYPE in VARCHAR2,
176 X_OBJECT_VERSION_NUMBER in NUMBER,
177 X_DISPLAY_ORDER in NUMBER,
178 X_ACCOUNT_OPTION_NAME in VARCHAR2,
179 X_CREATION_DATE in DATE,
180 X_CREATED_BY in NUMBER,
181 X_LAST_UPDATE_DATE in DATE,
182 X_LAST_UPDATED_BY in NUMBER,
183 X_LAST_UPDATE_LOGIN in NUMBER,
184 X_SECURED_FLAG in VARCHAR2,
185 X_UNIQUE_PER_BATCH_FLAG in VARCHAR2);
186
187 procedure BEP_OPT_UPDATE_ROW (
188 X_BEPID in NUMBER,
189 X_ACCOUNT_OPTION_CODE in VARCHAR2,
190 X_ACCOUNT_OPTION_DATATYPE in VARCHAR2,
191 X_OBJECT_VERSION_NUMBER in NUMBER,
192 X_DISPLAY_ORDER in NUMBER,
193 X_ACCOUNT_OPTION_NAME in VARCHAR2,
194 X_LAST_UPDATE_DATE in DATE,
195 X_LAST_UPDATED_BY in NUMBER,
196 X_LAST_UPDATE_LOGIN in NUMBER,
197 X_SECURED_FLAG in VARCHAR2,
198 X_UNIQUE_PER_BATCH_FLAG in VARCHAR2
199 );
200
201 procedure BEP_OPT_DELETE_ROW (
202 X_BEPID in NUMBER,
203 X_ACCOUNT_OPTION_CODE in VARCHAR2
204 );
205
206 procedure BEP_OPT_ADD_LANGUAGE;
207
208 procedure BEP_OPT_LOAD_ROW (
209 X_BEPID in NUMBER,
210 X_ACCOUNT_OPTION_CODE in VARCHAR2,
211 X_ACCOUNT_OPTION_DATATYPE in VARCHAR2,
212 X_OBJECT_VERSION_NUMBER in NUMBER,
213 X_DISPLAY_ORDER in NUMBER,
214 X_ACCOUNT_OPTION_NAME in VARCHAR2,
215 X_OWNER in VARCHAR2,
216 X_SECURED_FLAG in VARCHAR2,
217 X_UNIQUE_PER_BATCH_FLAG in VARCHAR2);
218
219 procedure BEP_OPT_TRANSLATE_ROW (
220 X_BEPID in NUMBER,
221 X_ACCOUNT_OPTION_CODE in VARCHAR2,
222 X_OBJECT_VERSION_NUMBER in NUMBER,
223 X_ACCOUNT_OPTION_NAME in VARCHAR2,
224 X_OWNER in VARCHAR2);
225
226
227 -- credit card system profiles
228
229 procedure SYS_CC_PROF_INSERT_ROW (
230 X_ROWID in out NOCOPY VARCHAR2,
231 X_SYS_CC_PROFILE_CODE in VARCHAR2,
232 X_SETTLEMENT_TRANS_PRTCL_CODE in VARCHAR2,
233 X_SETTLEMENT_ACK_RDR_CODE in VARCHAR2,
234 X_QUERY_FORMAT_CODE in VARCHAR2,
235 X_QUERY_TRANS_PRTCL_CODE in VARCHAR2,
236 X_QUERY_ACK_RDR_CODE in VARCHAR2,
237 X_INACTIVE_DATE in DATE,
238 X_OBJECT_VERSION_NUMBER in NUMBER,
239 X_ONLINE_AUTH_FORMAT_CODE in VARCHAR2,
240 X_ONLINE_AUTH_TRANS_PRTCL_CODE in VARCHAR2,
241 X_ONLINE_AUTH_ACK_RDR_CODE in VARCHAR2,
242 X_SETTLEMENT_FORMAT_CODE in VARCHAR2,
243 X_PAYMENT_SYSTEM_ID in NUMBER,
244 X_SYS_CC_PROFILE_NAME in VARCHAR2,
245 X_CREATION_DATE in DATE,
246 X_CREATED_BY in NUMBER,
247 X_LAST_UPDATE_DATE in DATE,
248 X_LAST_UPDATED_BY in NUMBER,
249 X_LAST_UPDATE_LOGIN in NUMBER);
250
251 procedure SYS_CC_PROF_UPDATE_ROW (
252 X_SYS_CC_PROFILE_CODE in VARCHAR2,
253 X_SETTLEMENT_TRANS_PRTCL_CODE in VARCHAR2,
254 X_SETTLEMENT_ACK_RDR_CODE in VARCHAR2,
255 X_QUERY_FORMAT_CODE in VARCHAR2,
256 X_QUERY_TRANS_PRTCL_CODE in VARCHAR2,
257 X_QUERY_ACK_RDR_CODE in VARCHAR2,
258 X_INACTIVE_DATE in DATE,
259 X_OBJECT_VERSION_NUMBER in NUMBER,
260 X_ONLINE_AUTH_FORMAT_CODE in VARCHAR2,
261 X_ONLINE_AUTH_TRANS_PRTCL_CODE in VARCHAR2,
262 X_ONLINE_AUTH_ACK_RDR_CODE in VARCHAR2,
263 X_SETTLEMENT_FORMAT_CODE in VARCHAR2,
264 X_PAYMENT_SYSTEM_ID in NUMBER,
265 X_SYS_CC_PROFILE_NAME in VARCHAR2,
266 X_LAST_UPDATE_DATE in DATE,
267 X_LAST_UPDATED_BY in NUMBER,
268 X_LAST_UPDATE_LOGIN in NUMBER
269 );
270
271 procedure SYS_CC_PROF_DELETE_ROW (
272 X_SYS_CC_PROFILE_CODE in VARCHAR2
273 );
274
275 procedure SYS_CC_PROF_ADD_LANGUAGE;
276
277 procedure SYS_CC_PROF_LOAD_ROW (
278 X_SYS_CC_PROFILE_CODE in VARCHAR2,
279 X_SETTLEMENT_TRANS_PRTCL_CODE in VARCHAR2,
280 X_SETTLEMENT_ACK_RDR_CODE in VARCHAR2,
281 X_QUERY_FORMAT_CODE in VARCHAR2,
282 X_QUERY_TRANS_PRTCL_CODE in VARCHAR2,
283 X_QUERY_ACK_RDR_CODE in VARCHAR2,
284 X_INACTIVE_DATE in DATE,
285 X_OBJECT_VERSION_NUMBER in NUMBER,
286 X_ONLINE_AUTH_FORMAT_CODE in VARCHAR2,
287 X_ONLINE_AUTH_TRANS_PRTCL_CODE in VARCHAR2,
288 X_ONLINE_AUTH_ACK_RDR_CODE in VARCHAR2,
289 X_SETTLEMENT_FORMAT_CODE in VARCHAR2,
290 X_PAYMENT_SYSTEM_ID in NUMBER,
291 X_SYS_CC_PROFILE_NAME in VARCHAR2,
292 X_LAST_UPDATE_DATE in DATE,
293 X_OWNER in VARCHAR2);
294
295 procedure SYS_CC_PROF_TRANSLATE_ROW (
296 X_SYS_CC_PROFILE_CODE in VARCHAR2,
297 X_OBJECT_VERSION_NUMBER in NUMBER,
298 X_SYS_CC_PROFILE_NAME in VARCHAR2,
299 X_LAST_UPDATE_DATE in DATE,
300 X_OWNER in VARCHAR2);
301
302
303 -- eft system profiles
304
305 procedure SYS_EFT_PROF_INSERT_ROW (
306 X_ROWID in out nocopy VARCHAR2,
307 X_SYS_EFT_PROFILE_CODE in VARCHAR2,
308 X_SETTLE_REQUIRE_VRFY_FLAG in VARCHAR2,
309 X_PAYMENT_SYSTEM_ID in NUMBER,
310 X_VERIFY_FORMAT_CODE in VARCHAR2,
311 X_VERIFY_TRANS_PRTCL_CODE in VARCHAR2,
312 X_VERIFY_ACK_RDR_CODE in VARCHAR2,
313 X_FUNDS_XFER_FORMAT_CODE in VARCHAR2,
314 X_FUNDS_XFER_TRANS_PRTCL_CODE in VARCHAR2,
315 X_FUNDS_XFER_ACK_RDR_CODE in VARCHAR2,
316 X_QUERY_FORMAT_CODE in VARCHAR2,
317 X_QUERY_TRANS_PRTCL_CODE in VARCHAR2,
318 X_QUERY_ACK_RDR_CODE in VARCHAR2,
319 X_INACTIVE_DATE in DATE,
320 X_OBJECT_VERSION_NUMBER in NUMBER,
321 X_SYS_EFT_PROFILE_NAME in VARCHAR2,
322 X_CREATION_DATE in DATE,
323 X_CREATED_BY in NUMBER,
324 X_LAST_UPDATE_DATE in DATE,
325 X_LAST_UPDATED_BY in NUMBER,
326 X_LAST_UPDATE_LOGIN in NUMBER,
327 X_PAYER_NOTIFICATION_FORMAT IN VARCHAR2,
328 X_PAYER_NOTIF_DEL_METHOD IN VARCHAR2,
329 X_GROUP_BY_ORG IN VARCHAR2,
330 X_GROUP_BY_LEGAL_ENTITY IN VARCHAR2,
331 X_GROUP_BY_INT_BANK_ACCOUNT IN VARCHAR2,
332 X_GROUP_BY_SETTLEMENT_CURR IN VARCHAR2,
333 X_GROUP_BY_SETTLEMENT_DATE IN VARCHAR2,
334 X_LIMIT_BY_AMT_CURR IN VARCHAR2,
335 X_LIMIT_BY_EXCH_RATE_TYPE IN VARCHAR2,
336 X_LIMIT_BY_TOTAL_AMT in NUMBER,
337 X_LIMIT_BY_SETTLEMENT_NUM in NUMBER,
338 X_SETTLEMENT_COMPLETE_POINT IN VARCHAR2,
339 X_OVERRIDE_PAYER_DELIVERY_FLAG IN VARCHAR2,
340 X_ACCOMPANY_LETTER_FORMAT IN VARCHAR2,
341 X_AUTOMATIC_PN_SUBMIT_FLAG IN VARCHAR2
342 );
343
344 procedure SYS_EFT_PROF_UPDATE_ROW (
345 X_SYS_EFT_PROFILE_CODE in VARCHAR2,
346 X_SETTLE_REQUIRE_VRFY_FLAG in VARCHAR2,
347 X_PAYMENT_SYSTEM_ID in NUMBER,
348 X_VERIFY_FORMAT_CODE in VARCHAR2,
349 X_VERIFY_TRANS_PRTCL_CODE in VARCHAR2,
350 X_VERIFY_ACK_RDR_CODE in VARCHAR2,
351 X_FUNDS_XFER_FORMAT_CODE in VARCHAR2,
352 X_FUNDS_XFER_TRANS_PRTCL_CODE in VARCHAR2,
353 X_FUNDS_XFER_ACK_RDR_CODE in VARCHAR2,
354 X_QUERY_FORMAT_CODE in VARCHAR2,
355 X_QUERY_TRANS_PRTCL_CODE in VARCHAR2,
356 X_QUERY_ACK_RDR_CODE in VARCHAR2,
357 X_INACTIVE_DATE in DATE,
358 X_OBJECT_VERSION_NUMBER in NUMBER,
359 X_SYS_EFT_PROFILE_NAME in VARCHAR2,
360 X_LAST_UPDATE_DATE in DATE,
361 X_LAST_UPDATED_BY in NUMBER,
362 X_LAST_UPDATE_LOGIN in NUMBER,
363 X_PAYER_NOTIFICATION_FORMAT IN VARCHAR2,
364 X_PAYER_NOTIF_DEL_METHOD IN VARCHAR2,
365 X_GROUP_BY_ORG IN VARCHAR2,
366 X_GROUP_BY_LEGAL_ENTITY IN VARCHAR2,
367 X_GROUP_BY_INT_BANK_ACCOUNT IN VARCHAR2,
368 X_GROUP_BY_SETTLEMENT_CURR IN VARCHAR2,
369 X_GROUP_BY_SETTLEMENT_DATE IN VARCHAR2,
370 X_LIMIT_BY_AMT_CURR IN VARCHAR2,
371 X_LIMIT_BY_EXCH_RATE_TYPE IN VARCHAR2,
372 X_LIMIT_BY_TOTAL_AMT in NUMBER,
373 X_LIMIT_BY_SETTLEMENT_NUM in NUMBER,
374 X_SETTLEMENT_COMPLETE_POINT IN VARCHAR2,
375 X_OVERRIDE_PAYER_DELIVERY_FLAG IN VARCHAR2,
376 X_ACCOMPANY_LETTER_FORMAT IN VARCHAR2,
377 X_AUTOMATIC_PN_SUBMIT_FLAG IN VARCHAR2
378 );
379
380 procedure SYS_EFT_PROF_DELETE_ROW (
381 X_SYS_EFT_PROFILE_CODE in VARCHAR2
382 );
383
384 procedure SYS_EFT_PROF_ADD_LANGUAGE;
385
386 procedure SYS_EFT_PROF_LOAD_ROW (
387 X_SYS_EFT_PROFILE_CODE in VARCHAR2,
388 X_SETTLE_REQUIRE_VRFY_FLAG in VARCHAR2,
389 X_PAYMENT_SYSTEM_ID in NUMBER,
390 X_VERIFY_FORMAT_CODE in VARCHAR2,
391 X_VERIFY_TRANS_PRTCL_CODE in VARCHAR2,
392 X_VERIFY_ACK_RDR_CODE in VARCHAR2,
393 X_FUNDS_XFER_FORMAT_CODE in VARCHAR2,
394 X_FUNDS_XFER_TRANS_PRTCL_CODE in VARCHAR2,
395 X_FUNDS_XFER_ACK_RDR_CODE in VARCHAR2,
396 X_QUERY_FORMAT_CODE in VARCHAR2,
397 X_QUERY_TRANS_PRTCL_CODE in VARCHAR2,
398 X_QUERY_ACK_RDR_CODE in VARCHAR2,
399 X_INACTIVE_DATE in DATE,
400 X_OBJECT_VERSION_NUMBER in NUMBER,
401 X_SYS_EFT_PROFILE_NAME in VARCHAR2,
402 X_LAST_UPDATE_DATE in DATE,
403 X_OWNER in VARCHAR2,
404 X_PAYER_NOTIFICATION_FORMAT IN VARCHAR2,
405 X_PAYER_NOTIF_DEL_METHOD IN VARCHAR2,
406 X_GROUP_BY_ORG IN VARCHAR2,
407 X_GROUP_BY_LEGAL_ENTITY IN VARCHAR2,
408 X_GROUP_BY_INT_BANK_ACCOUNT IN VARCHAR2,
409 X_GROUP_BY_SETTLEMENT_CURR IN VARCHAR2,
410 X_GROUP_BY_SETTLEMENT_DATE IN VARCHAR2,
411 X_LIMIT_BY_AMT_CURR IN VARCHAR2,
412 X_LIMIT_BY_EXCH_RATE_TYPE IN VARCHAR2,
413 X_LIMIT_BY_TOTAL_AMT in NUMBER,
414 X_LIMIT_BY_SETTLEMENT_NUM in NUMBER,
415 X_SETTLEMENT_COMPLETE_POINT IN VARCHAR2,
416 X_OVERRIDE_PAYER_DELIVERY_FLAG IN VARCHAR2,
417 X_ACCOMPANY_LETTER_FORMAT IN VARCHAR2,
418 X_AUTOMATIC_PN_SUBMIT_FLAG IN VARCHAR2);
419
420 procedure SYS_EFT_PROF_TRANSLATE_ROW (
421 X_SYS_EFT_PROFILE_CODE in VARCHAR2,
422 X_OBJECT_VERSION_NUMBER in NUMBER,
423 X_SYS_EFT_PROFILE_NAME in VARCHAR2,
424 X_LAST_UPDATE_DATE in DATE,
425 X_OWNER in VARCHAR2);
426
427
428 -- debit card system profiles
429
430 procedure SYS_DC_PROF_INSERT_ROW (
431 X_ROWID in out NOCOPY VARCHAR2,
432 X_SYS_DC_PROFILE_CODE in VARCHAR2,
433 X_ONLINE_DEB_FORMAT_CODE in VARCHAR2,
434 X_ONLINE_DEB_TRANS_PRTCL_CODE in VARCHAR2,
435 X_ONLINE_DEB_ACK_RDR_CODE in VARCHAR2,
436 X_SETTLEMENT_REQ_FLAG in VARCHAR2,
437 X_SETTLEMENT_FORMAT_CODE in VARCHAR2,
438 X_SETTLEMENT_TRANS_PRTCL_CODE in VARCHAR2,
439 X_SETTLEMENT_ACK_RDR_CODE in VARCHAR2,
440 X_QUERY_FORMAT_CODE in VARCHAR2,
441 X_QUERY_TRANS_PRTCL_CODE in VARCHAR2,
442 X_QUERY_ACK_RDR_CODE in VARCHAR2,
443 X_INACTIVE_DATE in DATE,
444 X_OBJECT_VERSION_NUMBER in NUMBER,
445 X_PAYMENT_SYSTEM_ID in NUMBER,
446 X_SYS_DC_PROFILE_NAME in VARCHAR2,
447 X_CREATION_DATE in DATE,
451 X_LAST_UPDATE_LOGIN in NUMBER);
448 X_CREATED_BY in NUMBER,
449 X_LAST_UPDATE_DATE in DATE,
450 X_LAST_UPDATED_BY in NUMBER,
452
453 procedure SYS_DC_PROF_UPDATE_ROW (
454 X_SYS_DC_PROFILE_CODE in VARCHAR2,
455 X_ONLINE_DEB_FORMAT_CODE in VARCHAR2,
456 X_ONLINE_DEB_TRANS_PRTCL_CODE in VARCHAR2,
457 X_ONLINE_DEB_ACK_RDR_CODE in VARCHAR2,
458 X_SETTLEMENT_REQ_FLAG in VARCHAR2,
459 X_SETTLEMENT_FORMAT_CODE in VARCHAR2,
460 X_SETTLEMENT_TRANS_PRTCL_CODE in VARCHAR2,
461 X_SETTLEMENT_ACK_RDR_CODE in VARCHAR2,
462 X_QUERY_FORMAT_CODE in VARCHAR2,
463 X_QUERY_TRANS_PRTCL_CODE in VARCHAR2,
464 X_QUERY_ACK_RDR_CODE in VARCHAR2,
465 X_INACTIVE_DATE in DATE,
466 X_OBJECT_VERSION_NUMBER in NUMBER,
467 X_PAYMENT_SYSTEM_ID in NUMBER,
468 X_SYS_DC_PROFILE_NAME in VARCHAR2,
469 X_LAST_UPDATE_DATE in DATE,
470 X_LAST_UPDATED_BY in NUMBER,
471 X_LAST_UPDATE_LOGIN in NUMBER
472 );
473
474 procedure SYS_DC_PROF_DELETE_ROW (
475 X_SYS_DC_PROFILE_CODE in VARCHAR2
476 );
477
478 procedure SYS_DC_PROF_ADD_LANGUAGE;
479
480 procedure SYS_DC_PROF_LOAD_ROW (
481 X_SYS_DC_PROFILE_CODE in VARCHAR2,
482 X_ONLINE_DEB_FORMAT_CODE in VARCHAR2,
483 X_ONLINE_DEB_TRANS_PRTCL_CODE in VARCHAR2,
484 X_ONLINE_DEB_ACK_RDR_CODE in VARCHAR2,
485 X_SETTLEMENT_REQ_FLAG in VARCHAR2,
486 X_SETTLEMENT_FORMAT_CODE in VARCHAR2,
487 X_SETTLEMENT_TRANS_PRTCL_CODE in VARCHAR2,
488 X_SETTLEMENT_ACK_RDR_CODE in VARCHAR2,
489 X_QUERY_FORMAT_CODE in VARCHAR2,
490 X_QUERY_TRANS_PRTCL_CODE in VARCHAR2,
491 X_QUERY_ACK_RDR_CODE in VARCHAR2,
492 X_INACTIVE_DATE in DATE,
493 X_OBJECT_VERSION_NUMBER in NUMBER,
494 X_PAYMENT_SYSTEM_ID in NUMBER,
495 X_SYS_DC_PROFILE_NAME in VARCHAR2,
496 X_LAST_UPDATE_DATE in DATE,
497 X_OWNER in VARCHAR2);
498
499 procedure SYS_DC_PROF_TRANSLATE_ROW (
500 X_SYS_DC_PROFILE_CODE in VARCHAR2,
501 X_OBJECT_VERSION_NUMBER in NUMBER,
502 X_SYS_DC_PROFILE_NAME in VARCHAR2,
503 X_LAST_UPDATE_DATE in DATE,
504 X_OWNER in VARCHAR2);
505
506
507 -- user credit card profiles
508
509 procedure USER_CC_PROF_INSERT_ROW (
510 X_ROWID in out NOCOPY VARCHAR2,
511 X_USER_CC_PROFILE_CODE in VARCHAR2,
512 X_OBJECT_VERSION_NUMBER in NUMBER,
513 X_BEP_ACCOUNT_ID in NUMBER,
514 X_SYS_CC_PROFILE_CODE in VARCHAR2,
515 X_INACTIVE_DATE in DATE,
516 X_QUERY_TRANS_CONFIG_ID in NUMBER,
517 X_ONLINE_AUTH_TRANS_CONFIG_ID in NUMBER,
518 X_SETTLEMENT_TRANS_CONFIG_ID in NUMBER,
519 X_USER_CC_PROFILE_NAME in VARCHAR2,
520 X_CREATION_DATE in DATE,
521 X_CREATED_BY in NUMBER,
522 X_LAST_UPDATE_DATE in DATE,
523 X_LAST_UPDATED_BY in NUMBER,
524 X_LAST_UPDATE_LOGIN in NUMBER);
525
526 procedure USER_CC_PROF_UPDATE_ROW (
527 X_USER_CC_PROFILE_CODE in VARCHAR2,
528 X_OBJECT_VERSION_NUMBER in NUMBER,
529 X_BEP_ACCOUNT_ID in NUMBER,
530 X_SYS_CC_PROFILE_CODE in VARCHAR2,
531 X_INACTIVE_DATE in DATE,
532 X_QUERY_TRANS_CONFIG_ID in NUMBER,
533 X_ONLINE_AUTH_TRANS_CONFIG_ID in NUMBER,
534 X_SETTLEMENT_TRANS_CONFIG_ID in NUMBER,
535 X_USER_CC_PROFILE_NAME in VARCHAR2,
536 X_LAST_UPDATE_DATE in DATE,
537 X_LAST_UPDATED_BY in NUMBER,
538 X_LAST_UPDATE_LOGIN in NUMBER
539 );
540
541 procedure USER_CC_PROF_DELETE_ROW (
542 X_USER_CC_PROFILE_CODE in VARCHAR2
543 );
544
545 procedure USER_CC_PROF_ADD_LANGUAGE;
546
547
548 -- user eft profiles
549
550 procedure USER_EFT_PROF_INSERT_ROW (
551 X_ROWID in out NOCOPY VARCHAR2,
552 X_USER_EFT_PROFILE_CODE in VARCHAR2,
553 X_OBJECT_VERSION_NUMBER in NUMBER,
554 X_BEP_ACCOUNT_ID in NUMBER,
555 X_VERIFY_TRANS_CONFIG_ID in NUMBER,
556 X_SYS_EFT_PROFILE_CODE in VARCHAR2,
557 X_INACTIVE_DATE in DATE,
558 X_FUNDS_XFER_TRANS_CONFIG_ID in NUMBER,
559 X_QUERY_TRANS_CONFIG_ID in NUMBER,
560 X_USER_EFT_PROFILE_NAME in VARCHAR2,
561 X_CREATION_DATE in DATE,
562 X_CREATED_BY in NUMBER,
563 X_LAST_UPDATE_DATE in DATE,
564 X_LAST_UPDATED_BY in NUMBER,
565 X_LAST_UPDATE_LOGIN in NUMBER);
566
567 procedure USER_EFT_PROF_UPDATE_ROW (
568 X_USER_EFT_PROFILE_CODE in VARCHAR2,
569 X_OBJECT_VERSION_NUMBER in NUMBER,
570 X_BEP_ACCOUNT_ID in NUMBER,
571 X_VERIFY_TRANS_CONFIG_ID in NUMBER,
572 X_SYS_EFT_PROFILE_CODE in VARCHAR2,
573 X_INACTIVE_DATE in DATE,
574 X_FUNDS_XFER_TRANS_CONFIG_ID in NUMBER,
575 X_QUERY_TRANS_CONFIG_ID in NUMBER,
576 X_USER_EFT_PROFILE_NAME in VARCHAR2,
577 X_LAST_UPDATE_DATE in DATE,
578 X_LAST_UPDATED_BY in NUMBER,
579 X_LAST_UPDATE_LOGIN in NUMBER
580 );
581
582 procedure USER_EFT_PROF_DELETE_ROW (
583 X_USER_EFT_PROFILE_CODE in VARCHAR2
584 );
585
586 procedure USER_EFT_PROF_ADD_LANGUAGE;
587
588
589 -- user debit card profiles
590
591 procedure USER_DC_PROF_INSERT_ROW (
592 X_ROWID in out NOCOPY VARCHAR2,
593 X_USER_DC_PROFILE_CODE in VARCHAR2,
594 X_SETTLEMENT_TRANS_CONFIG_ID in NUMBER,
595 X_QUERY_TRANS_CONFIG_ID in NUMBER,
596 X_INACTIVE_DATE in DATE,
597 X_OBJECT_VERSION_NUMBER in NUMBER,
598 X_ONLINE_DEB_TRANS_CONFIG_ID in VARCHAR2,
602 X_CREATION_DATE in DATE,
599 X_BEP_ACCOUNT_ID in NUMBER,
600 X_SYS_DC_PROFILE_CODE in VARCHAR2,
601 X_USER_DC_PROFILE_NAME in VARCHAR2,
603 X_CREATED_BY in NUMBER,
604 X_LAST_UPDATE_DATE in DATE,
605 X_LAST_UPDATED_BY in NUMBER,
606 X_LAST_UPDATE_LOGIN in NUMBER);
607
608 procedure USER_DC_PROF_UPDATE_ROW (
609 X_USER_DC_PROFILE_CODE in VARCHAR2,
610 X_SETTLEMENT_TRANS_CONFIG_ID in NUMBER,
611 X_QUERY_TRANS_CONFIG_ID in NUMBER,
612 X_INACTIVE_DATE in DATE,
613 X_OBJECT_VERSION_NUMBER in NUMBER,
614 X_ONLINE_DEB_TRANS_CONFIG_ID in VARCHAR2,
615 X_BEP_ACCOUNT_ID in NUMBER,
616 X_SYS_DC_PROFILE_CODE in VARCHAR2,
617 X_USER_DC_PROFILE_NAME in VARCHAR2,
618 X_LAST_UPDATE_DATE in DATE,
619 X_LAST_UPDATED_BY in NUMBER,
620 X_LAST_UPDATE_LOGIN in NUMBER
621 );
622
623 procedure USER_DC_PROF_DELETE_ROW (
624 X_USER_DC_PROFILE_CODE in VARCHAR2
625 );
626
627 procedure USER_DC_PROF_ADD_LANGUAGE;
628
629 -- payment channel
630
631 procedure PMT_CHANNEL_INSERT_ROW (
632 X_ROWID in out NOCOPY VARCHAR2,
633 X_PAYMENT_CHANNEL_CODE in VARCHAR2,
634 X_ATTRIBUTE13 in VARCHAR2,
635 X_ATTRIBUTE14 in VARCHAR2,
636 X_ATTRIBUTE15 in VARCHAR2,
637 X_OBJECT_VERSION_NUMBER in NUMBER,
638 X_INSTRUMENT_TYPE in VARCHAR2,
639 X_INACTIVE_DATE in DATE,
640 X_ATTRIBUTE_CATEGORY in VARCHAR2,
641 X_ATTRIBUTE1 in VARCHAR2,
642 X_ATTRIBUTE2 in VARCHAR2,
643 X_ATTRIBUTE3 in VARCHAR2,
644 X_ATTRIBUTE4 in VARCHAR2,
645 X_ATTRIBUTE5 in VARCHAR2,
646 X_ATTRIBUTE6 in VARCHAR2,
647 X_ATTRIBUTE7 in VARCHAR2,
648 X_ATTRIBUTE8 in VARCHAR2,
649 X_ATTRIBUTE9 in VARCHAR2,
650 X_ATTRIBUTE10 in VARCHAR2,
651 X_ATTRIBUTE11 in VARCHAR2,
652 X_ATTRIBUTE12 in VARCHAR2,
653 X_PAYMENT_CHANNEL_NAME in VARCHAR2,
654 X_DESCRIPTION in VARCHAR2,
655 X_CREATION_DATE in DATE,
656 X_CREATED_BY in NUMBER,
657 X_LAST_UPDATE_DATE in DATE,
658 X_LAST_UPDATED_BY in NUMBER,
659 X_LAST_UPDATE_LOGIN in NUMBER);
660
661 procedure PMT_CHANNEL_UPDATE_ROW (
662 X_PAYMENT_CHANNEL_CODE in VARCHAR2,
663 X_ATTRIBUTE13 in VARCHAR2,
664 X_ATTRIBUTE14 in VARCHAR2,
665 X_ATTRIBUTE15 in VARCHAR2,
666 X_OBJECT_VERSION_NUMBER in NUMBER,
667 X_INSTRUMENT_TYPE in VARCHAR2,
668 X_INACTIVE_DATE in DATE,
669 X_ATTRIBUTE_CATEGORY in VARCHAR2,
670 X_ATTRIBUTE1 in VARCHAR2,
671 X_ATTRIBUTE2 in VARCHAR2,
672 X_ATTRIBUTE3 in VARCHAR2,
673 X_ATTRIBUTE4 in VARCHAR2,
674 X_ATTRIBUTE5 in VARCHAR2,
675 X_ATTRIBUTE6 in VARCHAR2,
676 X_ATTRIBUTE7 in VARCHAR2,
677 X_ATTRIBUTE8 in VARCHAR2,
678 X_ATTRIBUTE9 in VARCHAR2,
679 X_ATTRIBUTE10 in VARCHAR2,
680 X_ATTRIBUTE11 in VARCHAR2,
681 X_ATTRIBUTE12 in VARCHAR2,
682 X_PAYMENT_CHANNEL_NAME in VARCHAR2,
683 X_DESCRIPTION in VARCHAR2,
684 X_LAST_UPDATE_DATE in DATE,
685 X_LAST_UPDATED_BY in NUMBER,
686 X_LAST_UPDATE_LOGIN in NUMBER
687 );
688
689 procedure PMT_CHANNEL_DELETE_ROW (
690 X_PAYMENT_CHANNEL_CODE in VARCHAR2
691 );
692
693 procedure PMT_CHANNEL_ADD_LANGUAGE;
694
695 procedure PMT_CHANNEL_LOAD_ROW (
696 X_PAYMENT_CHANNEL_CODE in VARCHAR2,
697 X_ATTRIBUTE13 in VARCHAR2,
698 X_ATTRIBUTE14 in VARCHAR2,
699 X_ATTRIBUTE15 in VARCHAR2,
700 X_OBJECT_VERSION_NUMBER in NUMBER,
701 X_INSTRUMENT_TYPE in VARCHAR2,
702 X_INACTIVE_DATE in DATE,
703 X_ATTRIBUTE_CATEGORY in VARCHAR2,
704 X_ATTRIBUTE1 in VARCHAR2,
705 X_ATTRIBUTE2 in VARCHAR2,
706 X_ATTRIBUTE3 in VARCHAR2,
707 X_ATTRIBUTE4 in VARCHAR2,
708 X_ATTRIBUTE5 in VARCHAR2,
709 X_ATTRIBUTE6 in VARCHAR2,
710 X_ATTRIBUTE7 in VARCHAR2,
711 X_ATTRIBUTE8 in VARCHAR2,
712 X_ATTRIBUTE9 in VARCHAR2,
713 X_ATTRIBUTE10 in VARCHAR2,
714 X_ATTRIBUTE11 in VARCHAR2,
715 X_ATTRIBUTE12 in VARCHAR2,
716 X_PAYMENT_CHANNEL_NAME in VARCHAR2,
717 X_DESCRIPTION in VARCHAR2,
718 X_LAST_UPDATE_DATE in DATE,
719 X_OWNER in VARCHAR2);
720
721 procedure PMT_CHANNEL_TRANSLATE_ROW (
722 X_PAYMENT_CHANNEL_CODE in VARCHAR2,
723 X_PAYMENT_CHANNEL_NAME in VARCHAR2,
724 X_DESCRIPTION in VARCHAR2,
725 X_OBJECT_VERSION_NUMBER in NUMBER,
726 X_LAST_UPDATE_DATE in DATE,
727 X_OWNER in VARCHAR2);
728
729 -- credit card issuers
730
731 procedure CC_ISSUER_INSERT_ROW (
732 X_ROWID in out NOCOPY VARCHAR2,
733 X_CARD_ISSUER_CODE in VARCHAR2,
734 X_OBJECT_VERSION_NUMBER in NUMBER,
735 X_CARD_ISSUER_ACCEPTED_FLAG in VARCHAR2,
736 X_AUTHORIZATION_VALIDITY_PERIO in NUMBER,
737 X_DIGIT_CHECK_FLAG in VARCHAR2,
738 X_CARD_ISSUER_NAME in VARCHAR2,
739 X_DESCRIPTION in VARCHAR2,
740 X_CREATION_DATE in DATE,
741 X_CREATED_BY in NUMBER,
742 X_LAST_UPDATE_DATE in DATE,
743 X_LAST_UPDATED_BY in NUMBER,
744 X_LAST_UPDATE_LOGIN in NUMBER);
745
746 procedure CC_ISSUER_UPDATE_ROW (
747 X_CARD_ISSUER_CODE in VARCHAR2,
748 X_OBJECT_VERSION_NUMBER in NUMBER,
749 X_CARD_ISSUER_ACCEPTED_FLAG in VARCHAR2,
750 X_AUTHORIZATION_VALIDITY_PERIO in NUMBER,
751 X_DIGIT_CHECK_FLAG in VARCHAR2,
752 X_CARD_ISSUER_NAME in VARCHAR2,
753 X_DESCRIPTION in VARCHAR2,
754 X_LAST_UPDATE_DATE in DATE,
755 X_LAST_UPDATED_BY in NUMBER,
756 X_LAST_UPDATE_LOGIN in NUMBER
757 );
758
759 procedure CC_ISSUER_DELETE_ROW (
760 X_CARD_ISSUER_CODE in VARCHAR2
761 );
762
763 procedure CC_ISSUER_ADD_LANGUAGE;
764
765 procedure CC_ISSUER_LOAD_ROW (
766 X_CARD_ISSUER_CODE in VARCHAR2,
767 X_OBJECT_VERSION_NUMBER in NUMBER,
768 X_CARD_ISSUER_ACCEPTED_FLAG in VARCHAR2,
769 X_AUTHORIZATION_VALIDITY_PERIO in NUMBER,
770 X_DIGIT_CHECK_FLAG in VARCHAR2,
771 X_CARD_ISSUER_NAME in VARCHAR2,
772 X_DESCRIPTION in VARCHAR2,
773 X_LAST_UPDATE_DATE in DATE,
774 X_OWNER in VARCHAR2);
775
776 procedure CC_ISSUER_TRANSLATE_ROW (
777 X_CARD_ISSUER_CODE in VARCHAR2,
778 X_OBJECT_VERSION_NUMBER in NUMBER,
779 X_CARD_ISSUER_NAME in VARCHAR2,
780 X_DESCRIPTION in VARCHAR2,
781 X_LAST_UPDATE_DATE in DATE,
782 X_OWNER in VARCHAR2);
783
784 END IBY_FNDCPT_MLSUTL_PVT;