11: --
12: procedure copy_template_canvas
13: (p_validate in boolean default false
14: ,p_effective_date in date
15: ,p_language_code in varchar2 default hr_api.userenv_lang
16: ,p_template_canvas_id_from in number
17: ,p_template_window_id in number
18: ,p_template_canvas_id_to out nocopy number
19: ,p_object_version_number out nocopy number
68: -- instead of p_language_code from now on, to allow an IN OUT parameter to
69: -- be passed through.
70: --
71: l_language_code := p_language_code;
72: hr_api.validate_language_code(p_language_code => l_language_code);
73: --
74: hr_utility.set_location(l_proc, 20);
75: --
76: --
83: ,p_template_canvas_id_from => p_template_canvas_id_from
84: ,p_template_window_id => p_template_window_id
85: );
86: exception
87: when hr_api.cannot_find_prog_unit then
88: hr_api.cannot_find_prog_unit_error
89: (p_module_name => 'copy_template_canvas'
90: ,p_hook_type => 'BP'
91: );
84: ,p_template_window_id => p_template_window_id
85: );
86: exception
87: when hr_api.cannot_find_prog_unit then
88: hr_api.cannot_find_prog_unit_error
89: (p_module_name => 'copy_template_canvas'
90: ,p_hook_type => 'BP'
91: );
92: end;
157: ,p_template_canvas_id_from => p_template_canvas_id_from
158: ,p_template_window_id => p_template_window_id
159: );
160: exception
161: when hr_api.cannot_find_prog_unit then
162: hr_api.cannot_find_prog_unit_error
163: (p_module_name => 'copy_template_canvas'
164: ,p_hook_type => 'AP'
165: );
158: ,p_template_window_id => p_template_window_id
159: );
160: exception
161: when hr_api.cannot_find_prog_unit then
162: hr_api.cannot_find_prog_unit_error
163: (p_module_name => 'copy_template_canvas'
164: ,p_hook_type => 'AP'
165: );
166: end;
169: --
170: hr_utility.set_location('At:'|| l_proc, 45);
171:
172: if p_validate then
173: raise hr_api.validate_enabled;
174: end if;
175: --
176: -- Set all output arguments
177: --
179: p_object_version_number := l_object_version_number;
180: --
181: hr_utility.set_location(' Leaving:'||l_proc, 70);
182: exception
183: when hr_api.validate_enabled then
184: --
185: -- As the Validate_Enabled exception has been raised
186: -- we must rollback to the savepoint
187: --
213: procedure create_template_canvas
214: (p_validate in boolean default false
215: ,p_effective_date in date
216: -- ask john
217: --,p_language_code in varchar2 default hr_api.userenv_lang
218: ,p_template_window_id in number
219: ,p_form_canvas_id in number
220: ,p_height in number default hr_api.g_number
221: ,p_visible in number default hr_api.g_number
216: -- ask john
217: --,p_language_code in varchar2 default hr_api.userenv_lang
218: ,p_template_window_id in number
219: ,p_form_canvas_id in number
220: ,p_height in number default hr_api.g_number
221: ,p_visible in number default hr_api.g_number
222: ,p_width in number default hr_api.g_number
223: ,p_x_position in number default hr_api.g_number
224: ,p_y_position in number default hr_api.g_number
217: --,p_language_code in varchar2 default hr_api.userenv_lang
218: ,p_template_window_id in number
219: ,p_form_canvas_id in number
220: ,p_height in number default hr_api.g_number
221: ,p_visible in number default hr_api.g_number
222: ,p_width in number default hr_api.g_number
223: ,p_x_position in number default hr_api.g_number
224: ,p_y_position in number default hr_api.g_number
225: ,p_information_category in varchar2 default hr_api.g_varchar2
218: ,p_template_window_id in number
219: ,p_form_canvas_id in number
220: ,p_height in number default hr_api.g_number
221: ,p_visible in number default hr_api.g_number
222: ,p_width in number default hr_api.g_number
223: ,p_x_position in number default hr_api.g_number
224: ,p_y_position in number default hr_api.g_number
225: ,p_information_category in varchar2 default hr_api.g_varchar2
226: ,p_information1 in varchar2 default hr_api.g_varchar2
219: ,p_form_canvas_id in number
220: ,p_height in number default hr_api.g_number
221: ,p_visible in number default hr_api.g_number
222: ,p_width in number default hr_api.g_number
223: ,p_x_position in number default hr_api.g_number
224: ,p_y_position in number default hr_api.g_number
225: ,p_information_category in varchar2 default hr_api.g_varchar2
226: ,p_information1 in varchar2 default hr_api.g_varchar2
227: ,p_information2 in varchar2 default hr_api.g_varchar2
220: ,p_height in number default hr_api.g_number
221: ,p_visible in number default hr_api.g_number
222: ,p_width in number default hr_api.g_number
223: ,p_x_position in number default hr_api.g_number
224: ,p_y_position in number default hr_api.g_number
225: ,p_information_category in varchar2 default hr_api.g_varchar2
226: ,p_information1 in varchar2 default hr_api.g_varchar2
227: ,p_information2 in varchar2 default hr_api.g_varchar2
228: ,p_information3 in varchar2 default hr_api.g_varchar2
221: ,p_visible in number default hr_api.g_number
222: ,p_width in number default hr_api.g_number
223: ,p_x_position in number default hr_api.g_number
224: ,p_y_position in number default hr_api.g_number
225: ,p_information_category in varchar2 default hr_api.g_varchar2
226: ,p_information1 in varchar2 default hr_api.g_varchar2
227: ,p_information2 in varchar2 default hr_api.g_varchar2
228: ,p_information3 in varchar2 default hr_api.g_varchar2
229: ,p_information4 in varchar2 default hr_api.g_varchar2
222: ,p_width in number default hr_api.g_number
223: ,p_x_position in number default hr_api.g_number
224: ,p_y_position in number default hr_api.g_number
225: ,p_information_category in varchar2 default hr_api.g_varchar2
226: ,p_information1 in varchar2 default hr_api.g_varchar2
227: ,p_information2 in varchar2 default hr_api.g_varchar2
228: ,p_information3 in varchar2 default hr_api.g_varchar2
229: ,p_information4 in varchar2 default hr_api.g_varchar2
230: ,p_information5 in varchar2 default hr_api.g_varchar2
223: ,p_x_position in number default hr_api.g_number
224: ,p_y_position in number default hr_api.g_number
225: ,p_information_category in varchar2 default hr_api.g_varchar2
226: ,p_information1 in varchar2 default hr_api.g_varchar2
227: ,p_information2 in varchar2 default hr_api.g_varchar2
228: ,p_information3 in varchar2 default hr_api.g_varchar2
229: ,p_information4 in varchar2 default hr_api.g_varchar2
230: ,p_information5 in varchar2 default hr_api.g_varchar2
231: ,p_information6 in varchar2 default hr_api.g_varchar2
224: ,p_y_position in number default hr_api.g_number
225: ,p_information_category in varchar2 default hr_api.g_varchar2
226: ,p_information1 in varchar2 default hr_api.g_varchar2
227: ,p_information2 in varchar2 default hr_api.g_varchar2
228: ,p_information3 in varchar2 default hr_api.g_varchar2
229: ,p_information4 in varchar2 default hr_api.g_varchar2
230: ,p_information5 in varchar2 default hr_api.g_varchar2
231: ,p_information6 in varchar2 default hr_api.g_varchar2
232: ,p_information7 in varchar2 default hr_api.g_varchar2
225: ,p_information_category in varchar2 default hr_api.g_varchar2
226: ,p_information1 in varchar2 default hr_api.g_varchar2
227: ,p_information2 in varchar2 default hr_api.g_varchar2
228: ,p_information3 in varchar2 default hr_api.g_varchar2
229: ,p_information4 in varchar2 default hr_api.g_varchar2
230: ,p_information5 in varchar2 default hr_api.g_varchar2
231: ,p_information6 in varchar2 default hr_api.g_varchar2
232: ,p_information7 in varchar2 default hr_api.g_varchar2
233: ,p_information8 in varchar2 default hr_api.g_varchar2
226: ,p_information1 in varchar2 default hr_api.g_varchar2
227: ,p_information2 in varchar2 default hr_api.g_varchar2
228: ,p_information3 in varchar2 default hr_api.g_varchar2
229: ,p_information4 in varchar2 default hr_api.g_varchar2
230: ,p_information5 in varchar2 default hr_api.g_varchar2
231: ,p_information6 in varchar2 default hr_api.g_varchar2
232: ,p_information7 in varchar2 default hr_api.g_varchar2
233: ,p_information8 in varchar2 default hr_api.g_varchar2
234: ,p_information9 in varchar2 default hr_api.g_varchar2
227: ,p_information2 in varchar2 default hr_api.g_varchar2
228: ,p_information3 in varchar2 default hr_api.g_varchar2
229: ,p_information4 in varchar2 default hr_api.g_varchar2
230: ,p_information5 in varchar2 default hr_api.g_varchar2
231: ,p_information6 in varchar2 default hr_api.g_varchar2
232: ,p_information7 in varchar2 default hr_api.g_varchar2
233: ,p_information8 in varchar2 default hr_api.g_varchar2
234: ,p_information9 in varchar2 default hr_api.g_varchar2
235: ,p_information10 in varchar2 default hr_api.g_varchar2
228: ,p_information3 in varchar2 default hr_api.g_varchar2
229: ,p_information4 in varchar2 default hr_api.g_varchar2
230: ,p_information5 in varchar2 default hr_api.g_varchar2
231: ,p_information6 in varchar2 default hr_api.g_varchar2
232: ,p_information7 in varchar2 default hr_api.g_varchar2
233: ,p_information8 in varchar2 default hr_api.g_varchar2
234: ,p_information9 in varchar2 default hr_api.g_varchar2
235: ,p_information10 in varchar2 default hr_api.g_varchar2
236: ,p_information11 in varchar2 default hr_api.g_varchar2
229: ,p_information4 in varchar2 default hr_api.g_varchar2
230: ,p_information5 in varchar2 default hr_api.g_varchar2
231: ,p_information6 in varchar2 default hr_api.g_varchar2
232: ,p_information7 in varchar2 default hr_api.g_varchar2
233: ,p_information8 in varchar2 default hr_api.g_varchar2
234: ,p_information9 in varchar2 default hr_api.g_varchar2
235: ,p_information10 in varchar2 default hr_api.g_varchar2
236: ,p_information11 in varchar2 default hr_api.g_varchar2
237: ,p_information12 in varchar2 default hr_api.g_varchar2
230: ,p_information5 in varchar2 default hr_api.g_varchar2
231: ,p_information6 in varchar2 default hr_api.g_varchar2
232: ,p_information7 in varchar2 default hr_api.g_varchar2
233: ,p_information8 in varchar2 default hr_api.g_varchar2
234: ,p_information9 in varchar2 default hr_api.g_varchar2
235: ,p_information10 in varchar2 default hr_api.g_varchar2
236: ,p_information11 in varchar2 default hr_api.g_varchar2
237: ,p_information12 in varchar2 default hr_api.g_varchar2
238: ,p_information13 in varchar2 default hr_api.g_varchar2
231: ,p_information6 in varchar2 default hr_api.g_varchar2
232: ,p_information7 in varchar2 default hr_api.g_varchar2
233: ,p_information8 in varchar2 default hr_api.g_varchar2
234: ,p_information9 in varchar2 default hr_api.g_varchar2
235: ,p_information10 in varchar2 default hr_api.g_varchar2
236: ,p_information11 in varchar2 default hr_api.g_varchar2
237: ,p_information12 in varchar2 default hr_api.g_varchar2
238: ,p_information13 in varchar2 default hr_api.g_varchar2
239: ,p_information14 in varchar2 default hr_api.g_varchar2
232: ,p_information7 in varchar2 default hr_api.g_varchar2
233: ,p_information8 in varchar2 default hr_api.g_varchar2
234: ,p_information9 in varchar2 default hr_api.g_varchar2
235: ,p_information10 in varchar2 default hr_api.g_varchar2
236: ,p_information11 in varchar2 default hr_api.g_varchar2
237: ,p_information12 in varchar2 default hr_api.g_varchar2
238: ,p_information13 in varchar2 default hr_api.g_varchar2
239: ,p_information14 in varchar2 default hr_api.g_varchar2
240: ,p_information15 in varchar2 default hr_api.g_varchar2
233: ,p_information8 in varchar2 default hr_api.g_varchar2
234: ,p_information9 in varchar2 default hr_api.g_varchar2
235: ,p_information10 in varchar2 default hr_api.g_varchar2
236: ,p_information11 in varchar2 default hr_api.g_varchar2
237: ,p_information12 in varchar2 default hr_api.g_varchar2
238: ,p_information13 in varchar2 default hr_api.g_varchar2
239: ,p_information14 in varchar2 default hr_api.g_varchar2
240: ,p_information15 in varchar2 default hr_api.g_varchar2
241: ,p_information16 in varchar2 default hr_api.g_varchar2
234: ,p_information9 in varchar2 default hr_api.g_varchar2
235: ,p_information10 in varchar2 default hr_api.g_varchar2
236: ,p_information11 in varchar2 default hr_api.g_varchar2
237: ,p_information12 in varchar2 default hr_api.g_varchar2
238: ,p_information13 in varchar2 default hr_api.g_varchar2
239: ,p_information14 in varchar2 default hr_api.g_varchar2
240: ,p_information15 in varchar2 default hr_api.g_varchar2
241: ,p_information16 in varchar2 default hr_api.g_varchar2
242: ,p_information17 in varchar2 default hr_api.g_varchar2
235: ,p_information10 in varchar2 default hr_api.g_varchar2
236: ,p_information11 in varchar2 default hr_api.g_varchar2
237: ,p_information12 in varchar2 default hr_api.g_varchar2
238: ,p_information13 in varchar2 default hr_api.g_varchar2
239: ,p_information14 in varchar2 default hr_api.g_varchar2
240: ,p_information15 in varchar2 default hr_api.g_varchar2
241: ,p_information16 in varchar2 default hr_api.g_varchar2
242: ,p_information17 in varchar2 default hr_api.g_varchar2
243: ,p_information18 in varchar2 default hr_api.g_varchar2
236: ,p_information11 in varchar2 default hr_api.g_varchar2
237: ,p_information12 in varchar2 default hr_api.g_varchar2
238: ,p_information13 in varchar2 default hr_api.g_varchar2
239: ,p_information14 in varchar2 default hr_api.g_varchar2
240: ,p_information15 in varchar2 default hr_api.g_varchar2
241: ,p_information16 in varchar2 default hr_api.g_varchar2
242: ,p_information17 in varchar2 default hr_api.g_varchar2
243: ,p_information18 in varchar2 default hr_api.g_varchar2
244: ,p_information19 in varchar2 default hr_api.g_varchar2
237: ,p_information12 in varchar2 default hr_api.g_varchar2
238: ,p_information13 in varchar2 default hr_api.g_varchar2
239: ,p_information14 in varchar2 default hr_api.g_varchar2
240: ,p_information15 in varchar2 default hr_api.g_varchar2
241: ,p_information16 in varchar2 default hr_api.g_varchar2
242: ,p_information17 in varchar2 default hr_api.g_varchar2
243: ,p_information18 in varchar2 default hr_api.g_varchar2
244: ,p_information19 in varchar2 default hr_api.g_varchar2
245: ,p_information20 in varchar2 default hr_api.g_varchar2
238: ,p_information13 in varchar2 default hr_api.g_varchar2
239: ,p_information14 in varchar2 default hr_api.g_varchar2
240: ,p_information15 in varchar2 default hr_api.g_varchar2
241: ,p_information16 in varchar2 default hr_api.g_varchar2
242: ,p_information17 in varchar2 default hr_api.g_varchar2
243: ,p_information18 in varchar2 default hr_api.g_varchar2
244: ,p_information19 in varchar2 default hr_api.g_varchar2
245: ,p_information20 in varchar2 default hr_api.g_varchar2
246: ,p_information21 in varchar2 default hr_api.g_varchar2
239: ,p_information14 in varchar2 default hr_api.g_varchar2
240: ,p_information15 in varchar2 default hr_api.g_varchar2
241: ,p_information16 in varchar2 default hr_api.g_varchar2
242: ,p_information17 in varchar2 default hr_api.g_varchar2
243: ,p_information18 in varchar2 default hr_api.g_varchar2
244: ,p_information19 in varchar2 default hr_api.g_varchar2
245: ,p_information20 in varchar2 default hr_api.g_varchar2
246: ,p_information21 in varchar2 default hr_api.g_varchar2
247: ,p_information22 in varchar2 default hr_api.g_varchar2
240: ,p_information15 in varchar2 default hr_api.g_varchar2
241: ,p_information16 in varchar2 default hr_api.g_varchar2
242: ,p_information17 in varchar2 default hr_api.g_varchar2
243: ,p_information18 in varchar2 default hr_api.g_varchar2
244: ,p_information19 in varchar2 default hr_api.g_varchar2
245: ,p_information20 in varchar2 default hr_api.g_varchar2
246: ,p_information21 in varchar2 default hr_api.g_varchar2
247: ,p_information22 in varchar2 default hr_api.g_varchar2
248: ,p_information23 in varchar2 default hr_api.g_varchar2
241: ,p_information16 in varchar2 default hr_api.g_varchar2
242: ,p_information17 in varchar2 default hr_api.g_varchar2
243: ,p_information18 in varchar2 default hr_api.g_varchar2
244: ,p_information19 in varchar2 default hr_api.g_varchar2
245: ,p_information20 in varchar2 default hr_api.g_varchar2
246: ,p_information21 in varchar2 default hr_api.g_varchar2
247: ,p_information22 in varchar2 default hr_api.g_varchar2
248: ,p_information23 in varchar2 default hr_api.g_varchar2
249: ,p_information24 in varchar2 default hr_api.g_varchar2
242: ,p_information17 in varchar2 default hr_api.g_varchar2
243: ,p_information18 in varchar2 default hr_api.g_varchar2
244: ,p_information19 in varchar2 default hr_api.g_varchar2
245: ,p_information20 in varchar2 default hr_api.g_varchar2
246: ,p_information21 in varchar2 default hr_api.g_varchar2
247: ,p_information22 in varchar2 default hr_api.g_varchar2
248: ,p_information23 in varchar2 default hr_api.g_varchar2
249: ,p_information24 in varchar2 default hr_api.g_varchar2
250: ,p_information25 in varchar2 default hr_api.g_varchar2
243: ,p_information18 in varchar2 default hr_api.g_varchar2
244: ,p_information19 in varchar2 default hr_api.g_varchar2
245: ,p_information20 in varchar2 default hr_api.g_varchar2
246: ,p_information21 in varchar2 default hr_api.g_varchar2
247: ,p_information22 in varchar2 default hr_api.g_varchar2
248: ,p_information23 in varchar2 default hr_api.g_varchar2
249: ,p_information24 in varchar2 default hr_api.g_varchar2
250: ,p_information25 in varchar2 default hr_api.g_varchar2
251: ,p_information26 in varchar2 default hr_api.g_varchar2
244: ,p_information19 in varchar2 default hr_api.g_varchar2
245: ,p_information20 in varchar2 default hr_api.g_varchar2
246: ,p_information21 in varchar2 default hr_api.g_varchar2
247: ,p_information22 in varchar2 default hr_api.g_varchar2
248: ,p_information23 in varchar2 default hr_api.g_varchar2
249: ,p_information24 in varchar2 default hr_api.g_varchar2
250: ,p_information25 in varchar2 default hr_api.g_varchar2
251: ,p_information26 in varchar2 default hr_api.g_varchar2
252: ,p_information27 in varchar2 default hr_api.g_varchar2
245: ,p_information20 in varchar2 default hr_api.g_varchar2
246: ,p_information21 in varchar2 default hr_api.g_varchar2
247: ,p_information22 in varchar2 default hr_api.g_varchar2
248: ,p_information23 in varchar2 default hr_api.g_varchar2
249: ,p_information24 in varchar2 default hr_api.g_varchar2
250: ,p_information25 in varchar2 default hr_api.g_varchar2
251: ,p_information26 in varchar2 default hr_api.g_varchar2
252: ,p_information27 in varchar2 default hr_api.g_varchar2
253: ,p_information28 in varchar2 default hr_api.g_varchar2
246: ,p_information21 in varchar2 default hr_api.g_varchar2
247: ,p_information22 in varchar2 default hr_api.g_varchar2
248: ,p_information23 in varchar2 default hr_api.g_varchar2
249: ,p_information24 in varchar2 default hr_api.g_varchar2
250: ,p_information25 in varchar2 default hr_api.g_varchar2
251: ,p_information26 in varchar2 default hr_api.g_varchar2
252: ,p_information27 in varchar2 default hr_api.g_varchar2
253: ,p_information28 in varchar2 default hr_api.g_varchar2
254: ,p_information29 in varchar2 default hr_api.g_varchar2
247: ,p_information22 in varchar2 default hr_api.g_varchar2
248: ,p_information23 in varchar2 default hr_api.g_varchar2
249: ,p_information24 in varchar2 default hr_api.g_varchar2
250: ,p_information25 in varchar2 default hr_api.g_varchar2
251: ,p_information26 in varchar2 default hr_api.g_varchar2
252: ,p_information27 in varchar2 default hr_api.g_varchar2
253: ,p_information28 in varchar2 default hr_api.g_varchar2
254: ,p_information29 in varchar2 default hr_api.g_varchar2
255: ,p_information30 in varchar2 default hr_api.g_varchar2
248: ,p_information23 in varchar2 default hr_api.g_varchar2
249: ,p_information24 in varchar2 default hr_api.g_varchar2
250: ,p_information25 in varchar2 default hr_api.g_varchar2
251: ,p_information26 in varchar2 default hr_api.g_varchar2
252: ,p_information27 in varchar2 default hr_api.g_varchar2
253: ,p_information28 in varchar2 default hr_api.g_varchar2
254: ,p_information29 in varchar2 default hr_api.g_varchar2
255: ,p_information30 in varchar2 default hr_api.g_varchar2
256: ,p_template_canvas_id out nocopy number
249: ,p_information24 in varchar2 default hr_api.g_varchar2
250: ,p_information25 in varchar2 default hr_api.g_varchar2
251: ,p_information26 in varchar2 default hr_api.g_varchar2
252: ,p_information27 in varchar2 default hr_api.g_varchar2
253: ,p_information28 in varchar2 default hr_api.g_varchar2
254: ,p_information29 in varchar2 default hr_api.g_varchar2
255: ,p_information30 in varchar2 default hr_api.g_varchar2
256: ,p_template_canvas_id out nocopy number
257: ,p_object_version_number out nocopy number
250: ,p_information25 in varchar2 default hr_api.g_varchar2
251: ,p_information26 in varchar2 default hr_api.g_varchar2
252: ,p_information27 in varchar2 default hr_api.g_varchar2
253: ,p_information28 in varchar2 default hr_api.g_varchar2
254: ,p_information29 in varchar2 default hr_api.g_varchar2
255: ,p_information30 in varchar2 default hr_api.g_varchar2
256: ,p_template_canvas_id out nocopy number
257: ,p_object_version_number out nocopy number
258: ) is
251: ,p_information26 in varchar2 default hr_api.g_varchar2
252: ,p_information27 in varchar2 default hr_api.g_varchar2
253: ,p_information28 in varchar2 default hr_api.g_varchar2
254: ,p_information29 in varchar2 default hr_api.g_varchar2
255: ,p_information30 in varchar2 default hr_api.g_varchar2
256: ,p_template_canvas_id out nocopy number
257: ,p_object_version_number out nocopy number
258: ) is
259: --
267: WHERE fcn.form_canvas_id = p_form_canvas_id;
268:
269: CURSOR cur_tmplt_window
270: IS
271: SELECT DECODE(p_height,hr_api.g_number,twn.height,p_height)
272: ,DECODE(p_width,hr_api.g_number,twn.width,p_width)
273: FROM hr_template_windows twn
274: WHERE twn.template_window_id = p_template_window_id;
275:
268:
269: CURSOR cur_tmplt_window
270: IS
271: SELECT DECODE(p_height,hr_api.g_number,twn.height,p_height)
272: ,DECODE(p_width,hr_api.g_number,twn.width,p_width)
273: FROM hr_template_windows twn
274: WHERE twn.template_window_id = p_template_window_id;
275:
276: l_temp number;
344: ,p_information28 => p_information28
345: ,p_information29 => p_information29
346: ,p_information30 => p_information30);
347: exception
348: when hr_api.cannot_find_prog_unit then
349: hr_api.cannot_find_prog_unit_error
350: (p_module_name => 'create_template_canvas'
351: ,p_hook_type => 'BP'
352: );
345: ,p_information29 => p_information29
346: ,p_information30 => p_information30);
347: exception
348: when hr_api.cannot_find_prog_unit then
349: hr_api.cannot_find_prog_unit_error
350: (p_module_name => 'create_template_canvas'
351: ,p_hook_type => 'BP'
352: );
353: end;
490: ,p_information30 => p_information30
491: ,p_template_canvas_id => p_template_canvas_id
492: ,p_object_version_number => p_object_version_number);
493: exception
494: when hr_api.cannot_find_prog_unit then
495: hr_api.cannot_find_prog_unit_error
496: (p_module_name => 'create_template_canvas'
497: ,p_hook_type => 'AP'
498: );
491: ,p_template_canvas_id => p_template_canvas_id
492: ,p_object_version_number => p_object_version_number);
493: exception
494: when hr_api.cannot_find_prog_unit then
495: hr_api.cannot_find_prog_unit_error
496: (p_module_name => 'create_template_canvas'
497: ,p_hook_type => 'AP'
498: );
499: end;
502: --
503: hr_utility.set_location('At:'|| l_proc, 45);
504:
505: if p_validate then
506: raise hr_api.validate_enabled;
507: end if;
508: --
509: -- Set all output arguments
510: --
512: p_object_version_number := l_object_version_number;
513: --
514: hr_utility.set_location(' Leaving:'||l_proc, 70);
515: exception
516: when hr_api.validate_enabled then
517: --
518: -- As the Validate_Enabled exception has been raised
519: -- we must rollback to the savepoint
520: --
587: ,p_delete_children_flag => p_delete_children_flag
588: ,p_object_version_number => p_object_version_number
589: );
590: exception
591: when hr_api.cannot_find_prog_unit then
592: hr_api.cannot_find_prog_unit_error
593: (p_module_name => 'delete_template_canvas'
594: ,p_hook_type => 'BP'
595: );
588: ,p_object_version_number => p_object_version_number
589: );
590: exception
591: when hr_api.cannot_find_prog_unit then
592: hr_api.cannot_find_prog_unit_error
593: (p_module_name => 'delete_template_canvas'
594: ,p_hook_type => 'BP'
595: );
596: end;
653: ,p_delete_children_flag => p_delete_children_flag
654: ,p_object_version_number => p_object_version_number
655: );
656: exception
657: when hr_api.cannot_find_prog_unit then
658: hr_api.cannot_find_prog_unit_error
659: (p_module_name => 'delete_template_canvas'
660: ,p_hook_type => 'AP'
661: );
654: ,p_object_version_number => p_object_version_number
655: );
656: exception
657: when hr_api.cannot_find_prog_unit then
658: hr_api.cannot_find_prog_unit_error
659: (p_module_name => 'delete_template_canvas'
660: ,p_hook_type => 'AP'
661: );
662: end;
665: --
666: hr_utility.set_location('At:'|| l_proc, 45);
667:
668: if p_validate then
669: raise hr_api.validate_enabled;
670: end if;
671: --
672: hr_utility.set_location(' Leaving:'||l_proc, 70);
673: exception
670: end if;
671: --
672: hr_utility.set_location(' Leaving:'||l_proc, 70);
673: exception
674: when hr_api.validate_enabled then
675: --
676: -- As the Validate_Enabled exception has been raised
677: -- we must rollback to the savepoint
678: --
699: procedure update_template_canvas
700: (p_validate in boolean default false
701: ,p_effective_date in date
702: -- ask john
703: --,p_language_code in varchar2 default hr_api.userenv_lang
704: ,p_template_canvas_id in number
705: ,p_object_version_number in out nocopy number
706: ,p_height in number default hr_api.g_number
707: ,p_visible in number default hr_api.g_number
702: -- ask john
703: --,p_language_code in varchar2 default hr_api.userenv_lang
704: ,p_template_canvas_id in number
705: ,p_object_version_number in out nocopy number
706: ,p_height in number default hr_api.g_number
707: ,p_visible in number default hr_api.g_number
708: ,p_width in number default hr_api.g_number
709: ,p_x_position in number default hr_api.g_number
710: ,p_y_position in number default hr_api.g_number
703: --,p_language_code in varchar2 default hr_api.userenv_lang
704: ,p_template_canvas_id in number
705: ,p_object_version_number in out nocopy number
706: ,p_height in number default hr_api.g_number
707: ,p_visible in number default hr_api.g_number
708: ,p_width in number default hr_api.g_number
709: ,p_x_position in number default hr_api.g_number
710: ,p_y_position in number default hr_api.g_number
711: ,p_information_category in varchar2 default hr_api.g_varchar2
704: ,p_template_canvas_id in number
705: ,p_object_version_number in out nocopy number
706: ,p_height in number default hr_api.g_number
707: ,p_visible in number default hr_api.g_number
708: ,p_width in number default hr_api.g_number
709: ,p_x_position in number default hr_api.g_number
710: ,p_y_position in number default hr_api.g_number
711: ,p_information_category in varchar2 default hr_api.g_varchar2
712: ,p_information1 in varchar2 default hr_api.g_varchar2
705: ,p_object_version_number in out nocopy number
706: ,p_height in number default hr_api.g_number
707: ,p_visible in number default hr_api.g_number
708: ,p_width in number default hr_api.g_number
709: ,p_x_position in number default hr_api.g_number
710: ,p_y_position in number default hr_api.g_number
711: ,p_information_category in varchar2 default hr_api.g_varchar2
712: ,p_information1 in varchar2 default hr_api.g_varchar2
713: ,p_information2 in varchar2 default hr_api.g_varchar2
706: ,p_height in number default hr_api.g_number
707: ,p_visible in number default hr_api.g_number
708: ,p_width in number default hr_api.g_number
709: ,p_x_position in number default hr_api.g_number
710: ,p_y_position in number default hr_api.g_number
711: ,p_information_category in varchar2 default hr_api.g_varchar2
712: ,p_information1 in varchar2 default hr_api.g_varchar2
713: ,p_information2 in varchar2 default hr_api.g_varchar2
714: ,p_information3 in varchar2 default hr_api.g_varchar2
707: ,p_visible in number default hr_api.g_number
708: ,p_width in number default hr_api.g_number
709: ,p_x_position in number default hr_api.g_number
710: ,p_y_position in number default hr_api.g_number
711: ,p_information_category in varchar2 default hr_api.g_varchar2
712: ,p_information1 in varchar2 default hr_api.g_varchar2
713: ,p_information2 in varchar2 default hr_api.g_varchar2
714: ,p_information3 in varchar2 default hr_api.g_varchar2
715: ,p_information4 in varchar2 default hr_api.g_varchar2
708: ,p_width in number default hr_api.g_number
709: ,p_x_position in number default hr_api.g_number
710: ,p_y_position in number default hr_api.g_number
711: ,p_information_category in varchar2 default hr_api.g_varchar2
712: ,p_information1 in varchar2 default hr_api.g_varchar2
713: ,p_information2 in varchar2 default hr_api.g_varchar2
714: ,p_information3 in varchar2 default hr_api.g_varchar2
715: ,p_information4 in varchar2 default hr_api.g_varchar2
716: ,p_information5 in varchar2 default hr_api.g_varchar2
709: ,p_x_position in number default hr_api.g_number
710: ,p_y_position in number default hr_api.g_number
711: ,p_information_category in varchar2 default hr_api.g_varchar2
712: ,p_information1 in varchar2 default hr_api.g_varchar2
713: ,p_information2 in varchar2 default hr_api.g_varchar2
714: ,p_information3 in varchar2 default hr_api.g_varchar2
715: ,p_information4 in varchar2 default hr_api.g_varchar2
716: ,p_information5 in varchar2 default hr_api.g_varchar2
717: ,p_information6 in varchar2 default hr_api.g_varchar2
710: ,p_y_position in number default hr_api.g_number
711: ,p_information_category in varchar2 default hr_api.g_varchar2
712: ,p_information1 in varchar2 default hr_api.g_varchar2
713: ,p_information2 in varchar2 default hr_api.g_varchar2
714: ,p_information3 in varchar2 default hr_api.g_varchar2
715: ,p_information4 in varchar2 default hr_api.g_varchar2
716: ,p_information5 in varchar2 default hr_api.g_varchar2
717: ,p_information6 in varchar2 default hr_api.g_varchar2
718: ,p_information7 in varchar2 default hr_api.g_varchar2
711: ,p_information_category in varchar2 default hr_api.g_varchar2
712: ,p_information1 in varchar2 default hr_api.g_varchar2
713: ,p_information2 in varchar2 default hr_api.g_varchar2
714: ,p_information3 in varchar2 default hr_api.g_varchar2
715: ,p_information4 in varchar2 default hr_api.g_varchar2
716: ,p_information5 in varchar2 default hr_api.g_varchar2
717: ,p_information6 in varchar2 default hr_api.g_varchar2
718: ,p_information7 in varchar2 default hr_api.g_varchar2
719: ,p_information8 in varchar2 default hr_api.g_varchar2
712: ,p_information1 in varchar2 default hr_api.g_varchar2
713: ,p_information2 in varchar2 default hr_api.g_varchar2
714: ,p_information3 in varchar2 default hr_api.g_varchar2
715: ,p_information4 in varchar2 default hr_api.g_varchar2
716: ,p_information5 in varchar2 default hr_api.g_varchar2
717: ,p_information6 in varchar2 default hr_api.g_varchar2
718: ,p_information7 in varchar2 default hr_api.g_varchar2
719: ,p_information8 in varchar2 default hr_api.g_varchar2
720: ,p_information9 in varchar2 default hr_api.g_varchar2
713: ,p_information2 in varchar2 default hr_api.g_varchar2
714: ,p_information3 in varchar2 default hr_api.g_varchar2
715: ,p_information4 in varchar2 default hr_api.g_varchar2
716: ,p_information5 in varchar2 default hr_api.g_varchar2
717: ,p_information6 in varchar2 default hr_api.g_varchar2
718: ,p_information7 in varchar2 default hr_api.g_varchar2
719: ,p_information8 in varchar2 default hr_api.g_varchar2
720: ,p_information9 in varchar2 default hr_api.g_varchar2
721: ,p_information10 in varchar2 default hr_api.g_varchar2
714: ,p_information3 in varchar2 default hr_api.g_varchar2
715: ,p_information4 in varchar2 default hr_api.g_varchar2
716: ,p_information5 in varchar2 default hr_api.g_varchar2
717: ,p_information6 in varchar2 default hr_api.g_varchar2
718: ,p_information7 in varchar2 default hr_api.g_varchar2
719: ,p_information8 in varchar2 default hr_api.g_varchar2
720: ,p_information9 in varchar2 default hr_api.g_varchar2
721: ,p_information10 in varchar2 default hr_api.g_varchar2
722: ,p_information11 in varchar2 default hr_api.g_varchar2
715: ,p_information4 in varchar2 default hr_api.g_varchar2
716: ,p_information5 in varchar2 default hr_api.g_varchar2
717: ,p_information6 in varchar2 default hr_api.g_varchar2
718: ,p_information7 in varchar2 default hr_api.g_varchar2
719: ,p_information8 in varchar2 default hr_api.g_varchar2
720: ,p_information9 in varchar2 default hr_api.g_varchar2
721: ,p_information10 in varchar2 default hr_api.g_varchar2
722: ,p_information11 in varchar2 default hr_api.g_varchar2
723: ,p_information12 in varchar2 default hr_api.g_varchar2
716: ,p_information5 in varchar2 default hr_api.g_varchar2
717: ,p_information6 in varchar2 default hr_api.g_varchar2
718: ,p_information7 in varchar2 default hr_api.g_varchar2
719: ,p_information8 in varchar2 default hr_api.g_varchar2
720: ,p_information9 in varchar2 default hr_api.g_varchar2
721: ,p_information10 in varchar2 default hr_api.g_varchar2
722: ,p_information11 in varchar2 default hr_api.g_varchar2
723: ,p_information12 in varchar2 default hr_api.g_varchar2
724: ,p_information13 in varchar2 default hr_api.g_varchar2
717: ,p_information6 in varchar2 default hr_api.g_varchar2
718: ,p_information7 in varchar2 default hr_api.g_varchar2
719: ,p_information8 in varchar2 default hr_api.g_varchar2
720: ,p_information9 in varchar2 default hr_api.g_varchar2
721: ,p_information10 in varchar2 default hr_api.g_varchar2
722: ,p_information11 in varchar2 default hr_api.g_varchar2
723: ,p_information12 in varchar2 default hr_api.g_varchar2
724: ,p_information13 in varchar2 default hr_api.g_varchar2
725: ,p_information14 in varchar2 default hr_api.g_varchar2
718: ,p_information7 in varchar2 default hr_api.g_varchar2
719: ,p_information8 in varchar2 default hr_api.g_varchar2
720: ,p_information9 in varchar2 default hr_api.g_varchar2
721: ,p_information10 in varchar2 default hr_api.g_varchar2
722: ,p_information11 in varchar2 default hr_api.g_varchar2
723: ,p_information12 in varchar2 default hr_api.g_varchar2
724: ,p_information13 in varchar2 default hr_api.g_varchar2
725: ,p_information14 in varchar2 default hr_api.g_varchar2
726: ,p_information15 in varchar2 default hr_api.g_varchar2
719: ,p_information8 in varchar2 default hr_api.g_varchar2
720: ,p_information9 in varchar2 default hr_api.g_varchar2
721: ,p_information10 in varchar2 default hr_api.g_varchar2
722: ,p_information11 in varchar2 default hr_api.g_varchar2
723: ,p_information12 in varchar2 default hr_api.g_varchar2
724: ,p_information13 in varchar2 default hr_api.g_varchar2
725: ,p_information14 in varchar2 default hr_api.g_varchar2
726: ,p_information15 in varchar2 default hr_api.g_varchar2
727: ,p_information16 in varchar2 default hr_api.g_varchar2
720: ,p_information9 in varchar2 default hr_api.g_varchar2
721: ,p_information10 in varchar2 default hr_api.g_varchar2
722: ,p_information11 in varchar2 default hr_api.g_varchar2
723: ,p_information12 in varchar2 default hr_api.g_varchar2
724: ,p_information13 in varchar2 default hr_api.g_varchar2
725: ,p_information14 in varchar2 default hr_api.g_varchar2
726: ,p_information15 in varchar2 default hr_api.g_varchar2
727: ,p_information16 in varchar2 default hr_api.g_varchar2
728: ,p_information17 in varchar2 default hr_api.g_varchar2
721: ,p_information10 in varchar2 default hr_api.g_varchar2
722: ,p_information11 in varchar2 default hr_api.g_varchar2
723: ,p_information12 in varchar2 default hr_api.g_varchar2
724: ,p_information13 in varchar2 default hr_api.g_varchar2
725: ,p_information14 in varchar2 default hr_api.g_varchar2
726: ,p_information15 in varchar2 default hr_api.g_varchar2
727: ,p_information16 in varchar2 default hr_api.g_varchar2
728: ,p_information17 in varchar2 default hr_api.g_varchar2
729: ,p_information18 in varchar2 default hr_api.g_varchar2
722: ,p_information11 in varchar2 default hr_api.g_varchar2
723: ,p_information12 in varchar2 default hr_api.g_varchar2
724: ,p_information13 in varchar2 default hr_api.g_varchar2
725: ,p_information14 in varchar2 default hr_api.g_varchar2
726: ,p_information15 in varchar2 default hr_api.g_varchar2
727: ,p_information16 in varchar2 default hr_api.g_varchar2
728: ,p_information17 in varchar2 default hr_api.g_varchar2
729: ,p_information18 in varchar2 default hr_api.g_varchar2
730: ,p_information19 in varchar2 default hr_api.g_varchar2
723: ,p_information12 in varchar2 default hr_api.g_varchar2
724: ,p_information13 in varchar2 default hr_api.g_varchar2
725: ,p_information14 in varchar2 default hr_api.g_varchar2
726: ,p_information15 in varchar2 default hr_api.g_varchar2
727: ,p_information16 in varchar2 default hr_api.g_varchar2
728: ,p_information17 in varchar2 default hr_api.g_varchar2
729: ,p_information18 in varchar2 default hr_api.g_varchar2
730: ,p_information19 in varchar2 default hr_api.g_varchar2
731: ,p_information20 in varchar2 default hr_api.g_varchar2
724: ,p_information13 in varchar2 default hr_api.g_varchar2
725: ,p_information14 in varchar2 default hr_api.g_varchar2
726: ,p_information15 in varchar2 default hr_api.g_varchar2
727: ,p_information16 in varchar2 default hr_api.g_varchar2
728: ,p_information17 in varchar2 default hr_api.g_varchar2
729: ,p_information18 in varchar2 default hr_api.g_varchar2
730: ,p_information19 in varchar2 default hr_api.g_varchar2
731: ,p_information20 in varchar2 default hr_api.g_varchar2
732: ,p_information21 in varchar2 default hr_api.g_varchar2
725: ,p_information14 in varchar2 default hr_api.g_varchar2
726: ,p_information15 in varchar2 default hr_api.g_varchar2
727: ,p_information16 in varchar2 default hr_api.g_varchar2
728: ,p_information17 in varchar2 default hr_api.g_varchar2
729: ,p_information18 in varchar2 default hr_api.g_varchar2
730: ,p_information19 in varchar2 default hr_api.g_varchar2
731: ,p_information20 in varchar2 default hr_api.g_varchar2
732: ,p_information21 in varchar2 default hr_api.g_varchar2
733: ,p_information22 in varchar2 default hr_api.g_varchar2
726: ,p_information15 in varchar2 default hr_api.g_varchar2
727: ,p_information16 in varchar2 default hr_api.g_varchar2
728: ,p_information17 in varchar2 default hr_api.g_varchar2
729: ,p_information18 in varchar2 default hr_api.g_varchar2
730: ,p_information19 in varchar2 default hr_api.g_varchar2
731: ,p_information20 in varchar2 default hr_api.g_varchar2
732: ,p_information21 in varchar2 default hr_api.g_varchar2
733: ,p_information22 in varchar2 default hr_api.g_varchar2
734: ,p_information23 in varchar2 default hr_api.g_varchar2
727: ,p_information16 in varchar2 default hr_api.g_varchar2
728: ,p_information17 in varchar2 default hr_api.g_varchar2
729: ,p_information18 in varchar2 default hr_api.g_varchar2
730: ,p_information19 in varchar2 default hr_api.g_varchar2
731: ,p_information20 in varchar2 default hr_api.g_varchar2
732: ,p_information21 in varchar2 default hr_api.g_varchar2
733: ,p_information22 in varchar2 default hr_api.g_varchar2
734: ,p_information23 in varchar2 default hr_api.g_varchar2
735: ,p_information24 in varchar2 default hr_api.g_varchar2
728: ,p_information17 in varchar2 default hr_api.g_varchar2
729: ,p_information18 in varchar2 default hr_api.g_varchar2
730: ,p_information19 in varchar2 default hr_api.g_varchar2
731: ,p_information20 in varchar2 default hr_api.g_varchar2
732: ,p_information21 in varchar2 default hr_api.g_varchar2
733: ,p_information22 in varchar2 default hr_api.g_varchar2
734: ,p_information23 in varchar2 default hr_api.g_varchar2
735: ,p_information24 in varchar2 default hr_api.g_varchar2
736: ,p_information25 in varchar2 default hr_api.g_varchar2
729: ,p_information18 in varchar2 default hr_api.g_varchar2
730: ,p_information19 in varchar2 default hr_api.g_varchar2
731: ,p_information20 in varchar2 default hr_api.g_varchar2
732: ,p_information21 in varchar2 default hr_api.g_varchar2
733: ,p_information22 in varchar2 default hr_api.g_varchar2
734: ,p_information23 in varchar2 default hr_api.g_varchar2
735: ,p_information24 in varchar2 default hr_api.g_varchar2
736: ,p_information25 in varchar2 default hr_api.g_varchar2
737: ,p_information26 in varchar2 default hr_api.g_varchar2
730: ,p_information19 in varchar2 default hr_api.g_varchar2
731: ,p_information20 in varchar2 default hr_api.g_varchar2
732: ,p_information21 in varchar2 default hr_api.g_varchar2
733: ,p_information22 in varchar2 default hr_api.g_varchar2
734: ,p_information23 in varchar2 default hr_api.g_varchar2
735: ,p_information24 in varchar2 default hr_api.g_varchar2
736: ,p_information25 in varchar2 default hr_api.g_varchar2
737: ,p_information26 in varchar2 default hr_api.g_varchar2
738: ,p_information27 in varchar2 default hr_api.g_varchar2
731: ,p_information20 in varchar2 default hr_api.g_varchar2
732: ,p_information21 in varchar2 default hr_api.g_varchar2
733: ,p_information22 in varchar2 default hr_api.g_varchar2
734: ,p_information23 in varchar2 default hr_api.g_varchar2
735: ,p_information24 in varchar2 default hr_api.g_varchar2
736: ,p_information25 in varchar2 default hr_api.g_varchar2
737: ,p_information26 in varchar2 default hr_api.g_varchar2
738: ,p_information27 in varchar2 default hr_api.g_varchar2
739: ,p_information28 in varchar2 default hr_api.g_varchar2
732: ,p_information21 in varchar2 default hr_api.g_varchar2
733: ,p_information22 in varchar2 default hr_api.g_varchar2
734: ,p_information23 in varchar2 default hr_api.g_varchar2
735: ,p_information24 in varchar2 default hr_api.g_varchar2
736: ,p_information25 in varchar2 default hr_api.g_varchar2
737: ,p_information26 in varchar2 default hr_api.g_varchar2
738: ,p_information27 in varchar2 default hr_api.g_varchar2
739: ,p_information28 in varchar2 default hr_api.g_varchar2
740: ,p_information29 in varchar2 default hr_api.g_varchar2
733: ,p_information22 in varchar2 default hr_api.g_varchar2
734: ,p_information23 in varchar2 default hr_api.g_varchar2
735: ,p_information24 in varchar2 default hr_api.g_varchar2
736: ,p_information25 in varchar2 default hr_api.g_varchar2
737: ,p_information26 in varchar2 default hr_api.g_varchar2
738: ,p_information27 in varchar2 default hr_api.g_varchar2
739: ,p_information28 in varchar2 default hr_api.g_varchar2
740: ,p_information29 in varchar2 default hr_api.g_varchar2
741: ,p_information30 in varchar2 default hr_api.g_varchar2
734: ,p_information23 in varchar2 default hr_api.g_varchar2
735: ,p_information24 in varchar2 default hr_api.g_varchar2
736: ,p_information25 in varchar2 default hr_api.g_varchar2
737: ,p_information26 in varchar2 default hr_api.g_varchar2
738: ,p_information27 in varchar2 default hr_api.g_varchar2
739: ,p_information28 in varchar2 default hr_api.g_varchar2
740: ,p_information29 in varchar2 default hr_api.g_varchar2
741: ,p_information30 in varchar2 default hr_api.g_varchar2
742: ) is
735: ,p_information24 in varchar2 default hr_api.g_varchar2
736: ,p_information25 in varchar2 default hr_api.g_varchar2
737: ,p_information26 in varchar2 default hr_api.g_varchar2
738: ,p_information27 in varchar2 default hr_api.g_varchar2
739: ,p_information28 in varchar2 default hr_api.g_varchar2
740: ,p_information29 in varchar2 default hr_api.g_varchar2
741: ,p_information30 in varchar2 default hr_api.g_varchar2
742: ) is
743: --
736: ,p_information25 in varchar2 default hr_api.g_varchar2
737: ,p_information26 in varchar2 default hr_api.g_varchar2
738: ,p_information27 in varchar2 default hr_api.g_varchar2
739: ,p_information28 in varchar2 default hr_api.g_varchar2
740: ,p_information29 in varchar2 default hr_api.g_varchar2
741: ,p_information30 in varchar2 default hr_api.g_varchar2
742: ) is
743: --
744: -- Declare cursors and local variables
737: ,p_information26 in varchar2 default hr_api.g_varchar2
738: ,p_information27 in varchar2 default hr_api.g_varchar2
739: ,p_information28 in varchar2 default hr_api.g_varchar2
740: ,p_information29 in varchar2 default hr_api.g_varchar2
741: ,p_information30 in varchar2 default hr_api.g_varchar2
742: ) is
743: --
744: -- Declare cursors and local variables
745: --
813: ,p_information28 => p_information28
814: ,p_information29 => p_information29
815: ,p_information30 => p_information30);
816: exception
817: when hr_api.cannot_find_prog_unit then
818: hr_api.cannot_find_prog_unit_error
819: (p_module_name => 'update_template_canvas'
820: ,p_hook_type => 'BP'
821: );
814: ,p_information29 => p_information29
815: ,p_information30 => p_information30);
816: exception
817: when hr_api.cannot_find_prog_unit then
818: hr_api.cannot_find_prog_unit_error
819: (p_module_name => 'update_template_canvas'
820: ,p_hook_type => 'BP'
821: );
822: end;
930: ,p_information28 => p_information28
931: ,p_information29 => p_information29
932: ,p_information30 => p_information30);
933: exception
934: when hr_api.cannot_find_prog_unit then
935: hr_api.cannot_find_prog_unit_error
936: (p_module_name => 'update_template_canvas'
937: ,p_hook_type => 'AP'
938: );
931: ,p_information29 => p_information29
932: ,p_information30 => p_information30);
933: exception
934: when hr_api.cannot_find_prog_unit then
935: hr_api.cannot_find_prog_unit_error
936: (p_module_name => 'update_template_canvas'
937: ,p_hook_type => 'AP'
938: );
939: end;
942: --
943: hr_utility.set_location('At:'|| l_proc, 35);
944:
945: if p_validate then
946: raise hr_api.validate_enabled;
947: end if;
948: --
949: -- Set all output arguments
950: --
951: p_object_version_number := l_object_version_number;
952: --
953: hr_utility.set_location(' Leaving:'||l_proc, 70);
954: exception
955: when hr_api.validate_enabled then
956: --
957: -- As the Validate_Enabled exception has been raised
958: -- we must rollback to the savepoint
959: --