1 PACKAGE hz_bank_pub AUTHID CURRENT_USER AS
2 /*$Header: ARHBKASS.pls 120.3 2006/02/15 00:07:27 jhuang noship $ */
3 TYPE bank_rec_type IS RECORD (
4 bank_or_branch_number VARCHAR2(60),
5 bank_code VARCHAR2(30),
6 branch_code VARCHAR2(30),
7 institution_type VARCHAR2(30),
8 branch_type VARCHAR2(30),
9 country VARCHAR2(30),
10 rfc_code VARCHAR2(30),
11 inactive_date DATE,
12 organization_rec hz_party_v2pub.organization_rec_type :=
13 hz_party_v2pub.g_miss_organization_rec
14 );
15
16 g_miss_bank_rec bank_rec_type;
17
18 /*=======================================================================+
19 | PUBLIC PROCEDURE create_bank |
20 | |
21 | DESCRIPTION |
22 | Create a code assignment for the bank organization. |
23 | |
24 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
25 | hz_utility_v2pub.debug |
26 | hz_party_v2pub.create_organization |
27 | hz_organization_profiles_pkg.update_row |
28 | |
29 | ARGUMENTS |
30 | IN: |
31 | p_init_msg_list Initialize message stack if it is set to |
32 | FND_API.G_TRUE. Default is fnd_api.g_false. |
33 | p_bank_rec Bank record. |
34 | IN/OUT: |
35 | OUT: |
36 | x_party_id Party ID for the bank. |
37 | x_party_number Party number for the bank. |
38 | x_profile_id Organization profile ID for the bank. |
39 | x_code_assignment_id The code assignment ID for the bank |
40 | classification. |
41 | x_return_status Return status after the call. The status can |
42 | be FND_API.G_RET_STS_SUCCESS (success), |
43 | fnd_api.g_ret_sts_error (error), |
44 | fnd_api.g_ret_sts_unexp_error (unexpected |
45 | error). |
46 | x_msg_count Number of messages in message stack. |
47 | x_msg_data Message text if x_msg_count is 1. |
48 | MODIFICATION HISTORY |
49 | 27-NOV-2001 J. del Callar Created. |
50 +=======================================================================*/
51 PROCEDURE create_bank (
52 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
53 p_bank_rec IN bank_rec_type,
54 x_party_id OUT NOCOPY NUMBER,
55 x_party_number OUT NOCOPY VARCHAR2,
56 x_profile_id OUT NOCOPY NUMBER,
57 x_code_assignment_id OUT NOCOPY NUMBER,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2
61 );
62
63 /*=======================================================================+
64 | PUBLIC PROCEDURE update_bank |
65 | |
66 | DESCRIPTION |
67 | Update a bank organization and update its type if the type was |
68 | specified. |
69 | |
70 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
71 | hz_utility_v2pub.debug |
72 | hz_party_v2pub.update_organization |
73 | hz_organization_profiles_pkg.update_row |
74 | |
75 | ARGUMENTS |
76 | IN: |
77 | p_init_msg_list Initialize message stack if it is |
78 | set to FND_API.G_TRUE. Default is |
79 | fnd_api.g_false. |
80 | p_bank_rec Bank record. |
81 | IN/OUT: |
82 | x_pobject_version_number New version number for the bank. |
83 | x_bitobject_version_number New version number for the code |
84 | assignment for the bank type. |
85 | OUT: |
86 | x_profile_id New organization profile ID for |
87 | the updated bank. |
88 | x_return_status Return status after the call. The |
89 | status can be |
90 | FND_API.G_RET_STS_SUCCESS |
91 | (success), fnd_api.g_ret_sts_error |
92 | (error), |
93 | fnd_api.g_ret_sts_unexp_error |
94 | (unexpected error). |
95 | x_msg_count Number of messages in message |
96 | stack. |
97 | x_msg_data Message text if x_msg_count is 1. |
98 | MODIFICATION HISTORY |
99 | 27-NOV-2001 J. del Callar Created. |
100 +=======================================================================*/
101 PROCEDURE update_bank (
102 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
103 p_bank_rec IN bank_rec_type,
104 p_pobject_version_number IN OUT NOCOPY NUMBER,
105 p_bitobject_version_number IN OUT NOCOPY NUMBER,
106 x_profile_id OUT NOCOPY NUMBER,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2
110 );
111
112 /*=======================================================================+
113 | PUBLIC PROCEDURE create_bank_branch |
114 | |
115 | DESCRIPTION |
116 | Create a bank branch organization. |
117 | |
118 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
119 | hz_utility_v2pub.debug |
120 | hz_party_v2pub.create_organization |
121 | |
122 | ARGUMENTS |
123 | IN: |
124 | p_init_msg_list Initialize message stack if it is set to |
125 | FND_API.G_TRUE. Default is fnd_api.g_false. |
126 | p_bank_rec Bank record. |
127 | p_bank_party_id Party ID of the parent bank. NULL if the |
128 | parent bank is not going to be reassigned. |
129 | IN/OUT: |
130 | OUT: |
131 | x_party_id Party ID for the bank branch. |
132 | x_party_number Party number for the bank branch. |
133 | x_profile_id Organization profile ID for the bank branch. |
134 | x_relationship_id ID for the relationship between the branch |
135 | and its parent bank. |
136 | x_rel_party_id ID for party relationship created. |
137 | x_rel_party_number Number for the party relationship created. |
138 | x_bitcode_assignment_id The code assignment ID for the bank org |
139 | classification as a BRANCH. |
140 | x_bbtcode_assignment_id The code assignment ID for the type of |
141 | bank branch. |
142 | x_rfccode_assignment_id The code assignment ID for the Regional |
143 | Finance Center used by the bank branch. |
144 | x_return_status Return status after the call. The status can |
145 | be FND_API.G_RET_STS_SUCCESS (success), |
146 | fnd_api.g_ret_sts_error (error), |
147 | fnd_api.g_ret_sts_unexp_error (unexpected |
148 | error). |
149 | x_msg_count Number of messages in message stack. |
150 | x_msg_data Message text if x_msg_count is 1. |
151 | MODIFICATION HISTORY |
152 | 27-NOV-2001 J. del Callar Created. |
153 | 06-MAY-2002 J. del Callar Added support for RFCs. |
154 +=======================================================================*/
155 PROCEDURE create_bank_branch (
156 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
157 p_bank_rec IN bank_rec_type,
158 p_bank_party_id IN NUMBER,
159 x_party_id OUT NOCOPY NUMBER,
160 x_party_number OUT NOCOPY VARCHAR2,
161 x_profile_id OUT NOCOPY NUMBER,
162 x_relationship_id OUT NOCOPY NUMBER,
163 x_rel_party_id OUT NOCOPY NUMBER,
164 x_rel_party_number OUT NOCOPY NUMBER,
165 x_bitcode_assignment_id OUT NOCOPY NUMBER,
166 x_bbtcode_assignment_id OUT NOCOPY NUMBER,
167 x_rfccode_assignment_id OUT NOCOPY NUMBER,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2
171 );
172
173 /*=======================================================================+
174 | PUBLIC PROCEDURE update_bank_branch |
175 | |
176 | DESCRIPTION |
177 | Update a bank branch organization. |
178 | |
179 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
180 | hz_utility_v2pub.debug |
181 | hz_party_v2pub.update_organization |
182 | |
183 | ARGUMENTS |
184 | IN: |
185 | p_init_msg_list Initialize message stack if it is set to |
186 | FND_API.G_TRUE. Default is fnd_api.g_false. |
187 | p_bank_rec Bank record. |
188 | p_relationship_id ID for relationship between bank branch and |
189 | its parent bank. NULL if the parent bank is |
190 | not going to be reassigned. |
191 | p_bank_party_id Party ID of the parent bank. NULL if the |
192 | parent bank is not going to be reassigned. |
193 | IN/OUT: |
194 | p_pobject_version_number New version number for the bank |
195 | branch party. |
196 | p_bbtobject_version_number New version number for the bank |
197 | branch type code assignment. |
198 | p_rfcobject_version_number New version number for the Regional|
199 | Finance Center code assignment. |
200 | OUT: |
201 | x_profile_id Organization profile ID for the bank branch. |
202 | x_rel_party_id ID for party relationship created. |
203 | x_rel_party_number Number for the party relationship created. |
204 | x_return_status Return status after the call. The status can |
205 | be FND_API.G_RET_STS_SUCCESS (success), |
206 | fnd_api.g_ret_sts_error (error), |
207 | fnd_api.g_ret_sts_unexp_error (unexpected |
208 | error). |
209 | x_msg_count Number of messages in message stack. |
210 | x_msg_data Message text if x_msg_count is 1. |
211 | MODIFICATION HISTORY |
212 | 27-NOV-2001 J. del Callar Created. |
213 | 06-MAY-2002 J. del Callar Added support for RFCs. |
214 +=======================================================================*/
215 PROCEDURE update_bank_branch (
216 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
217 p_bank_rec IN bank_rec_type,
218 p_bank_party_id IN NUMBER := NULL,
219 p_relationship_id IN OUT NOCOPY NUMBER,
220 p_pobject_version_number IN OUT NOCOPY NUMBER,
221 p_bbtobject_version_number IN OUT NOCOPY NUMBER,
222 p_rfcobject_version_number IN OUT NOCOPY NUMBER,
223 x_profile_id OUT NOCOPY NUMBER,
224 x_rel_party_id OUT NOCOPY NUMBER,
225 x_rel_party_number OUT NOCOPY NUMBER,
226 x_return_status OUT NOCOPY VARCHAR2,
230
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2
229 );
231 /*=======================================================================+
232 | PUBLIC PROCEDURE create_banking_group |
233 | |
234 | DESCRIPTION |
235 | Create a banking group. |
236 | |
237 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
238 | hz_utility_v2pub.debug |
239 | hz_party_v2pub.create_group |
240 | |
241 | ARGUMENTS |
242 | IN: |
243 | p_init_msg_list Initialize message stack if it is set to |
244 | FND_API.G_TRUE. Default is fnd_api.g_false. |
245 | p_group_rec Group record for the banking group. |
246 | IN/OUT: |
247 | OUT: |
248 | x_party_id Party ID for the banking group created. |
249 | x_party_number Party number for banking group created. |
250 | x_return_status Return status after the call. The status can |
251 | be FND_API.G_RET_STS_SUCCESS (success), |
252 | fnd_api.g_ret_sts_error (error), |
253 | fnd_api.g_ret_sts_unexp_error (unexpected |
254 | error). |
255 | x_msg_count Number of messages in message stack. |
256 | x_msg_data Message text if x_msg_count is 1. |
257 | MODIFICATION HISTORY |
258 | 27-NOV-2001 J. del Callar Created. |
259 +=======================================================================*/
260 PROCEDURE create_banking_group (
261 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
262 p_group_rec IN hz_party_v2pub.group_rec_type,
263 x_party_id OUT NOCOPY NUMBER,
264 x_party_number OUT NOCOPY VARCHAR2,
265 x_return_status OUT NOCOPY VARCHAR2,
266 x_msg_count OUT NOCOPY NUMBER,
267 x_msg_data OUT NOCOPY VARCHAR2
268 );
269
270 /*=======================================================================+
271 | PUBLIC PROCEDURE update_banking_group |
272 | |
273 | DESCRIPTION |
274 | Update a banking group. |
275 | |
276 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
277 | hz_utility_v2pub.debug |
278 | hz_party_v2pub.update_group |
279 | |
280 | ARGUMENTS |
281 | IN: |
282 | p_init_msg_list Initialize message stack if it is set to |
283 | FND_API.G_TRUE. Default is fnd_api.g_false. |
284 | p_group_rec Group record for the banking group. |
285 | IN/OUT: |
286 | p_pobject_version_number Version number for the banking group |
287 | party that was created. |
288 | OUT: |
289 | x_return_status Return status after the call. The status can |
290 | be FND_API.G_RET_STS_SUCCESS (success), |
291 | fnd_api.g_ret_sts_error (error), |
292 | fnd_api.g_ret_sts_unexp_error (unexpected |
293 | error). |
294 | x_msg_count Number of messages in message stack. |
295 | x_msg_data Message text if x_msg_count is 1. |
296 | MODIFICATION HISTORY |
297 | 27-NOV-2001 J. del Callar Created. |
298 +=======================================================================*/
299 PROCEDURE update_banking_group (
300 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
301 p_group_rec IN hz_party_v2pub.group_rec_type,
302 p_pobject_version_number IN OUT NOCOPY NUMBER,
303 x_return_status OUT NOCOPY VARCHAR2,
304 x_msg_count OUT NOCOPY NUMBER,
305 x_msg_data OUT NOCOPY VARCHAR2
306 );
307
308 /*=======================================================================+
309 | PUBLIC PROCEDURE create_bank_group_member |
310 | |
314 | |
311 | DESCRIPTION |
312 | Create a member relationship for a bank organization to a banking |
313 | group. |
315 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
316 | hz_utility_v2pub.debug |
317 | hz_party_v2pub.create_group |
318 | |
319 | ARGUMENTS |
320 | IN: |
321 | p_init_msg_list Initialize message stack if it is set to |
322 | FND_API.G_TRUE. Default is fnd_api.g_false. |
323 | p_relationship_rec Relationship record for the banking group |
324 | membership. |
325 | IN/OUT: |
326 | OUT: |
327 | x_relationship_id ID for the relationship record created. |
328 | x_party_id ID for the party created for the |
329 | relationship. |
330 | x_party_number Party number for the party created for the |
331 | relationship. |
332 | x_return_status Return status after the call. The status can |
333 | be FND_API.G_RET_STS_SUCCESS (success), |
334 | fnd_api.g_ret_sts_error (error), |
335 | fnd_api.g_ret_sts_unexp_error (unexpected |
336 | error). |
337 | x_msg_count Number of messages in message stack. |
338 | x_msg_data Message text if x_msg_count is 1. |
339 | MODIFICATION HISTORY |
340 | 27-NOV-2001 J. del Callar Created. |
341 +=======================================================================*/
342 PROCEDURE create_bank_group_member (
343 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
344 p_relationship_rec IN hz_relationship_v2pub.relationship_rec_type,
345 x_relationship_id OUT NOCOPY NUMBER,
346 x_party_id OUT NOCOPY NUMBER,
347 x_party_number OUT NOCOPY NUMBER,
348 x_return_status OUT NOCOPY VARCHAR2,
349 x_msg_count OUT NOCOPY NUMBER,
350 x_msg_data OUT NOCOPY VARCHAR2
351 );
352
353 /*=======================================================================+
354 | PUBLIC PROCEDURE update_bank_group_member |
355 | |
356 | DESCRIPTION |
357 | Update a member relationship for a bank organization to a banking |
358 | group. |
359 | |
360 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
361 | hz_utility_v2pub.debug |
362 | hz_party_v2pub.update_group |
363 | |
364 | ARGUMENTS |
365 | IN: |
366 | p_init_msg_list Initialize message stack if it is set to |
367 | FND_API.G_TRUE. Default is fnd_api.g_false. |
368 | p_relationship_rec Relationship record for the banking group |
369 | membership. |
370 | IN/OUT: |
371 | p_robject_version_number New version number for the banking |
372 | group membership relationship. |
373 | p_pobject_version_number New version number for the banking |
374 | group membership rel party. |
375 | OUT: |
376 | x_return_status Return status after the call. The status can |
377 | be FND_API.G_RET_STS_SUCCESS (success), |
378 | fnd_api.g_ret_sts_error (error), |
379 | fnd_api.g_ret_sts_unexp_error (unexpected |
380 | error). |
381 | x_msg_count Number of messages in message stack. |
382 | x_msg_data Message text if x_msg_count is 1. |
383 | MODIFICATION HISTORY |
384 | 27-NOV-2001 J. del Callar Updated. |
385 +=======================================================================*/
386 PROCEDURE update_bank_group_member (
387 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
388 p_relationship_rec IN hz_relationship_v2pub.relationship_rec_type,
389 p_robject_version_number IN OUT NOCOPY NUMBER,
390 p_pobject_version_number IN OUT NOCOPY NUMBER,
394 );
391 x_return_status OUT NOCOPY VARCHAR2,
392 x_msg_count OUT NOCOPY NUMBER,
393 x_msg_data OUT NOCOPY VARCHAR2
395
396 /*=======================================================================+
397 | PUBLIC PROCEDURE create_clearinghouse_assign |
398 | |
399 | DESCRIPTION |
400 | Assign a bank to a clearinghouse by creating a relationship. |
401 | |
402 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
403 | hz_utility_v2pub.debug |
404 | hz_party_v2pub.create_group |
405 | |
406 | ARGUMENTS |
407 | IN: |
408 | p_init_msg_list Initialize message stack if it is set to |
409 | FND_API.G_TRUE. Default is fnd_api.g_false. |
410 | p_relationship_rec Relationship record for the clearinghouse |
411 | assignment. |
412 | IN/OUT: |
413 | OUT: |
414 | x_relationship_id ID for the relationship record created. |
415 | x_party_id ID for the party created for the |
416 | relationship. |
417 | x_party_number Party number for the party created for the |
418 | relationship. |
419 | x_return_status Return status after the call. The status can |
420 | be FND_API.G_RET_STS_SUCCESS (success), |
421 | fnd_api.g_ret_sts_error (error), |
422 | fnd_api.g_ret_sts_unexp_error (unexpected |
423 | error). |
424 | x_msg_count Number of messages in message stack. |
425 | x_msg_data Message text if x_msg_count is 1. |
426 | MODIFICATION HISTORY |
427 | 27-NOV-2001 J. del Callar Created. |
428 +=======================================================================*/
429 PROCEDURE create_clearinghouse_assign (
430 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
431 p_relationship_rec IN hz_relationship_v2pub.relationship_rec_type,
432 x_relationship_id OUT NOCOPY NUMBER,
433 x_party_id OUT NOCOPY NUMBER,
434 x_party_number OUT NOCOPY NUMBER,
435 x_return_status OUT NOCOPY VARCHAR2,
436 x_msg_count OUT NOCOPY NUMBER,
437 x_msg_data OUT NOCOPY VARCHAR2
438 );
439
440 /*=======================================================================+
441 | PUBLIC PROCEDURE update_clearinghouse_assign |
442 | |
443 | DESCRIPTION |
444 | Update a relationship that assigns a bank to a clearinghouse. |
445 | |
446 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
447 | hz_utility_v2pub.debug |
448 | hz_party_v2pub.update_group |
449 | |
450 | ARGUMENTS |
451 | IN: |
452 | p_init_msg_list Initialize message stack if it is set to |
453 | FND_API.G_TRUE. Default is fnd_api.g_false. |
454 | p_relationship_rec Relationship record for the clearinghouse |
455 | assignment. |
456 | IN/OUT: |
457 | p_robject_version_number New version number for the banking |
458 | group membership relationship. |
459 | p_pobject_version_number New version number for the banking |
460 | group membership rel party. |
461 | OUT: |
462 | x_return_status Return status after the call. The status can |
463 | be FND_API.G_RET_STS_SUCCESS (success), |
464 | fnd_api.g_ret_sts_error (error), |
465 | fnd_api.g_ret_sts_unexp_error (unexpected |
466 | error). |
467 | x_msg_count Number of messages in message stack. |
468 | x_msg_data Message text if x_msg_count is 1. |
469 | MODIFICATION HISTORY |
470 | 27-NOV-2001 J. del Callar Updated. |
471 +=======================================================================*/
472 PROCEDURE update_clearinghouse_assign (
476 p_pobject_version_number IN OUT NOCOPY NUMBER,
473 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
474 p_relationship_rec IN hz_relationship_v2pub.relationship_rec_type,
475 p_robject_version_number IN OUT NOCOPY NUMBER,
477 x_return_status OUT NOCOPY VARCHAR2,
478 x_msg_count OUT NOCOPY NUMBER,
479 x_msg_data OUT NOCOPY VARCHAR2
480 );
481
482 /*=======================================================================+
483 | PUBLIC PROCEDURE create_bank_site |
484 | |
485 | DESCRIPTION |
486 | Create a party site for a bank-type organization. |
487 | |
488 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
489 | hz_utility_v2pub.debug |
490 | hz_party_v2pub.create_group |
491 | |
492 | ARGUMENTS |
493 | IN: |
494 | p_init_msg_list Initialize message stack if it is set to |
495 | FND_API.G_TRUE. Default is fnd_api.g_false. |
496 | p_party_site_rec Party site record for the bank organization. |
497 | IN/OUT: |
498 | OUT: |
499 | x_party_site_id ID for the party site created. |
500 | x_party_site_number Party site number for the bank site |
501 | created. |
502 | x_return_status Return status after the call. The status can |
503 | be FND_API.G_RET_STS_SUCCESS (success), |
504 | fnd_api.g_ret_sts_error (error), |
505 | fnd_api.g_ret_sts_unexp_error (unexpected |
506 | error). |
507 | x_msg_count Number of messages in message stack. |
508 | x_msg_data Message text if x_msg_count is 1. |
509 | MODIFICATION HISTORY |
510 | 27-NOV-2001 J. del Callar Created. |
511 +=======================================================================*/
512 PROCEDURE create_bank_site (
513 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
514 p_party_site_rec IN hz_party_site_v2pub.party_site_rec_type,
515 x_party_site_id OUT NOCOPY NUMBER,
516 x_party_site_number OUT NOCOPY NUMBER,
517 x_return_status OUT NOCOPY VARCHAR2,
518 x_msg_count OUT NOCOPY NUMBER,
519 x_msg_data OUT NOCOPY VARCHAR2
520 );
521
522 /*=======================================================================+
523 | PUBLIC PROCEDURE update_bank_site |
524 | |
525 | DESCRIPTION |
526 | Update a party site for a bank-type organization. |
527 | |
528 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
529 | hz_utility_v2pub.debug |
530 | hz_party_v2pub.update_group |
531 | |
532 | ARGUMENTS |
533 | IN: |
534 | p_init_msg_list Initialize message stack if it is set to |
535 | FND_API.G_TRUE. Default is fnd_api.g_false. |
536 | p_party_site_rec Party site record for the bank organization. |
537 | IN/OUT: |
538 | x_psobject_version_number Party site version number for the |
539 | updated bank site. |
540 | OUT: |
541 | x_return_status Return status after the call. The status can |
542 | be FND_API.G_RET_STS_SUCCESS (success), |
543 | fnd_api.g_ret_sts_error (error), |
544 | fnd_api.g_ret_sts_unexp_error (unexpected |
545 | error). |
546 | x_msg_count Number of messages in message stack. |
547 | x_msg_data Message text if x_msg_count is 1. |
548 | MODIFICATION HISTORY |
549 | 27-NOV-2001 J. del Callar Updated. |
550 +=======================================================================*/
551 PROCEDURE update_bank_site (
552 p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
553 p_party_site_rec IN hz_party_site_v2pub.party_site_rec_type,
554 p_psobject_version_number IN OUT NOCOPY NUMBER,
555 x_return_status OUT NOCOPY VARCHAR2,
559
556 x_msg_count OUT NOCOPY NUMBER,
557 x_msg_data OUT NOCOPY VARCHAR2
558 );
560 /*=======================================================================+
561 | PUBLIC PROCEDURE create_edi_contact_point |
562 | |
563 | DESCRIPTION |
564 | Creates an EDI contact point. |
565 | |
566 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
567 | hz_utility_v2pub.debug |
568 | hz_party_v2pub.create_edi_contact_point |
569 | |
570 | ARGUMENTS |
571 | IN: |
572 | p_init_msg_list Initialize message stack if it is set to |
573 | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
574 | p_contact_point_rec Contact point record. |
575 | p_edi_rec EDI record. |
576 | IN/OUT: |
577 | OUT: |
578 | x_contact_point_id ID of the contact point created. |
579 | x_party_number Party number for the party created for the |
580 | relationship. |
581 | x_return_status Return status after the call. The status can |
582 | be FND_API.G_RET_STS_SUCCESS (success), |
583 | fnd_api.g_ret_sts_error (error), |
584 | fnd_api.g_ret_sts_unexp_error (unexpected |
585 | error). |
586 | x_msg_count Number of messages in message stack. |
587 | x_msg_data Message text if x_msg_count is 1. |
588 | MODIFICATION HISTORY |
589 | 27-APR-2002 J. del Callar Bug 2238144: Created. |
590 +=======================================================================*/
591 PROCEDURE create_edi_contact_point (
592 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
593 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
594 p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
595 := hz_contact_point_v2pub.g_miss_edi_rec,
596 x_contact_point_id OUT NOCOPY NUMBER,
597 x_return_status OUT NOCOPY VARCHAR2,
598 x_msg_count OUT NOCOPY NUMBER,
599 x_msg_data OUT NOCOPY VARCHAR2
600 );
601
602 /*=======================================================================+
603 | PUBLIC PROCEDURE update_edi_contact_point |
604 | |
605 | DESCRIPTION |
606 | Updates an EDI contact point. |
607 | |
608 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
609 | hz_utility_v2pub.debug |
610 | hz_party_v2pub.update_edi_contact_point |
611 | |
612 | ARGUMENTS |
613 | IN: |
614 | p_init_msg_list Initialize message stack if it is set to |
615 | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
616 | p_contact_point_rec Contact point record. |
617 | p_edi_rec EDI record. |
618 | IN/OUT: |
619 | p_object_version_number Used to lock the record being updated. |
620 | OUT: |
621 | x_party_number Party number for the party created for the |
622 | relationship. |
623 | x_return_status Return status after the call. The status can |
624 | be FND_API.G_RET_STS_SUCCESS (success), |
625 | fnd_api.g_ret_sts_error (error), |
626 | fnd_api.g_ret_sts_unexp_error (unexpected |
627 | error). |
628 | x_msg_count Number of messages in message stack. |
629 | x_msg_data Message text if x_msg_count is 1. |
630 | MODIFICATION HISTORY |
631 | 27-APR-2002 J. del Callar Bug 2238144: Created. |
632 +=======================================================================*/
633 PROCEDURE update_edi_contact_point (
634 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
635 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
636 p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
640 x_msg_count OUT NOCOPY NUMBER,
637 := hz_contact_point_v2pub.g_miss_edi_rec,
638 p_object_version_number IN OUT NOCOPY NUMBER,
639 x_return_status OUT NOCOPY VARCHAR2,
641 x_msg_data OUT NOCOPY VARCHAR2
642 );
643
644 /*=======================================================================+
645 | PUBLIC PROCEDURE create_eft_contact_point |
646 | |
647 | DESCRIPTION |
648 | Creates an EFT contact point. |
649 | |
650 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
651 | hz_utility_v2pub.debug |
652 | hz_party_v2pub.create_eft_contact_point |
653 | |
654 | ARGUMENTS |
655 | IN: |
656 | p_init_msg_list Initialize message stack if it is set to |
657 | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
658 | p_contact_point_rec Contact point record. |
659 | p_eft_rec EFT record. |
660 | IN/OUT: |
661 | OUT: |
662 | x_contact_point_id ID of the contact point created. |
663 | x_party_number Party number for the party created for the |
664 | relationship. |
665 | x_return_status Return status after the call. The status can |
666 | be FND_API.G_RET_STS_SUCCESS (success), |
667 | fnd_api.g_ret_sts_error (error), |
668 | fnd_api.g_ret_sts_unexp_error (unexpected |
669 | error). |
670 | x_msg_count Number of messages in message stack. |
671 | x_msg_data Message text if x_msg_count is 1. |
672 | MODIFICATION HISTORY |
673 | 27-APR-2002 J. del Callar Bug 2238144: Created. |
674 +=======================================================================*/
675 PROCEDURE create_eft_contact_point (
676 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
677 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
678 p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
679 := hz_contact_point_v2pub.g_miss_eft_rec,
680 x_contact_point_id OUT NOCOPY NUMBER,
681 x_return_status OUT NOCOPY VARCHAR2,
682 x_msg_count OUT NOCOPY NUMBER,
683 x_msg_data OUT NOCOPY VARCHAR2
684 );
685
686 /*=======================================================================+
687 | PUBLIC PROCEDURE update_eft_contact_point |
688 | |
689 | DESCRIPTION |
690 | Updates an EFT contact point. |
691 | |
692 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
693 | hz_utility_v2pub.debug |
694 | hz_party_v2pub.update_eft_contact_point |
695 | |
696 | ARGUMENTS |
697 | IN: |
698 | p_init_msg_list Initialize message stack if it is set to |
699 | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
700 | p_contact_point_rec Contact point record. |
701 | p_eft_rec EFT record. |
702 | IN/OUT: |
703 | p_object_version_number Used to lock the record being updated. |
704 | OUT: |
705 | x_party_number Party number for the party created for the |
706 | relationship. |
707 | x_return_status Return status after the call. The status can |
708 | be FND_API.G_RET_STS_SUCCESS (success), |
709 | fnd_api.g_ret_sts_error (error), |
710 | fnd_api.g_ret_sts_unexp_error (unexpected |
711 | error). |
712 | x_msg_count Number of messages in message stack. |
713 | x_msg_data Message text if x_msg_count is 1. |
714 | MODIFICATION HISTORY |
715 | 27-APR-2002 J. del Callar Bug 2238144: Created. |
716 +=======================================================================*/
717 PROCEDURE update_eft_contact_point (
718 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
722 p_object_version_number IN OUT NOCOPY NUMBER,
719 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
720 p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
721 := hz_contact_point_v2pub.g_miss_eft_rec,
723 x_return_status OUT NOCOPY VARCHAR2,
724 x_msg_count OUT NOCOPY NUMBER,
725 x_msg_data OUT NOCOPY VARCHAR2
726 );
727
728 /*=======================================================================+
729 | PUBLIC PROCEDURE create_web_contact_point |
730 | |
731 | DESCRIPTION |
732 | Creates a Web contact point. |
733 | |
734 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
735 | hz_utility_v2pub.debug |
736 | hz_party_v2pub.create_web_contact_point |
737 | |
738 | ARGUMENTS |
739 | IN: |
740 | p_init_msg_list Initialize message stack if it is set to |
741 | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
742 | p_contact_point_rec Contact point record. |
743 | p_web_rec WEB record. |
744 | IN/OUT: |
745 | OUT: |
746 | x_contact_point_id ID of the contact point created. |
747 | x_party_number Party number for the party created for the |
748 | relationship. |
749 | x_return_status Return status after the call. The status can |
750 | be FND_API.G_RET_STS_SUCCESS (success), |
751 | fnd_api.g_ret_sts_error (error), |
752 | fnd_api.g_ret_sts_unexp_error (unexpected |
753 | error). |
754 | x_msg_count Number of messages in message stack. |
755 | x_msg_data Message text if x_msg_count is 1. |
756 | MODIFICATION HISTORY |
757 | 27-APR-2002 J. del Callar Bug 2238144: Created. |
758 +=======================================================================*/
759 PROCEDURE create_web_contact_point (
760 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
761 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
762 p_web_rec IN hz_contact_point_v2pub.web_rec_type
763 := hz_contact_point_v2pub.g_miss_web_rec,
764 x_contact_point_id OUT NOCOPY NUMBER,
765 x_return_status OUT NOCOPY VARCHAR2,
766 x_msg_count OUT NOCOPY NUMBER,
767 x_msg_data OUT NOCOPY VARCHAR2
768 );
769
770 /*=======================================================================+
771 | PUBLIC PROCEDURE update_web_contact_point |
772 | |
773 | DESCRIPTION |
774 | Updates a Web contact point. |
775 | |
776 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
777 | hz_utility_v2pub.debug |
778 | hz_party_v2pub.update_web_contact_point |
779 | |
780 | ARGUMENTS |
781 | IN: |
782 | p_init_msg_list Initialize message stack if it is set to |
783 | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
784 | p_contact_point_rec Contact point record. |
785 | p_web_rec WEB record. |
786 | IN/OUT: |
787 | p_object_version_number Used to lock the record being updated. |
788 | OUT: |
789 | x_party_number Party number for the party created for the |
790 | relationship. |
791 | x_return_status Return status after the call. The status can |
792 | be FND_API.G_RET_STS_SUCCESS (success), |
793 | fnd_api.g_ret_sts_error (error), |
794 | fnd_api.g_ret_sts_unexp_error (unexpected |
795 | error). |
796 | x_msg_count Number of messages in message stack. |
797 | x_msg_data Message text if x_msg_count is 1. |
798 | MODIFICATION HISTORY |
799 | 27-APR-2002 J. del Callar Bug 2238144: Created. |
800 +=======================================================================*/
804 p_web_rec IN hz_contact_point_v2pub.web_rec_type
801 PROCEDURE update_web_contact_point (
802 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
803 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
805 := hz_contact_point_v2pub.g_miss_web_rec,
806 p_object_version_number IN OUT NOCOPY NUMBER,
807 x_return_status OUT NOCOPY VARCHAR2,
808 x_msg_count OUT NOCOPY NUMBER,
809 x_msg_data OUT NOCOPY VARCHAR2
810 );
811
812 /*=======================================================================+
813 | PUBLIC PROCEDURE create_phone_contact_point |
814 | |
815 | DESCRIPTION |
816 | Creates a Phone contact point. |
817 | |
818 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
819 | hz_utility_v2pub.debug |
820 | hz_party_v2pub.create_phone_contact_point |
821 | |
822 | ARGUMENTS |
823 | IN: |
824 | p_init_msg_list Initialize message stack if it is set to |
825 | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
826 | p_contact_point_rec Contact point record. |
827 | p_phone_rec PHONE record. |
828 | IN/OUT: |
829 | OUT: |
830 | x_contact_point_id ID of the contact point created. |
831 | x_party_number Party number for the party created for the |
832 | relationship. |
833 | x_return_status Return status after the call. The status can |
834 | be FND_API.G_RET_STS_SUCCESS (success), |
835 | fnd_api.g_ret_sts_error (error), |
836 | fnd_api.g_ret_sts_unexp_error (unexpected |
837 | error). |
838 | x_msg_count Number of messages in message stack. |
839 | x_msg_data Message text if x_msg_count is 1. |
840 | MODIFICATION HISTORY |
841 | 27-APR-2002 J. del Callar Bug 2238144: Created. |
842 +=======================================================================*/
843 PROCEDURE create_phone_contact_point (
844 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
845 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
846 p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
847 := hz_contact_point_v2pub.g_miss_phone_rec,
848 x_contact_point_id OUT NOCOPY NUMBER,
849 x_return_status OUT NOCOPY VARCHAR2,
850 x_msg_count OUT NOCOPY NUMBER,
851 x_msg_data OUT NOCOPY VARCHAR2
852 );
853
854 /*=======================================================================+
855 | PUBLIC PROCEDURE update_phone_contact_point |
856 | |
857 | DESCRIPTION |
858 | Updates a Phone contact point. |
859 | |
860 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
861 | hz_utility_v2pub.debug |
862 | hz_party_v2pub.update_phone_contact_point |
863 | |
864 | ARGUMENTS |
865 | IN: |
866 | p_init_msg_list Initialize message stack if it is set to |
867 | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
868 | p_contact_point_rec Contact point record. |
869 | p_phone_rec PHONE record. |
870 | IN/OUT: |
871 | p_object_version_number Used to lock the record being updated. |
872 | OUT: |
873 | x_party_number Party number for the party created for the |
874 | relationship. |
875 | x_return_status Return status after the call. The status can |
876 | be FND_API.G_RET_STS_SUCCESS (success), |
877 | fnd_api.g_ret_sts_error (error), |
878 | fnd_api.g_ret_sts_unexp_error (unexpected |
879 | error). |
880 | x_msg_count Number of messages in message stack. |
881 | x_msg_data Message text if x_msg_count is 1. |
882 | MODIFICATION HISTORY |
886 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
883 | 27-APR-2002 J. del Callar Bug 2238144: Created. |
884 +=======================================================================*/
885 PROCEDURE update_phone_contact_point (
887 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
888 p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
889 := hz_contact_point_v2pub.g_miss_phone_rec,
890 p_object_version_number IN OUT NOCOPY NUMBER,
891 x_return_status OUT NOCOPY VARCHAR2,
892 x_msg_count OUT NOCOPY NUMBER,
893 x_msg_data OUT NOCOPY VARCHAR2
894 );
895
896 /*=======================================================================+
897 | PUBLIC PROCEDURE create_email_contact_point |
898 | |
899 | DESCRIPTION |
900 | Creates an Email contact point. |
901 | |
902 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
903 | hz_utility_v2pub.debug |
904 | hz_party_v2pub.create_email_contact_point |
905 | |
906 | ARGUMENTS |
907 | IN: |
908 | p_init_msg_list Initialize message stack if it is set to |
909 | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
910 | p_contact_point_rec Contact point record. |
911 | p_email_rec EMAIL record. |
912 | IN/OUT: |
913 | OUT: |
914 | x_contact_point_id ID of the contact point created. |
915 | x_party_number Party number for the party created for the |
916 | relationship. |
917 | x_return_status Return status after the call. The status can |
918 | be FND_API.G_RET_STS_SUCCESS (success), |
919 | fnd_api.g_ret_sts_error (error), |
920 | fnd_api.g_ret_sts_unexp_error (unexpected |
921 | error). |
922 | x_msg_count Number of messages in message stack. |
923 | x_msg_data Message text if x_msg_count is 1. |
924 | MODIFICATION HISTORY |
925 | 27-APR-2002 J. del Callar Bug 2238144: Created. |
926 +=======================================================================*/
927 PROCEDURE create_email_contact_point (
928 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
929 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
930 p_email_rec IN hz_contact_point_v2pub.email_rec_type
931 := hz_contact_point_v2pub.g_miss_email_rec,
932 x_contact_point_id OUT NOCOPY NUMBER,
933 x_return_status OUT NOCOPY VARCHAR2,
934 x_msg_count OUT NOCOPY NUMBER,
935 x_msg_data OUT NOCOPY VARCHAR2
936 );
937
938 /*=======================================================================+
939 | PUBLIC PROCEDURE update_email_contact_point |
940 | |
941 | DESCRIPTION |
942 | Updates an EMAIL contact point. |
943 | |
944 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
945 | hz_utility_v2pub.debug |
946 | hz_party_v2pub.update_email_contact_point |
947 | |
948 | ARGUMENTS |
949 | IN: |
950 | p_init_msg_list Initialize message stack if it is set to |
951 | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
952 | p_contact_point_rec Contact point record. |
953 | p_email_rec EMAIL record. |
954 | IN/OUT: |
955 | p_object_version_number Used to lock the record being updated. |
956 | OUT: |
957 | x_party_number Party number for the party created for the |
958 | relationship. |
959 | x_return_status Return status after the call. The status can |
960 | be FND_API.G_RET_STS_SUCCESS (success), |
961 | fnd_api.g_ret_sts_error (error), |
962 | fnd_api.g_ret_sts_unexp_error (unexpected |
963 | error). |
964 | x_msg_count Number of messages in message stack. |
968 +=======================================================================*/
965 | x_msg_data Message text if x_msg_count is 1. |
966 | MODIFICATION HISTORY |
967 | 27-APR-2002 J. del Callar Bug 2238144: Created. |
969 PROCEDURE update_email_contact_point (
970 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
971 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
972 p_email_rec IN hz_contact_point_v2pub.email_rec_type
973 := hz_contact_point_v2pub.g_miss_email_rec,
974 p_object_version_number IN OUT NOCOPY NUMBER,
975 x_return_status OUT NOCOPY VARCHAR2,
976 x_msg_count OUT NOCOPY NUMBER,
977 x_msg_data OUT NOCOPY VARCHAR2
978 );
979
980 /*=======================================================================+
981 | PUBLIC PROCEDURE create_telex_contact_point |
982 | |
983 | DESCRIPTION |
984 | Creates a Telex contact point. |
985 | |
986 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
987 | hz_utility_v2pub.debug |
988 | hz_party_v2pub.create_telex_contact_point |
989 | |
990 | ARGUMENTS |
991 | IN: |
992 | p_init_msg_list Initialize message stack if it is set to |
993 | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
994 | p_contact_point_rec Contact point record. |
995 | p_telex_rec TELEX record. |
996 | IN/OUT: |
997 | OUT: |
998 | x_contact_point_id ID of the contact point created. |
999 | x_party_number Party number for the party created for the |
1000 | relationship. |
1001 | x_return_status Return status after the call. The status can |
1002 | be FND_API.G_RET_STS_SUCCESS (success), |
1003 | fnd_api.g_ret_sts_error (error), |
1004 | fnd_api.g_ret_sts_unexp_error (unexpected |
1005 | error). |
1006 | x_msg_count Number of messages in message stack. |
1007 | x_msg_data Message text if x_msg_count is 1. |
1008 | MODIFICATION HISTORY |
1009 | 27-APR-2002 J. del Callar Bug 2238144: Created. |
1010 +=======================================================================*/
1011 PROCEDURE create_telex_contact_point (
1012 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1013 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1014 p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
1015 := hz_contact_point_v2pub.g_miss_telex_rec,
1016 x_contact_point_id OUT NOCOPY NUMBER,
1017 x_return_status OUT NOCOPY VARCHAR2,
1018 x_msg_count OUT NOCOPY NUMBER,
1019 x_msg_data OUT NOCOPY VARCHAR2
1020 );
1021
1022 /*=======================================================================+
1023 | PUBLIC PROCEDURE update_telex_contact_point |
1024 | |
1025 | DESCRIPTION |
1026 | Updates a Telex contact point. |
1027 | |
1028 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1029 | hz_utility_v2pub.debug |
1030 | hz_party_v2pub.update_telex_contact_point |
1031 | |
1032 | ARGUMENTS |
1033 | IN: |
1034 | p_init_msg_list Initialize message stack if it is set to |
1035 | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
1036 | p_contact_point_rec Contact point record. |
1037 | p_telex_rec TELEX record. |
1038 | IN/OUT: |
1039 | p_object_version_number Used to lock the record being updated. |
1040 | OUT: |
1041 | x_party_number Party number for the party created for the |
1042 | relationship. |
1043 | x_return_status Return status after the call. The status can |
1044 | be FND_API.G_RET_STS_SUCCESS (success), |
1045 | fnd_api.g_ret_sts_error (error), |
1046 | fnd_api.g_ret_sts_unexp_error (unexpected |
1050 | MODIFICATION HISTORY |
1047 | error). |
1048 | x_msg_count Number of messages in message stack. |
1049 | x_msg_data Message text if x_msg_count is 1. |
1051 | 27-APR-2002 J. del Callar Bug 2238144: Created. |
1052 +=======================================================================*/
1053 PROCEDURE update_telex_contact_point (
1054 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1055 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1056 p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
1057 := hz_contact_point_v2pub.g_miss_telex_rec,
1058 p_object_version_number IN OUT NOCOPY NUMBER,
1059 x_return_status OUT NOCOPY VARCHAR2,
1060 x_msg_count OUT NOCOPY NUMBER,
1061 x_msg_data OUT NOCOPY VARCHAR2
1062 );
1063
1064 /*=======================================================================+
1065 | PUBLIC PROCEDURE validate_bank |
1066 | |
1067 | DESCRIPTION |
1068 | Validate bank record |
1069 | |
1070 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1071 | |
1072 | ARGUMENTS |
1073 | IN: |
1074 | p_init_msg_list Initialize message stack if it is set to |
1075 | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
1076 | p_bank_rec bank record |
1077 | p_mode 'I' for insert mode. |
1078 | 'U' for update mode. |
1079 | IN/OUT: |
1080 | OUT: |
1081 | x_return_status Return status after the call. The status can |
1082 | be FND_API.G_RET_STS_SUCCESS (success), |
1083 | fnd_api.g_ret_sts_error (error), |
1084 | fnd_api.g_ret_sts_unexp_error (unexpected |
1085 | error). |
1086 | x_msg_count Number of messages in message stack. |
1087 | x_msg_data Message text if x_msg_count is 1. |
1088 | MODIFICATION HISTORY |
1089 | 14-FEB-2006 Jianying o Bug 4728668: Created. |
1090 +=======================================================================*/
1091
1092 PROCEDURE validate_bank (
1093 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
1094 p_bank_rec IN bank_rec_type,
1095 p_mode IN VARCHAR2,
1096 x_return_status OUT NOCOPY VARCHAR2,
1097 x_msg_count OUT NOCOPY NUMBER,
1098 x_msg_data OUT NOCOPY VARCHAR2
1099 );
1100
1101 /*=======================================================================+
1102 | PUBLIC PROCEDURE validate_bank_branch |
1103 | |
1104 | DESCRIPTION |
1105 | Validate bank branch record |
1106 | |
1107 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1108 | |
1109 | ARGUMENTS |
1110 | IN: |
1111 | p_init_msg_list Initialize message stack if it is set to |
1112 | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
1113 | p_bank_party_id bank party id. |
1114 | p_bank_branch_rec bank branch record |
1115 | p_mode 'I' for insert mode. |
1116 | 'U' for update mode. |
1117 | IN/OUT: |
1118 | OUT: |
1119 | x_return_status Return status after the call. The status can |
1120 | be FND_API.G_RET_STS_SUCCESS (success), |
1121 | fnd_api.g_ret_sts_error (error), |
1122 | fnd_api.g_ret_sts_unexp_error (unexpected |
1123 | error). |
1124 | x_msg_count Number of messages in message stack. |
1125 | x_msg_data Message text if x_msg_count is 1. |
1126 | MODIFICATION HISTORY |
1127 | 14-FEB-2006 Jianying o Bug 4728668: Created. |
1128 +=======================================================================*/
1129
1130 PROCEDURE validate_bank_branch (
1131 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
1132 p_bank_party_id IN NUMBER,
1133 p_bank_branch_rec IN bank_rec_type,
1134 p_mode IN VARCHAR2,
1135 x_return_status OUT NOCOPY VARCHAR2,
1136 x_msg_count OUT NOCOPY NUMBER,
1137 x_msg_data OUT NOCOPY VARCHAR2
1138 );
1139
1140 END hz_bank_pub;
[Home] [Help]