[Home] [Help]
PACKAGE: APPS.IBY_VALIDATIONSETS_CALLS_PUB
Source
1 PACKAGE IBY_VALIDATIONSETS_CALLS_PUB AUTHID CURRENT_USER AS
2 /*$Header: ibyvalcs.pls 120.13 2011/05/12 11:06:45 pschalla ship $*/
3
4 PROCEDURE CITI_AT_EFT_DOM_PAYEE (
5 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
6 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
7 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
8 p_is_online_val IN VARCHAR2,
9 x_result OUT NOCOPY NUMBER);
10
11 PROCEDURE CITI_AT_EFT_DOM_DOC (
12 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
13 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
14 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
15 p_is_online_val IN VARCHAR2,
16 x_result OUT NOCOPY NUMBER);
17
18 PROCEDURE AT_EFT_INT_INTERNAL_BANK (
19 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
20 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
21 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
22 p_is_online_val IN VARCHAR2,
23 x_result OUT NOCOPY NUMBER);
24
25 PROCEDURE AT_EFT_INT_PAYER (
26 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
27 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
28 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
29 p_is_online_val IN VARCHAR2,
30 x_result OUT NOCOPY NUMBER);
31
32 PROCEDURE AT_EFT_INT_PAYEE (
33 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
34 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
35 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
36 p_is_online_val IN VARCHAR2,
37 x_result OUT NOCOPY NUMBER);
38
39 PROCEDURE CITI_BE_EFT_DOM_PAYEE (
40 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
41 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
42 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
43 p_is_online_val IN VARCHAR2,
44 x_result OUT NOCOPY NUMBER);
45
46 PROCEDURE P_CITI_BE_EFT_DOM_PMT (
47 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
48 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
49 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
50 p_is_online_val IN VARCHAR2,
51 x_result OUT NOCOPY NUMBER);
52
53 PROCEDURE BE_EFT_DOM_DOC (
54 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
55 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
56 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
57 p_is_online_val IN VARCHAR2,
58 x_result OUT NOCOPY NUMBER);
59
60 PROCEDURE BE_EFT_INT_PAYEE (
61 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
62 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
63 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
64 p_is_online_val IN VARCHAR2,
65 x_result OUT NOCOPY NUMBER);
66
67 PROCEDURE BE_EFT_INT_DOC (
68 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
69 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
70 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
71 p_is_online_val IN VARCHAR2,
72 x_result OUT NOCOPY NUMBER);
73
74 PROCEDURE P_BE_EFT_INT_PMT (
78 p_is_online_val IN VARCHAR2,
75 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
76 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
77 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
79 x_result OUT NOCOPY NUMBER);
80
81 PROCEDURE I_BE_EFT_INT_INSTR (
82 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
83 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
84 p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%type,
85 p_is_online_val IN VARCHAR2,
86 x_result OUT NOCOPY NUMBER);
87
88 PROCEDURE CITI_CH_EFT_DOM_PAYEE (
89 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
90 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
91 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
92 p_is_online_val IN VARCHAR2,
93 x_result OUT NOCOPY NUMBER);
94
95 PROCEDURE CITI_CH_EFT_DOM_DOC (
96 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
97 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
98 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
99 p_is_online_val IN VARCHAR2,
100 x_result OUT NOCOPY NUMBER);
101
102 PROCEDURE P_CITI_CH_EFT_DOM_PMT (
103 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
104 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
105 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
106 p_is_online_val IN VARCHAR2,
107 x_result OUT NOCOPY NUMBER);
108
109 PROCEDURE CH_EFT_GEN_PAYEE (
110 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
111 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
112 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
113 p_is_online_val IN VARCHAR2,
114 x_result OUT NOCOPY NUMBER);
115
116 PROCEDURE CH_EFT_GEN_DOC (
117 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
118 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
119 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
120 p_is_online_val IN VARCHAR2,
121 x_result OUT NOCOPY NUMBER);
122
123 PROCEDURE CITI_DE_EFT_DOM_PAYEE (
124 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
125 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
126 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
127 p_is_online_val IN VARCHAR2,
128 x_result OUT NOCOPY NUMBER) ;
129
130 PROCEDURE CITI_DE_EFT_DOM_DOC (
131 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
132 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
133 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
134 p_is_online_val IN VARCHAR2,
135 x_result OUT NOCOPY NUMBER);
136
137 PROCEDURE DE_EFT_DOM_INTERNAL_BANK (
138 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
139 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
140 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
141 p_is_online_val IN VARCHAR2,
142 x_result OUT NOCOPY NUMBER) ;
143
144 PROCEDURE DE_EFT_DOM_PAYER (
145 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
146 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
147 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
148 p_is_online_val IN VARCHAR2,
149 x_result OUT NOCOPY NUMBER);
150
151 PROCEDURE DE_EFT_DOM_PAYEE (
152 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
153 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
154 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
155 p_is_online_val IN VARCHAR2,
156 x_result OUT NOCOPY NUMBER) ;
157
158 PROCEDURE P_DE_EFT_DOM_PMT (
159 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
160 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
161 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
162 p_is_online_val IN VARCHAR2,
163 x_result OUT NOCOPY NUMBER);
164
165 PROCEDURE DE_EFT_INT_INTERNAL_BANK (
166 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
167 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
168 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
169 p_is_online_val IN VARCHAR2,
170 x_result OUT NOCOPY NUMBER) ;
171
172 PROCEDURE DE_EFT_INT_PAYER (
173 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
174 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
175 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
176 p_is_online_val IN VARCHAR2,
177 x_result OUT NOCOPY NUMBER);
178
179 PROCEDURE DE_EFT_INT_PAYEE (
180 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
181 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
185
182 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
183 p_is_online_val IN VARCHAR2,
184 x_result OUT NOCOPY NUMBER) ;
186 PROCEDURE P_DE_EFT_INT_PMT (
187 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
188 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
189 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
190 p_is_online_val IN VARCHAR2,
191 x_result OUT NOCOPY NUMBER);
192
193 /* Bug 5569624: Added new document level validation set for Denmark */
194
195 PROCEDURE DK_EFT_DOM_DOC (
196 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
197 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
198 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
199 p_is_online_val IN VARCHAR2,
200 x_result OUT NOCOPY NUMBER);
201
202 PROCEDURE CITI_DK_EFT_DOM_PAYEE (
203 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
204 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
205 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
206 p_is_online_val IN VARCHAR2,
207 x_result OUT NOCOPY NUMBER);
208
209 PROCEDURE CITI_DK_EFT_DOM_DOC (
210 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
211 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
212 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
213 p_is_online_val IN VARCHAR2,
214 x_result OUT NOCOPY NUMBER);
215
216 PROCEDURE P_CITI_DK_EFT_DOM_PMT (
217 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
218 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
219 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
220 p_is_online_val IN VARCHAR2,
221 x_result OUT NOCOPY NUMBER);
222
223 PROCEDURE CITI_ES_CHECK_DOM_PAYEE (
224 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
225 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
226 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
227 p_is_online_val IN VARCHAR2,
228 x_result OUT NOCOPY NUMBER);
229
230 PROCEDURE P_CITI_ES_CHECK_DOM_PMT (
231 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
232 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
233 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
234 p_is_online_val IN VARCHAR2,
235 x_result OUT NOCOPY NUMBER);
236
237 PROCEDURE CITI_ES_EFT_DOM_PAYEE (
238 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
239 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
240 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
241 p_is_online_val IN VARCHAR2,
242 x_result OUT NOCOPY NUMBER) ;
243
244 PROCEDURE P_CITI_ES_EFT_DOM_PMT (
245 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
246 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
247 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
248 p_is_online_val IN VARCHAR2,
249 x_result OUT NOCOPY NUMBER);
250
251 PROCEDURE CITI_ES_EFT_DOM_DOC (
252 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
253 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
254 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
255 p_is_online_val IN VARCHAR2,
256 x_result OUT NOCOPY NUMBER);
257
258 PROCEDURE CITI_FI_EFT_DOM_PAYEE (
259 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
260 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
261 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
262 p_is_online_val IN VARCHAR2,
263 x_result OUT NOCOPY NUMBER);
264
265 PROCEDURE CITI_FI_EFT_DOM_DOC (
266 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
267 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
268 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
269 p_is_online_val IN VARCHAR2,
270 x_result OUT NOCOPY NUMBER);
271
272 PROCEDURE P_CITI_FI_EFT_DOM_PMT (
273 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
274 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
275 p_payment_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
276 p_is_online_val IN VARCHAR2,
277 x_result OUT NOCOPY NUMBER);
278
279 PROCEDURE CITI_FR_EFT_DOM_PAYEE (
280 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
281 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
282 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
283 p_is_online_val IN VARCHAR2,
284 x_result OUT NOCOPY NUMBER);
285
286 PROCEDURE CITI_FR_EFT_DOM_DOC (
287 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
288 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
289 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
290 p_is_online_val IN VARCHAR2,
291 x_result OUT NOCOPY NUMBER);
292
293 PROCEDURE P_CITI_FR_EFT_DOM_PMT (
294 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
295 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
296 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
297 p_is_online_val IN VARCHAR2,
298 x_result OUT NOCOPY NUMBER);
299
300 PROCEDURE CITI_GR_CHECK_DOM_PAYEE (
301 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
302 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
303 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
304 p_is_online_val IN VARCHAR2,
305 x_result OUT NOCOPY NUMBER);
306
307 PROCEDURE CITI_GR_CHECK_DOM_DOC (
308 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
309 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
310 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
311 p_is_online_val IN VARCHAR2,
312 x_result OUT NOCOPY NUMBER);
313
314 PROCEDURE P_CITI_GR_CHECK_DOM_PMT (
315 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
316 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
317 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
318 p_is_online_val IN VARCHAR2,
319 x_result OUT NOCOPY NUMBER);
320
321 PROCEDURE CITI_GR_EFT_DOM_PAYEE (
322 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
323 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
324 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
325 p_is_online_val IN VARCHAR2,
326 x_result OUT NOCOPY NUMBER);
327
328 PROCEDURE CITI_GR_EFT_DOM_DOC (
329 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
330 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
331 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
332 p_is_online_val IN VARCHAR2,
333 x_result OUT NOCOPY NUMBER);
334
335 PROCEDURE P_CITI_GR_EFT_DOM_PMT (
336 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
337 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
338 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
339 p_is_online_val IN VARCHAR2,
340 x_result OUT NOCOPY NUMBER);
341
342 PROCEDURE CITI_IE_EFT_DOM_PAYEE (
343 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
344 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
345 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
346 p_is_online_val IN VARCHAR2,
347 x_result OUT NOCOPY NUMBER);
348
349 PROCEDURE CITI_IE_EFT_DOM_DOC (
350 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
351 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
352 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
353 p_is_online_val IN VARCHAR2,
354 x_result OUT NOCOPY NUMBER);
355
356 PROCEDURE P_CITI_IE_EFT_DOM_PMT (
357 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
358 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
359 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
360 p_is_online_val IN VARCHAR2,
361 x_result OUT NOCOPY NUMBER);
362
363 PROCEDURE CITI_IT_EFT_DOM_PAYEE (
364 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
365 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
366 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
367 p_is_online_val IN VARCHAR2,
368 x_result OUT NOCOPY NUMBER);
369
370 PROCEDURE P_CITI_IT_EFT_DOM_PMT (
371 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
372 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
373 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
374 p_is_online_val IN VARCHAR2,
375 x_result OUT NOCOPY NUMBER);
376
377 PROCEDURE JP_EFT_ZENGIN_INTERNAL_BANK (
378 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
379 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
380 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
381 p_is_online_val IN VARCHAR2,
382 x_result OUT NOCOPY NUMBER);
383
384 PROCEDURE JP_EFT_ZENGIN_PAYEE (
385 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
386 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
387 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
388 p_is_online_val IN VARCHAR2,
389 x_result OUT NOCOPY NUMBER);
390
391 /* Bug 5571714: Unique Remittance Identifier (KID code) validation
392 for Norway. */
393
394 PROCEDURE NO_EFT_DOM_DOC (
395 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
396 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
397 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
398 p_is_online_val IN VARCHAR2,
399 x_result OUT NOCOPY NUMBER);
400
401 PROCEDURE CITI_NO_EFT_DOM_PAYEE (
402 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
403 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
404 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
405 p_is_online_val IN VARCHAR2,
406 x_result OUT NOCOPY NUMBER);
407
408 PROCEDURE CITI_NO_EFT_DOM_DOC (
409 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
410 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
411 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
412 p_is_online_val IN VARCHAR2,
413 x_result OUT NOCOPY NUMBER);
414
415 PROCEDURE P_CITI_NO_EFT_DOM_PMT (
416 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
417 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
418 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
419 p_is_online_val IN VARCHAR2,
420 x_result OUT NOCOPY NUMBER);
421
422 PROCEDURE CITI_PL_EFT_MTMS_INTERNAL_BANK (
423 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
424 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
425 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
426 p_is_online_val IN VARCHAR2,
427 x_result OUT NOCOPY NUMBER);
428
429 PROCEDURE CITI_PL_EFT_MTMS_PAYEE (
430 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
431 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
432 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
433 p_is_online_val IN VARCHAR2,
434 x_result OUT NOCOPY NUMBER);
435
436 PROCEDURE P_CITI_PL_EFT_MTMS_PMT (
437 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
438 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
439 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
440 p_is_online_val IN VARCHAR2,
441 x_result OUT NOCOPY NUMBER);
442
443 PROCEDURE PEKAO_PL_WIRE_TR_INTERNAL_BANK (
444 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
445 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
446 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
447 p_is_online_val IN VARCHAR2,
448 x_result OUT NOCOPY NUMBER);
449
450 PROCEDURE PEKAO_PL_WIRE_TR_PAYEE (
451 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
452 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
453 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
454 p_is_online_val IN VARCHAR2,
455 x_result OUT NOCOPY NUMBER);
456
457 PROCEDURE PEKAO_PL_WIRE_TR_DOC (
458 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
459 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
460 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
461 p_is_online_val IN VARCHAR2,
462 x_result OUT NOCOPY NUMBER);
463
464 PROCEDURE P_PEKAO_PL_WIRE_TR_PMT (
465 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
466 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
467 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
468 p_is_online_val IN VARCHAR2,
469 x_result OUT NOCOPY NUMBER);
470
471 PROCEDURE PEKAO_PL_WIRE_ST_INTERNAL_BANK (
472 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
473 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
474 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
475 p_is_online_val IN VARCHAR2,
476 x_result OUT NOCOPY NUMBER);
477
478 PROCEDURE PEKAO_PL_WIRE_ST_PAYEE (
479 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
480 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
481 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
482 p_is_online_val IN VARCHAR2,
483 x_result OUT NOCOPY NUMBER);
484
485 PROCEDURE PEKAO_PL_WIRE_ST_DOC (
486 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
490 x_result OUT NOCOPY NUMBER);
487 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
488 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
489 p_is_online_val IN VARCHAR2,
491
492 PROCEDURE CITI_PT_EFT_DOM_PAYEE (
493 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
494 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
495 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
496 p_is_online_val IN VARCHAR2,
497 x_result OUT NOCOPY NUMBER);
498
499 PROCEDURE CITI_PT_EFT_DOM_DOC (
500 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
501 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
502 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
503 p_is_online_val IN VARCHAR2,
504 x_result OUT NOCOPY NUMBER);
505
506 PROCEDURE P_CITI_PT_EFT_DOM_PMT (
507 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
508 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
509 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
510 p_is_online_val IN VARCHAR2,
511 x_result OUT NOCOPY NUMBER);
512
513 PROCEDURE PT_CHECK_GEN (
514 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
515 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
516 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
517 p_is_online_val IN VARCHAR2,
518 x_result OUT NOCOPY NUMBER);
519
520 PROCEDURE CITI_SE_EFT_DOM_PAYEE (
521 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
522 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
523 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
524 p_is_online_val IN VARCHAR2,
525 x_result OUT NOCOPY NUMBER);
526
527 PROCEDURE CITI_SE_EFT_DOM_DOC (
528 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
529 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
530 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
531 p_is_online_val IN VARCHAR2,
532 x_result OUT NOCOPY NUMBER);
533
534 PROCEDURE P_CITI_SE_EFT_DOM_PMT (
535 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
536 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
537 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
538 p_is_online_val IN VARCHAR2,
539 x_result OUT NOCOPY NUMBER);
540
541 PROCEDURE SE_EFT_BANKGIRO_INLAND_DOC (
542 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
543 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
544 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
545 p_is_online_val IN VARCHAR2,
546 x_result OUT NOCOPY NUMBER);
547
548 PROCEDURE SE_EFT_BANKGIRO_UTLAND_SI_DOC (
549 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
550 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
551 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
552 p_is_online_val IN VARCHAR2,
553 x_result OUT NOCOPY NUMBER);
554
555 PROCEDURE SE_EFT_BANKGIRO_UTLAND_UT_DOC (
556 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
557 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
558 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
559 p_is_online_val IN VARCHAR2,
560 x_result OUT NOCOPY NUMBER);
561
562 PROCEDURE SE_EFT_POSTGIRO_INLAND_DOC (
563 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
564 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
565 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
566 p_is_online_val IN VARCHAR2,
567 x_result OUT NOCOPY NUMBER);
568
569 PROCEDURE SE_EFT_POSTGIRO_UTLAND_DOC (
570 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
571 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
572 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
573 p_is_online_val IN VARCHAR2,
574 x_result OUT NOCOPY NUMBER);
575
576 PROCEDURE CITI_GB_EFT_DOM_PAYEE (
577 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
578 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
579 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
580 p_is_online_val IN VARCHAR2,
581 x_result OUT NOCOPY NUMBER);
582
583 PROCEDURE CITI_GB_EFT_DOM_DOC (
584 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
585 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
586 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
587 p_is_online_val IN VARCHAR2,
588 x_result OUT NOCOPY NUMBER);
589
590 PROCEDURE P_CITI_GB_EFT_DOM_PMT (
591 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
592 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
593 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
594 p_is_online_val IN VARCHAR2,
595 x_result OUT NOCOPY NUMBER);
596
600 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
597 PROCEDURE US_NACHA_INTERNAL_BANK (
598 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
599 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
601 p_is_online_val IN VARCHAR2,
602 x_result OUT NOCOPY NUMBER);
603
604 PROCEDURE US_NACHA_PAYEE (
605 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
606 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
607 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
608 p_is_online_val IN VARCHAR2,
609 x_result OUT NOCOPY NUMBER);
610
611 /*--------------------------------------------------------------------
612 | NAME:
613 | US_NACHA_PAYEE_ACCOUNT
614 |
615 | PURPOSE:
616 | In order to make sure that the payee bank account exists
617 | while making the IAT payments.
618 |
619 | PARAMETERS:
620 | IN
621 |
622 |
623 | OUT
624 |
625 |
626 | RETURNS:
627 |
628 | NOTES:
629 |
630 *---------------------------------------------------------------------*/
631
632 PROCEDURE US_NACHA_PAYEE_ACCOUNT (
633 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
634 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
635 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
636 p_is_online_val IN VARCHAR2,
637 x_result OUT NOCOPY NUMBER);
638
639 PROCEDURE I_US_NACHA_INSTR (
640 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
641 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
642 p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.
643 payment_instruction_id%type,
644 p_is_online_val IN VARCHAR2,
645 x_result OUT NOCOPY NUMBER);
646
647
648 PROCEDURE IS_NOT_NULL (
649 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
650 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
651 p_transaction_id IN NUMBER,
652 p_is_online_val IN VARCHAR2,
653 x_result OUT NOCOPY NUMBER);
654
655 PROCEDURE IS_NULL (
656 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
657 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
658 p_transaction_id IN NUMBER,
659 p_is_online_val IN VARCHAR2,
660 x_result OUT NOCOPY NUMBER);
661
662 PROCEDURE VALIDATE_LENGTH (
663 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
664 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
665 p_transaction_id IN NUMBER,
666 p_is_online_val IN VARCHAR2,
667 x_result OUT NOCOPY NUMBER);
668
669 PROCEDURE DIGITS_ONLY (
670 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
671 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
672 p_transaction_id IN NUMBER,
673 p_is_online_val IN VARCHAR2,
674 x_result OUT NOCOPY NUMBER);
675
676 PROCEDURE IS_NUMERIC (
677 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
678 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
679 p_transaction_id IN NUMBER,
680 p_is_online_val IN VARCHAR2,
681 x_result OUT NOCOPY NUMBER);
682
683 PROCEDURE IS_STRING (
684 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
685 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
686 p_transaction_id IN NUMBER,
687 p_is_online_val IN VARCHAR2,
688 x_result OUT NOCOPY NUMBER);
689
690 PROCEDURE IS_NOT_STRING (
691 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
692 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
693 p_transaction_id IN NUMBER,
694 p_is_online_val IN VARCHAR2,
695 x_result OUT NOCOPY NUMBER);
696
700 p_transaction_id IN NUMBER,
697 PROCEDURE IN_SET (
698 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
699 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
701 p_is_online_val IN VARCHAR2,
702 x_result OUT NOCOPY NUMBER);
703
704 PROCEDURE NOT_IN_SET (
705 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
706 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
707 p_transaction_id IN NUMBER,
708 p_is_online_val IN VARCHAR2,
709 x_result OUT NOCOPY NUMBER);
710
711 PROCEDURE START_WITH (
712 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
713 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
714 p_transaction_id IN NUMBER,
715 p_is_online_val IN VARCHAR2,
716 x_result OUT NOCOPY NUMBER);
717
718 PROCEDURE NOT_START_WITH (
719 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
720 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
721 p_transaction_id IN NUMBER,
722 p_is_online_val IN VARCHAR2,
723 x_result OUT NOCOPY NUMBER);
724
725 PROCEDURE IS_IN_LOOKUP (
726 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
727 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
728 p_transaction_id IN NUMBER,
729 p_is_online_val IN VARCHAR2,
730 x_result OUT NOCOPY NUMBER);
731
732 PROCEDURE GREATER_THAN (
733 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
734 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
735 p_transaction_id IN NUMBER,
736 p_is_online_val IN VARCHAR2,
737 x_result OUT NOCOPY NUMBER);
738
739 PROCEDURE GREATER_THAN_EQUAL_TO (
740 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
741 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
742 p_transaction_id IN NUMBER,
743 p_is_online_val IN VARCHAR2,
744 x_result OUT NOCOPY NUMBER);
745
746 PROCEDURE LESS_THAN (
747 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
748 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
749 p_transaction_id IN NUMBER,
750 p_is_online_val IN VARCHAR2,
751 x_result OUT NOCOPY NUMBER);
752
753 PROCEDURE LESS_THAN_EQUAL_TO (
754 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
755 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
756 p_transaction_id IN NUMBER,
757 p_is_online_val IN VARCHAR2,
758 x_result OUT NOCOPY NUMBER);
759
760 PROCEDURE EQUAL_TO (
761 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
762 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
763 p_transaction_id IN NUMBER,
764 p_is_online_val IN VARCHAR2,
765 x_result OUT NOCOPY NUMBER);
766
767 PROCEDURE NOT_EQUAL_TO (
768 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
769 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
770 p_transaction_id IN NUMBER,
771 p_is_online_val IN VARCHAR2,
772 x_result OUT NOCOPY NUMBER);
773
774 PROCEDURE performCharacterValidation(
775 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.
776 validation_assignment_id%TYPE,
777 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
778 p_document_id IN IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,
779 p_is_online_val IN VARCHAR2,
780 x_result OUT NOCOPY NUMBER);
781
782 PROCEDURE print_debuginfo(p_module IN VARCHAR2,
783 p_debug_text IN VARCHAR2);
784
785 PROCEDURE VALIDATE_PAYEE_BIC(
786 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
787 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
788 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
789 p_is_online_val IN VARCHAR2,
790 x_result OUT NOCOPY NUMBER);
791
792 PROCEDURE VALIDATE_PAYEE_IBAN(
793 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
794 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
795 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
796 p_is_online_val IN VARCHAR2,
797 x_result OUT NOCOPY NUMBER);
798
799 PROCEDURE VALIDATE_BANK_CHARGE_BEARER(
800 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
801 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
802 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
803 p_is_online_val IN VARCHAR2,
804 x_result OUT NOCOPY NUMBER);
805
806 PROCEDURE VALIDATE_PAYER_IBAN(
807 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
808 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
809 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
810 p_is_online_val IN VARCHAR2,
811 x_result OUT NOCOPY NUMBER);
812
813 PROCEDURE VALIDATE_PAYER_ADDRESS(
817 p_is_online_val IN VARCHAR2,
814 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
815 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
816 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
818 x_result OUT NOCOPY NUMBER);
819
820
821 /*--------------------------------------------------------------------
822 | NAME:
823 | ECE_DOC
824 |
825 | PURPOSE:
826 | Transactional field validations for E-Commerce gateway format
827 | (EDI validations).
828 |
829 | PARAMETERS:
830 | IN
831 |
832 |
833 | OUT
834 |
835 |
836 | RETURNS:
837 |
838 | NOTES:
839 |
840 *---------------------------------------------------------------------*/
841 PROCEDURE ECE_DOC (
842 p_validation_assign_id IN
843 IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
844 p_validation_set_code IN
845 IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
846 p_document_id IN
847 IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
848 p_is_online_val IN VARCHAR2,
849 x_result OUT NOCOPY NUMBER
850 );
851
852 /*--------------------------------------------------------------------
853 | NAME:
854 | ECE_INTERNAL_BANK
855 |
856 | PURPOSE:
857 | Internal bank account validations for E-Commerce gateway format.
858 | (EDI validations).
859 |
860 | PARAMETERS:
861 | IN
862 |
863 |
864 | OUT
865 |
866 |
867 | RETURNS:
868 |
869 | NOTES:
870 |
871 *---------------------------------------------------------------------*/
872 PROCEDURE ECE_INTERNAL_BANK (
873 p_validation_assign_id IN
874 IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
875 p_validation_set_code IN
876 IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
877 p_document_id IN
878 IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
879 p_is_online_val IN VARCHAR2,
880 x_result OUT NOCOPY NUMBER
881 );
882
883 /*--------------------------------------------------------------------
884 | NAME:
885 | ECE_PAYEE
886 |
887 | PURPOSE:
888 | Payee validations for E-Commerce gateway format.
889 | (EDI validations).
890 |
891 | PARAMETERS:
892 | IN
893 |
894 |
895 | OUT
896 |
897 |
898 | RETURNS:
899 |
900 | NOTES:
901 |
902 *---------------------------------------------------------------------*/
903 PROCEDURE ECE_PAYEE (
904 p_validation_assign_id IN
905 IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
906 p_validation_set_code IN
907 IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
908 p_document_id IN
909 IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
910 p_is_online_val IN VARCHAR2,
911 x_result OUT NOCOPY NUMBER
912 );
913
914
915 /*--------------------------------------------------------------------
916 | NAME:
917 | VALIDATE_INT_BANK_ACC_CURR_IN
918 |
919 | PURPOSE:
920 | Validate whether Internal Bank Account currency exists in the
921 | parameter defined while assigning validation.
922 |
923 | PARAMETERS:
924 | IN
925 |
926 |
927 | OUT
928 |
929 |
930 | RETURNS:
931 |
932 | NOTES:
933 |
934 *---------------------------------------------------------------------*/
935 PROCEDURE VALIDATE_INT_BANK_ACC_CURR_IN (
936 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
937 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
938 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
939 p_is_online_val IN VARCHAR2,
940 x_result OUT NOCOPY NUMBER
941 );
942
943
944 /*--------------------------------------------------------------------
945 | NAME:
946 | VALIDATE_DEL_CHN_FORMAT_VALUE
947 |
948 | PURPOSE:
949 | Validate whether delivery channel format value exists in the
950 | parameter defined while assigning validation.
951 |
952 | PARAMETERS:
953 | IN
954 |
955 |
956 | OUT
957 |
958 |
959 | RETURNS:
960 |
961 | NOTES:
962 |
963 *---------------------------------------------------------------------*/
964 PROCEDURE VALIDATE_DEL_CHN_FORMAT_VALUE (
965 p_validation_assign_id IN
966 IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
967 p_validation_set_code IN
968 IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
969 p_document_id IN
970 IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
971 p_is_online_val IN VARCHAR2,
972 x_result OUT NOCOPY NUMBER
973 );
974
975 /*--------------------------------------------------------------------
976 | NAME:
977 | VALIDATE_MAX_PAYMENT_AMOUNT
978 |
979 | PURPOSE:
980 | Validates the payment amount against the maximum limit defined
981 | with parameter while assigning validation.
982 |
983 | PARAMETERS:
984 | IN
985 |
986 |
987 | OUT
988 |
989 |
990 | RETURNS:
991 |
992 | NOTES:
993 |
994 *---------------------------------------------------------------------*/
995 PROCEDURE VALIDATE_MAX_PAYMENT_AMOUNT (
996 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
997 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
998 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
999 p_is_online_val IN VARCHAR2,
1000 x_result OUT NOCOPY NUMBER
1001 );
1002
1003 /*--------------------------------------------------------------------
1004 | NAME:
1005 | VALIDATE_DOC_PMT_CURR
1006 |
1007 | PURPOSE:
1008 | Validate whether document payment currency exists in the
1009 | parameter defined while assigning validation.
1010 |
1011 | PARAMETERS:
1012 | IN
1013 |
1014 |
1015 | OUT
1016 |
1017 |
1018 | RETURNS:
1019 |
1020 | NOTES:
1021 |
1022 *---------------------------------------------------------------------*/
1023 PROCEDURE VALIDATE_DOC_PMT_CURR (
1024 p_validation_assign_id IN
1025 IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1026 p_validation_set_code IN
1027 IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
1028 p_document_id IN
1029 IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1030 p_is_online_val IN VARCHAR2,
1031 x_result OUT NOCOPY NUMBER
1032 );
1033
1034
1035 /*--------------------------------------------------------------------
1036 | NAME:
1037 | VALIDATE_PAYEE_BRC_COUNTRY_IN
1038 |
1039 | PURPOSE:
1040 | Validate whether payee branch country exists in the list of
1041 | values given with the parameter while assigning validation.
1042 |
1043 | PARAMETERS:
1044 | IN
1045 |
1046 |
1047 | OUT
1048 |
1049 |
1050 | RETURNS:
1051 |
1052 | NOTES:
1053 |
1054 *---------------------------------------------------------------------*/
1055 PROCEDURE VALIDATE_PAYEE_BRC_COUNTRY_IN (
1056 p_validation_assign_id IN
1057 IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1058 p_validation_set_code IN
1059 IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
1060 p_document_id IN
1061 IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1062 p_is_online_val IN VARCHAR2,
1063 x_result OUT NOCOPY NUMBER
1064 );
1065
1066 /*--------------------------------------------------------------------
1067 | NAME:
1068 | VALIDATE_DEL_CHN_NOT_IN
1069 |
1070 | PURPOSE:
1071 | Validates whether delivery channel format value doesnt exists in
1072 | the list of values with the parameter while assigning validation.
1073 |
1074 | PARAMETERS:
1075 | IN
1076 |
1077 |
1078 | OUT
1079 |
1080 |
1081 | RETURNS:
1082 |
1083 | NOTES:
1084 |
1085 *---------------------------------------------------------------------*/
1086 PROCEDURE VALIDATE_DEL_CHN_NOT_IN (
1087 p_validation_assign_id IN
1088 IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1089 p_validation_set_code IN
1090 IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
1091 p_document_id IN
1092 IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1093 p_is_online_val IN VARCHAR2,
1094 x_result OUT NOCOPY NUMBER
1095 );
1096
1097 /*--------------------------------------------------------------------
1098 | NAME:
1099 | VALIDATE_FIN_URI
1100 |
1101 | PURPOSE:
1102 | Validates the combination of URI and URI check digit for Finland
1103 |
1104 | PARAMETERS:
1105 | IN
1106 |
1107 |
1108 | OUT
1109 |
1110 |
1111 | RETURNS:
1112 |
1113 | NOTES:
1114 |
1115 *---------------------------------------------------------------------*/
1116 PROCEDURE VALIDATE_FIN_URI (
1117 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1118 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
1119 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1120 p_is_online_val IN VARCHAR2,
1121 x_result OUT NOCOPY NUMBER);
1122
1123
1124 FUNCTION FIN_URI_CHECK_DIGIT_VAL( uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1125 uri_check_digit IBY_DOCS_PAYABLE_ALL.URI_CHECK_DIGIT%TYPE)
1126 RETURN BOOLEAN;
1127
1128 /*SEPA Credit Transfer 3.3 */
1129
1130 PROCEDURE VALIDATE_PAYER_LEGAL_ENTITY_ID(
1131 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1132 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1133 p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
1134 p_is_online_val IN VARCHAR2,
1135 x_result OUT NOCOPY NUMBER);
1136
1137 PROCEDURE VALIDATE_INV_LEGAL_ENTITY_ID(
1138 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1139 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%type,
1140 p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1141 p_is_online_val IN VARCHAR2,
1142 x_result OUT NOCOPY NUMBER);
1143
1144 PROCEDURE PAYMENT_COMPLETION_VALIDATION (
1145 p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.validation_assignment_id%TYPE,
1146 p_validation_set_code IN IBY_VALIDATION_SETS_VL.validation_set_code%TYPE,
1147 p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%type,
1148 p_is_online_val IN VARCHAR2,
1149 x_result OUT NOCOPY NUMBER);
1150 END IBY_VALIDATIONSETS_CALLS_PUB;