[Home] [Help]
PACKAGE: APPS.HR_FORM_TEMPLATES_API
Source
1 Package hr_form_templates_api AUTHID CURRENT_USER as
2 /* $Header: hrtmpapi.pkh 120.0 2005/05/31 03:20:53 appldev noship $ */
3 -- Global Variable definition
4 g_session_mode varchar2(30) := 'CUSTOMER_DATA';
5 --
6 --
7 -- ----------------------------------------------------------------------------
8 -- |--------------------------< copy_template >--------------------------|
9 -- ----------------------------------------------------------------------------
10 --
11 --
12 -- Description: This business process inserts a new form template in the
13 -- HR Schema based on an existing template. It also creates a
14 -- copy of every object within the copied from template in the
15 -- new template.
16 --
17 -- Prerequisites:
18 --
19 --
20 -- In Parameters:
21 -- Name Reqd Type Description
22 -- p_language_code N Varchar2
23 -- p_form_template_id_from Y Number
24 -- p_template_name N Varchar2
25 -- p_user_template_name N Varchar2
26 -- p_enabled_flag N Varchar2
27 -- p_description N Varchar2
28 -- p_legislation_code N Varchar2
29 -- p_attribute_category N Varchar2
30 -- p_attribute1 N Varchar2
31 -- p_attribute2 N Varchar2
32 -- p_attribute3 N Varchar2
33 -- p_attribute4 N Varchar2
34 -- p_attribute5 N Varchar2
35 -- p_attribute6 N Varchar2
36 -- p_attribute7 N Varchar2
37 -- p_attribute8 N Varchar2
38 -- p_attribute9 N Varchar2
39 -- p_attribute10 N Varchar2
40 -- p_attribute11 N Varchar2
41 -- p_attribute12 N Varchar2
42 -- p_attribute13 N Varchar2
43 -- p_attribute14 N Varchar2
44 -- p_attribute15 N Varchar2
45 -- p_attribute16 N Varchar2
46 -- p_attribute17 N Varchar2
47 -- p_attribute18 N Varchar2
48 -- p_attribute19 N Varchar2
49 -- p_attribute20 N Varchar2
50 -- p_attribute21 N Varchar2
51 -- p_attribute22 N Varchar2
52 -- p_attribute23 N Varchar2
53 -- p_attribute24 N Varchar2
54 -- p_attribute25 N Varchar2
55 -- p_attribute26 N Varchar2
56 -- p_attribute27 N Varchar2
57 -- p_attribute28 N Varchar2
58 -- p_attribute29 N Varchar2
62 --
59 -- p_attribute30 N Varchar2
60 --
61 -- Post Success:
63 -- Name Type Description
64 -- p_form_template_id_to Number
65 -- p_object_version_number Number
66 --
67 -- Post Failure:
68 --
69 --
70 -- {Start Of Comments}
71 -- Post Failure:
72 --
73 --
74 -- Access Status:
75 -- Internal.
76 --
77 -- {End Of Comments}
78 --
79 procedure copy_template
80 (p_validate in boolean default false
81 ,p_effective_date in date
82 ,p_form_template_id_from in number
83 ,p_language_code in varchar2 default hr_api.userenv_lang
84 --,p_template_name in varchar2 default hr_api.g_varchar2
85 ,p_template_name in varchar2
86 ,p_user_template_name in varchar2 default hr_api.g_varchar2
87 ,p_description in varchar2 default hr_api.g_varchar2
88 ,p_enabled_flag in varchar2 default hr_api.g_varchar2
89 ,p_legislation_code in varchar2 default hr_api.g_varchar2
90 ,p_attribute_category in varchar2 default hr_api.g_varchar2
91 ,p_attribute1 in varchar2 default hr_api.g_varchar2
92 ,p_attribute2 in varchar2 default hr_api.g_varchar2
93 ,p_attribute3 in varchar2 default hr_api.g_varchar2
94 ,p_attribute4 in varchar2 default hr_api.g_varchar2
95 ,p_attribute5 in varchar2 default hr_api.g_varchar2
96 ,p_attribute6 in varchar2 default hr_api.g_varchar2
97 ,p_attribute7 in varchar2 default hr_api.g_varchar2
98 ,p_attribute8 in varchar2 default hr_api.g_varchar2
99 ,p_attribute9 in varchar2 default hr_api.g_varchar2
100 ,p_attribute10 in varchar2 default hr_api.g_varchar2
101 ,p_attribute11 in varchar2 default hr_api.g_varchar2
102 ,p_attribute12 in varchar2 default hr_api.g_varchar2
103 ,p_attribute13 in varchar2 default hr_api.g_varchar2
104 ,p_attribute14 in varchar2 default hr_api.g_varchar2
105 ,p_attribute15 in varchar2 default hr_api.g_varchar2
106 ,p_attribute16 in varchar2 default hr_api.g_varchar2
107 ,p_attribute17 in varchar2 default hr_api.g_varchar2
108 ,p_attribute18 in varchar2 default hr_api.g_varchar2
109 ,p_attribute19 in varchar2 default hr_api.g_varchar2
110 ,p_attribute20 in varchar2 default hr_api.g_varchar2
111 ,p_attribute21 in varchar2 default hr_api.g_varchar2
112 ,p_attribute22 in varchar2 default hr_api.g_varchar2
113 ,p_attribute23 in varchar2 default hr_api.g_varchar2
114 ,p_attribute24 in varchar2 default hr_api.g_varchar2
115 ,p_attribute25 in varchar2 default hr_api.g_varchar2
116 ,p_attribute26 in varchar2 default hr_api.g_varchar2
117 ,p_attribute27 in varchar2 default hr_api.g_varchar2
118 ,p_attribute28 in varchar2 default hr_api.g_varchar2
119 ,p_attribute29 in varchar2 default hr_api.g_varchar2
120 ,p_attribute30 in varchar2 default hr_api.g_varchar2
121 ,p_form_template_id_to out nocopy number
122 ,p_object_version_number out nocopy number
123 );
124 --
125 --
126 -- ----------------------------------------------------------------------------
127 -- |--------------------------< create_template >--------------------------|
128 -- ----------------------------------------------------------------------------
129 -- {Start Of Comments}
130 --
131 -- Description: This business process inserts a new form template
132 -- in the HR Schema.
133 --
134 --
135 -- Prerequisites:
136 --
137 --
138 -- In Parameters:
139 -- Name Reqd Type Description
140 -- p_language_code N Varchar2
141 -- p_application_id Y Number
142 -- p_form_id Y Number
143 -- p_template_name Y Varchar2
144 -- p_enabled_flag Y Varchar2
145 -- p_user_template_name Y Varchar2
146 -- p_description N Varchar2
147 -- p_legislation_code N Varchar2
148 -- p_attribute_category N Varchar2
149 -- p_attribute1 N Varchar2
150 -- p_attribute2 N Varchar2
151 -- p_attribute3 N Varchar2
152 -- p_attribute4 N Varchar2
153 -- p_attribute5 N Varchar2
154 -- p_attribute6 N Varchar2
155 -- p_attribute7 N Varchar2
156 -- p_attribute8 N Varchar2
157 -- p_attribute9 N Varchar2
158 -- p_attribute10 N Varchar2
159 -- p_attribute11 N Varchar2
160 -- p_attribute12 N Varchar2
161 -- p_attribute13 N Varchar2
162 -- p_attribute14 N Varchar2
163 -- p_attribute15 N Varchar2
164 -- p_attribute16 N Varchar2
165 -- p_attribute17 N Varchar2
166 -- p_attribute18 N Varchar2
167 -- p_attribute19 N Varchar2
168 -- p_attribute20 N Varchar2
169 -- p_attribute21 N Varchar2
173 -- p_attribute25 N Varchar2
170 -- p_attribute22 N Varchar2
171 -- p_attribute23 N Varchar2
172 -- p_attribute24 N Varchar2
174 -- p_attribute26 N Varchar2
175 -- p_attribute27 N Varchar2
176 -- p_attribute28 N Varchar2
177 -- p_attribute29 N Varchar2
178 -- p_attribute30 N Varchar2
179 -- p_help_target N Varchar2
180 -- p_information_category N Varchar2
181 -- p_information1 N Varchar2
182 -- p_information2 N Varchar2
183 -- p_information3 N Varchar2
184 -- p_information4 N Varchar2
185 -- p_information5 N Varchar2
186 -- p_information6 N Varchar2
187 -- p_information7 N Varchar2
188 -- p_information8 N Varchar2
189 -- p_information9 N Varchar2
190 -- p_information10 N Varchar2
191 -- p_information11 N Varchar2
192 -- p_information12 N Varchar2
193 -- p_information13 N Varchar2
194 -- p_information14 N Varchar2
195 -- p_information15 N Varchar2
196 -- p_information16 N Varchar2
197 -- p_information17 N Varchar2
198 -- p_information18 N Varchar2
199 -- p_information19 N Varchar2
200 -- p_information20 N Varchar2
201 -- p_information21 N Varchar2
202 -- p_information22 N Varchar2
203 -- p_information23 N Varchar2
204 -- p_information24 N Varchar2
205 -- p_information25 N Varchar2
206 -- p_information26 N Varchar2
207 -- p_information27 N Varchar2
208 -- p_information28 N Varchar2
209 -- p_information29 N Varchar2
210 -- p_information30 N Varchar2
211 --
212 --
213 -- Post Success:
214 --
215 -- Name Type Description
216 -- p_form_template_id Number
217 -- p_object_version_number Number
218 --
219 -- Access Status:
220 -- Internal.
221 --
222 -- {End Of Comments}
223 --
224 procedure create_template
225 (p_validate in boolean default false
226 ,p_effective_date in date
227 ,p_language_code in varchar2 default hr_api.userenv_lang
228 ,p_application_id in number
229 ,p_form_id in number
230 ,p_template_name in varchar2
231 ,p_enabled_flag in varchar2
232 ,p_user_template_name in varchar2
233 ,p_description in varchar2 default null
234 ,p_legislation_code in varchar2 default null
235 ,p_attribute_category in varchar2 default null
236 ,p_attribute1 in varchar2 default null
237 ,p_attribute2 in varchar2 default null
238 ,p_attribute3 in varchar2 default null
239 ,p_attribute4 in varchar2 default null
240 ,p_attribute5 in varchar2 default null
241 ,p_attribute6 in varchar2 default null
242 ,p_attribute7 in varchar2 default null
243 ,p_attribute8 in varchar2 default null
244 ,p_attribute9 in varchar2 default null
245 ,p_attribute10 in varchar2 default null
246 ,p_attribute11 in varchar2 default null
247 ,p_attribute12 in varchar2 default null
248 ,p_attribute13 in varchar2 default null
249 ,p_attribute14 in varchar2 default null
250 ,p_attribute15 in varchar2 default null
251 ,p_attribute16 in varchar2 default null
252 ,p_attribute17 in varchar2 default null
253 ,p_attribute18 in varchar2 default null
254 ,p_attribute19 in varchar2 default null
255 ,p_attribute20 in varchar2 default null
256 ,p_attribute21 in varchar2 default null
257 ,p_attribute22 in varchar2 default null
258 ,p_attribute23 in varchar2 default null
259 ,p_attribute24 in varchar2 default null
260 ,p_attribute25 in varchar2 default null
261 ,p_attribute26 in varchar2 default null
262 ,p_attribute27 in varchar2 default null
263 ,p_attribute28 in varchar2 default null
264 ,p_attribute29 in varchar2 default null
265 ,p_attribute30 in varchar2 default null
266 ,p_help_target in varchar2 default hr_api.g_varchar2
267 ,p_information_category in varchar2 default hr_api.g_varchar2
268 ,p_information1 in varchar2 default hr_api.g_varchar2
269 ,p_information2 in varchar2 default hr_api.g_varchar2
270 ,p_information3 in varchar2 default hr_api.g_varchar2
271 ,p_information4 in varchar2 default hr_api.g_varchar2
272 ,p_information5 in varchar2 default hr_api.g_varchar2
273 ,p_information6 in varchar2 default hr_api.g_varchar2
274 ,p_information7 in varchar2 default hr_api.g_varchar2
278 ,p_information11 in varchar2 default hr_api.g_varchar2
275 ,p_information8 in varchar2 default hr_api.g_varchar2
276 ,p_information9 in varchar2 default hr_api.g_varchar2
277 ,p_information10 in varchar2 default hr_api.g_varchar2
279 ,p_information12 in varchar2 default hr_api.g_varchar2
280 ,p_information13 in varchar2 default hr_api.g_varchar2
281 ,p_information14 in varchar2 default hr_api.g_varchar2
282 ,p_information15 in varchar2 default hr_api.g_varchar2
283 ,p_information16 in varchar2 default hr_api.g_varchar2
284 ,p_information17 in varchar2 default hr_api.g_varchar2
285 ,p_information18 in varchar2 default hr_api.g_varchar2
286 ,p_information19 in varchar2 default hr_api.g_varchar2
287 ,p_information20 in varchar2 default hr_api.g_varchar2
288 ,p_information21 in varchar2 default hr_api.g_varchar2
289 ,p_information22 in varchar2 default hr_api.g_varchar2
290 ,p_information23 in varchar2 default hr_api.g_varchar2
291 ,p_information24 in varchar2 default hr_api.g_varchar2
292 ,p_information25 in varchar2 default hr_api.g_varchar2
293 ,p_information26 in varchar2 default hr_api.g_varchar2
294 ,p_information27 in varchar2 default hr_api.g_varchar2
295 ,p_information28 in varchar2 default hr_api.g_varchar2
296 ,p_information29 in varchar2 default hr_api.g_varchar2
297 ,p_information30 in varchar2 default hr_api.g_varchar2
298 ,p_form_template_id out nocopy number
299 ,p_object_version_number out nocopy number
300 );
301 --
302 --
303 -- ----------------------------------------------------------------------------
304 -- |--------------------------< delete_template >--------------------------|
305 -- ----------------------------------------------------------------------------
306 -- {Start Of Comments}
307 --
308 -- Description: This business process deletes a form template from
309 -- the HR Schema.
310 --
311 -- Prerequisites:
312 --
313 --
314 -- In Parameters:
315 -- Name Reqd Type Description
316 --
317 -- p_form_template_id Y Number
318 -- p_object_version_number Y Number
319 -- p_delete_children_flag N Varchar2
320 --
321 -- Post Success:
322 --
323 --
324 -- Name Type Description
325 --
326 -- Post Failure:
327 --
328 --
329 -- Access Status:
330 -- Internal.
331 --
332 -- {End Of Comments}
333 --
334 procedure delete_template
335 (p_validate in boolean default false
336 ,p_form_template_id in number
337 ,p_object_version_number in number
338 ,p_delete_children_flag in varchar2 default 'N'
339 );
340 --
341 --
342 -- ----------------------------------------------------------------------------
343 -- |--------------------------< set_session_mode procedures>------------------|
344 -- ----------------------------------------------------------------------------
345 -- {Start Of Comments}
346 --
347 -- Description: These business support process sets the type of session the
348 -- user is running. May be either a seed data or customer data
349 -- session.
350 --
351 -- Prerequisites:
352 --
353 --
354 -- In Parameters:
355 -- Name Reqd Type Description
356 --
357 --
358 -- Post Success:
359 --
360 --
361 -- Name Type Description
362 --
363 -- Post Failure:
364 --
365 --
366 -- Access Status:
367 -- Internal.
368 --
369 -- {End Of Comments}
370 --
371 procedure set_seed_data_session_mode;
372 --
373 procedure set_customer_data_session_mode;
374 --
375 function seed_data_session_mode
376 return boolean;
377 --
378 procedure assert_seed_data_session_mode;
379 --
380 -- ----------------------------------------------------------------------------
381 -- |--------------------------< update_template >-----------------------------|
382 -- ----------------------------------------------------------------------------
383 -- {Start Of Comments}
384 --
385 -- Description: This business process updates a form template in the HR Schema.
386 --
387 --
388 -- Prerequisites:
389 --
390 --
391 -- In Parameters:
392 -- Name Reqd Type Description
393 -- p_language_code N Varchar2
394 -- p_form_template_id Y Number
395 -- p_object_version_number Y Number
396 -- p_template_name N Varchar2
397 -- p_enabled_flag N Varchar2
398 -- p_user_template_name N Varchar2
399 -- p_description N Varchar2
400 -- p_legislation_code N Varchar2
401 -- p_attribute_category N Varchar2
402 -- p_attribute1 N Varchar2
403 -- p_attribute2 N Varchar2
404 -- p_attribute3 N Varchar2
405 -- p_attribute4 N Varchar2
406 -- p_attribute5 N Varchar2
407 -- p_attribute6 N Varchar2
411 -- p_attribute10 N Varchar2
408 -- p_attribute7 N Varchar2
409 -- p_attribute8 N Varchar2
410 -- p_attribute9 N Varchar2
412 -- p_attribute11 N Varchar2
413 -- p_attribute12 N Varchar2
414 -- p_attribute13 N Varchar2
415 -- p_attribute14 N Varchar2
416 -- p_attribute15 N Varchar2
417 -- p_attribute16 N Varchar2
418 -- p_attribute17 N Varchar2
419 -- p_attribute18 N Varchar2
420 -- p_attribute19 N Varchar2
421 -- p_attribute20 N Varchar2
422 -- p_attribute21 N Varchar2
423 -- p_attribute22 N Varchar2
424 -- p_attribute23 N Varchar2
425 -- p_attribute24 N Varchar2
426 -- p_attribute25 N Varchar2
427 -- p_attribute26 N Varchar2
428 -- p_attribute27 N Varchar2
429 -- p_attribute28 N Varchar2
430 -- p_attribute29 N Varchar2
431 -- p_attribute30 N Varchar2
432 -- p_help_target N Varchar2
433 -- p_information_category N Varchar2
434 -- p_information1 N Varchar2
435 -- p_information2 N Varchar2
436 -- p_information3 N Varchar2
437 -- p_information4 N Varchar2
438 -- p_information5 N Varchar2
439 -- p_information6 N Varchar2
440 -- p_information7 N Varchar2
441 -- p_information8 N Varchar2
442 -- p_information9 N Varchar2
443 -- p_information10 N Varchar2
444 -- p_information11 N Varchar2
445 -- p_information12 N Varchar2
446 -- p_information13 N Varchar2
447 -- p_information14 N Varchar2
448 -- p_information15 N Varchar2
449 -- p_information16 N Varchar2
450 -- p_information17 N Varchar2
451 -- p_information18 N Varchar2
452 -- p_information19 N Varchar2
453 -- p_information20 N Varchar2
454 -- p_information21 N Varchar2
455 -- p_information22 N Varchar2
456 -- p_information23 N Varchar2
457 -- p_information24 N Varchar2
458 -- p_information25 N Varchar2
459 -- p_information26 N Varchar2
460 -- p_information27 N Varchar2
461 -- p_information28 N Varchar2
462 -- p_information29 N Varchar2
463 -- p_information30 N Varchar2
464 --
465 -- Post Success:
466 --
467 --
468 -- Name Type Description
469 -- p_object_version_number Number
470 --
471 -- Post Failure:
472 --
473 --
474 -- Access Status:
475 -- Internal.
476 --
477 -- {End Of Comments}
478 --
479 procedure update_template
480 (p_validate in boolean default false
481 ,p_effective_date in date
482 ,p_form_template_id in number
483 ,p_object_version_number in out nocopy number
484 ,p_language_code in varchar2 default hr_api.userenv_lang
485 ,p_template_name in varchar2 default hr_api.g_varchar2
486 ,p_enabled_flag in varchar2 default hr_api.g_varchar2
487 ,p_user_template_name in varchar2 default hr_api.g_varchar2
488 ,p_description in varchar2 default hr_api.g_varchar2
489 ,p_legislation_code in varchar2 default hr_api.g_varchar2
490 ,p_attribute_category in varchar2 default hr_api.g_varchar2
491 ,p_attribute1 in varchar2 default hr_api.g_varchar2
492 ,p_attribute2 in varchar2 default hr_api.g_varchar2
493 ,p_attribute3 in varchar2 default hr_api.g_varchar2
494 ,p_attribute4 in varchar2 default hr_api.g_varchar2
495 ,p_attribute5 in varchar2 default hr_api.g_varchar2
496 ,p_attribute6 in varchar2 default hr_api.g_varchar2
497 ,p_attribute7 in varchar2 default hr_api.g_varchar2
498 ,p_attribute8 in varchar2 default hr_api.g_varchar2
499 ,p_attribute9 in varchar2 default hr_api.g_varchar2
500 ,p_attribute10 in varchar2 default hr_api.g_varchar2
501 ,p_attribute11 in varchar2 default hr_api.g_varchar2
502 ,p_attribute12 in varchar2 default hr_api.g_varchar2
503 ,p_attribute13 in varchar2 default hr_api.g_varchar2
504 ,p_attribute14 in varchar2 default hr_api.g_varchar2
505 ,p_attribute15 in varchar2 default hr_api.g_varchar2
506 ,p_attribute16 in varchar2 default hr_api.g_varchar2
507 ,p_attribute17 in varchar2 default hr_api.g_varchar2
508 ,p_attribute18 in varchar2 default hr_api.g_varchar2
509 ,p_attribute19 in varchar2 default hr_api.g_varchar2
510 ,p_attribute20 in varchar2 default hr_api.g_varchar2
511 ,p_attribute21 in varchar2 default hr_api.g_varchar2
512 ,p_attribute22 in varchar2 default hr_api.g_varchar2
513 ,p_attribute23 in varchar2 default hr_api.g_varchar2
517 ,p_attribute27 in varchar2 default hr_api.g_varchar2
514 ,p_attribute24 in varchar2 default hr_api.g_varchar2
515 ,p_attribute25 in varchar2 default hr_api.g_varchar2
516 ,p_attribute26 in varchar2 default hr_api.g_varchar2
518 ,p_attribute28 in varchar2 default hr_api.g_varchar2
519 ,p_attribute29 in varchar2 default hr_api.g_varchar2
520 ,p_attribute30 in varchar2 default hr_api.g_varchar2
521 ,p_help_target in varchar2 default hr_api.g_varchar2
522 ,p_information_category in varchar2 default hr_api.g_varchar2
523 ,p_information1 in varchar2 default hr_api.g_varchar2
524 ,p_information2 in varchar2 default hr_api.g_varchar2
525 ,p_information3 in varchar2 default hr_api.g_varchar2
526 ,p_information4 in varchar2 default hr_api.g_varchar2
527 ,p_information5 in varchar2 default hr_api.g_varchar2
528 ,p_information6 in varchar2 default hr_api.g_varchar2
529 ,p_information7 in varchar2 default hr_api.g_varchar2
530 ,p_information8 in varchar2 default hr_api.g_varchar2
531 ,p_information9 in varchar2 default hr_api.g_varchar2
532 ,p_information10 in varchar2 default hr_api.g_varchar2
533 ,p_information11 in varchar2 default hr_api.g_varchar2
534 ,p_information12 in varchar2 default hr_api.g_varchar2
535 ,p_information13 in varchar2 default hr_api.g_varchar2
536 ,p_information14 in varchar2 default hr_api.g_varchar2
537 ,p_information15 in varchar2 default hr_api.g_varchar2
538 ,p_information16 in varchar2 default hr_api.g_varchar2
539 ,p_information17 in varchar2 default hr_api.g_varchar2
540 ,p_information18 in varchar2 default hr_api.g_varchar2
541 ,p_information19 in varchar2 default hr_api.g_varchar2
542 ,p_information20 in varchar2 default hr_api.g_varchar2
543 ,p_information21 in varchar2 default hr_api.g_varchar2
544 ,p_information22 in varchar2 default hr_api.g_varchar2
545 ,p_information23 in varchar2 default hr_api.g_varchar2
546 ,p_information24 in varchar2 default hr_api.g_varchar2
547 ,p_information25 in varchar2 default hr_api.g_varchar2
548 ,p_information26 in varchar2 default hr_api.g_varchar2
549 ,p_information27 in varchar2 default hr_api.g_varchar2
550 ,p_information28 in varchar2 default hr_api.g_varchar2
551 ,p_information29 in varchar2 default hr_api.g_varchar2
552 ,p_information30 in varchar2 default hr_api.g_varchar2
553 );
554 --
555 end hr_form_templates_api;