DBA Data[Home] [Help]

APPS.HR_TEMPLATE_CANVASES_API dependencies on HR_API

Line 15: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 72: hr_api.validate_language_code(p_language_code => l_language_code);

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: --

Line 87: when hr_api.cannot_find_prog_unit then

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: );

Line 88: hr_api.cannot_find_prog_unit_error

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;

Line 161: when hr_api.cannot_find_prog_unit then

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: );

Line 162: hr_api.cannot_find_prog_unit_error

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;

Line 173: raise hr_api.validate_enabled;

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: --

Line 183: when hr_api.validate_enabled then

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: --

Line 217: --,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 220: ,p_height 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

Line 221: ,p_visible 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

Line 222: ,p_width in number default hr_api.g_number

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

Line 223: ,p_x_position in number default hr_api.g_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
227: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 224: ,p_y_position in number default hr_api.g_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
228: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 225: ,p_information_category 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

Line 226: ,p_information1 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

Line 227: ,p_information2 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

Line 228: ,p_information3 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

Line 229: ,p_information4 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

Line 230: ,p_information5 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

Line 231: ,p_information6 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

Line 232: ,p_information7 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

Line 233: ,p_information8 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

Line 234: ,p_information9 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

Line 235: ,p_information10 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

Line 236: ,p_information11 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

Line 237: ,p_information12 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

Line 238: ,p_information13 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

Line 239: ,p_information14 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

Line 240: ,p_information15 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

Line 241: ,p_information16 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

Line 242: ,p_information17 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

Line 243: ,p_information18 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

Line 244: ,p_information19 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

Line 245: ,p_information20 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

Line 246: ,p_information21 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

Line 247: ,p_information22 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

Line 248: ,p_information23 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

Line 249: ,p_information24 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

Line 250: ,p_information25 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

Line 251: ,p_information26 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

Line 252: ,p_information27 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

Line 253: ,p_information28 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
257: ,p_object_version_number out nocopy number

Line 254: ,p_information29 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
258: ) is

Line 255: ,p_information30 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
259: --

Line 271: SELECT DECODE(p_height,hr_api.g_number,twn.height,p_height)

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:

Line 272: ,DECODE(p_width,hr_api.g_number,twn.width,p_width)

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;

Line 348: when hr_api.cannot_find_prog_unit then

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: );

Line 349: hr_api.cannot_find_prog_unit_error

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;

Line 494: when hr_api.cannot_find_prog_unit then

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: );

Line 495: hr_api.cannot_find_prog_unit_error

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;

Line 506: raise hr_api.validate_enabled;

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: --

Line 516: when hr_api.validate_enabled then

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: --

Line 591: when hr_api.cannot_find_prog_unit then

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: );

Line 592: hr_api.cannot_find_prog_unit_error

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;

Line 657: when hr_api.cannot_find_prog_unit then

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: );

Line 658: hr_api.cannot_find_prog_unit_error

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;

Line 669: raise hr_api.validate_enabled;

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

Line 674: when hr_api.validate_enabled then

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: --

Line 703: --,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 706: ,p_height 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

Line 707: ,p_visible 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

Line 708: ,p_width in number default hr_api.g_number

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

Line 709: ,p_x_position in number default hr_api.g_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
713: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 710: ,p_y_position in number default hr_api.g_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
714: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 711: ,p_information_category 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

Line 712: ,p_information1 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

Line 713: ,p_information2 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

Line 714: ,p_information3 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

Line 715: ,p_information4 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

Line 716: ,p_information5 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

Line 717: ,p_information6 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

Line 718: ,p_information7 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

Line 719: ,p_information8 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

Line 720: ,p_information9 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

Line 721: ,p_information10 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

Line 722: ,p_information11 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

Line 723: ,p_information12 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

Line 724: ,p_information13 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

Line 725: ,p_information14 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

Line 726: ,p_information15 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

Line 727: ,p_information16 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

Line 728: ,p_information17 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

Line 729: ,p_information18 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

Line 730: ,p_information19 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

Line 731: ,p_information20 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

Line 732: ,p_information21 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

Line 733: ,p_information22 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

Line 734: ,p_information23 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

Line 735: ,p_information24 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

Line 736: ,p_information25 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

Line 737: ,p_information26 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

Line 738: ,p_information27 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

Line 739: ,p_information28 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
743: --

Line 740: ,p_information29 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: --
744: -- Declare cursors and local variables

Line 741: ,p_information30 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
745: --

Line 817: when hr_api.cannot_find_prog_unit then

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: );

Line 818: hr_api.cannot_find_prog_unit_error

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;

Line 934: when hr_api.cannot_find_prog_unit then

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: );

Line 935: hr_api.cannot_find_prog_unit_error

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;

Line 946: raise hr_api.validate_enabled;

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: --

Line 955: when hr_api.validate_enabled then

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: --