11: --
12: procedure copy_template_window
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_window_id_from in number
17: ,p_form_template_id in number
18: ,p_template_window_id_to out nocopy number
19: ,p_object_version_number out nocopy number
67: -- instead of p_language_code from now on, to allow an IN OUT parameter to
68: -- be passed through.
69: --
70: l_language_code := p_language_code;
71: hr_api.validate_language_code(p_language_code => l_language_code);
72: --
73: hr_utility.set_location(l_proc, 20);
74: --
75: --
81: ,p_language_code => l_language_code
82: ,p_template_window_id_from => p_template_window_id_from
83: ,p_form_template_id => p_form_template_id);
84: exception
85: when hr_api.cannot_find_prog_unit then
86: hr_api.cannot_find_prog_unit_error
87: (p_module_name => 'copy_template_window'
88: ,p_hook_type => 'BP'
89: );
82: ,p_template_window_id_from => p_template_window_id_from
83: ,p_form_template_id => p_form_template_id);
84: exception
85: when hr_api.cannot_find_prog_unit then
86: hr_api.cannot_find_prog_unit_error
87: (p_module_name => 'copy_template_window'
88: ,p_hook_type => 'BP'
89: );
90: end;
156: ,p_form_template_id => p_form_template_id
157: ,p_template_window_id_to => l_template_window_id_to
158: ,p_object_version_number => l_object_version_number);
159: exception
160: when hr_api.cannot_find_prog_unit then
161: hr_api.cannot_find_prog_unit_error
162: (p_module_name => 'copy_template_window'
163: ,p_hook_type => 'AP'
164: );
157: ,p_template_window_id_to => l_template_window_id_to
158: ,p_object_version_number => l_object_version_number);
159: exception
160: when hr_api.cannot_find_prog_unit then
161: hr_api.cannot_find_prog_unit_error
162: (p_module_name => 'copy_template_window'
163: ,p_hook_type => 'AP'
164: );
165: end;
166: --
167: -- When in validation only mode raise the Validate_Enabled exception
168: --
169: if p_validate then
170: raise hr_api.validate_enabled;
171: end if;
172: --
173: -- Set all output arguments
174: --
176: p_object_version_number := l_object_version_number;
177: --
178: hr_utility.set_location(' Leaving:'||l_proc, 70);
179: exception
180: when hr_api.validate_enabled then
181: --
182: -- As the Validate_Enabled exception has been raised
183: -- we must rollback to the savepoint
184: --
209: --
210: procedure create_template_window
211: (p_validate in boolean default false
212: ,p_effective_date in date
213: ,p_language_code in varchar2 default hr_api.userenv_lang
214: ,p_form_template_id in number
215: ,p_form_window_id in number
216: ,p_height in number default hr_api.g_number
217: ,p_title in varchar2 default hr_api.g_varchar2
212: ,p_effective_date in date
213: ,p_language_code in varchar2 default hr_api.userenv_lang
214: ,p_form_template_id in number
215: ,p_form_window_id in number
216: ,p_height in number default hr_api.g_number
217: ,p_title in varchar2 default hr_api.g_varchar2
218: ,p_width in number default hr_api.g_number
219: ,p_x_position in number default hr_api.g_number
220: ,p_y_position in number default hr_api.g_number
213: ,p_language_code in varchar2 default hr_api.userenv_lang
214: ,p_form_template_id in number
215: ,p_form_window_id in number
216: ,p_height in number default hr_api.g_number
217: ,p_title in varchar2 default hr_api.g_varchar2
218: ,p_width in number default hr_api.g_number
219: ,p_x_position in number default hr_api.g_number
220: ,p_y_position in number default hr_api.g_number
221: ,p_information_category in varchar2 default hr_api.g_varchar2
214: ,p_form_template_id in number
215: ,p_form_window_id in number
216: ,p_height in number default hr_api.g_number
217: ,p_title in varchar2 default hr_api.g_varchar2
218: ,p_width in number default hr_api.g_number
219: ,p_x_position in number default hr_api.g_number
220: ,p_y_position in number default hr_api.g_number
221: ,p_information_category in varchar2 default hr_api.g_varchar2
222: ,p_information1 in varchar2 default hr_api.g_varchar2
215: ,p_form_window_id in number
216: ,p_height in number default hr_api.g_number
217: ,p_title in varchar2 default hr_api.g_varchar2
218: ,p_width in number default hr_api.g_number
219: ,p_x_position in number default hr_api.g_number
220: ,p_y_position in number default hr_api.g_number
221: ,p_information_category in varchar2 default hr_api.g_varchar2
222: ,p_information1 in varchar2 default hr_api.g_varchar2
223: ,p_information2 in varchar2 default hr_api.g_varchar2
216: ,p_height in number default hr_api.g_number
217: ,p_title in varchar2 default hr_api.g_varchar2
218: ,p_width in number default hr_api.g_number
219: ,p_x_position in number default hr_api.g_number
220: ,p_y_position in number default hr_api.g_number
221: ,p_information_category in varchar2 default hr_api.g_varchar2
222: ,p_information1 in varchar2 default hr_api.g_varchar2
223: ,p_information2 in varchar2 default hr_api.g_varchar2
224: ,p_information3 in varchar2 default hr_api.g_varchar2
217: ,p_title in varchar2 default hr_api.g_varchar2
218: ,p_width in number default hr_api.g_number
219: ,p_x_position in number default hr_api.g_number
220: ,p_y_position in number default hr_api.g_number
221: ,p_information_category in varchar2 default hr_api.g_varchar2
222: ,p_information1 in varchar2 default hr_api.g_varchar2
223: ,p_information2 in varchar2 default hr_api.g_varchar2
224: ,p_information3 in varchar2 default hr_api.g_varchar2
225: ,p_information4 in varchar2 default hr_api.g_varchar2
218: ,p_width in number default hr_api.g_number
219: ,p_x_position in number default hr_api.g_number
220: ,p_y_position in number default hr_api.g_number
221: ,p_information_category in varchar2 default hr_api.g_varchar2
222: ,p_information1 in varchar2 default hr_api.g_varchar2
223: ,p_information2 in varchar2 default hr_api.g_varchar2
224: ,p_information3 in varchar2 default hr_api.g_varchar2
225: ,p_information4 in varchar2 default hr_api.g_varchar2
226: ,p_information5 in varchar2 default hr_api.g_varchar2
219: ,p_x_position in number default hr_api.g_number
220: ,p_y_position in number default hr_api.g_number
221: ,p_information_category in varchar2 default hr_api.g_varchar2
222: ,p_information1 in varchar2 default hr_api.g_varchar2
223: ,p_information2 in varchar2 default hr_api.g_varchar2
224: ,p_information3 in varchar2 default hr_api.g_varchar2
225: ,p_information4 in varchar2 default hr_api.g_varchar2
226: ,p_information5 in varchar2 default hr_api.g_varchar2
227: ,p_information6 in varchar2 default hr_api.g_varchar2
220: ,p_y_position in number default hr_api.g_number
221: ,p_information_category in varchar2 default hr_api.g_varchar2
222: ,p_information1 in varchar2 default hr_api.g_varchar2
223: ,p_information2 in varchar2 default hr_api.g_varchar2
224: ,p_information3 in varchar2 default hr_api.g_varchar2
225: ,p_information4 in varchar2 default hr_api.g_varchar2
226: ,p_information5 in varchar2 default hr_api.g_varchar2
227: ,p_information6 in varchar2 default hr_api.g_varchar2
228: ,p_information7 in varchar2 default hr_api.g_varchar2
221: ,p_information_category in varchar2 default hr_api.g_varchar2
222: ,p_information1 in varchar2 default hr_api.g_varchar2
223: ,p_information2 in varchar2 default hr_api.g_varchar2
224: ,p_information3 in varchar2 default hr_api.g_varchar2
225: ,p_information4 in varchar2 default hr_api.g_varchar2
226: ,p_information5 in varchar2 default hr_api.g_varchar2
227: ,p_information6 in varchar2 default hr_api.g_varchar2
228: ,p_information7 in varchar2 default hr_api.g_varchar2
229: ,p_information8 in varchar2 default hr_api.g_varchar2
222: ,p_information1 in varchar2 default hr_api.g_varchar2
223: ,p_information2 in varchar2 default hr_api.g_varchar2
224: ,p_information3 in varchar2 default hr_api.g_varchar2
225: ,p_information4 in varchar2 default hr_api.g_varchar2
226: ,p_information5 in varchar2 default hr_api.g_varchar2
227: ,p_information6 in varchar2 default hr_api.g_varchar2
228: ,p_information7 in varchar2 default hr_api.g_varchar2
229: ,p_information8 in varchar2 default hr_api.g_varchar2
230: ,p_information9 in varchar2 default hr_api.g_varchar2
223: ,p_information2 in varchar2 default hr_api.g_varchar2
224: ,p_information3 in varchar2 default hr_api.g_varchar2
225: ,p_information4 in varchar2 default hr_api.g_varchar2
226: ,p_information5 in varchar2 default hr_api.g_varchar2
227: ,p_information6 in varchar2 default hr_api.g_varchar2
228: ,p_information7 in varchar2 default hr_api.g_varchar2
229: ,p_information8 in varchar2 default hr_api.g_varchar2
230: ,p_information9 in varchar2 default hr_api.g_varchar2
231: ,p_information10 in varchar2 default hr_api.g_varchar2
224: ,p_information3 in varchar2 default hr_api.g_varchar2
225: ,p_information4 in varchar2 default hr_api.g_varchar2
226: ,p_information5 in varchar2 default hr_api.g_varchar2
227: ,p_information6 in varchar2 default hr_api.g_varchar2
228: ,p_information7 in varchar2 default hr_api.g_varchar2
229: ,p_information8 in varchar2 default hr_api.g_varchar2
230: ,p_information9 in varchar2 default hr_api.g_varchar2
231: ,p_information10 in varchar2 default hr_api.g_varchar2
232: ,p_information11 in varchar2 default hr_api.g_varchar2
225: ,p_information4 in varchar2 default hr_api.g_varchar2
226: ,p_information5 in varchar2 default hr_api.g_varchar2
227: ,p_information6 in varchar2 default hr_api.g_varchar2
228: ,p_information7 in varchar2 default hr_api.g_varchar2
229: ,p_information8 in varchar2 default hr_api.g_varchar2
230: ,p_information9 in varchar2 default hr_api.g_varchar2
231: ,p_information10 in varchar2 default hr_api.g_varchar2
232: ,p_information11 in varchar2 default hr_api.g_varchar2
233: ,p_information12 in varchar2 default hr_api.g_varchar2
226: ,p_information5 in varchar2 default hr_api.g_varchar2
227: ,p_information6 in varchar2 default hr_api.g_varchar2
228: ,p_information7 in varchar2 default hr_api.g_varchar2
229: ,p_information8 in varchar2 default hr_api.g_varchar2
230: ,p_information9 in varchar2 default hr_api.g_varchar2
231: ,p_information10 in varchar2 default hr_api.g_varchar2
232: ,p_information11 in varchar2 default hr_api.g_varchar2
233: ,p_information12 in varchar2 default hr_api.g_varchar2
234: ,p_information13 in varchar2 default hr_api.g_varchar2
227: ,p_information6 in varchar2 default hr_api.g_varchar2
228: ,p_information7 in varchar2 default hr_api.g_varchar2
229: ,p_information8 in varchar2 default hr_api.g_varchar2
230: ,p_information9 in varchar2 default hr_api.g_varchar2
231: ,p_information10 in varchar2 default hr_api.g_varchar2
232: ,p_information11 in varchar2 default hr_api.g_varchar2
233: ,p_information12 in varchar2 default hr_api.g_varchar2
234: ,p_information13 in varchar2 default hr_api.g_varchar2
235: ,p_information14 in varchar2 default hr_api.g_varchar2
228: ,p_information7 in varchar2 default hr_api.g_varchar2
229: ,p_information8 in varchar2 default hr_api.g_varchar2
230: ,p_information9 in varchar2 default hr_api.g_varchar2
231: ,p_information10 in varchar2 default hr_api.g_varchar2
232: ,p_information11 in varchar2 default hr_api.g_varchar2
233: ,p_information12 in varchar2 default hr_api.g_varchar2
234: ,p_information13 in varchar2 default hr_api.g_varchar2
235: ,p_information14 in varchar2 default hr_api.g_varchar2
236: ,p_information15 in varchar2 default hr_api.g_varchar2
229: ,p_information8 in varchar2 default hr_api.g_varchar2
230: ,p_information9 in varchar2 default hr_api.g_varchar2
231: ,p_information10 in varchar2 default hr_api.g_varchar2
232: ,p_information11 in varchar2 default hr_api.g_varchar2
233: ,p_information12 in varchar2 default hr_api.g_varchar2
234: ,p_information13 in varchar2 default hr_api.g_varchar2
235: ,p_information14 in varchar2 default hr_api.g_varchar2
236: ,p_information15 in varchar2 default hr_api.g_varchar2
237: ,p_information16 in varchar2 default hr_api.g_varchar2
230: ,p_information9 in varchar2 default hr_api.g_varchar2
231: ,p_information10 in varchar2 default hr_api.g_varchar2
232: ,p_information11 in varchar2 default hr_api.g_varchar2
233: ,p_information12 in varchar2 default hr_api.g_varchar2
234: ,p_information13 in varchar2 default hr_api.g_varchar2
235: ,p_information14 in varchar2 default hr_api.g_varchar2
236: ,p_information15 in varchar2 default hr_api.g_varchar2
237: ,p_information16 in varchar2 default hr_api.g_varchar2
238: ,p_information17 in varchar2 default hr_api.g_varchar2
231: ,p_information10 in varchar2 default hr_api.g_varchar2
232: ,p_information11 in varchar2 default hr_api.g_varchar2
233: ,p_information12 in varchar2 default hr_api.g_varchar2
234: ,p_information13 in varchar2 default hr_api.g_varchar2
235: ,p_information14 in varchar2 default hr_api.g_varchar2
236: ,p_information15 in varchar2 default hr_api.g_varchar2
237: ,p_information16 in varchar2 default hr_api.g_varchar2
238: ,p_information17 in varchar2 default hr_api.g_varchar2
239: ,p_information18 in varchar2 default hr_api.g_varchar2
232: ,p_information11 in varchar2 default hr_api.g_varchar2
233: ,p_information12 in varchar2 default hr_api.g_varchar2
234: ,p_information13 in varchar2 default hr_api.g_varchar2
235: ,p_information14 in varchar2 default hr_api.g_varchar2
236: ,p_information15 in varchar2 default hr_api.g_varchar2
237: ,p_information16 in varchar2 default hr_api.g_varchar2
238: ,p_information17 in varchar2 default hr_api.g_varchar2
239: ,p_information18 in varchar2 default hr_api.g_varchar2
240: ,p_information19 in varchar2 default hr_api.g_varchar2
233: ,p_information12 in varchar2 default hr_api.g_varchar2
234: ,p_information13 in varchar2 default hr_api.g_varchar2
235: ,p_information14 in varchar2 default hr_api.g_varchar2
236: ,p_information15 in varchar2 default hr_api.g_varchar2
237: ,p_information16 in varchar2 default hr_api.g_varchar2
238: ,p_information17 in varchar2 default hr_api.g_varchar2
239: ,p_information18 in varchar2 default hr_api.g_varchar2
240: ,p_information19 in varchar2 default hr_api.g_varchar2
241: ,p_information20 in varchar2 default hr_api.g_varchar2
234: ,p_information13 in varchar2 default hr_api.g_varchar2
235: ,p_information14 in varchar2 default hr_api.g_varchar2
236: ,p_information15 in varchar2 default hr_api.g_varchar2
237: ,p_information16 in varchar2 default hr_api.g_varchar2
238: ,p_information17 in varchar2 default hr_api.g_varchar2
239: ,p_information18 in varchar2 default hr_api.g_varchar2
240: ,p_information19 in varchar2 default hr_api.g_varchar2
241: ,p_information20 in varchar2 default hr_api.g_varchar2
242: ,p_information21 in varchar2 default hr_api.g_varchar2
235: ,p_information14 in varchar2 default hr_api.g_varchar2
236: ,p_information15 in varchar2 default hr_api.g_varchar2
237: ,p_information16 in varchar2 default hr_api.g_varchar2
238: ,p_information17 in varchar2 default hr_api.g_varchar2
239: ,p_information18 in varchar2 default hr_api.g_varchar2
240: ,p_information19 in varchar2 default hr_api.g_varchar2
241: ,p_information20 in varchar2 default hr_api.g_varchar2
242: ,p_information21 in varchar2 default hr_api.g_varchar2
243: ,p_information22 in varchar2 default hr_api.g_varchar2
236: ,p_information15 in varchar2 default hr_api.g_varchar2
237: ,p_information16 in varchar2 default hr_api.g_varchar2
238: ,p_information17 in varchar2 default hr_api.g_varchar2
239: ,p_information18 in varchar2 default hr_api.g_varchar2
240: ,p_information19 in varchar2 default hr_api.g_varchar2
241: ,p_information20 in varchar2 default hr_api.g_varchar2
242: ,p_information21 in varchar2 default hr_api.g_varchar2
243: ,p_information22 in varchar2 default hr_api.g_varchar2
244: ,p_information23 in varchar2 default hr_api.g_varchar2
237: ,p_information16 in varchar2 default hr_api.g_varchar2
238: ,p_information17 in varchar2 default hr_api.g_varchar2
239: ,p_information18 in varchar2 default hr_api.g_varchar2
240: ,p_information19 in varchar2 default hr_api.g_varchar2
241: ,p_information20 in varchar2 default hr_api.g_varchar2
242: ,p_information21 in varchar2 default hr_api.g_varchar2
243: ,p_information22 in varchar2 default hr_api.g_varchar2
244: ,p_information23 in varchar2 default hr_api.g_varchar2
245: ,p_information24 in varchar2 default hr_api.g_varchar2
238: ,p_information17 in varchar2 default hr_api.g_varchar2
239: ,p_information18 in varchar2 default hr_api.g_varchar2
240: ,p_information19 in varchar2 default hr_api.g_varchar2
241: ,p_information20 in varchar2 default hr_api.g_varchar2
242: ,p_information21 in varchar2 default hr_api.g_varchar2
243: ,p_information22 in varchar2 default hr_api.g_varchar2
244: ,p_information23 in varchar2 default hr_api.g_varchar2
245: ,p_information24 in varchar2 default hr_api.g_varchar2
246: ,p_information25 in varchar2 default hr_api.g_varchar2
239: ,p_information18 in varchar2 default hr_api.g_varchar2
240: ,p_information19 in varchar2 default hr_api.g_varchar2
241: ,p_information20 in varchar2 default hr_api.g_varchar2
242: ,p_information21 in varchar2 default hr_api.g_varchar2
243: ,p_information22 in varchar2 default hr_api.g_varchar2
244: ,p_information23 in varchar2 default hr_api.g_varchar2
245: ,p_information24 in varchar2 default hr_api.g_varchar2
246: ,p_information25 in varchar2 default hr_api.g_varchar2
247: ,p_information26 in varchar2 default hr_api.g_varchar2
240: ,p_information19 in varchar2 default hr_api.g_varchar2
241: ,p_information20 in varchar2 default hr_api.g_varchar2
242: ,p_information21 in varchar2 default hr_api.g_varchar2
243: ,p_information22 in varchar2 default hr_api.g_varchar2
244: ,p_information23 in varchar2 default hr_api.g_varchar2
245: ,p_information24 in varchar2 default hr_api.g_varchar2
246: ,p_information25 in varchar2 default hr_api.g_varchar2
247: ,p_information26 in varchar2 default hr_api.g_varchar2
248: ,p_information27 in varchar2 default hr_api.g_varchar2
241: ,p_information20 in varchar2 default hr_api.g_varchar2
242: ,p_information21 in varchar2 default hr_api.g_varchar2
243: ,p_information22 in varchar2 default hr_api.g_varchar2
244: ,p_information23 in varchar2 default hr_api.g_varchar2
245: ,p_information24 in varchar2 default hr_api.g_varchar2
246: ,p_information25 in varchar2 default hr_api.g_varchar2
247: ,p_information26 in varchar2 default hr_api.g_varchar2
248: ,p_information27 in varchar2 default hr_api.g_varchar2
249: ,p_information28 in varchar2 default hr_api.g_varchar2
242: ,p_information21 in varchar2 default hr_api.g_varchar2
243: ,p_information22 in varchar2 default hr_api.g_varchar2
244: ,p_information23 in varchar2 default hr_api.g_varchar2
245: ,p_information24 in varchar2 default hr_api.g_varchar2
246: ,p_information25 in varchar2 default hr_api.g_varchar2
247: ,p_information26 in varchar2 default hr_api.g_varchar2
248: ,p_information27 in varchar2 default hr_api.g_varchar2
249: ,p_information28 in varchar2 default hr_api.g_varchar2
250: ,p_information29 in varchar2 default hr_api.g_varchar2
243: ,p_information22 in varchar2 default hr_api.g_varchar2
244: ,p_information23 in varchar2 default hr_api.g_varchar2
245: ,p_information24 in varchar2 default hr_api.g_varchar2
246: ,p_information25 in varchar2 default hr_api.g_varchar2
247: ,p_information26 in varchar2 default hr_api.g_varchar2
248: ,p_information27 in varchar2 default hr_api.g_varchar2
249: ,p_information28 in varchar2 default hr_api.g_varchar2
250: ,p_information29 in varchar2 default hr_api.g_varchar2
251: ,p_information30 in varchar2 default hr_api.g_varchar2
244: ,p_information23 in varchar2 default hr_api.g_varchar2
245: ,p_information24 in varchar2 default hr_api.g_varchar2
246: ,p_information25 in varchar2 default hr_api.g_varchar2
247: ,p_information26 in varchar2 default hr_api.g_varchar2
248: ,p_information27 in varchar2 default hr_api.g_varchar2
249: ,p_information28 in varchar2 default hr_api.g_varchar2
250: ,p_information29 in varchar2 default hr_api.g_varchar2
251: ,p_information30 in varchar2 default hr_api.g_varchar2
252: ,p_template_window_id out nocopy number
245: ,p_information24 in varchar2 default hr_api.g_varchar2
246: ,p_information25 in varchar2 default hr_api.g_varchar2
247: ,p_information26 in varchar2 default hr_api.g_varchar2
248: ,p_information27 in varchar2 default hr_api.g_varchar2
249: ,p_information28 in varchar2 default hr_api.g_varchar2
250: ,p_information29 in varchar2 default hr_api.g_varchar2
251: ,p_information30 in varchar2 default hr_api.g_varchar2
252: ,p_template_window_id out nocopy number
253: ,p_object_version_number out nocopy number
246: ,p_information25 in varchar2 default hr_api.g_varchar2
247: ,p_information26 in varchar2 default hr_api.g_varchar2
248: ,p_information27 in varchar2 default hr_api.g_varchar2
249: ,p_information28 in varchar2 default hr_api.g_varchar2
250: ,p_information29 in varchar2 default hr_api.g_varchar2
251: ,p_information30 in varchar2 default hr_api.g_varchar2
252: ,p_template_window_id out nocopy number
253: ,p_object_version_number out nocopy number
254: ) is
247: ,p_information26 in varchar2 default hr_api.g_varchar2
248: ,p_information27 in varchar2 default hr_api.g_varchar2
249: ,p_information28 in varchar2 default hr_api.g_varchar2
250: ,p_information29 in varchar2 default hr_api.g_varchar2
251: ,p_information30 in varchar2 default hr_api.g_varchar2
252: ,p_template_window_id out nocopy number
253: ,p_object_version_number out nocopy number
254: ) is
255: --
299: -- instead of p_language_code from now on, to allow an IN OUT parameter to
300: -- be passed through.
301: --
302: l_language_code := p_language_code;
303: hr_api.validate_language_code(p_language_code => l_language_code);
304: --
305: hr_utility.set_location(l_proc, 20);
306: --
307: --
350: ,p_information29 => p_information29
351: ,p_information30 => p_information30);
352:
353: exception
354: when hr_api.cannot_find_prog_unit then
355: hr_api.cannot_find_prog_unit_error
356: (p_module_name => 'create_template_window'
357: ,p_hook_type => 'BP'
358: );
351: ,p_information30 => p_information30);
352:
353: exception
354: when hr_api.cannot_find_prog_unit then
355: hr_api.cannot_find_prog_unit_error
356: (p_module_name => 'create_template_window'
357: ,p_hook_type => 'BP'
358: );
359: end;
494: ,p_information30 => p_information30
495: ,p_template_window_id => l_template_window_id
496: ,p_object_version_number => l_object_version_number);
497: exception
498: when hr_api.cannot_find_prog_unit then
499: hr_api.cannot_find_prog_unit_error
500: (p_module_name => 'create_template_window'
501: ,p_hook_type => 'AP'
502: );
495: ,p_template_window_id => l_template_window_id
496: ,p_object_version_number => l_object_version_number);
497: exception
498: when hr_api.cannot_find_prog_unit then
499: hr_api.cannot_find_prog_unit_error
500: (p_module_name => 'create_template_window'
501: ,p_hook_type => 'AP'
502: );
503: end;
504: --
505: -- When in validation only mode raise the Validate_Enabled exception
506: --
507: if p_validate then
508: raise hr_api.validate_enabled;
509: end if;
510: --
511: -- Set all output arguments
512: --
514: p_object_version_number := l_object_version_number;
515: --
516: hr_utility.set_location(' Leaving:'||l_proc, 70);
517: exception
518: when hr_api.validate_enabled then
519: --
520: -- As the Validate_Enabled exception has been raised
521: -- we must rollback to the savepoint
522: --
598: (p_template_window_id => p_template_window_id
599: ,p_object_version_number => p_object_version_number
600: ,p_delete_children_flag => p_delete_children_flag);
601: exception
602: when hr_api.cannot_find_prog_unit then
603: hr_api.cannot_find_prog_unit_error
604: (p_module_name => 'delete_template_window'
605: ,p_hook_type => 'BP'
606: );
599: ,p_object_version_number => p_object_version_number
600: ,p_delete_children_flag => p_delete_children_flag);
601: exception
602: when hr_api.cannot_find_prog_unit then
603: hr_api.cannot_find_prog_unit_error
604: (p_module_name => 'delete_template_window'
605: ,p_hook_type => 'BP'
606: );
607: end;
673: (p_template_window_id => p_template_window_id
674: ,p_object_version_number => p_object_version_number
675: ,p_delete_children_flag => p_delete_children_flag);
676: exception
677: when hr_api.cannot_find_prog_unit then
678: hr_api.cannot_find_prog_unit_error
679: (p_module_name => 'delete_template_window'
680: ,p_hook_type => 'AP'
681: );
674: ,p_object_version_number => p_object_version_number
675: ,p_delete_children_flag => p_delete_children_flag);
676: exception
677: when hr_api.cannot_find_prog_unit then
678: hr_api.cannot_find_prog_unit_error
679: (p_module_name => 'delete_template_window'
680: ,p_hook_type => 'AP'
681: );
682: end;
683: --
684: -- When in validation only mode raise the Validate_Enabled exception
685: --
686: if p_validate then
687: raise hr_api.validate_enabled;
688: end if;
689: --
690: hr_utility.set_location(' Leaving:'||l_proc, 70);
691: exception
688: end if;
689: --
690: hr_utility.set_location(' Leaving:'||l_proc, 70);
691: exception
692: when hr_api.validate_enabled then
693: --
694: -- As the Validate_Enabled exception has been raised
695: -- we must rollback to the savepoint
696: --
716: --
717: procedure update_template_window
718: (p_validate in boolean default false
719: ,p_effective_date in date
720: ,p_language_code in varchar2 default hr_api.userenv_lang
721: ,p_template_window_id in number
722: ,p_object_version_number in out nocopy number
723: ,p_height in number default hr_api.g_number
724: ,p_title in varchar2 default hr_api.g_varchar2
719: ,p_effective_date in date
720: ,p_language_code in varchar2 default hr_api.userenv_lang
721: ,p_template_window_id in number
722: ,p_object_version_number in out nocopy number
723: ,p_height in number default hr_api.g_number
724: ,p_title in varchar2 default hr_api.g_varchar2
725: ,p_width in number default hr_api.g_number
726: ,p_x_position in number default hr_api.g_number
727: ,p_y_position in number default hr_api.g_number
720: ,p_language_code in varchar2 default hr_api.userenv_lang
721: ,p_template_window_id in number
722: ,p_object_version_number in out nocopy number
723: ,p_height in number default hr_api.g_number
724: ,p_title in varchar2 default hr_api.g_varchar2
725: ,p_width in number default hr_api.g_number
726: ,p_x_position in number default hr_api.g_number
727: ,p_y_position in number default hr_api.g_number
728: ,p_information_category in varchar2 default hr_api.g_varchar2
721: ,p_template_window_id in number
722: ,p_object_version_number in out nocopy number
723: ,p_height in number default hr_api.g_number
724: ,p_title in varchar2 default hr_api.g_varchar2
725: ,p_width in number default hr_api.g_number
726: ,p_x_position in number default hr_api.g_number
727: ,p_y_position in number default hr_api.g_number
728: ,p_information_category in varchar2 default hr_api.g_varchar2
729: ,p_information1 in varchar2 default hr_api.g_varchar2
722: ,p_object_version_number in out nocopy number
723: ,p_height in number default hr_api.g_number
724: ,p_title in varchar2 default hr_api.g_varchar2
725: ,p_width in number default hr_api.g_number
726: ,p_x_position in number default hr_api.g_number
727: ,p_y_position in number default hr_api.g_number
728: ,p_information_category in varchar2 default hr_api.g_varchar2
729: ,p_information1 in varchar2 default hr_api.g_varchar2
730: ,p_information2 in varchar2 default hr_api.g_varchar2
723: ,p_height in number default hr_api.g_number
724: ,p_title in varchar2 default hr_api.g_varchar2
725: ,p_width in number default hr_api.g_number
726: ,p_x_position in number default hr_api.g_number
727: ,p_y_position in number default hr_api.g_number
728: ,p_information_category in varchar2 default hr_api.g_varchar2
729: ,p_information1 in varchar2 default hr_api.g_varchar2
730: ,p_information2 in varchar2 default hr_api.g_varchar2
731: ,p_information3 in varchar2 default hr_api.g_varchar2
724: ,p_title in varchar2 default hr_api.g_varchar2
725: ,p_width in number default hr_api.g_number
726: ,p_x_position in number default hr_api.g_number
727: ,p_y_position in number default hr_api.g_number
728: ,p_information_category in varchar2 default hr_api.g_varchar2
729: ,p_information1 in varchar2 default hr_api.g_varchar2
730: ,p_information2 in varchar2 default hr_api.g_varchar2
731: ,p_information3 in varchar2 default hr_api.g_varchar2
732: ,p_information4 in varchar2 default hr_api.g_varchar2
725: ,p_width in number default hr_api.g_number
726: ,p_x_position in number default hr_api.g_number
727: ,p_y_position in number default hr_api.g_number
728: ,p_information_category in varchar2 default hr_api.g_varchar2
729: ,p_information1 in varchar2 default hr_api.g_varchar2
730: ,p_information2 in varchar2 default hr_api.g_varchar2
731: ,p_information3 in varchar2 default hr_api.g_varchar2
732: ,p_information4 in varchar2 default hr_api.g_varchar2
733: ,p_information5 in varchar2 default hr_api.g_varchar2
726: ,p_x_position in number default hr_api.g_number
727: ,p_y_position in number default hr_api.g_number
728: ,p_information_category in varchar2 default hr_api.g_varchar2
729: ,p_information1 in varchar2 default hr_api.g_varchar2
730: ,p_information2 in varchar2 default hr_api.g_varchar2
731: ,p_information3 in varchar2 default hr_api.g_varchar2
732: ,p_information4 in varchar2 default hr_api.g_varchar2
733: ,p_information5 in varchar2 default hr_api.g_varchar2
734: ,p_information6 in varchar2 default hr_api.g_varchar2
727: ,p_y_position in number default hr_api.g_number
728: ,p_information_category in varchar2 default hr_api.g_varchar2
729: ,p_information1 in varchar2 default hr_api.g_varchar2
730: ,p_information2 in varchar2 default hr_api.g_varchar2
731: ,p_information3 in varchar2 default hr_api.g_varchar2
732: ,p_information4 in varchar2 default hr_api.g_varchar2
733: ,p_information5 in varchar2 default hr_api.g_varchar2
734: ,p_information6 in varchar2 default hr_api.g_varchar2
735: ,p_information7 in varchar2 default hr_api.g_varchar2
728: ,p_information_category in varchar2 default hr_api.g_varchar2
729: ,p_information1 in varchar2 default hr_api.g_varchar2
730: ,p_information2 in varchar2 default hr_api.g_varchar2
731: ,p_information3 in varchar2 default hr_api.g_varchar2
732: ,p_information4 in varchar2 default hr_api.g_varchar2
733: ,p_information5 in varchar2 default hr_api.g_varchar2
734: ,p_information6 in varchar2 default hr_api.g_varchar2
735: ,p_information7 in varchar2 default hr_api.g_varchar2
736: ,p_information8 in varchar2 default hr_api.g_varchar2
729: ,p_information1 in varchar2 default hr_api.g_varchar2
730: ,p_information2 in varchar2 default hr_api.g_varchar2
731: ,p_information3 in varchar2 default hr_api.g_varchar2
732: ,p_information4 in varchar2 default hr_api.g_varchar2
733: ,p_information5 in varchar2 default hr_api.g_varchar2
734: ,p_information6 in varchar2 default hr_api.g_varchar2
735: ,p_information7 in varchar2 default hr_api.g_varchar2
736: ,p_information8 in varchar2 default hr_api.g_varchar2
737: ,p_information9 in varchar2 default hr_api.g_varchar2
730: ,p_information2 in varchar2 default hr_api.g_varchar2
731: ,p_information3 in varchar2 default hr_api.g_varchar2
732: ,p_information4 in varchar2 default hr_api.g_varchar2
733: ,p_information5 in varchar2 default hr_api.g_varchar2
734: ,p_information6 in varchar2 default hr_api.g_varchar2
735: ,p_information7 in varchar2 default hr_api.g_varchar2
736: ,p_information8 in varchar2 default hr_api.g_varchar2
737: ,p_information9 in varchar2 default hr_api.g_varchar2
738: ,p_information10 in varchar2 default hr_api.g_varchar2
731: ,p_information3 in varchar2 default hr_api.g_varchar2
732: ,p_information4 in varchar2 default hr_api.g_varchar2
733: ,p_information5 in varchar2 default hr_api.g_varchar2
734: ,p_information6 in varchar2 default hr_api.g_varchar2
735: ,p_information7 in varchar2 default hr_api.g_varchar2
736: ,p_information8 in varchar2 default hr_api.g_varchar2
737: ,p_information9 in varchar2 default hr_api.g_varchar2
738: ,p_information10 in varchar2 default hr_api.g_varchar2
739: ,p_information11 in varchar2 default hr_api.g_varchar2
732: ,p_information4 in varchar2 default hr_api.g_varchar2
733: ,p_information5 in varchar2 default hr_api.g_varchar2
734: ,p_information6 in varchar2 default hr_api.g_varchar2
735: ,p_information7 in varchar2 default hr_api.g_varchar2
736: ,p_information8 in varchar2 default hr_api.g_varchar2
737: ,p_information9 in varchar2 default hr_api.g_varchar2
738: ,p_information10 in varchar2 default hr_api.g_varchar2
739: ,p_information11 in varchar2 default hr_api.g_varchar2
740: ,p_information12 in varchar2 default hr_api.g_varchar2
733: ,p_information5 in varchar2 default hr_api.g_varchar2
734: ,p_information6 in varchar2 default hr_api.g_varchar2
735: ,p_information7 in varchar2 default hr_api.g_varchar2
736: ,p_information8 in varchar2 default hr_api.g_varchar2
737: ,p_information9 in varchar2 default hr_api.g_varchar2
738: ,p_information10 in varchar2 default hr_api.g_varchar2
739: ,p_information11 in varchar2 default hr_api.g_varchar2
740: ,p_information12 in varchar2 default hr_api.g_varchar2
741: ,p_information13 in varchar2 default hr_api.g_varchar2
734: ,p_information6 in varchar2 default hr_api.g_varchar2
735: ,p_information7 in varchar2 default hr_api.g_varchar2
736: ,p_information8 in varchar2 default hr_api.g_varchar2
737: ,p_information9 in varchar2 default hr_api.g_varchar2
738: ,p_information10 in varchar2 default hr_api.g_varchar2
739: ,p_information11 in varchar2 default hr_api.g_varchar2
740: ,p_information12 in varchar2 default hr_api.g_varchar2
741: ,p_information13 in varchar2 default hr_api.g_varchar2
742: ,p_information14 in varchar2 default hr_api.g_varchar2
735: ,p_information7 in varchar2 default hr_api.g_varchar2
736: ,p_information8 in varchar2 default hr_api.g_varchar2
737: ,p_information9 in varchar2 default hr_api.g_varchar2
738: ,p_information10 in varchar2 default hr_api.g_varchar2
739: ,p_information11 in varchar2 default hr_api.g_varchar2
740: ,p_information12 in varchar2 default hr_api.g_varchar2
741: ,p_information13 in varchar2 default hr_api.g_varchar2
742: ,p_information14 in varchar2 default hr_api.g_varchar2
743: ,p_information15 in varchar2 default hr_api.g_varchar2
736: ,p_information8 in varchar2 default hr_api.g_varchar2
737: ,p_information9 in varchar2 default hr_api.g_varchar2
738: ,p_information10 in varchar2 default hr_api.g_varchar2
739: ,p_information11 in varchar2 default hr_api.g_varchar2
740: ,p_information12 in varchar2 default hr_api.g_varchar2
741: ,p_information13 in varchar2 default hr_api.g_varchar2
742: ,p_information14 in varchar2 default hr_api.g_varchar2
743: ,p_information15 in varchar2 default hr_api.g_varchar2
744: ,p_information16 in varchar2 default hr_api.g_varchar2
737: ,p_information9 in varchar2 default hr_api.g_varchar2
738: ,p_information10 in varchar2 default hr_api.g_varchar2
739: ,p_information11 in varchar2 default hr_api.g_varchar2
740: ,p_information12 in varchar2 default hr_api.g_varchar2
741: ,p_information13 in varchar2 default hr_api.g_varchar2
742: ,p_information14 in varchar2 default hr_api.g_varchar2
743: ,p_information15 in varchar2 default hr_api.g_varchar2
744: ,p_information16 in varchar2 default hr_api.g_varchar2
745: ,p_information17 in varchar2 default hr_api.g_varchar2
738: ,p_information10 in varchar2 default hr_api.g_varchar2
739: ,p_information11 in varchar2 default hr_api.g_varchar2
740: ,p_information12 in varchar2 default hr_api.g_varchar2
741: ,p_information13 in varchar2 default hr_api.g_varchar2
742: ,p_information14 in varchar2 default hr_api.g_varchar2
743: ,p_information15 in varchar2 default hr_api.g_varchar2
744: ,p_information16 in varchar2 default hr_api.g_varchar2
745: ,p_information17 in varchar2 default hr_api.g_varchar2
746: ,p_information18 in varchar2 default hr_api.g_varchar2
739: ,p_information11 in varchar2 default hr_api.g_varchar2
740: ,p_information12 in varchar2 default hr_api.g_varchar2
741: ,p_information13 in varchar2 default hr_api.g_varchar2
742: ,p_information14 in varchar2 default hr_api.g_varchar2
743: ,p_information15 in varchar2 default hr_api.g_varchar2
744: ,p_information16 in varchar2 default hr_api.g_varchar2
745: ,p_information17 in varchar2 default hr_api.g_varchar2
746: ,p_information18 in varchar2 default hr_api.g_varchar2
747: ,p_information19 in varchar2 default hr_api.g_varchar2
740: ,p_information12 in varchar2 default hr_api.g_varchar2
741: ,p_information13 in varchar2 default hr_api.g_varchar2
742: ,p_information14 in varchar2 default hr_api.g_varchar2
743: ,p_information15 in varchar2 default hr_api.g_varchar2
744: ,p_information16 in varchar2 default hr_api.g_varchar2
745: ,p_information17 in varchar2 default hr_api.g_varchar2
746: ,p_information18 in varchar2 default hr_api.g_varchar2
747: ,p_information19 in varchar2 default hr_api.g_varchar2
748: ,p_information20 in varchar2 default hr_api.g_varchar2
741: ,p_information13 in varchar2 default hr_api.g_varchar2
742: ,p_information14 in varchar2 default hr_api.g_varchar2
743: ,p_information15 in varchar2 default hr_api.g_varchar2
744: ,p_information16 in varchar2 default hr_api.g_varchar2
745: ,p_information17 in varchar2 default hr_api.g_varchar2
746: ,p_information18 in varchar2 default hr_api.g_varchar2
747: ,p_information19 in varchar2 default hr_api.g_varchar2
748: ,p_information20 in varchar2 default hr_api.g_varchar2
749: ,p_information21 in varchar2 default hr_api.g_varchar2
742: ,p_information14 in varchar2 default hr_api.g_varchar2
743: ,p_information15 in varchar2 default hr_api.g_varchar2
744: ,p_information16 in varchar2 default hr_api.g_varchar2
745: ,p_information17 in varchar2 default hr_api.g_varchar2
746: ,p_information18 in varchar2 default hr_api.g_varchar2
747: ,p_information19 in varchar2 default hr_api.g_varchar2
748: ,p_information20 in varchar2 default hr_api.g_varchar2
749: ,p_information21 in varchar2 default hr_api.g_varchar2
750: ,p_information22 in varchar2 default hr_api.g_varchar2
743: ,p_information15 in varchar2 default hr_api.g_varchar2
744: ,p_information16 in varchar2 default hr_api.g_varchar2
745: ,p_information17 in varchar2 default hr_api.g_varchar2
746: ,p_information18 in varchar2 default hr_api.g_varchar2
747: ,p_information19 in varchar2 default hr_api.g_varchar2
748: ,p_information20 in varchar2 default hr_api.g_varchar2
749: ,p_information21 in varchar2 default hr_api.g_varchar2
750: ,p_information22 in varchar2 default hr_api.g_varchar2
751: ,p_information23 in varchar2 default hr_api.g_varchar2
744: ,p_information16 in varchar2 default hr_api.g_varchar2
745: ,p_information17 in varchar2 default hr_api.g_varchar2
746: ,p_information18 in varchar2 default hr_api.g_varchar2
747: ,p_information19 in varchar2 default hr_api.g_varchar2
748: ,p_information20 in varchar2 default hr_api.g_varchar2
749: ,p_information21 in varchar2 default hr_api.g_varchar2
750: ,p_information22 in varchar2 default hr_api.g_varchar2
751: ,p_information23 in varchar2 default hr_api.g_varchar2
752: ,p_information24 in varchar2 default hr_api.g_varchar2
745: ,p_information17 in varchar2 default hr_api.g_varchar2
746: ,p_information18 in varchar2 default hr_api.g_varchar2
747: ,p_information19 in varchar2 default hr_api.g_varchar2
748: ,p_information20 in varchar2 default hr_api.g_varchar2
749: ,p_information21 in varchar2 default hr_api.g_varchar2
750: ,p_information22 in varchar2 default hr_api.g_varchar2
751: ,p_information23 in varchar2 default hr_api.g_varchar2
752: ,p_information24 in varchar2 default hr_api.g_varchar2
753: ,p_information25 in varchar2 default hr_api.g_varchar2
746: ,p_information18 in varchar2 default hr_api.g_varchar2
747: ,p_information19 in varchar2 default hr_api.g_varchar2
748: ,p_information20 in varchar2 default hr_api.g_varchar2
749: ,p_information21 in varchar2 default hr_api.g_varchar2
750: ,p_information22 in varchar2 default hr_api.g_varchar2
751: ,p_information23 in varchar2 default hr_api.g_varchar2
752: ,p_information24 in varchar2 default hr_api.g_varchar2
753: ,p_information25 in varchar2 default hr_api.g_varchar2
754: ,p_information26 in varchar2 default hr_api.g_varchar2
747: ,p_information19 in varchar2 default hr_api.g_varchar2
748: ,p_information20 in varchar2 default hr_api.g_varchar2
749: ,p_information21 in varchar2 default hr_api.g_varchar2
750: ,p_information22 in varchar2 default hr_api.g_varchar2
751: ,p_information23 in varchar2 default hr_api.g_varchar2
752: ,p_information24 in varchar2 default hr_api.g_varchar2
753: ,p_information25 in varchar2 default hr_api.g_varchar2
754: ,p_information26 in varchar2 default hr_api.g_varchar2
755: ,p_information27 in varchar2 default hr_api.g_varchar2
748: ,p_information20 in varchar2 default hr_api.g_varchar2
749: ,p_information21 in varchar2 default hr_api.g_varchar2
750: ,p_information22 in varchar2 default hr_api.g_varchar2
751: ,p_information23 in varchar2 default hr_api.g_varchar2
752: ,p_information24 in varchar2 default hr_api.g_varchar2
753: ,p_information25 in varchar2 default hr_api.g_varchar2
754: ,p_information26 in varchar2 default hr_api.g_varchar2
755: ,p_information27 in varchar2 default hr_api.g_varchar2
756: ,p_information28 in varchar2 default hr_api.g_varchar2
749: ,p_information21 in varchar2 default hr_api.g_varchar2
750: ,p_information22 in varchar2 default hr_api.g_varchar2
751: ,p_information23 in varchar2 default hr_api.g_varchar2
752: ,p_information24 in varchar2 default hr_api.g_varchar2
753: ,p_information25 in varchar2 default hr_api.g_varchar2
754: ,p_information26 in varchar2 default hr_api.g_varchar2
755: ,p_information27 in varchar2 default hr_api.g_varchar2
756: ,p_information28 in varchar2 default hr_api.g_varchar2
757: ,p_information29 in varchar2 default hr_api.g_varchar2
750: ,p_information22 in varchar2 default hr_api.g_varchar2
751: ,p_information23 in varchar2 default hr_api.g_varchar2
752: ,p_information24 in varchar2 default hr_api.g_varchar2
753: ,p_information25 in varchar2 default hr_api.g_varchar2
754: ,p_information26 in varchar2 default hr_api.g_varchar2
755: ,p_information27 in varchar2 default hr_api.g_varchar2
756: ,p_information28 in varchar2 default hr_api.g_varchar2
757: ,p_information29 in varchar2 default hr_api.g_varchar2
758: ,p_information30 in varchar2 default hr_api.g_varchar2
751: ,p_information23 in varchar2 default hr_api.g_varchar2
752: ,p_information24 in varchar2 default hr_api.g_varchar2
753: ,p_information25 in varchar2 default hr_api.g_varchar2
754: ,p_information26 in varchar2 default hr_api.g_varchar2
755: ,p_information27 in varchar2 default hr_api.g_varchar2
756: ,p_information28 in varchar2 default hr_api.g_varchar2
757: ,p_information29 in varchar2 default hr_api.g_varchar2
758: ,p_information30 in varchar2 default hr_api.g_varchar2
759: ) is
752: ,p_information24 in varchar2 default hr_api.g_varchar2
753: ,p_information25 in varchar2 default hr_api.g_varchar2
754: ,p_information26 in varchar2 default hr_api.g_varchar2
755: ,p_information27 in varchar2 default hr_api.g_varchar2
756: ,p_information28 in varchar2 default hr_api.g_varchar2
757: ,p_information29 in varchar2 default hr_api.g_varchar2
758: ,p_information30 in varchar2 default hr_api.g_varchar2
759: ) is
760: --
753: ,p_information25 in varchar2 default hr_api.g_varchar2
754: ,p_information26 in varchar2 default hr_api.g_varchar2
755: ,p_information27 in varchar2 default hr_api.g_varchar2
756: ,p_information28 in varchar2 default hr_api.g_varchar2
757: ,p_information29 in varchar2 default hr_api.g_varchar2
758: ,p_information30 in varchar2 default hr_api.g_varchar2
759: ) is
760: --
761: -- Declare cursors and local variables
754: ,p_information26 in varchar2 default hr_api.g_varchar2
755: ,p_information27 in varchar2 default hr_api.g_varchar2
756: ,p_information28 in varchar2 default hr_api.g_varchar2
757: ,p_information29 in varchar2 default hr_api.g_varchar2
758: ,p_information30 in varchar2 default hr_api.g_varchar2
759: ) is
760: --
761: -- Declare cursors and local variables
762: --
808: -- instead of p_language_code from now on, to allow an IN OUT parameter to
809: -- be passed through.
810: --
811: l_language_code := p_language_code;
812: hr_api.validate_language_code(p_language_code => l_language_code);
813: --
814: hr_utility.set_location(l_proc, 20);
815: --
816: --
858: ,p_information28 => p_information28
859: ,p_information29 => p_information29
860: ,p_information30 => p_information30);
861: exception
862: when hr_api.cannot_find_prog_unit then
863: hr_api.cannot_find_prog_unit_error
864: (p_module_name => 'update_template_window'
865: ,p_hook_type => 'BP'
866: );
859: ,p_information29 => p_information29
860: ,p_information30 => p_information30);
861: exception
862: when hr_api.cannot_find_prog_unit then
863: hr_api.cannot_find_prog_unit_error
864: (p_module_name => 'update_template_window'
865: ,p_hook_type => 'BP'
866: );
867: end;
994: ,p_information28 => p_information28
995: ,p_information29 => p_information29
996: ,p_information30 => p_information30);
997: exception
998: when hr_api.cannot_find_prog_unit then
999: hr_api.cannot_find_prog_unit_error
1000: (p_module_name => 'update_template_window'
1001: ,p_hook_type => 'AP'
1002: );
995: ,p_information29 => p_information29
996: ,p_information30 => p_information30);
997: exception
998: when hr_api.cannot_find_prog_unit then
999: hr_api.cannot_find_prog_unit_error
1000: (p_module_name => 'update_template_window'
1001: ,p_hook_type => 'AP'
1002: );
1003: end;
1004: --
1005: -- When in validation only mode raise the Validate_Enabled exception
1006: --
1007: if p_validate then
1008: raise hr_api.validate_enabled;
1009: end if;
1010: --
1011: -- Set all output arguments
1012: --
1013: p_object_version_number := l_object_version_number;
1014: --
1015: hr_utility.set_location(' Leaving:'||l_proc, 70);
1016: exception
1017: when hr_api.validate_enabled then
1018: --
1019: -- As the Validate_Enabled exception has been raised
1020: -- we must rollback to the savepoint
1021: --