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