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.OTA_SKILL_PROVISION_API dependencies on HR_API

Line 87: when hr_api.cannot_find_prog_unit then

83: p_tsp_information19 => p_tsp_information19 ,
84: p_tsp_information20 => p_tsp_information20 ,
85: p_analysis_criteria_id => p_analysis_criteria_id );
86: exception
87: when hr_api.cannot_find_prog_unit then
88: hr_api.cannot_find_prog_unit_error
89: (p_module_name => 'CREATE_SKILL_PROVISION'
90: ,p_hook_type => 'BP'
91: );

Line 88: hr_api.cannot_find_prog_unit_error

84: p_tsp_information20 => p_tsp_information20 ,
85: p_analysis_criteria_id => p_analysis_criteria_id );
86: exception
87: when hr_api.cannot_find_prog_unit then
88: hr_api.cannot_find_prog_unit_error
89: (p_module_name => 'CREATE_SKILL_PROVISION'
90: ,p_hook_type => 'BP'
91: );
92: end;

Line 157: when hr_api.cannot_find_prog_unit then

153: p_tsp_information19 => p_tsp_information19 ,
154: p_tsp_information20 => p_tsp_information20 ,
155: p_analysis_criteria_id => p_analysis_criteria_id );
156: exception
157: when hr_api.cannot_find_prog_unit then
158: hr_api.cannot_find_prog_unit_error
159: (p_module_name => 'CREATE_SKILL_PROVISION'
160: ,p_hook_type => 'AP'
161: );

Line 158: hr_api.cannot_find_prog_unit_error

154: p_tsp_information20 => p_tsp_information20 ,
155: p_analysis_criteria_id => p_analysis_criteria_id );
156: exception
157: when hr_api.cannot_find_prog_unit then
158: hr_api.cannot_find_prog_unit_error
159: (p_module_name => 'CREATE_SKILL_PROVISION'
160: ,p_hook_type => 'AP'
161: );
162: end;

Line 172: raise hr_api.validate_enabled;

168:
169: -- When in validation only mode raise the Validate_Enabled exception
170: --
171: if p_validate then
172: raise hr_api.validate_enabled;
173: end if;
174: --
175: -- Set all output arguments
176: --

Line 182: when hr_api.validate_enabled then

178: p_object_version_number := l_object_version_number;
179: --
180: hr_utility.set_location(' Leaving:'||l_proc, 70);
181: exception
182: when hr_api.validate_enabled then
183: --
184: -- As the Validate_Enabled exception has been raised
185: -- we must rollback to the savepoint
186: --

Line 213: p_activity_version_id in number default hr_api.g_number,

209: --
210: procedure update_skill_provision
211: (
212: p_skill_provision_id in number,
213: p_activity_version_id in number default hr_api.g_number,
214: p_object_version_number in out nocopy number,
215: p_type in varchar2 default hr_api.g_varchar2,
216: p_comments in varchar2 default hr_api.g_varchar2,
217: p_tsp_information_category in varchar2 default hr_api.g_varchar2,

Line 215: p_type in varchar2 default hr_api.g_varchar2,

211: (
212: p_skill_provision_id in number,
213: p_activity_version_id in number default hr_api.g_number,
214: p_object_version_number in out nocopy number,
215: p_type in varchar2 default hr_api.g_varchar2,
216: p_comments in varchar2 default hr_api.g_varchar2,
217: p_tsp_information_category in varchar2 default hr_api.g_varchar2,
218: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
219: p_tsp_information2 in varchar2 default hr_api.g_varchar2,

Line 216: p_comments in varchar2 default hr_api.g_varchar2,

212: p_skill_provision_id in number,
213: p_activity_version_id in number default hr_api.g_number,
214: p_object_version_number in out nocopy number,
215: p_type in varchar2 default hr_api.g_varchar2,
216: p_comments in varchar2 default hr_api.g_varchar2,
217: p_tsp_information_category in varchar2 default hr_api.g_varchar2,
218: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
219: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
220: p_tsp_information3 in varchar2 default hr_api.g_varchar2,

Line 217: p_tsp_information_category in varchar2 default hr_api.g_varchar2,

213: p_activity_version_id in number default hr_api.g_number,
214: p_object_version_number in out nocopy number,
215: p_type in varchar2 default hr_api.g_varchar2,
216: p_comments in varchar2 default hr_api.g_varchar2,
217: p_tsp_information_category in varchar2 default hr_api.g_varchar2,
218: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
219: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
220: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
221: p_tsp_information4 in varchar2 default hr_api.g_varchar2,

Line 218: p_tsp_information1 in varchar2 default hr_api.g_varchar2,

214: p_object_version_number in out nocopy number,
215: p_type in varchar2 default hr_api.g_varchar2,
216: p_comments in varchar2 default hr_api.g_varchar2,
217: p_tsp_information_category in varchar2 default hr_api.g_varchar2,
218: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
219: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
220: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
221: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
222: p_tsp_information5 in varchar2 default hr_api.g_varchar2,

Line 219: p_tsp_information2 in varchar2 default hr_api.g_varchar2,

215: p_type in varchar2 default hr_api.g_varchar2,
216: p_comments in varchar2 default hr_api.g_varchar2,
217: p_tsp_information_category in varchar2 default hr_api.g_varchar2,
218: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
219: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
220: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
221: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
222: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
223: p_tsp_information6 in varchar2 default hr_api.g_varchar2,

Line 220: p_tsp_information3 in varchar2 default hr_api.g_varchar2,

216: p_comments in varchar2 default hr_api.g_varchar2,
217: p_tsp_information_category in varchar2 default hr_api.g_varchar2,
218: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
219: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
220: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
221: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
222: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
223: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
224: p_tsp_information7 in varchar2 default hr_api.g_varchar2,

Line 221: p_tsp_information4 in varchar2 default hr_api.g_varchar2,

217: p_tsp_information_category in varchar2 default hr_api.g_varchar2,
218: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
219: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
220: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
221: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
222: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
223: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
224: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
225: p_tsp_information8 in varchar2 default hr_api.g_varchar2,

Line 222: p_tsp_information5 in varchar2 default hr_api.g_varchar2,

218: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
219: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
220: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
221: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
222: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
223: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
224: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
225: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
226: p_tsp_information9 in varchar2 default hr_api.g_varchar2,

Line 223: p_tsp_information6 in varchar2 default hr_api.g_varchar2,

219: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
220: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
221: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
222: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
223: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
224: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
225: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
226: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
227: p_tsp_information10 in varchar2 default hr_api.g_varchar2,

Line 224: p_tsp_information7 in varchar2 default hr_api.g_varchar2,

220: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
221: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
222: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
223: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
224: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
225: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
226: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
227: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
228: p_tsp_information11 in varchar2 default hr_api.g_varchar2,

Line 225: p_tsp_information8 in varchar2 default hr_api.g_varchar2,

221: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
222: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
223: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
224: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
225: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
226: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
227: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
228: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
229: p_tsp_information12 in varchar2 default hr_api.g_varchar2,

Line 226: p_tsp_information9 in varchar2 default hr_api.g_varchar2,

222: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
223: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
224: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
225: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
226: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
227: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
228: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
229: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
230: p_tsp_information13 in varchar2 default hr_api.g_varchar2,

Line 227: p_tsp_information10 in varchar2 default hr_api.g_varchar2,

223: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
224: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
225: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
226: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
227: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
228: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
229: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
230: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
231: p_tsp_information14 in varchar2 default hr_api.g_varchar2,

Line 228: p_tsp_information11 in varchar2 default hr_api.g_varchar2,

224: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
225: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
226: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
227: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
228: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
229: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
230: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
231: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
232: p_tsp_information15 in varchar2 default hr_api.g_varchar2,

Line 229: p_tsp_information12 in varchar2 default hr_api.g_varchar2,

225: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
226: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
227: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
228: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
229: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
230: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
231: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
232: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
233: p_tsp_information16 in varchar2 default hr_api.g_varchar2,

Line 230: p_tsp_information13 in varchar2 default hr_api.g_varchar2,

226: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
227: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
228: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
229: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
230: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
231: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
232: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
233: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
234: p_tsp_information17 in varchar2 default hr_api.g_varchar2,

Line 231: p_tsp_information14 in varchar2 default hr_api.g_varchar2,

227: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
228: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
229: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
230: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
231: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
232: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
233: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
234: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
235: p_tsp_information18 in varchar2 default hr_api.g_varchar2,

Line 232: p_tsp_information15 in varchar2 default hr_api.g_varchar2,

228: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
229: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
230: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
231: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
232: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
233: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
234: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
235: p_tsp_information18 in varchar2 default hr_api.g_varchar2,
236: p_tsp_information19 in varchar2 default hr_api.g_varchar2,

Line 233: p_tsp_information16 in varchar2 default hr_api.g_varchar2,

229: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
230: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
231: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
232: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
233: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
234: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
235: p_tsp_information18 in varchar2 default hr_api.g_varchar2,
236: p_tsp_information19 in varchar2 default hr_api.g_varchar2,
237: p_tsp_information20 in varchar2 default hr_api.g_varchar2,

Line 234: p_tsp_information17 in varchar2 default hr_api.g_varchar2,

230: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
231: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
232: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
233: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
234: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
235: p_tsp_information18 in varchar2 default hr_api.g_varchar2,
236: p_tsp_information19 in varchar2 default hr_api.g_varchar2,
237: p_tsp_information20 in varchar2 default hr_api.g_varchar2,
238: p_analysis_criteria_id in number default hr_api.g_number,

Line 235: p_tsp_information18 in varchar2 default hr_api.g_varchar2,

231: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
232: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
233: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
234: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
235: p_tsp_information18 in varchar2 default hr_api.g_varchar2,
236: p_tsp_information19 in varchar2 default hr_api.g_varchar2,
237: p_tsp_information20 in varchar2 default hr_api.g_varchar2,
238: p_analysis_criteria_id in number default hr_api.g_number,
239: p_validate in boolean default false

Line 236: p_tsp_information19 in varchar2 default hr_api.g_varchar2,

232: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
233: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
234: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
235: p_tsp_information18 in varchar2 default hr_api.g_varchar2,
236: p_tsp_information19 in varchar2 default hr_api.g_varchar2,
237: p_tsp_information20 in varchar2 default hr_api.g_varchar2,
238: p_analysis_criteria_id in number default hr_api.g_number,
239: p_validate in boolean default false
240: ) is

Line 237: p_tsp_information20 in varchar2 default hr_api.g_varchar2,

233: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
234: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
235: p_tsp_information18 in varchar2 default hr_api.g_varchar2,
236: p_tsp_information19 in varchar2 default hr_api.g_varchar2,
237: p_tsp_information20 in varchar2 default hr_api.g_varchar2,
238: p_analysis_criteria_id in number default hr_api.g_number,
239: p_validate in boolean default false
240: ) is
241: --

Line 238: p_analysis_criteria_id in number default hr_api.g_number,

234: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
235: p_tsp_information18 in varchar2 default hr_api.g_varchar2,
236: p_tsp_information19 in varchar2 default hr_api.g_varchar2,
237: p_tsp_information20 in varchar2 default hr_api.g_varchar2,
238: p_analysis_criteria_id in number default hr_api.g_number,
239: p_validate in boolean default false
240: ) is
241: --
242: -- Declare cursors and local variables

Line 284: when hr_api.cannot_find_prog_unit then

280: p_tsp_information19 => p_tsp_information19 ,
281: p_tsp_information20 => p_tsp_information20 ,
282: p_analysis_criteria_id => p_analysis_criteria_id );
283: exception
284: when hr_api.cannot_find_prog_unit then
285: hr_api.cannot_find_prog_unit_error
286: (p_module_name => 'UPDATE_SKILL_PROVISION'
287: ,p_hook_type => 'BP'
288: );

Line 285: hr_api.cannot_find_prog_unit_error

281: p_tsp_information20 => p_tsp_information20 ,
282: p_analysis_criteria_id => p_analysis_criteria_id );
283: exception
284: when hr_api.cannot_find_prog_unit then
285: hr_api.cannot_find_prog_unit_error
286: (p_module_name => 'UPDATE_SKILL_PROVISION'
287: ,p_hook_type => 'BP'
288: );
289: end;

Line 358: when hr_api.cannot_find_prog_unit then

354: p_tsp_information19 => p_tsp_information19 ,
355: p_tsp_information20 => p_tsp_information20 ,
356: p_analysis_criteria_id => p_analysis_criteria_id );
357: exception
358: when hr_api.cannot_find_prog_unit then
359: hr_api.cannot_find_prog_unit_error
360: (p_module_name => 'UPDATE_SKILL_PROVISION'
361: ,p_hook_type => 'AP'
362: );

Line 359: hr_api.cannot_find_prog_unit_error

355: p_tsp_information20 => p_tsp_information20 ,
356: p_analysis_criteria_id => p_analysis_criteria_id );
357: exception
358: when hr_api.cannot_find_prog_unit then
359: hr_api.cannot_find_prog_unit_error
360: (p_module_name => 'UPDATE_SKILL_PROVISION'
361: ,p_hook_type => 'AP'
362: );
363: end;

Line 369: raise hr_api.validate_enabled;

365:
366: -- When in validation only mode raise the Validate_Enabled exception
367: --
368: if p_validate then
369: raise hr_api.validate_enabled;
370: end if;
371: --
372: -- Set all output arguments
373: --

Line 376: when hr_api.validate_enabled then

372: -- Set all output arguments
373: --
374: hr_utility.set_location(' Leaving:'||l_proc, 70);
375: exception
376: when hr_api.validate_enabled then
377: --
378: -- As the Validate_Enabled exception has been raised
379: -- we must rollback to the savepoint
380: --

Line 431: when hr_api.cannot_find_prog_unit then

427: (p_skill_provision_id => p_skill_provision_id ,
428: p_object_version_number => p_object_version_number
429: );
430: exception
431: when hr_api.cannot_find_prog_unit then
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'DELETE_SKILL_PROVISION'
434: ,p_hook_type => 'BP'
435: );

Line 432: hr_api.cannot_find_prog_unit_error

428: p_object_version_number => p_object_version_number
429: );
430: exception
431: when hr_api.cannot_find_prog_unit then
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'DELETE_SKILL_PROVISION'
434: ,p_hook_type => 'BP'
435: );
436: end;

Line 459: when hr_api.cannot_find_prog_unit then

455: (p_skill_provision_id => p_skill_provision_id ,
456: p_object_version_number => p_object_version_number
457: );
458: exception
459: when hr_api.cannot_find_prog_unit then
460: hr_api.cannot_find_prog_unit_error
461: (p_module_name => 'DELETE_SKILL_PROVISION'
462: ,p_hook_type => 'AP'
463: );

Line 460: hr_api.cannot_find_prog_unit_error

456: p_object_version_number => p_object_version_number
457: );
458: exception
459: when hr_api.cannot_find_prog_unit then
460: hr_api.cannot_find_prog_unit_error
461: (p_module_name => 'DELETE_SKILL_PROVISION'
462: ,p_hook_type => 'AP'
463: );
464: end;

Line 466: raise hr_api.validate_enabled;

462: ,p_hook_type => 'AP'
463: );
464: end;
465: if p_validate then
466: raise hr_api.validate_enabled;
467: end if;
468: --
469: -- Set all output arguments
470: --

Line 474: when hr_api.validate_enabled then

470: --
471: --
472: hr_utility.set_location(' Leaving:'||l_proc, 170);
473: exception
474: when hr_api.validate_enabled then
475: --
476: -- As the Validate_Enabled exception has been raised
477: -- we must rollback to the savepoint
478: --