eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_TEMPLATE_TAB_PAGES_API dependencies on HR_API

Line 15: ,p_language_code in varchar2 default hr_api.userenv_lang

11: --
12: procedure copy_template_tab_page
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_tab_page_id_from in number
17: ,p_template_canvas_id in number
18: ,p_template_tab_page_id_to out nocopy number
19: ,p_object_version_number out nocopy number

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

64: -- instead of p_language_code from now on, to allow an IN OUT parameter to
65: -- be passed through.
66: --
67: l_language_code := p_language_code;
68: hr_api.validate_language_code(p_language_code => l_language_code);
69: --
70: hr_utility.set_location(l_proc, 20);
71: --
72: --

Line 83: when hr_api.cannot_find_prog_unit then

79: ,p_template_tab_page_id_from => p_template_tab_page_id_from
80: ,p_template_canvas_id => p_template_canvas_id
81: );
82: exception
83: when hr_api.cannot_find_prog_unit then
84: hr_api.cannot_find_prog_unit_error
85: (p_module_name => 'copy_template_tab_page'
86: ,p_hook_type => 'BP'
87: );

Line 84: hr_api.cannot_find_prog_unit_error

80: ,p_template_canvas_id => p_template_canvas_id
81: );
82: exception
83: when hr_api.cannot_find_prog_unit then
84: hr_api.cannot_find_prog_unit_error
85: (p_module_name => 'copy_template_tab_page'
86: ,p_hook_type => 'BP'
87: );
88: end;

Line 150: when hr_api.cannot_find_prog_unit then

146: ,p_object_version_number => l_object_version_number
147: --,p_override_value_warning => l_override_value_warning
148: );
149: exception
150: when hr_api.cannot_find_prog_unit then
151: hr_api.cannot_find_prog_unit_error
152: (p_module_name => 'copy_template_tab_page'
153: ,p_hook_type => 'AP'
154: );

Line 151: hr_api.cannot_find_prog_unit_error

147: --,p_override_value_warning => l_override_value_warning
148: );
149: exception
150: when hr_api.cannot_find_prog_unit then
151: hr_api.cannot_find_prog_unit_error
152: (p_module_name => 'copy_template_tab_page'
153: ,p_hook_type => 'AP'
154: );
155: end;

Line 160: raise hr_api.validate_enabled;

156: --
157: -- When in validation only mode raise the Validate_Enabled exception
158: --
159: if p_validate then
160: raise hr_api.validate_enabled;
161: end if;
162: --
163: -- Set all output arguments
164: --

Line 172: when hr_api.validate_enabled then

168: --p_override_value_warning := l_override_value_warning;
169:
170: hr_utility.set_location(' Leaving:'||l_proc, 70);
171: exception
172: when hr_api.validate_enabled then
173: --
174: -- As the Validate_Enabled exception has been raised
175: -- we must rollback to the savepoint
176: --

Line 207: ,p_language_code in varchar2 default hr_api.userenv_lang

203: --
204: procedure create_template_tab_page
205: (p_validate in boolean default false
206: ,p_effective_date in date
207: ,p_language_code in varchar2 default hr_api.userenv_lang
208: ,p_template_canvas_id in number
209: ,p_form_tab_page_id in number
210: ,p_label in varchar2 default hr_api.g_varchar2
211: ,p_navigation_direction in varchar2 default hr_api.g_varchar2

Line 210: ,p_label in varchar2 default hr_api.g_varchar2

206: ,p_effective_date in date
207: ,p_language_code in varchar2 default hr_api.userenv_lang
208: ,p_template_canvas_id in number
209: ,p_form_tab_page_id in number
210: ,p_label in varchar2 default hr_api.g_varchar2
211: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
212: ,p_visible in number default hr_api.g_number
213: ,p_information_category in varchar2 default hr_api.g_varchar2
214: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 211: ,p_navigation_direction in varchar2 default hr_api.g_varchar2

207: ,p_language_code in varchar2 default hr_api.userenv_lang
208: ,p_template_canvas_id in number
209: ,p_form_tab_page_id in number
210: ,p_label in varchar2 default hr_api.g_varchar2
211: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
212: ,p_visible in number default hr_api.g_number
213: ,p_information_category in varchar2 default hr_api.g_varchar2
214: ,p_information1 in varchar2 default hr_api.g_varchar2
215: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 212: ,p_visible in number default hr_api.g_number

208: ,p_template_canvas_id in number
209: ,p_form_tab_page_id in number
210: ,p_label in varchar2 default hr_api.g_varchar2
211: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
212: ,p_visible in number default hr_api.g_number
213: ,p_information_category in varchar2 default hr_api.g_varchar2
214: ,p_information1 in varchar2 default hr_api.g_varchar2
215: ,p_information2 in varchar2 default hr_api.g_varchar2
216: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 213: ,p_information_category in varchar2 default hr_api.g_varchar2

209: ,p_form_tab_page_id in number
210: ,p_label in varchar2 default hr_api.g_varchar2
211: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
212: ,p_visible in number default hr_api.g_number
213: ,p_information_category in varchar2 default hr_api.g_varchar2
214: ,p_information1 in varchar2 default hr_api.g_varchar2
215: ,p_information2 in varchar2 default hr_api.g_varchar2
216: ,p_information3 in varchar2 default hr_api.g_varchar2
217: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 214: ,p_information1 in varchar2 default hr_api.g_varchar2

210: ,p_label in varchar2 default hr_api.g_varchar2
211: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
212: ,p_visible in number default hr_api.g_number
213: ,p_information_category in varchar2 default hr_api.g_varchar2
214: ,p_information1 in varchar2 default hr_api.g_varchar2
215: ,p_information2 in varchar2 default hr_api.g_varchar2
216: ,p_information3 in varchar2 default hr_api.g_varchar2
217: ,p_information4 in varchar2 default hr_api.g_varchar2
218: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 215: ,p_information2 in varchar2 default hr_api.g_varchar2

211: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
212: ,p_visible in number default hr_api.g_number
213: ,p_information_category in varchar2 default hr_api.g_varchar2
214: ,p_information1 in varchar2 default hr_api.g_varchar2
215: ,p_information2 in varchar2 default hr_api.g_varchar2
216: ,p_information3 in varchar2 default hr_api.g_varchar2
217: ,p_information4 in varchar2 default hr_api.g_varchar2
218: ,p_information5 in varchar2 default hr_api.g_varchar2
219: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 216: ,p_information3 in varchar2 default hr_api.g_varchar2

212: ,p_visible in number default hr_api.g_number
213: ,p_information_category in varchar2 default hr_api.g_varchar2
214: ,p_information1 in varchar2 default hr_api.g_varchar2
215: ,p_information2 in varchar2 default hr_api.g_varchar2
216: ,p_information3 in varchar2 default hr_api.g_varchar2
217: ,p_information4 in varchar2 default hr_api.g_varchar2
218: ,p_information5 in varchar2 default hr_api.g_varchar2
219: ,p_information6 in varchar2 default hr_api.g_varchar2
220: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 217: ,p_information4 in varchar2 default hr_api.g_varchar2

213: ,p_information_category in varchar2 default hr_api.g_varchar2
214: ,p_information1 in varchar2 default hr_api.g_varchar2
215: ,p_information2 in varchar2 default hr_api.g_varchar2
216: ,p_information3 in varchar2 default hr_api.g_varchar2
217: ,p_information4 in varchar2 default hr_api.g_varchar2
218: ,p_information5 in varchar2 default hr_api.g_varchar2
219: ,p_information6 in varchar2 default hr_api.g_varchar2
220: ,p_information7 in varchar2 default hr_api.g_varchar2
221: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 218: ,p_information5 in varchar2 default hr_api.g_varchar2

214: ,p_information1 in varchar2 default hr_api.g_varchar2
215: ,p_information2 in varchar2 default hr_api.g_varchar2
216: ,p_information3 in varchar2 default hr_api.g_varchar2
217: ,p_information4 in varchar2 default hr_api.g_varchar2
218: ,p_information5 in varchar2 default hr_api.g_varchar2
219: ,p_information6 in varchar2 default hr_api.g_varchar2
220: ,p_information7 in varchar2 default hr_api.g_varchar2
221: ,p_information8 in varchar2 default hr_api.g_varchar2
222: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 219: ,p_information6 in varchar2 default hr_api.g_varchar2

215: ,p_information2 in varchar2 default hr_api.g_varchar2
216: ,p_information3 in varchar2 default hr_api.g_varchar2
217: ,p_information4 in varchar2 default hr_api.g_varchar2
218: ,p_information5 in varchar2 default hr_api.g_varchar2
219: ,p_information6 in varchar2 default hr_api.g_varchar2
220: ,p_information7 in varchar2 default hr_api.g_varchar2
221: ,p_information8 in varchar2 default hr_api.g_varchar2
222: ,p_information9 in varchar2 default hr_api.g_varchar2
223: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 220: ,p_information7 in varchar2 default hr_api.g_varchar2

216: ,p_information3 in varchar2 default hr_api.g_varchar2
217: ,p_information4 in varchar2 default hr_api.g_varchar2
218: ,p_information5 in varchar2 default hr_api.g_varchar2
219: ,p_information6 in varchar2 default hr_api.g_varchar2
220: ,p_information7 in varchar2 default hr_api.g_varchar2
221: ,p_information8 in varchar2 default hr_api.g_varchar2
222: ,p_information9 in varchar2 default hr_api.g_varchar2
223: ,p_information10 in varchar2 default hr_api.g_varchar2
224: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 221: ,p_information8 in varchar2 default hr_api.g_varchar2

217: ,p_information4 in varchar2 default hr_api.g_varchar2
218: ,p_information5 in varchar2 default hr_api.g_varchar2
219: ,p_information6 in varchar2 default hr_api.g_varchar2
220: ,p_information7 in varchar2 default hr_api.g_varchar2
221: ,p_information8 in varchar2 default hr_api.g_varchar2
222: ,p_information9 in varchar2 default hr_api.g_varchar2
223: ,p_information10 in varchar2 default hr_api.g_varchar2
224: ,p_information11 in varchar2 default hr_api.g_varchar2
225: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 222: ,p_information9 in varchar2 default hr_api.g_varchar2

218: ,p_information5 in varchar2 default hr_api.g_varchar2
219: ,p_information6 in varchar2 default hr_api.g_varchar2
220: ,p_information7 in varchar2 default hr_api.g_varchar2
221: ,p_information8 in varchar2 default hr_api.g_varchar2
222: ,p_information9 in varchar2 default hr_api.g_varchar2
223: ,p_information10 in varchar2 default hr_api.g_varchar2
224: ,p_information11 in varchar2 default hr_api.g_varchar2
225: ,p_information12 in varchar2 default hr_api.g_varchar2
226: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 223: ,p_information10 in varchar2 default hr_api.g_varchar2

219: ,p_information6 in varchar2 default hr_api.g_varchar2
220: ,p_information7 in varchar2 default hr_api.g_varchar2
221: ,p_information8 in varchar2 default hr_api.g_varchar2
222: ,p_information9 in varchar2 default hr_api.g_varchar2
223: ,p_information10 in varchar2 default hr_api.g_varchar2
224: ,p_information11 in varchar2 default hr_api.g_varchar2
225: ,p_information12 in varchar2 default hr_api.g_varchar2
226: ,p_information13 in varchar2 default hr_api.g_varchar2
227: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 224: ,p_information11 in varchar2 default hr_api.g_varchar2

220: ,p_information7 in varchar2 default hr_api.g_varchar2
221: ,p_information8 in varchar2 default hr_api.g_varchar2
222: ,p_information9 in varchar2 default hr_api.g_varchar2
223: ,p_information10 in varchar2 default hr_api.g_varchar2
224: ,p_information11 in varchar2 default hr_api.g_varchar2
225: ,p_information12 in varchar2 default hr_api.g_varchar2
226: ,p_information13 in varchar2 default hr_api.g_varchar2
227: ,p_information14 in varchar2 default hr_api.g_varchar2
228: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 225: ,p_information12 in varchar2 default hr_api.g_varchar2

221: ,p_information8 in varchar2 default hr_api.g_varchar2
222: ,p_information9 in varchar2 default hr_api.g_varchar2
223: ,p_information10 in varchar2 default hr_api.g_varchar2
224: ,p_information11 in varchar2 default hr_api.g_varchar2
225: ,p_information12 in varchar2 default hr_api.g_varchar2
226: ,p_information13 in varchar2 default hr_api.g_varchar2
227: ,p_information14 in varchar2 default hr_api.g_varchar2
228: ,p_information15 in varchar2 default hr_api.g_varchar2
229: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 226: ,p_information13 in varchar2 default hr_api.g_varchar2

222: ,p_information9 in varchar2 default hr_api.g_varchar2
223: ,p_information10 in varchar2 default hr_api.g_varchar2
224: ,p_information11 in varchar2 default hr_api.g_varchar2
225: ,p_information12 in varchar2 default hr_api.g_varchar2
226: ,p_information13 in varchar2 default hr_api.g_varchar2
227: ,p_information14 in varchar2 default hr_api.g_varchar2
228: ,p_information15 in varchar2 default hr_api.g_varchar2
229: ,p_information16 in varchar2 default hr_api.g_varchar2
230: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 227: ,p_information14 in varchar2 default hr_api.g_varchar2

223: ,p_information10 in varchar2 default hr_api.g_varchar2
224: ,p_information11 in varchar2 default hr_api.g_varchar2
225: ,p_information12 in varchar2 default hr_api.g_varchar2
226: ,p_information13 in varchar2 default hr_api.g_varchar2
227: ,p_information14 in varchar2 default hr_api.g_varchar2
228: ,p_information15 in varchar2 default hr_api.g_varchar2
229: ,p_information16 in varchar2 default hr_api.g_varchar2
230: ,p_information17 in varchar2 default hr_api.g_varchar2
231: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 228: ,p_information15 in varchar2 default hr_api.g_varchar2

224: ,p_information11 in varchar2 default hr_api.g_varchar2
225: ,p_information12 in varchar2 default hr_api.g_varchar2
226: ,p_information13 in varchar2 default hr_api.g_varchar2
227: ,p_information14 in varchar2 default hr_api.g_varchar2
228: ,p_information15 in varchar2 default hr_api.g_varchar2
229: ,p_information16 in varchar2 default hr_api.g_varchar2
230: ,p_information17 in varchar2 default hr_api.g_varchar2
231: ,p_information18 in varchar2 default hr_api.g_varchar2
232: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 229: ,p_information16 in varchar2 default hr_api.g_varchar2

225: ,p_information12 in varchar2 default hr_api.g_varchar2
226: ,p_information13 in varchar2 default hr_api.g_varchar2
227: ,p_information14 in varchar2 default hr_api.g_varchar2
228: ,p_information15 in varchar2 default hr_api.g_varchar2
229: ,p_information16 in varchar2 default hr_api.g_varchar2
230: ,p_information17 in varchar2 default hr_api.g_varchar2
231: ,p_information18 in varchar2 default hr_api.g_varchar2
232: ,p_information19 in varchar2 default hr_api.g_varchar2
233: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 230: ,p_information17 in varchar2 default hr_api.g_varchar2

226: ,p_information13 in varchar2 default hr_api.g_varchar2
227: ,p_information14 in varchar2 default hr_api.g_varchar2
228: ,p_information15 in varchar2 default hr_api.g_varchar2
229: ,p_information16 in varchar2 default hr_api.g_varchar2
230: ,p_information17 in varchar2 default hr_api.g_varchar2
231: ,p_information18 in varchar2 default hr_api.g_varchar2
232: ,p_information19 in varchar2 default hr_api.g_varchar2
233: ,p_information20 in varchar2 default hr_api.g_varchar2
234: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 231: ,p_information18 in varchar2 default hr_api.g_varchar2

227: ,p_information14 in varchar2 default hr_api.g_varchar2
228: ,p_information15 in varchar2 default hr_api.g_varchar2
229: ,p_information16 in varchar2 default hr_api.g_varchar2
230: ,p_information17 in varchar2 default hr_api.g_varchar2
231: ,p_information18 in varchar2 default hr_api.g_varchar2
232: ,p_information19 in varchar2 default hr_api.g_varchar2
233: ,p_information20 in varchar2 default hr_api.g_varchar2
234: ,p_information21 in varchar2 default hr_api.g_varchar2
235: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 232: ,p_information19 in varchar2 default hr_api.g_varchar2

228: ,p_information15 in varchar2 default hr_api.g_varchar2
229: ,p_information16 in varchar2 default hr_api.g_varchar2
230: ,p_information17 in varchar2 default hr_api.g_varchar2
231: ,p_information18 in varchar2 default hr_api.g_varchar2
232: ,p_information19 in varchar2 default hr_api.g_varchar2
233: ,p_information20 in varchar2 default hr_api.g_varchar2
234: ,p_information21 in varchar2 default hr_api.g_varchar2
235: ,p_information22 in varchar2 default hr_api.g_varchar2
236: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 233: ,p_information20 in varchar2 default hr_api.g_varchar2

229: ,p_information16 in varchar2 default hr_api.g_varchar2
230: ,p_information17 in varchar2 default hr_api.g_varchar2
231: ,p_information18 in varchar2 default hr_api.g_varchar2
232: ,p_information19 in varchar2 default hr_api.g_varchar2
233: ,p_information20 in varchar2 default hr_api.g_varchar2
234: ,p_information21 in varchar2 default hr_api.g_varchar2
235: ,p_information22 in varchar2 default hr_api.g_varchar2
236: ,p_information23 in varchar2 default hr_api.g_varchar2
237: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 234: ,p_information21 in varchar2 default hr_api.g_varchar2

230: ,p_information17 in varchar2 default hr_api.g_varchar2
231: ,p_information18 in varchar2 default hr_api.g_varchar2
232: ,p_information19 in varchar2 default hr_api.g_varchar2
233: ,p_information20 in varchar2 default hr_api.g_varchar2
234: ,p_information21 in varchar2 default hr_api.g_varchar2
235: ,p_information22 in varchar2 default hr_api.g_varchar2
236: ,p_information23 in varchar2 default hr_api.g_varchar2
237: ,p_information24 in varchar2 default hr_api.g_varchar2
238: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 235: ,p_information22 in varchar2 default hr_api.g_varchar2

231: ,p_information18 in varchar2 default hr_api.g_varchar2
232: ,p_information19 in varchar2 default hr_api.g_varchar2
233: ,p_information20 in varchar2 default hr_api.g_varchar2
234: ,p_information21 in varchar2 default hr_api.g_varchar2
235: ,p_information22 in varchar2 default hr_api.g_varchar2
236: ,p_information23 in varchar2 default hr_api.g_varchar2
237: ,p_information24 in varchar2 default hr_api.g_varchar2
238: ,p_information25 in varchar2 default hr_api.g_varchar2
239: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 236: ,p_information23 in varchar2 default hr_api.g_varchar2

232: ,p_information19 in varchar2 default hr_api.g_varchar2
233: ,p_information20 in varchar2 default hr_api.g_varchar2
234: ,p_information21 in varchar2 default hr_api.g_varchar2
235: ,p_information22 in varchar2 default hr_api.g_varchar2
236: ,p_information23 in varchar2 default hr_api.g_varchar2
237: ,p_information24 in varchar2 default hr_api.g_varchar2
238: ,p_information25 in varchar2 default hr_api.g_varchar2
239: ,p_information26 in varchar2 default hr_api.g_varchar2
240: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 237: ,p_information24 in varchar2 default hr_api.g_varchar2

233: ,p_information20 in varchar2 default hr_api.g_varchar2
234: ,p_information21 in varchar2 default hr_api.g_varchar2
235: ,p_information22 in varchar2 default hr_api.g_varchar2
236: ,p_information23 in varchar2 default hr_api.g_varchar2
237: ,p_information24 in varchar2 default hr_api.g_varchar2
238: ,p_information25 in varchar2 default hr_api.g_varchar2
239: ,p_information26 in varchar2 default hr_api.g_varchar2
240: ,p_information27 in varchar2 default hr_api.g_varchar2
241: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 238: ,p_information25 in varchar2 default hr_api.g_varchar2

234: ,p_information21 in varchar2 default hr_api.g_varchar2
235: ,p_information22 in varchar2 default hr_api.g_varchar2
236: ,p_information23 in varchar2 default hr_api.g_varchar2
237: ,p_information24 in varchar2 default hr_api.g_varchar2
238: ,p_information25 in varchar2 default hr_api.g_varchar2
239: ,p_information26 in varchar2 default hr_api.g_varchar2
240: ,p_information27 in varchar2 default hr_api.g_varchar2
241: ,p_information28 in varchar2 default hr_api.g_varchar2
242: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 239: ,p_information26 in varchar2 default hr_api.g_varchar2

235: ,p_information22 in varchar2 default hr_api.g_varchar2
236: ,p_information23 in varchar2 default hr_api.g_varchar2
237: ,p_information24 in varchar2 default hr_api.g_varchar2
238: ,p_information25 in varchar2 default hr_api.g_varchar2
239: ,p_information26 in varchar2 default hr_api.g_varchar2
240: ,p_information27 in varchar2 default hr_api.g_varchar2
241: ,p_information28 in varchar2 default hr_api.g_varchar2
242: ,p_information29 in varchar2 default hr_api.g_varchar2
243: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 240: ,p_information27 in varchar2 default hr_api.g_varchar2

236: ,p_information23 in varchar2 default hr_api.g_varchar2
237: ,p_information24 in varchar2 default hr_api.g_varchar2
238: ,p_information25 in varchar2 default hr_api.g_varchar2
239: ,p_information26 in varchar2 default hr_api.g_varchar2
240: ,p_information27 in varchar2 default hr_api.g_varchar2
241: ,p_information28 in varchar2 default hr_api.g_varchar2
242: ,p_information29 in varchar2 default hr_api.g_varchar2
243: ,p_information30 in varchar2 default hr_api.g_varchar2
244: ,p_template_tab_page_id out nocopy number

Line 241: ,p_information28 in varchar2 default hr_api.g_varchar2

237: ,p_information24 in varchar2 default hr_api.g_varchar2
238: ,p_information25 in varchar2 default hr_api.g_varchar2
239: ,p_information26 in varchar2 default hr_api.g_varchar2
240: ,p_information27 in varchar2 default hr_api.g_varchar2
241: ,p_information28 in varchar2 default hr_api.g_varchar2
242: ,p_information29 in varchar2 default hr_api.g_varchar2
243: ,p_information30 in varchar2 default hr_api.g_varchar2
244: ,p_template_tab_page_id out nocopy number
245: ,p_object_version_number out nocopy number

Line 242: ,p_information29 in varchar2 default hr_api.g_varchar2

238: ,p_information25 in varchar2 default hr_api.g_varchar2
239: ,p_information26 in varchar2 default hr_api.g_varchar2
240: ,p_information27 in varchar2 default hr_api.g_varchar2
241: ,p_information28 in varchar2 default hr_api.g_varchar2
242: ,p_information29 in varchar2 default hr_api.g_varchar2
243: ,p_information30 in varchar2 default hr_api.g_varchar2
244: ,p_template_tab_page_id out nocopy number
245: ,p_object_version_number out nocopy number
246: ,p_override_value_warning out nocopy boolean

Line 243: ,p_information30 in varchar2 default hr_api.g_varchar2

239: ,p_information26 in varchar2 default hr_api.g_varchar2
240: ,p_information27 in varchar2 default hr_api.g_varchar2
241: ,p_information28 in varchar2 default hr_api.g_varchar2
242: ,p_information29 in varchar2 default hr_api.g_varchar2
243: ,p_information30 in varchar2 default hr_api.g_varchar2
244: ,p_template_tab_page_id out nocopy number
245: ,p_object_version_number out nocopy number
246: ,p_override_value_warning out nocopy boolean
247: ) is

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

291: -- instead of p_language_code from now on, to allow an IN OUT parameter to
292: -- be passed through.
293: --
294: l_language_code := p_language_code;
295: hr_api.validate_language_code(p_language_code => l_language_code);
296: --
297: hr_utility.set_location(l_proc, 20);
298: --
299: --

Line 343: when hr_api.cannot_find_prog_unit then

339: ,p_information28 => p_information28
340: ,p_information29 => p_information29
341: ,p_information30 => p_information30);
342: exception
343: when hr_api.cannot_find_prog_unit then
344: hr_api.cannot_find_prog_unit_error
345: (p_module_name => 'create_template_tab_page'
346: ,p_hook_type => 'BP'
347: );

Line 344: hr_api.cannot_find_prog_unit_error

340: ,p_information29 => p_information29
341: ,p_information30 => p_information30);
342: exception
343: when hr_api.cannot_find_prog_unit then
344: hr_api.cannot_find_prog_unit_error
345: (p_module_name => 'create_template_tab_page'
346: ,p_hook_type => 'BP'
347: );
348: end;

Line 360: IF ( p_visible <> hr_api.g_number ) AND

356: CLOSE cur_override;
357:
358: hr_utility.set_location('At:'|| l_proc, 20);
359:
360: IF ( p_visible <> hr_api.g_number ) AND
361: ( p_visible is not null and l_visible_override is not null ) THEN
362: l_override_value_warning := TRUE;
363: END IF;
364:

Line 485: when hr_api.cannot_find_prog_unit then

481: ,p_object_version_number => l_object_version_number
482: ,p_override_value_warning => l_override_value_warning
483: );
484: exception
485: when hr_api.cannot_find_prog_unit then
486: hr_api.cannot_find_prog_unit_error
487: (p_module_name => 'create_template_tab_page'
488: ,p_hook_type => 'AP'
489: );

Line 486: hr_api.cannot_find_prog_unit_error

482: ,p_override_value_warning => l_override_value_warning
483: );
484: exception
485: when hr_api.cannot_find_prog_unit then
486: hr_api.cannot_find_prog_unit_error
487: (p_module_name => 'create_template_tab_page'
488: ,p_hook_type => 'AP'
489: );
490: end;

Line 495: raise hr_api.validate_enabled;

491: --
492: -- When in validation only mode raise the Validate_Enabled exception
493: --
494: if p_validate then
495: raise hr_api.validate_enabled;
496: end if;
497: --
498: -- Set all output arguments
499: --

Line 506: when hr_api.validate_enabled then

502: p_override_value_warning := l_override_value_warning;
503: --
504: hr_utility.set_location(' Leaving:'||l_proc, 70);
505: exception
506: when hr_api.validate_enabled then
507: --
508: -- As the Validate_Enabled exception has been raised
509: -- we must rollback to the savepoint
510: --

Line 593: when hr_api.cannot_find_prog_unit then

589: ,p_object_version_number => p_object_version_number
590: ,p_delete_children_flag => p_delete_children_flag
591: );
592: exception
593: when hr_api.cannot_find_prog_unit then
594: hr_api.cannot_find_prog_unit_error
595: (p_module_name => 'delete_template_tab_page'
596: ,p_hook_type => 'BP'
597: );

Line 594: hr_api.cannot_find_prog_unit_error

590: ,p_delete_children_flag => p_delete_children_flag
591: );
592: exception
593: when hr_api.cannot_find_prog_unit then
594: hr_api.cannot_find_prog_unit_error
595: (p_module_name => 'delete_template_tab_page'
596: ,p_hook_type => 'BP'
597: );
598: end;

Line 664: when hr_api.cannot_find_prog_unit then

660: ,p_object_version_number => p_object_version_number
661: ,p_delete_children_flag => p_delete_children_flag
662: );
663: exception
664: when hr_api.cannot_find_prog_unit then
665: hr_api.cannot_find_prog_unit_error
666: (p_module_name => 'delete_template_tab_page'
667: ,p_hook_type => 'AP'
668: );

Line 665: hr_api.cannot_find_prog_unit_error

661: ,p_delete_children_flag => p_delete_children_flag
662: );
663: exception
664: when hr_api.cannot_find_prog_unit then
665: hr_api.cannot_find_prog_unit_error
666: (p_module_name => 'delete_template_tab_page'
667: ,p_hook_type => 'AP'
668: );
669: end;

Line 674: raise hr_api.validate_enabled;

670: --
671: -- When in validation only mode raise the Validate_Enabled exception
672: --
673: if p_validate then
674: raise hr_api.validate_enabled;
675: end if;
676: --
677: hr_utility.set_location(' Leaving:'||l_proc, 70);
678: exception

Line 679: when hr_api.validate_enabled then

675: end if;
676: --
677: hr_utility.set_location(' Leaving:'||l_proc, 70);
678: exception
679: when hr_api.validate_enabled then
680: --
681: -- As the Validate_Enabled exception has been raised
682: -- we must rollback to the savepoint
683: --

Line 707: ,p_language_code in varchar2 default hr_api.userenv_lang

703: --
704: procedure update_template_tab_page
705: (p_validate in boolean default false
706: ,p_effective_date in date
707: ,p_language_code in varchar2 default hr_api.userenv_lang
708: ,p_template_tab_page_id in number
709: ,p_object_version_number in out nocopy number
710: ,p_label in varchar2 default hr_api.g_varchar2
711: ,p_navigation_direction in varchar2 default hr_api.g_varchar2

Line 710: ,p_label in varchar2 default hr_api.g_varchar2

706: ,p_effective_date in date
707: ,p_language_code in varchar2 default hr_api.userenv_lang
708: ,p_template_tab_page_id in number
709: ,p_object_version_number in out nocopy number
710: ,p_label in varchar2 default hr_api.g_varchar2
711: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
712: ,p_visible in number default hr_api.g_number
713: ,p_information_category in varchar2 default hr_api.g_varchar2
714: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 711: ,p_navigation_direction in varchar2 default hr_api.g_varchar2

707: ,p_language_code in varchar2 default hr_api.userenv_lang
708: ,p_template_tab_page_id in number
709: ,p_object_version_number in out nocopy number
710: ,p_label in varchar2 default hr_api.g_varchar2
711: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
712: ,p_visible in number default hr_api.g_number
713: ,p_information_category in varchar2 default hr_api.g_varchar2
714: ,p_information1 in varchar2 default hr_api.g_varchar2
715: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 712: ,p_visible in number default hr_api.g_number

708: ,p_template_tab_page_id in number
709: ,p_object_version_number in out nocopy number
710: ,p_label in varchar2 default hr_api.g_varchar2
711: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
712: ,p_visible in number default hr_api.g_number
713: ,p_information_category in varchar2 default hr_api.g_varchar2
714: ,p_information1 in varchar2 default hr_api.g_varchar2
715: ,p_information2 in varchar2 default hr_api.g_varchar2
716: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 713: ,p_information_category in varchar2 default hr_api.g_varchar2

709: ,p_object_version_number in out nocopy number
710: ,p_label in varchar2 default hr_api.g_varchar2
711: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
712: ,p_visible in number default hr_api.g_number
713: ,p_information_category in varchar2 default hr_api.g_varchar2
714: ,p_information1 in varchar2 default hr_api.g_varchar2
715: ,p_information2 in varchar2 default hr_api.g_varchar2
716: ,p_information3 in varchar2 default hr_api.g_varchar2
717: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 714: ,p_information1 in varchar2 default hr_api.g_varchar2

710: ,p_label in varchar2 default hr_api.g_varchar2
711: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
712: ,p_visible in number default hr_api.g_number
713: ,p_information_category in varchar2 default hr_api.g_varchar2
714: ,p_information1 in varchar2 default hr_api.g_varchar2
715: ,p_information2 in varchar2 default hr_api.g_varchar2
716: ,p_information3 in varchar2 default hr_api.g_varchar2
717: ,p_information4 in varchar2 default hr_api.g_varchar2
718: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 715: ,p_information2 in varchar2 default hr_api.g_varchar2

711: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
712: ,p_visible in number default hr_api.g_number
713: ,p_information_category in varchar2 default hr_api.g_varchar2
714: ,p_information1 in varchar2 default hr_api.g_varchar2
715: ,p_information2 in varchar2 default hr_api.g_varchar2
716: ,p_information3 in varchar2 default hr_api.g_varchar2
717: ,p_information4 in varchar2 default hr_api.g_varchar2
718: ,p_information5 in varchar2 default hr_api.g_varchar2
719: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 716: ,p_information3 in varchar2 default hr_api.g_varchar2

712: ,p_visible in number default hr_api.g_number
713: ,p_information_category in varchar2 default hr_api.g_varchar2
714: ,p_information1 in varchar2 default hr_api.g_varchar2
715: ,p_information2 in varchar2 default hr_api.g_varchar2
716: ,p_information3 in varchar2 default hr_api.g_varchar2
717: ,p_information4 in varchar2 default hr_api.g_varchar2
718: ,p_information5 in varchar2 default hr_api.g_varchar2
719: ,p_information6 in varchar2 default hr_api.g_varchar2
720: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 717: ,p_information4 in varchar2 default hr_api.g_varchar2

713: ,p_information_category in varchar2 default hr_api.g_varchar2
714: ,p_information1 in varchar2 default hr_api.g_varchar2
715: ,p_information2 in varchar2 default hr_api.g_varchar2
716: ,p_information3 in varchar2 default hr_api.g_varchar2
717: ,p_information4 in varchar2 default hr_api.g_varchar2
718: ,p_information5 in varchar2 default hr_api.g_varchar2
719: ,p_information6 in varchar2 default hr_api.g_varchar2
720: ,p_information7 in varchar2 default hr_api.g_varchar2
721: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 718: ,p_information5 in varchar2 default hr_api.g_varchar2

714: ,p_information1 in varchar2 default hr_api.g_varchar2
715: ,p_information2 in varchar2 default hr_api.g_varchar2
716: ,p_information3 in varchar2 default hr_api.g_varchar2
717: ,p_information4 in varchar2 default hr_api.g_varchar2
718: ,p_information5 in varchar2 default hr_api.g_varchar2
719: ,p_information6 in varchar2 default hr_api.g_varchar2
720: ,p_information7 in varchar2 default hr_api.g_varchar2
721: ,p_information8 in varchar2 default hr_api.g_varchar2
722: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 719: ,p_information6 in varchar2 default hr_api.g_varchar2

715: ,p_information2 in varchar2 default hr_api.g_varchar2
716: ,p_information3 in varchar2 default hr_api.g_varchar2
717: ,p_information4 in varchar2 default hr_api.g_varchar2
718: ,p_information5 in varchar2 default hr_api.g_varchar2
719: ,p_information6 in varchar2 default hr_api.g_varchar2
720: ,p_information7 in varchar2 default hr_api.g_varchar2
721: ,p_information8 in varchar2 default hr_api.g_varchar2
722: ,p_information9 in varchar2 default hr_api.g_varchar2
723: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 720: ,p_information7 in varchar2 default hr_api.g_varchar2

716: ,p_information3 in varchar2 default hr_api.g_varchar2
717: ,p_information4 in varchar2 default hr_api.g_varchar2
718: ,p_information5 in varchar2 default hr_api.g_varchar2
719: ,p_information6 in varchar2 default hr_api.g_varchar2
720: ,p_information7 in varchar2 default hr_api.g_varchar2
721: ,p_information8 in varchar2 default hr_api.g_varchar2
722: ,p_information9 in varchar2 default hr_api.g_varchar2
723: ,p_information10 in varchar2 default hr_api.g_varchar2
724: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 721: ,p_information8 in varchar2 default hr_api.g_varchar2

717: ,p_information4 in varchar2 default hr_api.g_varchar2
718: ,p_information5 in varchar2 default hr_api.g_varchar2
719: ,p_information6 in varchar2 default hr_api.g_varchar2
720: ,p_information7 in varchar2 default hr_api.g_varchar2
721: ,p_information8 in varchar2 default hr_api.g_varchar2
722: ,p_information9 in varchar2 default hr_api.g_varchar2
723: ,p_information10 in varchar2 default hr_api.g_varchar2
724: ,p_information11 in varchar2 default hr_api.g_varchar2
725: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 722: ,p_information9 in varchar2 default hr_api.g_varchar2

718: ,p_information5 in varchar2 default hr_api.g_varchar2
719: ,p_information6 in varchar2 default hr_api.g_varchar2
720: ,p_information7 in varchar2 default hr_api.g_varchar2
721: ,p_information8 in varchar2 default hr_api.g_varchar2
722: ,p_information9 in varchar2 default hr_api.g_varchar2
723: ,p_information10 in varchar2 default hr_api.g_varchar2
724: ,p_information11 in varchar2 default hr_api.g_varchar2
725: ,p_information12 in varchar2 default hr_api.g_varchar2
726: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 723: ,p_information10 in varchar2 default hr_api.g_varchar2

719: ,p_information6 in varchar2 default hr_api.g_varchar2
720: ,p_information7 in varchar2 default hr_api.g_varchar2
721: ,p_information8 in varchar2 default hr_api.g_varchar2
722: ,p_information9 in varchar2 default hr_api.g_varchar2
723: ,p_information10 in varchar2 default hr_api.g_varchar2
724: ,p_information11 in varchar2 default hr_api.g_varchar2
725: ,p_information12 in varchar2 default hr_api.g_varchar2
726: ,p_information13 in varchar2 default hr_api.g_varchar2
727: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 724: ,p_information11 in varchar2 default hr_api.g_varchar2

720: ,p_information7 in varchar2 default hr_api.g_varchar2
721: ,p_information8 in varchar2 default hr_api.g_varchar2
722: ,p_information9 in varchar2 default hr_api.g_varchar2
723: ,p_information10 in varchar2 default hr_api.g_varchar2
724: ,p_information11 in varchar2 default hr_api.g_varchar2
725: ,p_information12 in varchar2 default hr_api.g_varchar2
726: ,p_information13 in varchar2 default hr_api.g_varchar2
727: ,p_information14 in varchar2 default hr_api.g_varchar2
728: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 725: ,p_information12 in varchar2 default hr_api.g_varchar2

721: ,p_information8 in varchar2 default hr_api.g_varchar2
722: ,p_information9 in varchar2 default hr_api.g_varchar2
723: ,p_information10 in varchar2 default hr_api.g_varchar2
724: ,p_information11 in varchar2 default hr_api.g_varchar2
725: ,p_information12 in varchar2 default hr_api.g_varchar2
726: ,p_information13 in varchar2 default hr_api.g_varchar2
727: ,p_information14 in varchar2 default hr_api.g_varchar2
728: ,p_information15 in varchar2 default hr_api.g_varchar2
729: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 726: ,p_information13 in varchar2 default hr_api.g_varchar2

722: ,p_information9 in varchar2 default hr_api.g_varchar2
723: ,p_information10 in varchar2 default hr_api.g_varchar2
724: ,p_information11 in varchar2 default hr_api.g_varchar2
725: ,p_information12 in varchar2 default hr_api.g_varchar2
726: ,p_information13 in varchar2 default hr_api.g_varchar2
727: ,p_information14 in varchar2 default hr_api.g_varchar2
728: ,p_information15 in varchar2 default hr_api.g_varchar2
729: ,p_information16 in varchar2 default hr_api.g_varchar2
730: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 727: ,p_information14 in varchar2 default hr_api.g_varchar2

723: ,p_information10 in varchar2 default hr_api.g_varchar2
724: ,p_information11 in varchar2 default hr_api.g_varchar2
725: ,p_information12 in varchar2 default hr_api.g_varchar2
726: ,p_information13 in varchar2 default hr_api.g_varchar2
727: ,p_information14 in varchar2 default hr_api.g_varchar2
728: ,p_information15 in varchar2 default hr_api.g_varchar2
729: ,p_information16 in varchar2 default hr_api.g_varchar2
730: ,p_information17 in varchar2 default hr_api.g_varchar2
731: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 728: ,p_information15 in varchar2 default hr_api.g_varchar2

724: ,p_information11 in varchar2 default hr_api.g_varchar2
725: ,p_information12 in varchar2 default hr_api.g_varchar2
726: ,p_information13 in varchar2 default hr_api.g_varchar2
727: ,p_information14 in varchar2 default hr_api.g_varchar2
728: ,p_information15 in varchar2 default hr_api.g_varchar2
729: ,p_information16 in varchar2 default hr_api.g_varchar2
730: ,p_information17 in varchar2 default hr_api.g_varchar2
731: ,p_information18 in varchar2 default hr_api.g_varchar2
732: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 729: ,p_information16 in varchar2 default hr_api.g_varchar2

725: ,p_information12 in varchar2 default hr_api.g_varchar2
726: ,p_information13 in varchar2 default hr_api.g_varchar2
727: ,p_information14 in varchar2 default hr_api.g_varchar2
728: ,p_information15 in varchar2 default hr_api.g_varchar2
729: ,p_information16 in varchar2 default hr_api.g_varchar2
730: ,p_information17 in varchar2 default hr_api.g_varchar2
731: ,p_information18 in varchar2 default hr_api.g_varchar2
732: ,p_information19 in varchar2 default hr_api.g_varchar2
733: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 730: ,p_information17 in varchar2 default hr_api.g_varchar2

726: ,p_information13 in varchar2 default hr_api.g_varchar2
727: ,p_information14 in varchar2 default hr_api.g_varchar2
728: ,p_information15 in varchar2 default hr_api.g_varchar2
729: ,p_information16 in varchar2 default hr_api.g_varchar2
730: ,p_information17 in varchar2 default hr_api.g_varchar2
731: ,p_information18 in varchar2 default hr_api.g_varchar2
732: ,p_information19 in varchar2 default hr_api.g_varchar2
733: ,p_information20 in varchar2 default hr_api.g_varchar2
734: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 731: ,p_information18 in varchar2 default hr_api.g_varchar2

727: ,p_information14 in varchar2 default hr_api.g_varchar2
728: ,p_information15 in varchar2 default hr_api.g_varchar2
729: ,p_information16 in varchar2 default hr_api.g_varchar2
730: ,p_information17 in varchar2 default hr_api.g_varchar2
731: ,p_information18 in varchar2 default hr_api.g_varchar2
732: ,p_information19 in varchar2 default hr_api.g_varchar2
733: ,p_information20 in varchar2 default hr_api.g_varchar2
734: ,p_information21 in varchar2 default hr_api.g_varchar2
735: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 732: ,p_information19 in varchar2 default hr_api.g_varchar2

728: ,p_information15 in varchar2 default hr_api.g_varchar2
729: ,p_information16 in varchar2 default hr_api.g_varchar2
730: ,p_information17 in varchar2 default hr_api.g_varchar2
731: ,p_information18 in varchar2 default hr_api.g_varchar2
732: ,p_information19 in varchar2 default hr_api.g_varchar2
733: ,p_information20 in varchar2 default hr_api.g_varchar2
734: ,p_information21 in varchar2 default hr_api.g_varchar2
735: ,p_information22 in varchar2 default hr_api.g_varchar2
736: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 733: ,p_information20 in varchar2 default hr_api.g_varchar2

729: ,p_information16 in varchar2 default hr_api.g_varchar2
730: ,p_information17 in varchar2 default hr_api.g_varchar2
731: ,p_information18 in varchar2 default hr_api.g_varchar2
732: ,p_information19 in varchar2 default hr_api.g_varchar2
733: ,p_information20 in varchar2 default hr_api.g_varchar2
734: ,p_information21 in varchar2 default hr_api.g_varchar2
735: ,p_information22 in varchar2 default hr_api.g_varchar2
736: ,p_information23 in varchar2 default hr_api.g_varchar2
737: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 734: ,p_information21 in varchar2 default hr_api.g_varchar2

730: ,p_information17 in varchar2 default hr_api.g_varchar2
731: ,p_information18 in varchar2 default hr_api.g_varchar2
732: ,p_information19 in varchar2 default hr_api.g_varchar2
733: ,p_information20 in varchar2 default hr_api.g_varchar2
734: ,p_information21 in varchar2 default hr_api.g_varchar2
735: ,p_information22 in varchar2 default hr_api.g_varchar2
736: ,p_information23 in varchar2 default hr_api.g_varchar2
737: ,p_information24 in varchar2 default hr_api.g_varchar2
738: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 735: ,p_information22 in varchar2 default hr_api.g_varchar2

731: ,p_information18 in varchar2 default hr_api.g_varchar2
732: ,p_information19 in varchar2 default hr_api.g_varchar2
733: ,p_information20 in varchar2 default hr_api.g_varchar2
734: ,p_information21 in varchar2 default hr_api.g_varchar2
735: ,p_information22 in varchar2 default hr_api.g_varchar2
736: ,p_information23 in varchar2 default hr_api.g_varchar2
737: ,p_information24 in varchar2 default hr_api.g_varchar2
738: ,p_information25 in varchar2 default hr_api.g_varchar2
739: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 736: ,p_information23 in varchar2 default hr_api.g_varchar2

732: ,p_information19 in varchar2 default hr_api.g_varchar2
733: ,p_information20 in varchar2 default hr_api.g_varchar2
734: ,p_information21 in varchar2 default hr_api.g_varchar2
735: ,p_information22 in varchar2 default hr_api.g_varchar2
736: ,p_information23 in varchar2 default hr_api.g_varchar2
737: ,p_information24 in varchar2 default hr_api.g_varchar2
738: ,p_information25 in varchar2 default hr_api.g_varchar2
739: ,p_information26 in varchar2 default hr_api.g_varchar2
740: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 737: ,p_information24 in varchar2 default hr_api.g_varchar2

733: ,p_information20 in varchar2 default hr_api.g_varchar2
734: ,p_information21 in varchar2 default hr_api.g_varchar2
735: ,p_information22 in varchar2 default hr_api.g_varchar2
736: ,p_information23 in varchar2 default hr_api.g_varchar2
737: ,p_information24 in varchar2 default hr_api.g_varchar2
738: ,p_information25 in varchar2 default hr_api.g_varchar2
739: ,p_information26 in varchar2 default hr_api.g_varchar2
740: ,p_information27 in varchar2 default hr_api.g_varchar2
741: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 738: ,p_information25 in varchar2 default hr_api.g_varchar2

734: ,p_information21 in varchar2 default hr_api.g_varchar2
735: ,p_information22 in varchar2 default hr_api.g_varchar2
736: ,p_information23 in varchar2 default hr_api.g_varchar2
737: ,p_information24 in varchar2 default hr_api.g_varchar2
738: ,p_information25 in varchar2 default hr_api.g_varchar2
739: ,p_information26 in varchar2 default hr_api.g_varchar2
740: ,p_information27 in varchar2 default hr_api.g_varchar2
741: ,p_information28 in varchar2 default hr_api.g_varchar2
742: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 739: ,p_information26 in varchar2 default hr_api.g_varchar2

735: ,p_information22 in varchar2 default hr_api.g_varchar2
736: ,p_information23 in varchar2 default hr_api.g_varchar2
737: ,p_information24 in varchar2 default hr_api.g_varchar2
738: ,p_information25 in varchar2 default hr_api.g_varchar2
739: ,p_information26 in varchar2 default hr_api.g_varchar2
740: ,p_information27 in varchar2 default hr_api.g_varchar2
741: ,p_information28 in varchar2 default hr_api.g_varchar2
742: ,p_information29 in varchar2 default hr_api.g_varchar2
743: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 740: ,p_information27 in varchar2 default hr_api.g_varchar2

736: ,p_information23 in varchar2 default hr_api.g_varchar2
737: ,p_information24 in varchar2 default hr_api.g_varchar2
738: ,p_information25 in varchar2 default hr_api.g_varchar2
739: ,p_information26 in varchar2 default hr_api.g_varchar2
740: ,p_information27 in varchar2 default hr_api.g_varchar2
741: ,p_information28 in varchar2 default hr_api.g_varchar2
742: ,p_information29 in varchar2 default hr_api.g_varchar2
743: ,p_information30 in varchar2 default hr_api.g_varchar2
744: ,p_override_value_warning out nocopy boolean

Line 741: ,p_information28 in varchar2 default hr_api.g_varchar2

737: ,p_information24 in varchar2 default hr_api.g_varchar2
738: ,p_information25 in varchar2 default hr_api.g_varchar2
739: ,p_information26 in varchar2 default hr_api.g_varchar2
740: ,p_information27 in varchar2 default hr_api.g_varchar2
741: ,p_information28 in varchar2 default hr_api.g_varchar2
742: ,p_information29 in varchar2 default hr_api.g_varchar2
743: ,p_information30 in varchar2 default hr_api.g_varchar2
744: ,p_override_value_warning out nocopy boolean
745: ) is

Line 742: ,p_information29 in varchar2 default hr_api.g_varchar2

738: ,p_information25 in varchar2 default hr_api.g_varchar2
739: ,p_information26 in varchar2 default hr_api.g_varchar2
740: ,p_information27 in varchar2 default hr_api.g_varchar2
741: ,p_information28 in varchar2 default hr_api.g_varchar2
742: ,p_information29 in varchar2 default hr_api.g_varchar2
743: ,p_information30 in varchar2 default hr_api.g_varchar2
744: ,p_override_value_warning out nocopy boolean
745: ) is
746: --

Line 743: ,p_information30 in varchar2 default hr_api.g_varchar2

739: ,p_information26 in varchar2 default hr_api.g_varchar2
740: ,p_information27 in varchar2 default hr_api.g_varchar2
741: ,p_information28 in varchar2 default hr_api.g_varchar2
742: ,p_information29 in varchar2 default hr_api.g_varchar2
743: ,p_information30 in varchar2 default hr_api.g_varchar2
744: ,p_override_value_warning out nocopy boolean
745: ) is
746: --
747: -- Declare cursors and local variables

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

793: -- instead of p_language_code from now on, to allow an IN OUT parameter to
794: -- be passed through.
795: --
796: l_language_code := p_language_code;
797: hr_api.validate_language_code(p_language_code => l_language_code);
798: --
799: hr_utility.set_location(l_proc, 20);
800: --
801: --

Line 845: when hr_api.cannot_find_prog_unit then

841: ,p_information28 => p_information28
842: ,p_information29 => p_information29
843: ,p_information30 => p_information30);
844: exception
845: when hr_api.cannot_find_prog_unit then
846: hr_api.cannot_find_prog_unit_error
847: (p_module_name => 'update_template_tab_page'
848: ,p_hook_type => 'BP'
849: );

Line 846: hr_api.cannot_find_prog_unit_error

842: ,p_information29 => p_information29
843: ,p_information30 => p_information30);
844: exception
845: when hr_api.cannot_find_prog_unit then
846: hr_api.cannot_find_prog_unit_error
847: (p_module_name => 'update_template_tab_page'
848: ,p_hook_type => 'BP'
849: );
850: end;

Line 862: IF ( p_visible <> hr_api.g_number ) AND

858: CLOSE cur_override;
859:
860: hr_utility.set_location('At:'|| l_proc, 20);
861:
862: IF ( p_visible <> hr_api.g_number ) AND
863: ( p_visible is not null and l_visible_override is not null ) THEN
864: l_override_value_warning := TRUE;
865: END IF;
866:

Line 976: when hr_api.cannot_find_prog_unit then

972: ,p_information30 => p_information30
973: ,p_override_value_warning => l_override_value_warning
974: );
975: exception
976: when hr_api.cannot_find_prog_unit then
977: hr_api.cannot_find_prog_unit_error
978: (p_module_name => 'update_template_tab_page'
979: ,p_hook_type => 'AP'
980: );

Line 977: hr_api.cannot_find_prog_unit_error

973: ,p_override_value_warning => l_override_value_warning
974: );
975: exception
976: when hr_api.cannot_find_prog_unit then
977: hr_api.cannot_find_prog_unit_error
978: (p_module_name => 'update_template_tab_page'
979: ,p_hook_type => 'AP'
980: );
981: end;

Line 986: raise hr_api.validate_enabled;

982: --
983: -- When in validation only mode raise the Validate_Enabled exception
984: --
985: if p_validate then
986: raise hr_api.validate_enabled;
987: end if;
988: --
989: -- Set all output arguments
990: --

Line 996: when hr_api.validate_enabled then

992: p_override_value_warning := l_override_value_warning;
993: --
994: hr_utility.set_location(' Leaving:'||l_proc, 70);
995: exception
996: when hr_api.validate_enabled then
997: --
998: -- As the Validate_Enabled exception has been raised
999: -- we must rollback to the savepoint
1000: --