1 Package hr_template_windows_api AUTHID CURRENT_USER as
2 /* $Header: hrtwuapi.pkh 120.0 2005/05/31 03:36:24 appldev noship $ */
3 --
4 --
5 -- ----------------------------------------------------------------------------
6 -- |-----------------------< copy_template_window >--------------------------|
7 -- ----------------------------------------------------------------------------
8 -- {Start Of Comments}
9 --
10 -- Description: This business process inserts a new template window in the
11 -- HR Schema based on an existing template window. It also
12 -- creates a copy of every object within the copied from template
13 -- window in the new template window.
14 --
15 -- Prerequisites:
16 --
17 --
18 -- In Parameters:
19 -- Name Reqd Type Description
20 -- p_language_code N Varchar2
21 -- p_template_window_id_from Y Number
22 -- p_form_template_id Y Number
23 --
24 -- Post Success:
25 --
26 -- Name Type Description
27 -- p_template_window_id_to Number
28 -- p_object_version_number Number
29 --
30 -- Post Failure:
31 --
32 --
33 -- Access Status:
34 -- Internal.
35 --
36 -- {End Of Comments}
37 --
38 procedure copy_template_window
39 (p_validate in boolean default false
40 ,p_effective_date in date
41 ,p_language_code in varchar2 default hr_api.userenv_lang
42 ,p_template_window_id_from in number
43 ,p_form_template_id in number
44 ,p_template_window_id_to out nocopy number
45 ,p_object_version_number out nocopy number
46 );
47 --
48 --
49 -- ----------------------------------------------------------------------------
50 -- |------------------------< create_template_window >------------------------|
51 -- ----------------------------------------------------------------------------
52 -- {Start Of Comments}
53 --
54 -- Description: This business process inserts a new template window in
55 -- the HR Schema.
56 --
57 -- Prerequisites:
58 --
59 --
60 -- In Parameters:
61 -- Name Reqd Type Description
62 -- p_language_code N varchar2
63 -- p_form_template_id Y number
64 -- p_form_window_id Y number
65 -- p_height N number
66 -- p_title N varchar2
67 -- p_width N number
68 -- p_x_position N number
69 -- p_y_position N number
70 -- p_information_category N varchar2
71 -- p_information1 N varchar2
72 -- p_information2 N varchar2
73 -- p_information3 N varchar2
74 -- p_information4 N varchar2
75 -- p_information5 N varchar2
76 -- p_information6 N varchar2
77 -- p_information7 N varchar2
78 -- p_information8 N varchar2
79 -- p_information9 N varchar2
80 -- p_information10 N varchar2
81 -- p_information11 N varchar2
82 -- p_information12 N varchar2
83 -- p_information13 N varchar2
84 -- p_information14 N varchar2
85 -- p_information15 N varchar2
86 -- p_information16 N varchar2
87 -- p_information17 N varchar2
88 -- p_information18 N varchar2
89 -- p_information19 N varchar2
90 -- p_information20 N varchar2
91 -- p_information21 N varchar2
92 -- p_information22 N varchar2
93 -- p_information23 N varchar2
94 -- p_information24 N varchar2
95 -- p_information25 N varchar2
96 -- p_information26 N varchar2
97 -- p_information27 N varchar2
98 -- p_information28 N varchar2
99 -- p_information29 N varchar2
100 -- p_information30 N varchar2
101 --
102 --
103 -- Post Success:
104 --
105 --
106 -- Name Type Description
107 -- p_template_window_id number
108 -- p_object_version_number number
109 --
110 -- Post Failure:
111 --
112 --
113 -- Access Status:
114 -- Internal.
115 --
116 -- {End Of Comments}
117 --
118 procedure create_template_window
119 (p_validate in boolean default false
120 ,p_effective_date in date
121 ,p_language_code in varchar2 default hr_api.userenv_lang
122 ,p_form_template_id in number
123 ,p_form_window_id in number
124 ,p_height in number default hr_api.g_number
125 ,p_title in varchar2 default hr_api.g_varchar2
126 ,p_width in number default hr_api.g_number
127 ,p_x_position in number default hr_api.g_number
128 ,p_y_position in number default hr_api.g_number
129 ,p_information_category in varchar2 default hr_api.g_varchar2
130 ,p_information1 in varchar2 default hr_api.g_varchar2
131 ,p_information2 in varchar2 default hr_api.g_varchar2
132 ,p_information3 in varchar2 default hr_api.g_varchar2
133 ,p_information4 in varchar2 default hr_api.g_varchar2
134 ,p_information5 in varchar2 default hr_api.g_varchar2
135 ,p_information6 in varchar2 default hr_api.g_varchar2
136 ,p_information7 in varchar2 default hr_api.g_varchar2
137 ,p_information8 in varchar2 default hr_api.g_varchar2
138 ,p_information9 in varchar2 default hr_api.g_varchar2
139 ,p_information10 in varchar2 default hr_api.g_varchar2
140 ,p_information11 in varchar2 default hr_api.g_varchar2
141 ,p_information12 in varchar2 default hr_api.g_varchar2
142 ,p_information13 in varchar2 default hr_api.g_varchar2
143 ,p_information14 in varchar2 default hr_api.g_varchar2
144 ,p_information15 in varchar2 default hr_api.g_varchar2
145 ,p_information16 in varchar2 default hr_api.g_varchar2
146 ,p_information17 in varchar2 default hr_api.g_varchar2
147 ,p_information18 in varchar2 default hr_api.g_varchar2
148 ,p_information19 in varchar2 default hr_api.g_varchar2
149 ,p_information20 in varchar2 default hr_api.g_varchar2
150 ,p_information21 in varchar2 default hr_api.g_varchar2
151 ,p_information22 in varchar2 default hr_api.g_varchar2
152 ,p_information23 in varchar2 default hr_api.g_varchar2
153 ,p_information24 in varchar2 default hr_api.g_varchar2
154 ,p_information25 in varchar2 default hr_api.g_varchar2
155 ,p_information26 in varchar2 default hr_api.g_varchar2
156 ,p_information27 in varchar2 default hr_api.g_varchar2
157 ,p_information28 in varchar2 default hr_api.g_varchar2
158 ,p_information29 in varchar2 default hr_api.g_varchar2
159 ,p_information30 in varchar2 default hr_api.g_varchar2
160 ,p_template_window_id out nocopy number
161 ,p_object_version_number out nocopy number
162 );
163 --
164 --
165 -- ----------------------------------------------------------------------------
166 -- |-------------------------< delete_template_window >-----------------------|
167 -- ----------------------------------------------------------------------------
168 -- {Start Of Comments}
169 --
170 -- Description: This business process deletes a template window from the
171 -- HR Schema.
172 --
173 -- Prerequisites:
174 --
175 --
176 -- In Parameters:
177 -- Name Reqd Type Description
178 -- p_form_window_id Y Number
179 -- p_object_version_number Y Number
180 -- p_delete_children_flag N Varchar2
181 --
182 -- Post Success:
183 --
184 --
185 -- Name Type Description
186 --
187 -- Post Failure:
188 --
189 --
190 -- Access Status:
191 -- Internal.
192 --
193 -- {End Of Comments}
194 --
195 procedure delete_template_window
196 (p_validate in boolean default false
197 ,p_template_window_id in number
198 ,p_object_version_number in number
199 ,p_delete_children_flag in varchar2 default 'N'
200 );
201 --
202 --
203 -- ----------------------------------------------------------------------------
204 -- |-------------------------< update_template_window >-----------------------|
205 -- ----------------------------------------------------------------------------
206 -- {Start Of Comments}
207 --
208 -- Description: This business process updates a template window in the
209 -- HR Schema.
210 --
211 -- Prerequisites:
212 --
213 --
214 -- In Parameters:
215 -- Name Reqd Type Description
216 -- p_language_code N varchar2
217 -- p_template_window_id Y number
218 -- p_object_version_number Y number
219 -- p_height N number
220 -- p_title N varchar2
221 -- p_width N number
222 -- p_x_position N number
223 -- p_y_position N number
224 -- p_information_category N varchar2
225 -- p_information1 N varchar2
226 -- p_information2 N varchar2
227 -- p_information3 N varchar2
228 -- p_information4 N varchar2
229 -- p_information5 N varchar2
230 -- p_information6 N varchar2
231 -- p_information7 N varchar2
232 -- p_information8 N varchar2
233 -- p_information9 N varchar2
234 -- p_information10 N varchar2
235 -- p_information11 N varchar2
236 -- p_information12 N varchar2
237 -- p_information13 N varchar2
238 -- p_information14 N varchar2
239 -- p_information15 N varchar2
240 -- p_information16 N varchar2
241 -- p_information17 N varchar2
242 -- p_information18 N varchar2
243 -- p_information19 N varchar2
244 -- p_information20 N varchar2
245 -- p_information21 N varchar2
246 -- p_information22 N varchar2
247 -- p_information23 N varchar2
248 -- p_information24 N varchar2
249 -- p_information25 N varchar2
250 -- p_information26 N varchar2
251 -- p_information27 N varchar2
252 -- p_information28 N varchar2
253 -- p_information29 N varchar2
254 -- p_information30 N varchar2
255 --
256 -- Post Success:
257 --
258 --
259 -- Name Type Description
260 -- p_object_version_number number
261 --
262 -- Post Failure:
263 --
264 --
265 -- Access Status:
266 -- Internal.
267 --
268 -- {End Of Comments}
269 --
270 procedure update_template_window
271 (p_validate in boolean default false
272 ,p_effective_date in date
273 ,p_language_code in varchar2 default hr_api.userenv_lang
274 ,p_template_window_id in number
275 ,p_object_version_number in out nocopy number
276 ,p_height in number default hr_api.g_number
277 ,p_title in varchar2 default hr_api.g_varchar2
278 ,p_width in number default hr_api.g_number
279 ,p_x_position in number default hr_api.g_number
280 ,p_y_position in number default hr_api.g_number
281 ,p_information_category in varchar2 default hr_api.g_varchar2
282 ,p_information1 in varchar2 default hr_api.g_varchar2
283 ,p_information2 in varchar2 default hr_api.g_varchar2
284 ,p_information3 in varchar2 default hr_api.g_varchar2
285 ,p_information4 in varchar2 default hr_api.g_varchar2
286 ,p_information5 in varchar2 default hr_api.g_varchar2
287 ,p_information6 in varchar2 default hr_api.g_varchar2
288 ,p_information7 in varchar2 default hr_api.g_varchar2
289 ,p_information8 in varchar2 default hr_api.g_varchar2
290 ,p_information9 in varchar2 default hr_api.g_varchar2
291 ,p_information10 in varchar2 default hr_api.g_varchar2
292 ,p_information11 in varchar2 default hr_api.g_varchar2
293 ,p_information12 in varchar2 default hr_api.g_varchar2
294 ,p_information13 in varchar2 default hr_api.g_varchar2
295 ,p_information14 in varchar2 default hr_api.g_varchar2
296 ,p_information15 in varchar2 default hr_api.g_varchar2
297 ,p_information16 in varchar2 default hr_api.g_varchar2
298 ,p_information17 in varchar2 default hr_api.g_varchar2
299 ,p_information18 in varchar2 default hr_api.g_varchar2
300 ,p_information19 in varchar2 default hr_api.g_varchar2
301 ,p_information20 in varchar2 default hr_api.g_varchar2
302 ,p_information21 in varchar2 default hr_api.g_varchar2
303 ,p_information22 in varchar2 default hr_api.g_varchar2
304 ,p_information23 in varchar2 default hr_api.g_varchar2
305 ,p_information24 in varchar2 default hr_api.g_varchar2
306 ,p_information25 in varchar2 default hr_api.g_varchar2
307 ,p_information26 in varchar2 default hr_api.g_varchar2
308 ,p_information27 in varchar2 default hr_api.g_varchar2
309 ,p_information28 in varchar2 default hr_api.g_varchar2
310 ,p_information29 in varchar2 default hr_api.g_varchar2
311 ,p_information30 in varchar2 default hr_api.g_varchar2
312 );
313 --
314 end hr_template_windows_api;