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

Line 149: when hr_api.cannot_find_prog_unit then

145: -- Modified for Bug#3479186
146: ,p_contact_id => p_contact_id
147: );
148: exception
149: when hr_api.cannot_find_prog_unit then
150: hr_api.cannot_find_prog_unit_error
151: (p_module_name => 'CREATE_TRAINING_PLAN'
152: ,p_hook_type => 'BP'
153: );

Line 150: hr_api.cannot_find_prog_unit_error

146: ,p_contact_id => p_contact_id
147: );
148: exception
149: when hr_api.cannot_find_prog_unit then
150: hr_api.cannot_find_prog_unit_error
151: (p_module_name => 'CREATE_TRAINING_PLAN'
152: ,p_hook_type => 'BP'
153: );
154: end;

Line 270: when hr_api.cannot_find_prog_unit then

266: ,p_training_plan_id => l_training_plan_id
267: ,p_object_version_number => l_object_version_number
268: );
269: exception
270: when hr_api.cannot_find_prog_unit then
271: hr_api.cannot_find_prog_unit_error
272: (p_module_name => 'CREATE_TRAINING_PLAN'
273: ,p_hook_type => 'AP'
274: );

Line 271: hr_api.cannot_find_prog_unit_error

267: ,p_object_version_number => l_object_version_number
268: );
269: exception
270: when hr_api.cannot_find_prog_unit then
271: hr_api.cannot_find_prog_unit_error
272: (p_module_name => 'CREATE_TRAINING_PLAN'
273: ,p_hook_type => 'AP'
274: );
275: end;

Line 280: raise hr_api.validate_enabled;

276: --
277: -- When in validation only mode raise the Validate_Enabled exception
278: --
279: if p_validate then
280: raise hr_api.validate_enabled;
281: end if;
282: --
283: -- Set all output arguments
284: --

Line 306: when hr_api.validate_enabled then

302: end if;
303: --
304: hr_utility.set_location(' Leaving:'||l_proc, 70);
305: exception
306: when hr_api.validate_enabled then
307: --
308: -- As the Validate_Enabled exception has been raised
309: -- we must rollback to the savepoint
310: --

Line 343: ,p_description in varchar2 default hr_api.g_varchar2

339: ,p_time_period_id in number
340: ,p_plan_status_type_id in varchar2
341: ,p_budget_currency in varchar2
342: ,p_name in varchar2
343: ,p_description in varchar2 default hr_api.g_varchar2
344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 344: ,p_attribute_category in varchar2 default hr_api.g_varchar2

340: ,p_plan_status_type_id in varchar2
341: ,p_budget_currency in varchar2
342: ,p_name in varchar2
343: ,p_description in varchar2 default hr_api.g_varchar2
344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 345: ,p_attribute1 in varchar2 default hr_api.g_varchar2

341: ,p_budget_currency in varchar2
342: ,p_name in varchar2
343: ,p_description in varchar2 default hr_api.g_varchar2
344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 346: ,p_attribute2 in varchar2 default hr_api.g_varchar2

342: ,p_name in varchar2
343: ,p_description in varchar2 default hr_api.g_varchar2
344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 347: ,p_attribute3 in varchar2 default hr_api.g_varchar2

343: ,p_description in varchar2 default hr_api.g_varchar2
344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 348: ,p_attribute4 in varchar2 default hr_api.g_varchar2

344: ,p_attribute_category in varchar2 default hr_api.g_varchar2
345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 349: ,p_attribute5 in varchar2 default hr_api.g_varchar2

345: ,p_attribute1 in varchar2 default hr_api.g_varchar2
346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 350: ,p_attribute6 in varchar2 default hr_api.g_varchar2

346: ,p_attribute2 in varchar2 default hr_api.g_varchar2
347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 351: ,p_attribute7 in varchar2 default hr_api.g_varchar2

347: ,p_attribute3 in varchar2 default hr_api.g_varchar2
348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 352: ,p_attribute8 in varchar2 default hr_api.g_varchar2

348: ,p_attribute4 in varchar2 default hr_api.g_varchar2
349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 353: ,p_attribute9 in varchar2 default hr_api.g_varchar2

349: ,p_attribute5 in varchar2 default hr_api.g_varchar2
350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 354: ,p_attribute10 in varchar2 default hr_api.g_varchar2

350: ,p_attribute6 in varchar2 default hr_api.g_varchar2
351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 355: ,p_attribute11 in varchar2 default hr_api.g_varchar2

351: ,p_attribute7 in varchar2 default hr_api.g_varchar2
352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 356: ,p_attribute12 in varchar2 default hr_api.g_varchar2

352: ,p_attribute8 in varchar2 default hr_api.g_varchar2
353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 357: ,p_attribute13 in varchar2 default hr_api.g_varchar2

353: ,p_attribute9 in varchar2 default hr_api.g_varchar2
354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 358: ,p_attribute14 in varchar2 default hr_api.g_varchar2

354: ,p_attribute10 in varchar2 default hr_api.g_varchar2
355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 359: ,p_attribute15 in varchar2 default hr_api.g_varchar2

355: ,p_attribute11 in varchar2 default hr_api.g_varchar2
356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 360: ,p_attribute16 in varchar2 default hr_api.g_varchar2

356: ,p_attribute12 in varchar2 default hr_api.g_varchar2
357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 361: ,p_attribute17 in varchar2 default hr_api.g_varchar2

357: ,p_attribute13 in varchar2 default hr_api.g_varchar2
358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 362: ,p_attribute18 in varchar2 default hr_api.g_varchar2

358: ,p_attribute14 in varchar2 default hr_api.g_varchar2
359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_attribute21 in varchar2 default hr_api.g_varchar2
366: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 363: ,p_attribute19 in varchar2 default hr_api.g_varchar2

359: ,p_attribute15 in varchar2 default hr_api.g_varchar2
360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_attribute21 in varchar2 default hr_api.g_varchar2
366: ,p_attribute22 in varchar2 default hr_api.g_varchar2
367: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 364: ,p_attribute20 in varchar2 default hr_api.g_varchar2

360: ,p_attribute16 in varchar2 default hr_api.g_varchar2
361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_attribute21 in varchar2 default hr_api.g_varchar2
366: ,p_attribute22 in varchar2 default hr_api.g_varchar2
367: ,p_attribute23 in varchar2 default hr_api.g_varchar2
368: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 365: ,p_attribute21 in varchar2 default hr_api.g_varchar2

361: ,p_attribute17 in varchar2 default hr_api.g_varchar2
362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_attribute21 in varchar2 default hr_api.g_varchar2
366: ,p_attribute22 in varchar2 default hr_api.g_varchar2
367: ,p_attribute23 in varchar2 default hr_api.g_varchar2
368: ,p_attribute24 in varchar2 default hr_api.g_varchar2
369: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 366: ,p_attribute22 in varchar2 default hr_api.g_varchar2

362: ,p_attribute18 in varchar2 default hr_api.g_varchar2
363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_attribute21 in varchar2 default hr_api.g_varchar2
366: ,p_attribute22 in varchar2 default hr_api.g_varchar2
367: ,p_attribute23 in varchar2 default hr_api.g_varchar2
368: ,p_attribute24 in varchar2 default hr_api.g_varchar2
369: ,p_attribute25 in varchar2 default hr_api.g_varchar2
370: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 367: ,p_attribute23 in varchar2 default hr_api.g_varchar2

363: ,p_attribute19 in varchar2 default hr_api.g_varchar2
364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_attribute21 in varchar2 default hr_api.g_varchar2
366: ,p_attribute22 in varchar2 default hr_api.g_varchar2
367: ,p_attribute23 in varchar2 default hr_api.g_varchar2
368: ,p_attribute24 in varchar2 default hr_api.g_varchar2
369: ,p_attribute25 in varchar2 default hr_api.g_varchar2
370: ,p_attribute26 in varchar2 default hr_api.g_varchar2
371: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 368: ,p_attribute24 in varchar2 default hr_api.g_varchar2

364: ,p_attribute20 in varchar2 default hr_api.g_varchar2
365: ,p_attribute21 in varchar2 default hr_api.g_varchar2
366: ,p_attribute22 in varchar2 default hr_api.g_varchar2
367: ,p_attribute23 in varchar2 default hr_api.g_varchar2
368: ,p_attribute24 in varchar2 default hr_api.g_varchar2
369: ,p_attribute25 in varchar2 default hr_api.g_varchar2
370: ,p_attribute26 in varchar2 default hr_api.g_varchar2
371: ,p_attribute27 in varchar2 default hr_api.g_varchar2
372: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 369: ,p_attribute25 in varchar2 default hr_api.g_varchar2

365: ,p_attribute21 in varchar2 default hr_api.g_varchar2
366: ,p_attribute22 in varchar2 default hr_api.g_varchar2
367: ,p_attribute23 in varchar2 default hr_api.g_varchar2
368: ,p_attribute24 in varchar2 default hr_api.g_varchar2
369: ,p_attribute25 in varchar2 default hr_api.g_varchar2
370: ,p_attribute26 in varchar2 default hr_api.g_varchar2
371: ,p_attribute27 in varchar2 default hr_api.g_varchar2
372: ,p_attribute28 in varchar2 default hr_api.g_varchar2
373: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 370: ,p_attribute26 in varchar2 default hr_api.g_varchar2

366: ,p_attribute22 in varchar2 default hr_api.g_varchar2
367: ,p_attribute23 in varchar2 default hr_api.g_varchar2
368: ,p_attribute24 in varchar2 default hr_api.g_varchar2
369: ,p_attribute25 in varchar2 default hr_api.g_varchar2
370: ,p_attribute26 in varchar2 default hr_api.g_varchar2
371: ,p_attribute27 in varchar2 default hr_api.g_varchar2
372: ,p_attribute28 in varchar2 default hr_api.g_varchar2
373: ,p_attribute29 in varchar2 default hr_api.g_varchar2
374: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 371: ,p_attribute27 in varchar2 default hr_api.g_varchar2

367: ,p_attribute23 in varchar2 default hr_api.g_varchar2
368: ,p_attribute24 in varchar2 default hr_api.g_varchar2
369: ,p_attribute25 in varchar2 default hr_api.g_varchar2
370: ,p_attribute26 in varchar2 default hr_api.g_varchar2
371: ,p_attribute27 in varchar2 default hr_api.g_varchar2
372: ,p_attribute28 in varchar2 default hr_api.g_varchar2
373: ,p_attribute29 in varchar2 default hr_api.g_varchar2
374: ,p_attribute30 in varchar2 default hr_api.g_varchar2
375: ,p_plan_source in varchar2 default hr_api.g_varchar2 --changed

Line 372: ,p_attribute28 in varchar2 default hr_api.g_varchar2

368: ,p_attribute24 in varchar2 default hr_api.g_varchar2
369: ,p_attribute25 in varchar2 default hr_api.g_varchar2
370: ,p_attribute26 in varchar2 default hr_api.g_varchar2
371: ,p_attribute27 in varchar2 default hr_api.g_varchar2
372: ,p_attribute28 in varchar2 default hr_api.g_varchar2
373: ,p_attribute29 in varchar2 default hr_api.g_varchar2
374: ,p_attribute30 in varchar2 default hr_api.g_varchar2
375: ,p_plan_source in varchar2 default hr_api.g_varchar2 --changed
376: ,p_start_date in date default hr_api.g_date

Line 373: ,p_attribute29 in varchar2 default hr_api.g_varchar2

369: ,p_attribute25 in varchar2 default hr_api.g_varchar2
370: ,p_attribute26 in varchar2 default hr_api.g_varchar2
371: ,p_attribute27 in varchar2 default hr_api.g_varchar2
372: ,p_attribute28 in varchar2 default hr_api.g_varchar2
373: ,p_attribute29 in varchar2 default hr_api.g_varchar2
374: ,p_attribute30 in varchar2 default hr_api.g_varchar2
375: ,p_plan_source in varchar2 default hr_api.g_varchar2 --changed
376: ,p_start_date in date default hr_api.g_date
377: ,p_end_date in date default hr_api.g_date

Line 374: ,p_attribute30 in varchar2 default hr_api.g_varchar2

370: ,p_attribute26 in varchar2 default hr_api.g_varchar2
371: ,p_attribute27 in varchar2 default hr_api.g_varchar2
372: ,p_attribute28 in varchar2 default hr_api.g_varchar2
373: ,p_attribute29 in varchar2 default hr_api.g_varchar2
374: ,p_attribute30 in varchar2 default hr_api.g_varchar2
375: ,p_plan_source in varchar2 default hr_api.g_varchar2 --changed
376: ,p_start_date in date default hr_api.g_date
377: ,p_end_date in date default hr_api.g_date
378: ,p_creator_person_id in number

Line 375: ,p_plan_source in varchar2 default hr_api.g_varchar2 --changed

371: ,p_attribute27 in varchar2 default hr_api.g_varchar2
372: ,p_attribute28 in varchar2 default hr_api.g_varchar2
373: ,p_attribute29 in varchar2 default hr_api.g_varchar2
374: ,p_attribute30 in varchar2 default hr_api.g_varchar2
375: ,p_plan_source in varchar2 default hr_api.g_varchar2 --changed
376: ,p_start_date in date default hr_api.g_date
377: ,p_end_date in date default hr_api.g_date
378: ,p_creator_person_id in number
379: ,p_additional_member_flag in varchar2 default hr_api.g_varchar2

Line 376: ,p_start_date in date default hr_api.g_date

372: ,p_attribute28 in varchar2 default hr_api.g_varchar2
373: ,p_attribute29 in varchar2 default hr_api.g_varchar2
374: ,p_attribute30 in varchar2 default hr_api.g_varchar2
375: ,p_plan_source in varchar2 default hr_api.g_varchar2 --changed
376: ,p_start_date in date default hr_api.g_date
377: ,p_end_date in date default hr_api.g_date
378: ,p_creator_person_id in number
379: ,p_additional_member_flag in varchar2 default hr_api.g_varchar2
380: ,p_learning_path_id in number

Line 377: ,p_end_date in date default hr_api.g_date

373: ,p_attribute29 in varchar2 default hr_api.g_varchar2
374: ,p_attribute30 in varchar2 default hr_api.g_varchar2
375: ,p_plan_source in varchar2 default hr_api.g_varchar2 --changed
376: ,p_start_date in date default hr_api.g_date
377: ,p_end_date in date default hr_api.g_date
378: ,p_creator_person_id in number
379: ,p_additional_member_flag in varchar2 default hr_api.g_varchar2
380: ,p_learning_path_id in number
381: -- Modified for Bug#3479186

Line 379: ,p_additional_member_flag in varchar2 default hr_api.g_varchar2

375: ,p_plan_source in varchar2 default hr_api.g_varchar2 --changed
376: ,p_start_date in date default hr_api.g_date
377: ,p_end_date in date default hr_api.g_date
378: ,p_creator_person_id in number
379: ,p_additional_member_flag in varchar2 default hr_api.g_varchar2
380: ,p_learning_path_id in number
381: -- Modified for Bug#3479186
382: ,p_contact_id in number
383: ) is

Line 465: when hr_api.cannot_find_prog_unit then

461: ,p_learning_path_id => p_learning_path_id
462: ,p_contact_id => p_contact_id
463: );
464: exception
465: when hr_api.cannot_find_prog_unit then
466: hr_api.cannot_find_prog_unit_error
467: (p_module_name => 'UPDATE_TRAINING_PLAN'
468: ,p_hook_type => 'BP'
469: );

Line 466: hr_api.cannot_find_prog_unit_error

462: ,p_contact_id => p_contact_id
463: );
464: exception
465: when hr_api.cannot_find_prog_unit then
466: hr_api.cannot_find_prog_unit_error
467: (p_module_name => 'UPDATE_TRAINING_PLAN'
468: ,p_hook_type => 'BP'
469: );
470: end;

Line 578: when hr_api.cannot_find_prog_unit then

574: ,p_learning_path_id => p_learning_path_id
575: ,p_contact_id => p_contact_id
576: );
577: exception
578: when hr_api.cannot_find_prog_unit then
579: hr_api.cannot_find_prog_unit_error
580: (p_module_name => 'UPDATE_TRAINING_PLAN'
581: ,p_hook_type => 'AP'
582: );

Line 579: hr_api.cannot_find_prog_unit_error

575: ,p_contact_id => p_contact_id
576: );
577: exception
578: when hr_api.cannot_find_prog_unit then
579: hr_api.cannot_find_prog_unit_error
580: (p_module_name => 'UPDATE_TRAINING_PLAN'
581: ,p_hook_type => 'AP'
582: );
583: end;

Line 588: raise hr_api.validate_enabled;

584: --
585: -- When in validation only mode raise the Validate_Enabled exception
586: --
587: if p_validate then
588: raise hr_api.validate_enabled;
589: end if;
590: -- bug 3547628
591: --for comptency update associated with LP
592:

Line 610: when hr_api.validate_enabled then

606: -- Set all output arguments
607: --
608: hr_utility.set_location(' Leaving:'||l_proc, 70);
609: exception
610: when hr_api.validate_enabled then
611: --
612: -- As the Validate_Enabled exception has been raised
613: -- we must rollback to the savepoint
614: --

Line 667: when hr_api.cannot_find_prog_unit then

663: (p_training_plan_id => p_training_plan_id
664: ,p_object_version_number => p_object_version_number
665: );
666: exception
667: when hr_api.cannot_find_prog_unit then
668: hr_api.cannot_find_prog_unit_error
669: (p_module_name => 'DELETE_TRAINING_PLAN'
670: ,p_hook_type => 'BP'
671: );

Line 668: hr_api.cannot_find_prog_unit_error

664: ,p_object_version_number => p_object_version_number
665: );
666: exception
667: when hr_api.cannot_find_prog_unit then
668: hr_api.cannot_find_prog_unit_error
669: (p_module_name => 'DELETE_TRAINING_PLAN'
670: ,p_hook_type => 'BP'
671: );
672: end;

Line 692: when hr_api.cannot_find_prog_unit then

688: (p_training_plan_id => p_training_plan_id
689: ,p_object_version_number => p_object_version_number
690: );
691: exception
692: when hr_api.cannot_find_prog_unit then
693: hr_api.cannot_find_prog_unit_error
694: (p_module_name => 'DELETE_TRAINING_PLAN'
695: ,p_hook_type => 'AP'
696: );

Line 693: hr_api.cannot_find_prog_unit_error

689: ,p_object_version_number => p_object_version_number
690: );
691: exception
692: when hr_api.cannot_find_prog_unit then
693: hr_api.cannot_find_prog_unit_error
694: (p_module_name => 'DELETE_TRAINING_PLAN'
695: ,p_hook_type => 'AP'
696: );
697: end;

Line 702: raise hr_api.validate_enabled;

698: --
699: -- When in validation only mode raise the Validate_Enabled exception
700: --
701: if p_validate then
702: raise hr_api.validate_enabled;
703: end if;
704: --
705: -- Set all output arguments
706: --

Line 710: when hr_api.validate_enabled then

706: --
707: --
708: hr_utility.set_location(' Leaving:'||l_proc, 170);
709: exception
710: when hr_api.validate_enabled then
711: --
712: -- As the Validate_Enabled exception has been raised
713: -- we must rollback to the savepoint
714: --