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_LP_SECTION_API dependencies on HR_API

Line 101: when hr_api.cannot_find_prog_unit then

97: ,p_attribute19 => p_attribute19
98: ,p_attribute20 => p_attribute20
99: );
100: exception
101: when hr_api.cannot_find_prog_unit then
102: hr_api.cannot_find_prog_unit_error
103: (p_module_name => 'Create_Lp_Section'
104: ,p_hook_type => 'BP'
105: );

Line 102: hr_api.cannot_find_prog_unit_error

98: ,p_attribute20 => p_attribute20
99: );
100: exception
101: when hr_api.cannot_find_prog_unit then
102: hr_api.cannot_find_prog_unit_error
103: (p_module_name => 'Create_Lp_Section'
104: ,p_hook_type => 'BP'
105: );
106: end;

Line 197: when hr_api.cannot_find_prog_unit then

193: ,p_learning_path_section_id => l_learning_path_section_id
194: ,p_object_version_number => l_object_version_number
195: );
196: exception
197: when hr_api.cannot_find_prog_unit then
198: hr_api.cannot_find_prog_unit_error
199: (p_module_name => 'Create_Lp_Section'
200: ,p_hook_type => 'AP'
201: );

Line 198: hr_api.cannot_find_prog_unit_error

194: ,p_object_version_number => l_object_version_number
195: );
196: exception
197: when hr_api.cannot_find_prog_unit then
198: hr_api.cannot_find_prog_unit_error
199: (p_module_name => 'Create_Lp_Section'
200: ,p_hook_type => 'AP'
201: );
202: end;

Line 207: raise hr_api.validate_enabled;

203: --
204: -- When in validation only mode raise the Validate_Enabled exception
205: --
206: if p_validate then
207: raise hr_api.validate_enabled;
208: end if;
209: --
210: -- Set all output arguments
211: --

Line 217: when hr_api.validate_enabled then

213: p_object_version_number := l_object_version_number;
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 70);
216: exception
217: when hr_api.validate_enabled then
218: --
219: -- As the Validate_Enabled exception has been raised
220: -- we must rollback to the savepoint
221: --

Line 250: ,p_description in varchar2 default hr_api.g_varchar2

246: (p_validate in boolean default false
247: ,p_effective_date in date
248: ,p_learning_path_section_id in number
249: ,p_section_name in varchar2
250: ,p_description in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
252: ,p_section_sequence in number default hr_api.g_number
253: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
254: ,p_no_of_mandatory_courses in number default hr_api.g_number

Line 252: ,p_section_sequence in number default hr_api.g_number

248: ,p_learning_path_section_id in number
249: ,p_section_name in varchar2
250: ,p_description in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
252: ,p_section_sequence in number default hr_api.g_number
253: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
254: ,p_no_of_mandatory_courses in number default hr_api.g_number
255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 253: ,p_completion_type_code in varchar2 default hr_api.g_varchar2

249: ,p_section_name in varchar2
250: ,p_description in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
252: ,p_section_sequence in number default hr_api.g_number
253: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
254: ,p_no_of_mandatory_courses in number default hr_api.g_number
255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 254: ,p_no_of_mandatory_courses in number default hr_api.g_number

250: ,p_description in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
252: ,p_section_sequence in number default hr_api.g_number
253: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
254: ,p_no_of_mandatory_courses in number default hr_api.g_number
255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 255: ,p_attribute_category in varchar2 default hr_api.g_varchar2

251: ,p_object_version_number in out nocopy number
252: ,p_section_sequence in number default hr_api.g_number
253: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
254: ,p_no_of_mandatory_courses in number default hr_api.g_number
255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 256: ,p_attribute1 in varchar2 default hr_api.g_varchar2

252: ,p_section_sequence in number default hr_api.g_number
253: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
254: ,p_no_of_mandatory_courses in number default hr_api.g_number
255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 257: ,p_attribute2 in varchar2 default hr_api.g_varchar2

253: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
254: ,p_no_of_mandatory_courses in number default hr_api.g_number
255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 258: ,p_attribute3 in varchar2 default hr_api.g_varchar2

254: ,p_no_of_mandatory_courses in number default hr_api.g_number
255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 259: ,p_attribute4 in varchar2 default hr_api.g_varchar2

255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 260: ,p_attribute5 in varchar2 default hr_api.g_varchar2

256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 261: ,p_attribute6 in varchar2 default hr_api.g_varchar2

257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 262: ,p_attribute7 in varchar2 default hr_api.g_varchar2

258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 263: ,p_attribute8 in varchar2 default hr_api.g_varchar2

259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 264: ,p_attribute9 in varchar2 default hr_api.g_varchar2

260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 265: ,p_attribute10 in varchar2 default hr_api.g_varchar2

261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 266: ,p_attribute11 in varchar2 default hr_api.g_varchar2

262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 267: ,p_attribute12 in varchar2 default hr_api.g_varchar2

263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 268: ,p_attribute13 in varchar2 default hr_api.g_varchar2

264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 269: ,p_attribute14 in varchar2 default hr_api.g_varchar2

265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2
273: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 270: ,p_attribute15 in varchar2 default hr_api.g_varchar2

266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2
273: ,p_attribute18 in varchar2 default hr_api.g_varchar2
274: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 271: ,p_attribute16 in varchar2 default hr_api.g_varchar2

267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2
273: ,p_attribute18 in varchar2 default hr_api.g_varchar2
274: ,p_attribute19 in varchar2 default hr_api.g_varchar2
275: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 272: ,p_attribute17 in varchar2 default hr_api.g_varchar2

268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2
273: ,p_attribute18 in varchar2 default hr_api.g_varchar2
274: ,p_attribute19 in varchar2 default hr_api.g_varchar2
275: ,p_attribute20 in varchar2 default hr_api.g_varchar2
276: ) is

Line 273: ,p_attribute18 in varchar2 default hr_api.g_varchar2

269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2
273: ,p_attribute18 in varchar2 default hr_api.g_varchar2
274: ,p_attribute19 in varchar2 default hr_api.g_varchar2
275: ,p_attribute20 in varchar2 default hr_api.g_varchar2
276: ) is
277: --

Line 274: ,p_attribute19 in varchar2 default hr_api.g_varchar2

270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2
273: ,p_attribute18 in varchar2 default hr_api.g_varchar2
274: ,p_attribute19 in varchar2 default hr_api.g_varchar2
275: ,p_attribute20 in varchar2 default hr_api.g_varchar2
276: ) is
277: --
278: -- Declare cursors and local variables

Line 275: ,p_attribute20 in varchar2 default hr_api.g_varchar2

271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2
273: ,p_attribute18 in varchar2 default hr_api.g_varchar2
274: ,p_attribute19 in varchar2 default hr_api.g_varchar2
275: ,p_attribute20 in varchar2 default hr_api.g_varchar2
276: ) is
277: --
278: -- Declare cursors and local variables
279: --

Line 361: when hr_api.cannot_find_prog_unit then

357: ,p_attribute19 => p_attribute19
358: ,p_attribute20 => p_attribute20
359: );
360: exception
361: when hr_api.cannot_find_prog_unit then
362: hr_api.cannot_find_prog_unit_error
363: (p_module_name => 'Update_Lp_Section'
364: ,p_hook_type => 'BP'
365: );

Line 362: hr_api.cannot_find_prog_unit_error

358: ,p_attribute20 => p_attribute20
359: );
360: exception
361: when hr_api.cannot_find_prog_unit then
362: hr_api.cannot_find_prog_unit_error
363: (p_module_name => 'Update_Lp_Section'
364: ,p_hook_type => 'BP'
365: );
366: end;

Line 448: when hr_api.cannot_find_prog_unit then

444: ,p_attribute19 => p_attribute19
445: ,p_attribute20 => p_attribute20
446: );
447: exception
448: when hr_api.cannot_find_prog_unit then
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'Update_Lp_Section'
451: ,p_hook_type => 'AP'
452: );

Line 449: hr_api.cannot_find_prog_unit_error

445: ,p_attribute20 => p_attribute20
446: );
447: exception
448: when hr_api.cannot_find_prog_unit then
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'Update_Lp_Section'
451: ,p_hook_type => 'AP'
452: );
453: end;

Line 478: raise hr_api.validate_enabled;

474:
475: -- When in validation only mode raise the Validate_Enabled exception
476: --
477: if p_validate then
478: raise hr_api.validate_enabled;
479: end if;
480: --
481: -- Set all output arguments
482: --

Line 487: when hr_api.validate_enabled then

483: p_object_version_number := l_object_version_number;
484: --
485: hr_utility.set_location(' Leaving:'||l_proc, 70);
486: exception
487: when hr_api.validate_enabled then
488: --
489: -- As the Validate_Enabled exception has been raised
490: -- we must rollback to the savepoint
491: --

Line 540: when hr_api.cannot_find_prog_unit then

536: (p_learning_path_section_id => p_learning_path_section_id
537: ,p_object_version_number => p_object_version_number
538: );
539: exception
540: when hr_api.cannot_find_prog_unit then
541: hr_api.cannot_find_prog_unit_error
542: (p_module_name => 'Delete_Learning_Path_Section'
543: ,p_hook_type => 'BP'
544: );

Line 541: hr_api.cannot_find_prog_unit_error

537: ,p_object_version_number => p_object_version_number
538: );
539: exception
540: when hr_api.cannot_find_prog_unit then
541: hr_api.cannot_find_prog_unit_error
542: (p_module_name => 'Delete_Learning_Path_Section'
543: ,p_hook_type => 'BP'
544: );
545: end;

Line 565: when hr_api.cannot_find_prog_unit then

561: (p_learning_path_section_id => p_learning_path_section_id
562: ,p_object_version_number => p_object_version_number
563: );
564: exception
565: when hr_api.cannot_find_prog_unit then
566: hr_api.cannot_find_prog_unit_error
567: (p_module_name => 'Delete_Lp_Section'
568: ,p_hook_type => 'AP'
569: );

Line 566: hr_api.cannot_find_prog_unit_error

562: ,p_object_version_number => p_object_version_number
563: );
564: exception
565: when hr_api.cannot_find_prog_unit then
566: hr_api.cannot_find_prog_unit_error
567: (p_module_name => 'Delete_Lp_Section'
568: ,p_hook_type => 'AP'
569: );
570: end;

Line 575: raise hr_api.validate_enabled;

571: --
572: -- When in validation only mode raise the Validate_Enabled exception
573: --
574: if p_validate then
575: raise hr_api.validate_enabled;
576: end if;
577: --
578: -- Set all output arguments
579: --

Line 583: when hr_api.validate_enabled then

579: --
580: --
581: hr_utility.set_location(' Leaving:'||l_proc, 170);
582: exception
583: when hr_api.validate_enabled then
584: --
585: -- As the Validate_Enabled exception has been raised
586: -- we must rollback to the savepoint
587: --