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