[Home] [Help]
PACKAGE: APPS.PER_CONTACT_INFO_TYPES_PKG
Source
1 PACKAGE per_contact_info_types_pkg AUTHID CURRENT_USER AS
2 /* $Header: pecit01t.pkh 115.5 2002/12/04 12:18:11 pkakar noship $ */
3 -- ---------------------------------------------------------------------------
4 -- |-----------------------< chk_active_inactive_flag >----------------------|
5 -- ---------------------------------------------------------------------------
6 -- {Start Of Comments}
7 --
8 -- Description:
9 -- Validates that active_inactive_flag is 'Y' or 'N'.
10 --
11 -- Prerequisites:
12 -- None.
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- x_active_inactive_flag Yes VARCHAR2 Active or Inactive
17 -- Flag.
18 --
19 -- Out Parameters:
20 -- None.
21 --
22 -- Post Success:
23 -- The process succeeds.
24 --
25 -- Post Failure:
26 -- The process will be terminated.
27 --
28 -- Developer Implementation Notes:
29 -- None.
30 --
31 -- Access Status:
32 -- Public.
33 --
34 -- {End Of Comments}
35 -- ---------------------------------------------------------------------------
36 PROCEDURE chk_active_inactive_flag(
37 x_active_inactive_flag IN per_contact_info_types.active_inactive_flag%TYPE);
38 --
39 -- ---------------------------------------------------------------------------
40 -- |---------------------< chk_multiple_occurences_flag >--------------------|
41 -- ---------------------------------------------------------------------------
42 -- {Start Of Comments}
43 --
44 -- Description:
45 -- Validates that multiple_occurences_flag is 'Y' or 'N'.
46 --
47 -- Prerequisites:
48 -- None.
49 --
50 -- In Parameters:
51 -- Name Reqd Type Description
52 -- x_multiple_occurences_flag Yes VARCHAR2 Multiple Occurrences
53 -- Flag.
54 --
55 -- Out Parameters:
56 -- None.
57 --
58 -- Post Success:
59 -- The process succeeds.
60 --
61 -- Post Failure:
62 -- The process will be terminated.
63 --
64 -- Developer Implementation Notes:
65 -- None.
66 --
67 -- Access Status:
68 -- Public.
69 --
70 -- {End Of Comments}
71 -- ---------------------------------------------------------------------------
72 PROCEDURE chk_multiple_occurences_flag(
73 x_multiple_occurences_flag IN per_contact_info_types.multiple_occurences_flag%TYPE);
74 --
75 -- ---------------------------------------------------------------------------
76 -- |---------------------< chk_update_mltpl_occrncs_flg >--------------------|
77 -- ---------------------------------------------------------------------------
78 -- {Start Of Comments}
79 --
80 -- Description:
81 -- Error when multiple_occurences_flag is updated to 'Y' from 'N'.
82 --
83 -- Prerequisites:
84 -- This procedure must be called after chk_multiple_occurences_flag.
85 --
86 -- In Parameters:
87 -- Name Reqd Type Description
88 -- x_information_type Yes VARCHAR2 Information Type.
89 -- x_multiple_occurences_flag Yes VARCHAR2 Multiple Occurrences
90 -- Flag.
91 --
92 -- Out Parameters:
93 -- None.
94 --
95 -- Post Success:
96 -- The process succeeds.
97 --
98 -- Post Failure:
99 -- The process will be terminated.
100 --
101 -- Developer Implementation Notes:
102 -- None.
103 --
104 -- Access Status:
105 -- Public.
106 --
107 -- {End Of Comments}
108 -- ---------------------------------------------------------------------------
109 PROCEDURE chk_update_mltpl_occrncs_flg(
110 x_information_type IN per_contact_info_types.information_type%TYPE,
111 x_multiple_occurences_flag IN per_contact_info_types.multiple_occurences_flag%TYPE);
112 --
113 -- ---------------------------------------------------------------------------
114 -- |------------------------------< insert_row >-----------------------------|
115 -- ---------------------------------------------------------------------------
116 -- {Start Of Comments}
117 --
118 -- Description:
119 -- Create a contact information type.
120 --
121 -- Prerequisites:
122 -- None.
123 --
124 -- In Parameters:
125 -- Name Reqd Type Description
126 -- x_rowid Yes VARCHAR2 Row ID.
127 -- x_information_type Yes VARCHAR2 Contact Information
128 -- Type.
129 -- x_active_inactive_flag Yes VARCHAR2 Active or Inactive
130 -- Flag.
131 -- x_multiple_occurences_flag Yes VARCHAR2 Multiple Occurrences
132 -- Flag.
133 -- x_legislation_code Yes VARCHAR2 Legislation Code.
134 -- x_description Yes VARCHAR2 Description.
135 -- x_last_update_date Yes DATE Last Update Date.
136 -- x_last_updated_by Yes NUMBER User ID who last
137 -- updates the row.
138 -- x_last_update_login Yes NUMBER Login ID who last
139 -- updates the row.
140 -- x_created_by Yes NUMBER User ID who creates
141 -- the row.
142 -- x_creation_date Yes DATE Creation Date.
143 -- x_request_id Yes NUMBER Request ID that
144 -- updates the row.
145 -- x_program_application_id Yes NUMBER Application ID to which
146 -- the concurrent program
147 -- that updates the row
148 -- belongs.
149 -- x_program_id Yes NUMBER Concurrent Program ID
150 -- that updates the row.
151 -- x_program_update_date Yes DATE Date concurrent program
152 -- updates the row.
153 -- x_object_version_number Yes NUMBER Version number of the
154 -- row.
155 --
156 -- Out Parameters:
157 -- Name Type Description
158 -- x_row_id VARCHAR2 Row ID.
159 --
160 -- Post Success:
161 -- The process succeeds.
162 --
163 -- Post Failure:
164 -- The process will be terminated.
165 --
166 -- Developer Implementation Notes:
167 -- None.
168 --
169 -- Access Status:
170 -- Public.
171 --
172 -- {End Of Comments}
173 -- ---------------------------------------------------------------------------
174 PROCEDURE insert_row(
175 x_rowid IN OUT NOCOPY VARCHAR2,
176 x_information_type IN VARCHAR2,
177 x_active_inactive_flag IN VARCHAR2,
178 x_multiple_occurences_flag IN VARCHAR2,
179 x_legislation_code IN VARCHAR2,
180 x_description IN VARCHAR2,
181 x_last_update_date IN DATE,
182 x_last_updated_by IN NUMBER,
183 x_last_update_login IN NUMBER,
184 x_created_by IN NUMBER,
185 x_creation_date IN DATE,
186 x_request_id IN NUMBER,
187 x_program_application_id IN NUMBER,
188 x_program_id IN NUMBER,
189 x_program_update_date IN DATE,
190 x_object_version_number IN NUMBER);
191 -- ---------------------------------------------------------------------------
192 -- |-------------------------------< lock_row >------------------------------|
193 -- ---------------------------------------------------------------------------
194 -- {Start Of Comments}
195 --
196 -- Description:
197 -- Lock a contact information type.
198 --
199 -- Prerequisites:
200 -- None.
201 --
202 -- In Parameters:
203 -- Name Reqd Type Description
204 -- x_information_type Yes VARCHAR2 Contact Information
205 -- Type.
206 -- x_active_inactive_flag Yes VARCHAR2 Active or Inactive
207 -- Flag.
208 -- x_multiple_occurences_flag Yes VARCHAR2 Multiple Occurrences
209 -- Flag.
210 -- x_legislation_code Yes VARCHAR2 Legislation Code.
211 -- x_description Yes VARCHAR2 Description.
212 -- x_object_version_number Yes NUMBER Version number of the
213 -- row.
214 --
215 -- Out Parameters:
216 -- None.
217 --
218 -- Post Success:
219 -- The process succeeds.
220 --
221 -- Post Failure:
222 -- The process will be terminated.
223 --
224 -- Developer Implementation Notes:
225 -- None.
226 --
227 -- Access Status:
228 -- Public.
229 --
230 -- {End Of Comments}
231 -- ---------------------------------------------------------------------------
232 PROCEDURE lock_row(
233 x_information_type IN VARCHAR2,
234 x_active_inactive_flag IN VARCHAR2,
235 x_multiple_occurences_flag IN VARCHAR2,
236 x_legislation_code IN VARCHAR2,
237 x_description IN VARCHAR2,
238 x_object_version_number IN NUMBER);
239 -- ---------------------------------------------------------------------------
240 -- |------------------------------< update_row >-----------------------------|
241 -- ---------------------------------------------------------------------------
242 -- {Start Of Comments}
243 --
244 -- Description:
245 -- Update a contact information type.
246 --
247 -- Prerequisites:
248 -- None.
249 --
250 -- In Parameters:
251 -- Name Reqd Type Description
252 -- x_information_type Yes VARCHAR2 Contact Information
253 -- Type.
254 -- x_active_inactive_flag Yes VARCHAR2 Active or Inactive
255 -- Flag.
256 -- x_multiple_occurences_flag Yes VARCHAR2 Multiple Occurrences
257 -- Flag.
258 -- x_legislation_code Yes VARCHAR2 Legislation Code.
259 -- x_description Yes VARCHAR2 Description.
260 -- x_last_update_date Yes DATE Last Update Date.
261 -- x_last_updated_by Yes NUMBER User ID who last
262 -- updates the row.
263 -- x_last_update_login Yes NUMBER Login ID who last
264 -- updates the row.
265 -- x_request_id Yes NUMBER Request ID that
266 -- updates the row.
267 -- x_program_application_id Yes NUMBER Application ID to which
268 -- the concurrent program
269 -- that updates the row
270 -- belongs.
271 -- x_program_id Yes NUMBER Concurrent Program ID
272 -- that updates the row.
273 -- x_program_update_date Yes DATE Date concurrent program
274 -- updates the row.
275 -- x_object_version_number Yes NUMBER Version number of the
276 -- row.
277 --
278 -- Out Parameters:
279 -- Name Type Description
280 -- x_object_version_number NUMBER Set to the version number of this
281 -- contact information type.
282 --
283 -- Post Success:
284 -- The process succeeds.
285 --
286 -- Post Failure:
287 -- The process will be terminated.
288 --
289 -- Developer Implementation Notes:
290 -- None.
291 --
292 -- Access Status:
293 -- Public.
294 --
295 -- {End Of Comments}
296 -- ---------------------------------------------------------------------------
297 PROCEDURE update_row(
298 x_information_type IN VARCHAR2,
299 x_active_inactive_flag IN VARCHAR2,
300 x_multiple_occurences_flag IN VARCHAR2,
301 x_legislation_code IN VARCHAR2,
302 x_description IN VARCHAR2,
303 x_last_update_date IN DATE,
304 x_last_updated_by IN NUMBER,
305 x_last_update_login IN NUMBER,
306 x_request_id IN NUMBER,
307 x_program_application_id IN NUMBER,
308 x_program_id IN NUMBER,
309 x_program_update_date IN DATE,
310 x_object_version_number IN OUT NOCOPY NUMBER);
311 -- ---------------------------------------------------------------------------
312 -- |------------------------------< delete_row >-----------------------------|
313 -- ---------------------------------------------------------------------------
314 -- {Start Of Comments}
315 --
316 -- Description:
317 -- Delete a contact information type.
318 --
319 -- Prerequisites:
320 -- None.
321 --
322 -- In Parameters:
323 -- Name Reqd Type Description
324 -- x_information_type Yes VARCHAR2 Contact Information
325 -- Type.
326 --
327 -- Out Parameters:
328 -- None.
329 --
330 -- Post Success:
331 -- The process succeeds.
332 --
333 -- Post Failure:
334 -- The process will be terminated.
335 --
336 -- Developer Implementation Notes:
337 -- None.
338 --
339 -- Access Status:
340 -- Public.
341 --
342 -- {End Of Comments}
343 -- ---------------------------------------------------------------------------
344 PROCEDURE delete_row(
345 x_information_type IN VARCHAR2);
346 -- ---------------------------------------------------------------------------
347 -- |-------------------------------< load_row >------------------------------|
348 -- ---------------------------------------------------------------------------
349 -- {Start Of Comments}
350 --
351 -- Description:
352 -- Update or insert row as appropriate.
353 --
354 -- Prerequisites:
355 -- None.
356 --
357 -- In Parameters:
358 -- Name Reqd Type Description
359 -- x_information_type Yes VARCHAR2 Contact Information
360 -- Type.
361 -- x_active_inactive_flag Yes VARCHAR2 Active or Inactive
362 -- Flag.
363 -- x_multiple_occurences_flag Yes VARCHAR2 Multiple Occurrences
364 -- Flag.
365 -- x_description Yes VARCHAR2 Description.
366 -- x_legislation_code Yes VARCHAR2 Legislation Code.
367 -- x_object_version_number Yes NUMBER Version number of the
368 -- row.
369 -- x_owner Yes VARCHAR2 'SEED' or 'CUSTOM'.
370 --
371 -- Out Parameters:
372 -- None.
373 --
374 -- Post Success:
375 -- The process succeeds. No parameters are returned.
376 --
380 -- Developer Implementation Notes:
377 -- Post Failure:
378 -- None.
379 --
381 -- This procedure is called from percit.lct.
382 --
383 -- Access Status:
384 -- Public.
385 --
386 -- {End Of Comments}
387 -- ---------------------------------------------------------------------------
388 PROCEDURE load_row(
389 x_information_type IN VARCHAR2,
390 x_active_inactive_flag IN VARCHAR2,
391 x_multiple_occurences_flag IN VARCHAR2,
392 x_description IN VARCHAR2,
393 x_legislation_code IN VARCHAR2,
394 x_object_version_number IN NUMBER,
395 x_owner IN VARCHAR2);
396 -- ---------------------------------------------------------------------------
397 -- |----------------------------< traslate_row >-----------------------------|
398 -- ---------------------------------------------------------------------------
399 -- {Start Of Comments}
400 --
401 -- Description:
402 -- Update translatable column.
403 --
404 -- Prerequisites:
405 -- None.
406 --
407 -- In Parameters:
408 -- Name Reqd Type Description
409 -- x_information_type Yes VARCHAR2 Contact Information
410 -- Type.
411 -- x_description Yes VARCHAR2 Description.
412 -- x_owner Yes VARCHAR2 'SEED' or 'CUSTOM'.
413 --
414 -- Out Parameters:
415 -- None.
416 --
417 -- Post Success:
418 -- The process succeeds. No parameters are returned.
419 --
420 -- Post Failure:
421 -- None.
422 --
423 -- Developer Implementation Notes:
424 -- This procedure is called from pecit.lct.
425 --
426 -- Access Status:
427 -- Public.
428 --
429 -- {End Of Comments}
430 -- ---------------------------------------------------------------------------
431 PROCEDURE translate_row(
432 x_information_type IN VARCHAR2,
433 x_description IN VARCHAR2,
434 x_owner IN VARCHAR2);
435 -- ---------------------------------------------------------------------------
436 -- |----------------------------< add_language >-----------------------------|
437 -- ---------------------------------------------------------------------------
438 -- {Start Of Comments}
439 --
440 -- Description:
441 -- Update translation table for all languages.
442 --
443 -- Prerequisites:
444 -- None.
445 --
446 -- In Parameters:
447 -- None.
448 --
449 -- Out Parameters:
450 -- None.
451 --
452 -- Post Success:
453 -- The process succeeds. No parameters are returned.
454 --
455 -- Post Failure:
456 -- None.
457 --
458 -- Developer Implementation Notes:
459 -- None.
460 --
461 -- Access Status:
462 -- Public.
463 --
464 -- {End Of Comments}
465 -- ---------------------------------------------------------------------------
466 PROCEDURE add_language;
467 -- ---------------------------------------------------------------------------
468 -- |-----------------------< set_translation_globals >-----------------------|
469 -- ---------------------------------------------------------------------------
470 -- {Start Of Comments}
471 --
472 -- Description:
473 -- Set global variables used in MLS validation.
474 --
475 -- Prerequisites:
476 -- None.
477 --
478 -- In Parameters:
479 -- Name Reqd Type Description
480 -- p_business_group_id Yes NUMBER Business Group ID.
481 -- p_legislation_code Yes VARCHAR2 Legislation Code.
482 --
483 -- Out Parameters:
484 -- None.
485 --
486 -- Post Success:
487 -- The process succeeds. No parameters are returned.
488 --
489 -- Post Failure:
490 -- None.
491 --
492 -- Developer Implementation Notes:
493 -- None.
494 --
495 -- Access Status:
496 -- Public.
497 --
498 -- {End Of Comments}
502 p_legislation_code IN VARCHAR2);
499 -- ---------------------------------------------------------------------------
500 PROCEDURE set_translation_globals(
501 p_business_group_id IN NUMBER,
503 -- ---------------------------------------------------------------------------
504 -- |-------------------------< validate_translation >------------------------|
505 -- ---------------------------------------------------------------------------
506 -- {Start Of Comments}
507 --
508 -- Description:
509 -- Validate if the translation of specified language for contact information
510 -- type description is unique.
511 --
512 -- Prerequisites:
513 -- Global variable g_dummy must be set before executing this procedure.
514 --
515 -- In Parameters:
516 -- Name Reqd Type Description
517 -- information_type Yes VARCHAR2 Contact Information Type.
518 -- language Yes VARCHAR2 Language.
519 -- description Yes VARCHAR2 Description for Contact
520 -- Information Type.
521 -- Out Parameters:
522 -- None.
523 --
524 -- Post Success:
525 -- The process succeeds. No parameters are returned.
526 --
527 -- Post Failure:
528 -- The process will be terminated.
529 --
530 -- Developer Implementation Notes:
531 -- This procedure is called in user-named trigger 'TRANSLATIONS' of Enter
532 -- Contact Relationship Extra Information form.
533 --
534 -- Access Status:
535 -- Public.
536 --
537 -- {End Of Comments}
538 -- ---------------------------------------------------------------------------
539 PROCEDURE validate_translation(
540 information_type IN VARCHAR2,
541 language IN VARCHAR2,
542 description IN VARCHAR2);
543 END per_contact_info_types_pkg;