1 Package hr_form_properties_bsi AUTHID CURRENT_USER as
2 /* $Header: hrfmpbsi.pkh 115.2 2003/09/24 02:00:16 bsubrama noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------< create_form_property >--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description: This business support process inserts a new form property
10 -- in the HR Schema.
11 --
12 --
13 -- Prerequisites:
14 --
15 --
16 -- In Parameters:
17 -- Name Reqd Type Description
18 -- p_application_id N Number
19 -- p_form_id N Number
20 -- p_form_template_id N Number
21 -- p_help_target N varchar2
22 -- p_information_category N varchar2
23 -- p_information1 N varchar2
24 -- p_information2 N varchar2
25 -- p_information3 N varchar2
26 -- p_information4 N varchar2
27 -- p_information5 N varchar2
28 -- p_information6 N varchar2
29 -- p_information7 N varchar2
30 -- p_information8 N varchar2
31 -- p_information9 N varchar2
32 -- p_information10 N varchar2
33 -- p_information11 N varchar2
34 -- p_information12 N varchar2
35 -- p_information13 N varchar2
36 -- p_information14 N varchar2
37 -- p_information15 N varchar2
38 -- p_information16 N varchar2
39 -- p_information17 N varchar2
40 -- p_information18 N varchar2
41 -- p_information19 N varchar2
42 -- p_information20 N varchar2
43 -- p_information21 N varchar2
44 -- p_information22 N varchar2
45 -- p_information23 N varchar2
46 -- p_information24 N varchar2
47 -- p_information25 N varchar2
48 -- p_information26 N varchar2
49 -- p_information27 N varchar2
50 -- p_information28 N varchar2
51 -- p_information29 N varchar2
52 -- p_information30 N varchar2
53 --
54 --
55 -- Post Success:
56 --
57 --
58 -- Name Type Description
59 -- p_form_property_id Number
60 --
61 -- Post Failure:
62 --
63 --
64 -- Access Status:
65 -- Public.
66 --
67 -- {End Of Comments}
68 --
69 procedure create_form_property
70 (p_validate in boolean default false
71 ,p_effective_date in date
72 ,p_application_id in number default null
73 ,p_form_id in number default null
74 ,p_form_template_id in number default null
75 ,p_help_target in varchar2 default null
76 ,p_information_category in varchar2 default null
77 ,p_information1 in varchar2 default null
78 ,p_information2 in varchar2 default null
79 ,p_information3 in varchar2 default null
80 ,p_information4 in varchar2 default null
81 ,p_information5 in varchar2 default null
82 ,p_information6 in varchar2 default null
83 ,p_information7 in varchar2 default null
84 ,p_information8 in varchar2 default null
85 ,p_information9 in varchar2 default null
86 ,p_information10 in varchar2 default null
87 ,p_information11 in varchar2 default null
88 ,p_information12 in varchar2 default null
89 ,p_information13 in varchar2 default null
90 ,p_information14 in varchar2 default null
91 ,p_information15 in varchar2 default null
92 ,p_information16 in varchar2 default null
93 ,p_information17 in varchar2 default null
94 ,p_information18 in varchar2 default null
95 ,p_information19 in varchar2 default null
96 ,p_information20 in varchar2 default null
97 ,p_information21 in varchar2 default null
98 ,p_information22 in varchar2 default null
99 ,p_information23 in varchar2 default null
100 ,p_information24 in varchar2 default null
101 ,p_information25 in varchar2 default null
102 ,p_information26 in varchar2 default null
103 ,p_information27 in varchar2 default null
104 ,p_information28 in varchar2 default null
105 ,p_information29 in varchar2 default null
106 ,p_information30 in varchar2 default null
107 ,p_form_property_id out nocopy number
108 ,p_object_version_number out nocopy number
109 );
110 --
111 -- ----------------------------------------------------------------------------
112 -- |--------------------------< update_form_property >------------------------|
113 -- ----------------------------------------------------------------------------
114 -- {Start Of Comments}
115 --
116 -- Description: This business support process updates a form property in
117 -- the HR Schema.
118 --
119 -- Prerequisites:
120 --
121 --
122 -- In Parameters:
123 -- Name Reqd Type Description
124 -- p_form_property_id N Number
125 -- p_application_id N Number
126 -- p_form_id N Number
127 -- p_form_template_id N Number
128 -- p_help_target N varchar2
129 -- p_information_category N varchar2
130 -- p_information1 N varchar2
131 -- p_information2 N varchar2
132 -- p_information3 N varchar2
133 -- p_information4 N varchar2
134 -- p_information5 N varchar2
135 -- p_information6 N varchar2
136 -- p_information7 N varchar2
137 -- p_information8 N varchar2
138 -- p_information9 N varchar2
139 -- p_information10 N varchar2
140 -- p_information11 N varchar2
141 -- p_information12 N varchar2
142 -- p_information13 N varchar2
143 -- p_information14 N varchar2
144 -- p_information15 N varchar2
145 -- p_information16 N varchar2
146 -- p_information17 N varchar2
147 -- p_information18 N varchar2
148 -- p_information19 N varchar2
149 -- p_information20 N varchar2
150 -- p_information21 N varchar2
151 -- p_information22 N varchar2
152 -- p_information23 N varchar2
153 -- p_information24 N varchar2
154 -- p_information25 N varchar2
155 -- p_information26 N varchar2
156 -- p_information27 N varchar2
157 -- p_information28 N varchar2
158 -- p_information29 N varchar2
159 -- p_information30 N varchar2
160 --
161 --
162 -- Post Success:
163 --
164 --
165 -- Name Type Description
166 --
167 -- Post Failure:
168 --
169 --
170 -- Access Status:
171 -- Public.
172 --
173 -- {End Of Comments}
174 --
175 procedure update_form_property
176 (p_validate in boolean default false
177 ,p_effective_date in date
178 ,p_form_property_id in number default null
179 ,p_object_version_number in out nocopy number
180 ,p_application_id in number default null
181 ,p_form_id in number default null
182 ,p_form_template_id in number default null
183 ,p_help_target in varchar2 default hr_api.g_varchar2
184 ,p_information_category in varchar2 default hr_api.g_varchar2
185 ,p_information1 in varchar2 default hr_api.g_varchar2
186 ,p_information2 in varchar2 default hr_api.g_varchar2
187 ,p_information3 in varchar2 default hr_api.g_varchar2
188 ,p_information4 in varchar2 default hr_api.g_varchar2
189 ,p_information5 in varchar2 default hr_api.g_varchar2
190 ,p_information6 in varchar2 default hr_api.g_varchar2
191 ,p_information7 in varchar2 default hr_api.g_varchar2
192 ,p_information8 in varchar2 default hr_api.g_varchar2
193 ,p_information9 in varchar2 default hr_api.g_varchar2
194 ,p_information10 in varchar2 default hr_api.g_varchar2
195 ,p_information11 in varchar2 default hr_api.g_varchar2
196 ,p_information12 in varchar2 default hr_api.g_varchar2
197 ,p_information13 in varchar2 default hr_api.g_varchar2
198 ,p_information14 in varchar2 default hr_api.g_varchar2
199 ,p_information15 in varchar2 default hr_api.g_varchar2
200 ,p_information16 in varchar2 default hr_api.g_varchar2
201 ,p_information17 in varchar2 default hr_api.g_varchar2
202 ,p_information18 in varchar2 default hr_api.g_varchar2
203 ,p_information19 in varchar2 default hr_api.g_varchar2
204 ,p_information20 in varchar2 default hr_api.g_varchar2
205 ,p_information21 in varchar2 default hr_api.g_varchar2
206 ,p_information22 in varchar2 default hr_api.g_varchar2
207 ,p_information23 in varchar2 default hr_api.g_varchar2
208 ,p_information24 in varchar2 default hr_api.g_varchar2
209 ,p_information25 in varchar2 default hr_api.g_varchar2
210 ,p_information26 in varchar2 default hr_api.g_varchar2
211 ,p_information27 in varchar2 default hr_api.g_varchar2
212 ,p_information28 in varchar2 default hr_api.g_varchar2
213 ,p_information29 in varchar2 default hr_api.g_varchar2
214 ,p_information30 in varchar2 default hr_api.g_varchar2
215 );
216 --
217 --
218 -- ----------------------------------------------------------------------------
219 -- |--------------------------< delete_form_property >------------------------|
220 -- ----------------------------------------------------------------------------
221 -- {Start Of Comments}
222 --
223 -- Description: This business support process deletes a form property from
224 -- the HR Schema.
225 --
226 -- Prerequisites:
227 --
228 --
229 -- In Parameters:
230 -- Name Reqd Type Description
231 -- p_form_property_id N Number
232 -- p_application_id N Number
233 -- p_form_id N Number
234 -- p_form_template_id N Number
235 --
236 --
237 -- Post Success:
238 --
239 --
240 -- Name Type Description
241 --
242 -- Post Failure:
243 --
244 --
245 -- Access Status:
246 -- Public.
247 --
248 -- {End Of Comments}
249 --
250 procedure delete_form_property
251 (p_validate in boolean default false
252 ,p_form_property_id in number default null
253 ,p_object_version_number in number
254 ,p_application_id in number default null
255 ,p_form_id in number default null
256 ,p_form_template_id in number default null
257 );
258 --
259 --
260 -- ----------------------------------------------------------------------------
261 -- |--------------------------< copy_form_property >--------------------------|
262 -- ----------------------------------------------------------------------------
263 -- {Start Of Comments}
264 --
265 -- Description: This business support process copies properties from a form
266 -- to a template. Any property may not be copied by specifying
267 -- the value required in the parameter list.
268 --
269 -- Prerequisites:
270 --
271 --
272 -- In Parameters:
273 -- Name Reqd Type Description
274 -- p_application_id N Number
275 -- p_form_id N Number
276 -- p_form_template_id N Number
277 -- p_help_target N varchar2
278 -- p_information_category N varchar2
279 -- p_information1 N varchar2
280 -- p_information2 N varchar2
281 -- p_information3 N varchar2
282 -- p_information4 N varchar2
283 -- p_information5 N varchar2
284 -- p_information6 N varchar2
285 -- p_information7 N varchar2
286 -- p_information8 N varchar2
287 -- p_information9 N varchar2
288 -- p_information10 N varchar2
289 -- p_information11 N varchar2
290 -- p_information12 N varchar2
291 -- p_information13 N varchar2
292 -- p_information14 N varchar2
293 -- p_information15 N varchar2
294 -- p_information16 N varchar2
295 -- p_information17 N varchar2
296 -- p_information18 N varchar2
297 -- p_information19 N varchar2
298 -- p_information20 N varchar2
299 -- p_information21 N varchar2
300 -- p_information22 N varchar2
301 -- p_information23 N varchar2
302 -- p_information24 N varchar2
303 -- p_information25 N varchar2
304 -- p_information26 N varchar2
305 -- p_information27 N varchar2
306 -- p_information28 N varchar2
307 -- p_information29 N varchar2
308 -- p_information30 N varchar2
309 --
310 --
311 -- Post Success:
312 --
313 --
314 -- Name Type Description
315 -- p_form_property_id number
316 --
317 -- Post Failure:
318 --
319 --
320 -- Access Status:
321 -- Public.
322 --
323 -- {End Of Comments}
324 --
325 procedure copy_form_property
326 (p_validate in boolean default false
327 ,p_effective_date in date
328 ,p_application_id in number
329 ,p_form_id in number
330 ,p_form_template_id in number
331 ,p_help_target in varchar2 default hr_api.g_varchar2
332 ,p_information_category in varchar2 default hr_api.g_varchar2
333 ,p_information1 in varchar2 default hr_api.g_varchar2
334 ,p_information2 in varchar2 default hr_api.g_varchar2
335 ,p_information3 in varchar2 default hr_api.g_varchar2
336 ,p_information4 in varchar2 default hr_api.g_varchar2
337 ,p_information5 in varchar2 default hr_api.g_varchar2
338 ,p_information6 in varchar2 default hr_api.g_varchar2
339 ,p_information7 in varchar2 default hr_api.g_varchar2
340 ,p_information8 in varchar2 default hr_api.g_varchar2
341 ,p_information9 in varchar2 default hr_api.g_varchar2
342 ,p_information10 in varchar2 default hr_api.g_varchar2
343 ,p_information11 in varchar2 default hr_api.g_varchar2
344 ,p_information12 in varchar2 default hr_api.g_varchar2
345 ,p_information13 in varchar2 default hr_api.g_varchar2
346 ,p_information14 in varchar2 default hr_api.g_varchar2
347 ,p_information15 in varchar2 default hr_api.g_varchar2
348 ,p_information16 in varchar2 default hr_api.g_varchar2
349 ,p_information17 in varchar2 default hr_api.g_varchar2
350 ,p_information18 in varchar2 default hr_api.g_varchar2
351 ,p_information19 in varchar2 default hr_api.g_varchar2
352 ,p_information20 in varchar2 default hr_api.g_varchar2
353 ,p_information21 in varchar2 default hr_api.g_varchar2
354 ,p_information22 in varchar2 default hr_api.g_varchar2
355 ,p_information23 in varchar2 default hr_api.g_varchar2
356 ,p_information24 in varchar2 default hr_api.g_varchar2
357 ,p_information25 in varchar2 default hr_api.g_varchar2
358 ,p_information26 in varchar2 default hr_api.g_varchar2
359 ,p_information27 in varchar2 default hr_api.g_varchar2
360 ,p_information28 in varchar2 default hr_api.g_varchar2
361 ,p_information29 in varchar2 default hr_api.g_varchar2
362 ,p_information30 in varchar2 default hr_api.g_varchar2
363 ,p_form_property_id out nocopy number
364 ,p_object_version_number out nocopy number
365 );
366 --
367 --
368 -- ----------------------------------------------------------------------------
369 -- |----------------------< copy_form_property - overload >------------------|
370 -- ----------------------------------------------------------------------------
371 -- {Start Of Comments}
372 --
373 -- Description: This business support process copies properties from a
374 -- template to another template. Any property may not be copied
375 -- by specifying the value required in the parameter list.
376 --
377 -- Prerequisites:
378 --
379 --
380 -- In Parameters:
381 -- Name Reqd Type Description
382 -- p_form_template_id_to Y Number
383 -- p_form_template_id_from Y Number
384 -- p_help_target N varchar2
385 -- p_information_category N varchar2
386 -- p_information1 N varchar2
387 -- p_information2 N varchar2
388 -- p_information3 N varchar2
389 -- p_information4 N varchar2
390 -- p_information5 N varchar2
391 -- p_information6 N varchar2
392 -- p_information7 N varchar2
393 -- p_information8 N varchar2
394 -- p_information9 N varchar2
395 -- p_information10 N varchar2
396 -- p_information11 N varchar2
397 -- p_information12 N varchar2
398 -- p_information13 N varchar2
399 -- p_information14 N varchar2
400 -- p_information15 N varchar2
401 -- p_information16 N varchar2
402 -- p_information17 N varchar2
403 -- p_information18 N varchar2
404 -- p_information19 N varchar2
405 -- p_information20 N varchar2
406 -- p_information21 N varchar2
407 -- p_information22 N varchar2
408 -- p_information23 N varchar2
409 -- p_information24 N varchar2
410 -- p_information25 N varchar2
411 -- p_information26 N varchar2
412 -- p_information27 N varchar2
413 -- p_information28 N varchar2
414 -- p_information29 N varchar2
415 -- p_information30 N varchar2
416 --
417 --
418 -- Post Success:
419 --
420 --
421 -- Name Type Description
422 -- p_form_property_id number
423 --
424 -- Post Failure:
425 --
426 --
427 -- Access Status:
428 -- Public.
429 --
430 -- {End Of Comments}
431 --
432 procedure copy_form_property
433 (p_validate in boolean default false
434 ,p_effective_date in date
435 ,p_form_template_id_to in number
436 ,p_form_template_id_from in number
437 ,p_help_target in varchar2 default hr_api.g_varchar2
438 ,p_information_category in varchar2 default hr_api.g_varchar2
439 ,p_information1 in varchar2 default hr_api.g_varchar2
440 ,p_information2 in varchar2 default hr_api.g_varchar2
441 ,p_information3 in varchar2 default hr_api.g_varchar2
442 ,p_information4 in varchar2 default hr_api.g_varchar2
443 ,p_information5 in varchar2 default hr_api.g_varchar2
444 ,p_information6 in varchar2 default hr_api.g_varchar2
445 ,p_information7 in varchar2 default hr_api.g_varchar2
446 ,p_information8 in varchar2 default hr_api.g_varchar2
447 ,p_information9 in varchar2 default hr_api.g_varchar2
448 ,p_information10 in varchar2 default hr_api.g_varchar2
449 ,p_information11 in varchar2 default hr_api.g_varchar2
450 ,p_information12 in varchar2 default hr_api.g_varchar2
451 ,p_information13 in varchar2 default hr_api.g_varchar2
452 ,p_information14 in varchar2 default hr_api.g_varchar2
453 ,p_information15 in varchar2 default hr_api.g_varchar2
454 ,p_information16 in varchar2 default hr_api.g_varchar2
455 ,p_information17 in varchar2 default hr_api.g_varchar2
456 ,p_information18 in varchar2 default hr_api.g_varchar2
457 ,p_information19 in varchar2 default hr_api.g_varchar2
458 ,p_information20 in varchar2 default hr_api.g_varchar2
459 ,p_information21 in varchar2 default hr_api.g_varchar2
460 ,p_information22 in varchar2 default hr_api.g_varchar2
461 ,p_information23 in varchar2 default hr_api.g_varchar2
462 ,p_information24 in varchar2 default hr_api.g_varchar2
463 ,p_information25 in varchar2 default hr_api.g_varchar2
464 ,p_information26 in varchar2 default hr_api.g_varchar2
465 ,p_information27 in varchar2 default hr_api.g_varchar2
466 ,p_information28 in varchar2 default hr_api.g_varchar2
467 ,p_information29 in varchar2 default hr_api.g_varchar2
468 ,p_information30 in varchar2 default hr_api.g_varchar2
469 ,p_form_property_id out nocopy number
470 ,p_object_version_number out nocopy number
471 );
472 --
473 end hr_form_properties_bsi;