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