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

Line 145: when hr_api.cannot_find_prog_unit then

141: ,p_competency_update_level => p_competency_update_level
142: ,p_language_code => p_language_code -- 2733966
143: );
144: exception
145: when hr_api.cannot_find_prog_unit then
146: hr_api.cannot_find_prog_unit_error
147: (p_module_name => 'CREATE_OFFERING'
148: ,p_hook_type => 'BP'
149: );

Line 146: hr_api.cannot_find_prog_unit_error

142: ,p_language_code => p_language_code -- 2733966
143: );
144: exception
145: when hr_api.cannot_find_prog_unit then
146: hr_api.cannot_find_prog_unit_error
147: (p_module_name => 'CREATE_OFFERING'
148: ,p_hook_type => 'BP'
149: );
150: end;

Line 285: when hr_api.cannot_find_prog_unit then

281: ,p_competency_update_level => p_competency_update_level
282: ,p_language_code => p_language_code -- 2733966
283: );
284: exception
285: when hr_api.cannot_find_prog_unit then
286: hr_api.cannot_find_prog_unit_error
287: (p_module_name => 'CREATE_OFFERING'
288: ,p_hook_type => 'AP'
289: );

Line 286: hr_api.cannot_find_prog_unit_error

282: ,p_language_code => p_language_code -- 2733966
283: );
284: exception
285: when hr_api.cannot_find_prog_unit then
286: hr_api.cannot_find_prog_unit_error
287: (p_module_name => 'CREATE_OFFERING'
288: ,p_hook_type => 'AP'
289: );
290: end;

Line 296: raise hr_api.validate_enabled;

292: --
293: -- When in validation only mode raise the Validate_Enabled exception
294: --
295: if p_validate then
296: raise hr_api.validate_enabled;
297: end if;
298: --
299: -- Set all output arguments
300: --

Line 307: when hr_api.validate_enabled then

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

Line 340: ,p_business_group_id in number default hr_api.g_number

336: (p_validate in boolean default false
337: ,p_effective_date in date
338: ,p_offering_id in number
339: ,p_object_version_number in out nocopy number
340: ,p_business_group_id in number default hr_api.g_number
341: ,p_name in varchar2 default hr_api.g_varchar2
342: ,p_start_date in date default hr_api.g_date
343: ,p_activity_version_id in number default hr_api.g_number
344: ,p_end_date in date default hr_api.g_date

Line 341: ,p_name in varchar2 default hr_api.g_varchar2

337: ,p_effective_date in date
338: ,p_offering_id in number
339: ,p_object_version_number in out nocopy number
340: ,p_business_group_id in number default hr_api.g_number
341: ,p_name in varchar2 default hr_api.g_varchar2
342: ,p_start_date in date default hr_api.g_date
343: ,p_activity_version_id in number default hr_api.g_number
344: ,p_end_date in date default hr_api.g_date
345: ,p_owner_id in number default hr_api.g_number

Line 342: ,p_start_date in date default hr_api.g_date

338: ,p_offering_id in number
339: ,p_object_version_number in out nocopy number
340: ,p_business_group_id in number default hr_api.g_number
341: ,p_name in varchar2 default hr_api.g_varchar2
342: ,p_start_date in date default hr_api.g_date
343: ,p_activity_version_id in number default hr_api.g_number
344: ,p_end_date in date default hr_api.g_date
345: ,p_owner_id in number default hr_api.g_number
346: ,p_delivery_mode_id in number default hr_api.g_number

Line 343: ,p_activity_version_id in number default hr_api.g_number

339: ,p_object_version_number in out nocopy number
340: ,p_business_group_id in number default hr_api.g_number
341: ,p_name in varchar2 default hr_api.g_varchar2
342: ,p_start_date in date default hr_api.g_date
343: ,p_activity_version_id in number default hr_api.g_number
344: ,p_end_date in date default hr_api.g_date
345: ,p_owner_id in number default hr_api.g_number
346: ,p_delivery_mode_id in number default hr_api.g_number
347: ,p_language_id in number default hr_api.g_number

Line 344: ,p_end_date in date default hr_api.g_date

340: ,p_business_group_id in number default hr_api.g_number
341: ,p_name in varchar2 default hr_api.g_varchar2
342: ,p_start_date in date default hr_api.g_date
343: ,p_activity_version_id in number default hr_api.g_number
344: ,p_end_date in date default hr_api.g_date
345: ,p_owner_id in number default hr_api.g_number
346: ,p_delivery_mode_id in number default hr_api.g_number
347: ,p_language_id in number default hr_api.g_number
348: ,p_duration in number default hr_api.g_number

Line 345: ,p_owner_id in number default hr_api.g_number

341: ,p_name in varchar2 default hr_api.g_varchar2
342: ,p_start_date in date default hr_api.g_date
343: ,p_activity_version_id in number default hr_api.g_number
344: ,p_end_date in date default hr_api.g_date
345: ,p_owner_id in number default hr_api.g_number
346: ,p_delivery_mode_id in number default hr_api.g_number
347: ,p_language_id in number default hr_api.g_number
348: ,p_duration in number default hr_api.g_number
349: ,p_duration_units in varchar2 default hr_api.g_varchar2

Line 346: ,p_delivery_mode_id in number default hr_api.g_number

342: ,p_start_date in date default hr_api.g_date
343: ,p_activity_version_id in number default hr_api.g_number
344: ,p_end_date in date default hr_api.g_date
345: ,p_owner_id in number default hr_api.g_number
346: ,p_delivery_mode_id in number default hr_api.g_number
347: ,p_language_id in number default hr_api.g_number
348: ,p_duration in number default hr_api.g_number
349: ,p_duration_units in varchar2 default hr_api.g_varchar2
350: ,p_learning_object_id in number default hr_api.g_number

Line 347: ,p_language_id in number default hr_api.g_number

343: ,p_activity_version_id in number default hr_api.g_number
344: ,p_end_date in date default hr_api.g_date
345: ,p_owner_id in number default hr_api.g_number
346: ,p_delivery_mode_id in number default hr_api.g_number
347: ,p_language_id in number default hr_api.g_number
348: ,p_duration in number default hr_api.g_number
349: ,p_duration_units in varchar2 default hr_api.g_varchar2
350: ,p_learning_object_id in number default hr_api.g_number
351: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2

Line 348: ,p_duration in number default hr_api.g_number

344: ,p_end_date in date default hr_api.g_date
345: ,p_owner_id in number default hr_api.g_number
346: ,p_delivery_mode_id in number default hr_api.g_number
347: ,p_language_id in number default hr_api.g_number
348: ,p_duration in number default hr_api.g_number
349: ,p_duration_units in varchar2 default hr_api.g_varchar2
350: ,p_learning_object_id in number default hr_api.g_number
351: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
352: ,p_player_toolbar_bitset in number default hr_api.g_number

Line 349: ,p_duration_units in varchar2 default hr_api.g_varchar2

345: ,p_owner_id in number default hr_api.g_number
346: ,p_delivery_mode_id in number default hr_api.g_number
347: ,p_language_id in number default hr_api.g_number
348: ,p_duration in number default hr_api.g_number
349: ,p_duration_units in varchar2 default hr_api.g_varchar2
350: ,p_learning_object_id in number default hr_api.g_number
351: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
352: ,p_player_toolbar_bitset in number default hr_api.g_number
353: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2

Line 350: ,p_learning_object_id in number default hr_api.g_number

346: ,p_delivery_mode_id in number default hr_api.g_number
347: ,p_language_id in number default hr_api.g_number
348: ,p_duration in number default hr_api.g_number
349: ,p_duration_units in varchar2 default hr_api.g_varchar2
350: ,p_learning_object_id in number default hr_api.g_number
351: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
352: ,p_player_toolbar_bitset in number default hr_api.g_number
353: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
354: ,p_maximum_attendees in number default hr_api.g_number

Line 351: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2

347: ,p_language_id in number default hr_api.g_number
348: ,p_duration in number default hr_api.g_number
349: ,p_duration_units in varchar2 default hr_api.g_varchar2
350: ,p_learning_object_id in number default hr_api.g_number
351: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
352: ,p_player_toolbar_bitset in number default hr_api.g_number
353: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
354: ,p_maximum_attendees in number default hr_api.g_number
355: ,p_maximum_internal_attendees in number default hr_api.g_number

Line 352: ,p_player_toolbar_bitset in number default hr_api.g_number

348: ,p_duration in number default hr_api.g_number
349: ,p_duration_units in varchar2 default hr_api.g_varchar2
350: ,p_learning_object_id in number default hr_api.g_number
351: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
352: ,p_player_toolbar_bitset in number default hr_api.g_number
353: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
354: ,p_maximum_attendees in number default hr_api.g_number
355: ,p_maximum_internal_attendees in number default hr_api.g_number
356: ,p_minimum_attendees in number default hr_api.g_number

Line 353: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2

349: ,p_duration_units in varchar2 default hr_api.g_varchar2
350: ,p_learning_object_id in number default hr_api.g_number
351: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
352: ,p_player_toolbar_bitset in number default hr_api.g_number
353: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
354: ,p_maximum_attendees in number default hr_api.g_number
355: ,p_maximum_internal_attendees in number default hr_api.g_number
356: ,p_minimum_attendees in number default hr_api.g_number
357: ,p_actual_cost in number default hr_api.g_number

Line 354: ,p_maximum_attendees in number default hr_api.g_number

350: ,p_learning_object_id in number default hr_api.g_number
351: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
352: ,p_player_toolbar_bitset in number default hr_api.g_number
353: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
354: ,p_maximum_attendees in number default hr_api.g_number
355: ,p_maximum_internal_attendees in number default hr_api.g_number
356: ,p_minimum_attendees in number default hr_api.g_number
357: ,p_actual_cost in number default hr_api.g_number
358: ,p_budget_cost in number default hr_api.g_number

Line 355: ,p_maximum_internal_attendees in number default hr_api.g_number

351: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
352: ,p_player_toolbar_bitset in number default hr_api.g_number
353: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
354: ,p_maximum_attendees in number default hr_api.g_number
355: ,p_maximum_internal_attendees in number default hr_api.g_number
356: ,p_minimum_attendees in number default hr_api.g_number
357: ,p_actual_cost in number default hr_api.g_number
358: ,p_budget_cost in number default hr_api.g_number
359: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2

Line 356: ,p_minimum_attendees in number default hr_api.g_number

352: ,p_player_toolbar_bitset in number default hr_api.g_number
353: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
354: ,p_maximum_attendees in number default hr_api.g_number
355: ,p_maximum_internal_attendees in number default hr_api.g_number
356: ,p_minimum_attendees in number default hr_api.g_number
357: ,p_actual_cost in number default hr_api.g_number
358: ,p_budget_cost in number default hr_api.g_number
359: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
360: ,p_price_basis in varchar2 default hr_api.g_varchar2

Line 357: ,p_actual_cost in number default hr_api.g_number

353: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
354: ,p_maximum_attendees in number default hr_api.g_number
355: ,p_maximum_internal_attendees in number default hr_api.g_number
356: ,p_minimum_attendees in number default hr_api.g_number
357: ,p_actual_cost in number default hr_api.g_number
358: ,p_budget_cost in number default hr_api.g_number
359: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
360: ,p_price_basis in varchar2 default hr_api.g_varchar2
361: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 358: ,p_budget_cost in number default hr_api.g_number

354: ,p_maximum_attendees in number default hr_api.g_number
355: ,p_maximum_internal_attendees in number default hr_api.g_number
356: ,p_minimum_attendees in number default hr_api.g_number
357: ,p_actual_cost in number default hr_api.g_number
358: ,p_budget_cost in number default hr_api.g_number
359: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
360: ,p_price_basis in varchar2 default hr_api.g_varchar2
361: ,p_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_standard_price in number default hr_api.g_number

Line 359: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2

355: ,p_maximum_internal_attendees in number default hr_api.g_number
356: ,p_minimum_attendees in number default hr_api.g_number
357: ,p_actual_cost in number default hr_api.g_number
358: ,p_budget_cost in number default hr_api.g_number
359: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
360: ,p_price_basis in varchar2 default hr_api.g_varchar2
361: ,p_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_standard_price in number default hr_api.g_number
363: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 360: ,p_price_basis in varchar2 default hr_api.g_varchar2

356: ,p_minimum_attendees in number default hr_api.g_number
357: ,p_actual_cost in number default hr_api.g_number
358: ,p_budget_cost in number default hr_api.g_number
359: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
360: ,p_price_basis in varchar2 default hr_api.g_varchar2
361: ,p_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_standard_price in number default hr_api.g_number
363: ,p_attribute_category in varchar2 default hr_api.g_varchar2
364: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 361: ,p_currency_code in varchar2 default hr_api.g_varchar2

357: ,p_actual_cost in number default hr_api.g_number
358: ,p_budget_cost in number default hr_api.g_number
359: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
360: ,p_price_basis in varchar2 default hr_api.g_varchar2
361: ,p_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_standard_price in number default hr_api.g_number
363: ,p_attribute_category in varchar2 default hr_api.g_varchar2
364: ,p_attribute1 in varchar2 default hr_api.g_varchar2
365: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 362: ,p_standard_price in number default hr_api.g_number

358: ,p_budget_cost in number default hr_api.g_number
359: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
360: ,p_price_basis in varchar2 default hr_api.g_varchar2
361: ,p_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_standard_price in number default hr_api.g_number
363: ,p_attribute_category in varchar2 default hr_api.g_varchar2
364: ,p_attribute1 in varchar2 default hr_api.g_varchar2
365: ,p_attribute2 in varchar2 default hr_api.g_varchar2
366: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 363: ,p_attribute_category in varchar2 default hr_api.g_varchar2

359: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
360: ,p_price_basis in varchar2 default hr_api.g_varchar2
361: ,p_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_standard_price in number default hr_api.g_number
363: ,p_attribute_category in varchar2 default hr_api.g_varchar2
364: ,p_attribute1 in varchar2 default hr_api.g_varchar2
365: ,p_attribute2 in varchar2 default hr_api.g_varchar2
366: ,p_attribute3 in varchar2 default hr_api.g_varchar2
367: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 364: ,p_attribute1 in varchar2 default hr_api.g_varchar2

360: ,p_price_basis in varchar2 default hr_api.g_varchar2
361: ,p_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_standard_price in number default hr_api.g_number
363: ,p_attribute_category in varchar2 default hr_api.g_varchar2
364: ,p_attribute1 in varchar2 default hr_api.g_varchar2
365: ,p_attribute2 in varchar2 default hr_api.g_varchar2
366: ,p_attribute3 in varchar2 default hr_api.g_varchar2
367: ,p_attribute4 in varchar2 default hr_api.g_varchar2
368: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 365: ,p_attribute2 in varchar2 default hr_api.g_varchar2

361: ,p_currency_code in varchar2 default hr_api.g_varchar2
362: ,p_standard_price in number default hr_api.g_number
363: ,p_attribute_category in varchar2 default hr_api.g_varchar2
364: ,p_attribute1 in varchar2 default hr_api.g_varchar2
365: ,p_attribute2 in varchar2 default hr_api.g_varchar2
366: ,p_attribute3 in varchar2 default hr_api.g_varchar2
367: ,p_attribute4 in varchar2 default hr_api.g_varchar2
368: ,p_attribute5 in varchar2 default hr_api.g_varchar2
369: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 366: ,p_attribute3 in varchar2 default hr_api.g_varchar2

362: ,p_standard_price in number default hr_api.g_number
363: ,p_attribute_category in varchar2 default hr_api.g_varchar2
364: ,p_attribute1 in varchar2 default hr_api.g_varchar2
365: ,p_attribute2 in varchar2 default hr_api.g_varchar2
366: ,p_attribute3 in varchar2 default hr_api.g_varchar2
367: ,p_attribute4 in varchar2 default hr_api.g_varchar2
368: ,p_attribute5 in varchar2 default hr_api.g_varchar2
369: ,p_attribute6 in varchar2 default hr_api.g_varchar2
370: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 367: ,p_attribute4 in varchar2 default hr_api.g_varchar2

363: ,p_attribute_category in varchar2 default hr_api.g_varchar2
364: ,p_attribute1 in varchar2 default hr_api.g_varchar2
365: ,p_attribute2 in varchar2 default hr_api.g_varchar2
366: ,p_attribute3 in varchar2 default hr_api.g_varchar2
367: ,p_attribute4 in varchar2 default hr_api.g_varchar2
368: ,p_attribute5 in varchar2 default hr_api.g_varchar2
369: ,p_attribute6 in varchar2 default hr_api.g_varchar2
370: ,p_attribute7 in varchar2 default hr_api.g_varchar2
371: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 368: ,p_attribute5 in varchar2 default hr_api.g_varchar2

364: ,p_attribute1 in varchar2 default hr_api.g_varchar2
365: ,p_attribute2 in varchar2 default hr_api.g_varchar2
366: ,p_attribute3 in varchar2 default hr_api.g_varchar2
367: ,p_attribute4 in varchar2 default hr_api.g_varchar2
368: ,p_attribute5 in varchar2 default hr_api.g_varchar2
369: ,p_attribute6 in varchar2 default hr_api.g_varchar2
370: ,p_attribute7 in varchar2 default hr_api.g_varchar2
371: ,p_attribute8 in varchar2 default hr_api.g_varchar2
372: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 369: ,p_attribute6 in varchar2 default hr_api.g_varchar2

365: ,p_attribute2 in varchar2 default hr_api.g_varchar2
366: ,p_attribute3 in varchar2 default hr_api.g_varchar2
367: ,p_attribute4 in varchar2 default hr_api.g_varchar2
368: ,p_attribute5 in varchar2 default hr_api.g_varchar2
369: ,p_attribute6 in varchar2 default hr_api.g_varchar2
370: ,p_attribute7 in varchar2 default hr_api.g_varchar2
371: ,p_attribute8 in varchar2 default hr_api.g_varchar2
372: ,p_attribute9 in varchar2 default hr_api.g_varchar2
373: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 370: ,p_attribute7 in varchar2 default hr_api.g_varchar2

366: ,p_attribute3 in varchar2 default hr_api.g_varchar2
367: ,p_attribute4 in varchar2 default hr_api.g_varchar2
368: ,p_attribute5 in varchar2 default hr_api.g_varchar2
369: ,p_attribute6 in varchar2 default hr_api.g_varchar2
370: ,p_attribute7 in varchar2 default hr_api.g_varchar2
371: ,p_attribute8 in varchar2 default hr_api.g_varchar2
372: ,p_attribute9 in varchar2 default hr_api.g_varchar2
373: ,p_attribute10 in varchar2 default hr_api.g_varchar2
374: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 371: ,p_attribute8 in varchar2 default hr_api.g_varchar2

367: ,p_attribute4 in varchar2 default hr_api.g_varchar2
368: ,p_attribute5 in varchar2 default hr_api.g_varchar2
369: ,p_attribute6 in varchar2 default hr_api.g_varchar2
370: ,p_attribute7 in varchar2 default hr_api.g_varchar2
371: ,p_attribute8 in varchar2 default hr_api.g_varchar2
372: ,p_attribute9 in varchar2 default hr_api.g_varchar2
373: ,p_attribute10 in varchar2 default hr_api.g_varchar2
374: ,p_attribute11 in varchar2 default hr_api.g_varchar2
375: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 372: ,p_attribute9 in varchar2 default hr_api.g_varchar2

368: ,p_attribute5 in varchar2 default hr_api.g_varchar2
369: ,p_attribute6 in varchar2 default hr_api.g_varchar2
370: ,p_attribute7 in varchar2 default hr_api.g_varchar2
371: ,p_attribute8 in varchar2 default hr_api.g_varchar2
372: ,p_attribute9 in varchar2 default hr_api.g_varchar2
373: ,p_attribute10 in varchar2 default hr_api.g_varchar2
374: ,p_attribute11 in varchar2 default hr_api.g_varchar2
375: ,p_attribute12 in varchar2 default hr_api.g_varchar2
376: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 373: ,p_attribute10 in varchar2 default hr_api.g_varchar2

369: ,p_attribute6 in varchar2 default hr_api.g_varchar2
370: ,p_attribute7 in varchar2 default hr_api.g_varchar2
371: ,p_attribute8 in varchar2 default hr_api.g_varchar2
372: ,p_attribute9 in varchar2 default hr_api.g_varchar2
373: ,p_attribute10 in varchar2 default hr_api.g_varchar2
374: ,p_attribute11 in varchar2 default hr_api.g_varchar2
375: ,p_attribute12 in varchar2 default hr_api.g_varchar2
376: ,p_attribute13 in varchar2 default hr_api.g_varchar2
377: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 374: ,p_attribute11 in varchar2 default hr_api.g_varchar2

370: ,p_attribute7 in varchar2 default hr_api.g_varchar2
371: ,p_attribute8 in varchar2 default hr_api.g_varchar2
372: ,p_attribute9 in varchar2 default hr_api.g_varchar2
373: ,p_attribute10 in varchar2 default hr_api.g_varchar2
374: ,p_attribute11 in varchar2 default hr_api.g_varchar2
375: ,p_attribute12 in varchar2 default hr_api.g_varchar2
376: ,p_attribute13 in varchar2 default hr_api.g_varchar2
377: ,p_attribute14 in varchar2 default hr_api.g_varchar2
378: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 375: ,p_attribute12 in varchar2 default hr_api.g_varchar2

371: ,p_attribute8 in varchar2 default hr_api.g_varchar2
372: ,p_attribute9 in varchar2 default hr_api.g_varchar2
373: ,p_attribute10 in varchar2 default hr_api.g_varchar2
374: ,p_attribute11 in varchar2 default hr_api.g_varchar2
375: ,p_attribute12 in varchar2 default hr_api.g_varchar2
376: ,p_attribute13 in varchar2 default hr_api.g_varchar2
377: ,p_attribute14 in varchar2 default hr_api.g_varchar2
378: ,p_attribute15 in varchar2 default hr_api.g_varchar2
379: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 376: ,p_attribute13 in varchar2 default hr_api.g_varchar2

372: ,p_attribute9 in varchar2 default hr_api.g_varchar2
373: ,p_attribute10 in varchar2 default hr_api.g_varchar2
374: ,p_attribute11 in varchar2 default hr_api.g_varchar2
375: ,p_attribute12 in varchar2 default hr_api.g_varchar2
376: ,p_attribute13 in varchar2 default hr_api.g_varchar2
377: ,p_attribute14 in varchar2 default hr_api.g_varchar2
378: ,p_attribute15 in varchar2 default hr_api.g_varchar2
379: ,p_attribute16 in varchar2 default hr_api.g_varchar2
380: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 377: ,p_attribute14 in varchar2 default hr_api.g_varchar2

373: ,p_attribute10 in varchar2 default hr_api.g_varchar2
374: ,p_attribute11 in varchar2 default hr_api.g_varchar2
375: ,p_attribute12 in varchar2 default hr_api.g_varchar2
376: ,p_attribute13 in varchar2 default hr_api.g_varchar2
377: ,p_attribute14 in varchar2 default hr_api.g_varchar2
378: ,p_attribute15 in varchar2 default hr_api.g_varchar2
379: ,p_attribute16 in varchar2 default hr_api.g_varchar2
380: ,p_attribute17 in varchar2 default hr_api.g_varchar2
381: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 378: ,p_attribute15 in varchar2 default hr_api.g_varchar2

374: ,p_attribute11 in varchar2 default hr_api.g_varchar2
375: ,p_attribute12 in varchar2 default hr_api.g_varchar2
376: ,p_attribute13 in varchar2 default hr_api.g_varchar2
377: ,p_attribute14 in varchar2 default hr_api.g_varchar2
378: ,p_attribute15 in varchar2 default hr_api.g_varchar2
379: ,p_attribute16 in varchar2 default hr_api.g_varchar2
380: ,p_attribute17 in varchar2 default hr_api.g_varchar2
381: ,p_attribute18 in varchar2 default hr_api.g_varchar2
382: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 379: ,p_attribute16 in varchar2 default hr_api.g_varchar2

375: ,p_attribute12 in varchar2 default hr_api.g_varchar2
376: ,p_attribute13 in varchar2 default hr_api.g_varchar2
377: ,p_attribute14 in varchar2 default hr_api.g_varchar2
378: ,p_attribute15 in varchar2 default hr_api.g_varchar2
379: ,p_attribute16 in varchar2 default hr_api.g_varchar2
380: ,p_attribute17 in varchar2 default hr_api.g_varchar2
381: ,p_attribute18 in varchar2 default hr_api.g_varchar2
382: ,p_attribute19 in varchar2 default hr_api.g_varchar2
383: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 380: ,p_attribute17 in varchar2 default hr_api.g_varchar2

376: ,p_attribute13 in varchar2 default hr_api.g_varchar2
377: ,p_attribute14 in varchar2 default hr_api.g_varchar2
378: ,p_attribute15 in varchar2 default hr_api.g_varchar2
379: ,p_attribute16 in varchar2 default hr_api.g_varchar2
380: ,p_attribute17 in varchar2 default hr_api.g_varchar2
381: ,p_attribute18 in varchar2 default hr_api.g_varchar2
382: ,p_attribute19 in varchar2 default hr_api.g_varchar2
383: ,p_attribute20 in varchar2 default hr_api.g_varchar2
384: ,p_data_source in varchar2 default hr_api.g_varchar2

Line 381: ,p_attribute18 in varchar2 default hr_api.g_varchar2

377: ,p_attribute14 in varchar2 default hr_api.g_varchar2
378: ,p_attribute15 in varchar2 default hr_api.g_varchar2
379: ,p_attribute16 in varchar2 default hr_api.g_varchar2
380: ,p_attribute17 in varchar2 default hr_api.g_varchar2
381: ,p_attribute18 in varchar2 default hr_api.g_varchar2
382: ,p_attribute19 in varchar2 default hr_api.g_varchar2
383: ,p_attribute20 in varchar2 default hr_api.g_varchar2
384: ,p_data_source in varchar2 default hr_api.g_varchar2
385: ,p_vendor_id in number default hr_api.g_number

Line 382: ,p_attribute19 in varchar2 default hr_api.g_varchar2

378: ,p_attribute15 in varchar2 default hr_api.g_varchar2
379: ,p_attribute16 in varchar2 default hr_api.g_varchar2
380: ,p_attribute17 in varchar2 default hr_api.g_varchar2
381: ,p_attribute18 in varchar2 default hr_api.g_varchar2
382: ,p_attribute19 in varchar2 default hr_api.g_varchar2
383: ,p_attribute20 in varchar2 default hr_api.g_varchar2
384: ,p_data_source in varchar2 default hr_api.g_varchar2
385: ,p_vendor_id in number default hr_api.g_number
386: ,p_description in varchar2 default hr_api.g_varchar2

Line 383: ,p_attribute20 in varchar2 default hr_api.g_varchar2

379: ,p_attribute16 in varchar2 default hr_api.g_varchar2
380: ,p_attribute17 in varchar2 default hr_api.g_varchar2
381: ,p_attribute18 in varchar2 default hr_api.g_varchar2
382: ,p_attribute19 in varchar2 default hr_api.g_varchar2
383: ,p_attribute20 in varchar2 default hr_api.g_varchar2
384: ,p_data_source in varchar2 default hr_api.g_varchar2
385: ,p_vendor_id in number default hr_api.g_number
386: ,p_description in varchar2 default hr_api.g_varchar2
387: ,p_competency_update_level in varchar2 default hr_api.g_varchar2

Line 384: ,p_data_source in varchar2 default hr_api.g_varchar2

380: ,p_attribute17 in varchar2 default hr_api.g_varchar2
381: ,p_attribute18 in varchar2 default hr_api.g_varchar2
382: ,p_attribute19 in varchar2 default hr_api.g_varchar2
383: ,p_attribute20 in varchar2 default hr_api.g_varchar2
384: ,p_data_source in varchar2 default hr_api.g_varchar2
385: ,p_vendor_id in number default hr_api.g_number
386: ,p_description in varchar2 default hr_api.g_varchar2
387: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
388: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966

Line 385: ,p_vendor_id in number default hr_api.g_number

381: ,p_attribute18 in varchar2 default hr_api.g_varchar2
382: ,p_attribute19 in varchar2 default hr_api.g_varchar2
383: ,p_attribute20 in varchar2 default hr_api.g_varchar2
384: ,p_data_source in varchar2 default hr_api.g_varchar2
385: ,p_vendor_id in number default hr_api.g_number
386: ,p_description in varchar2 default hr_api.g_varchar2
387: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
388: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966
389: ) is

Line 386: ,p_description in varchar2 default hr_api.g_varchar2

382: ,p_attribute19 in varchar2 default hr_api.g_varchar2
383: ,p_attribute20 in varchar2 default hr_api.g_varchar2
384: ,p_data_source in varchar2 default hr_api.g_varchar2
385: ,p_vendor_id in number default hr_api.g_number
386: ,p_description in varchar2 default hr_api.g_varchar2
387: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
388: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966
389: ) is
390: --

Line 387: ,p_competency_update_level in varchar2 default hr_api.g_varchar2

383: ,p_attribute20 in varchar2 default hr_api.g_varchar2
384: ,p_data_source in varchar2 default hr_api.g_varchar2
385: ,p_vendor_id in number default hr_api.g_number
386: ,p_description in varchar2 default hr_api.g_varchar2
387: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
388: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966
389: ) is
390: --
391: -- Declare cursors and local variables

Line 388: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966

384: ,p_data_source in varchar2 default hr_api.g_varchar2
385: ,p_vendor_id in number default hr_api.g_number
386: ,p_description in varchar2 default hr_api.g_varchar2
387: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
388: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966
389: ) is
390: --
391: -- Declare cursors and local variables
392: --bug 5435877 l_proc variable changed from 'Update Training Plan' to 'Update Offering'

Line 468: when hr_api.cannot_find_prog_unit then

464: ,p_competency_update_level => p_competency_update_level
465: ,p_language_code => p_language_code -- 2733966
466: );
467: exception
468: when hr_api.cannot_find_prog_unit then
469: hr_api.cannot_find_prog_unit_error
470: (p_module_name => 'UPDATE_OFFERING'
471: ,p_hook_type => 'BP'
472: );

Line 469: hr_api.cannot_find_prog_unit_error

465: ,p_language_code => p_language_code -- 2733966
466: );
467: exception
468: when hr_api.cannot_find_prog_unit then
469: hr_api.cannot_find_prog_unit_error
470: (p_module_name => 'UPDATE_OFFERING'
471: ,p_hook_type => 'BP'
472: );
473: end;

Line 600: when hr_api.cannot_find_prog_unit then

596: ,p_competency_update_level => p_competency_update_level
597: ,p_language_code => p_language_code -- 2733966
598: );
599: exception
600: when hr_api.cannot_find_prog_unit then
601: hr_api.cannot_find_prog_unit_error
602: (p_module_name => 'UPDATE_OFFERING'
603: ,p_hook_type => 'AP'
604: );

Line 601: hr_api.cannot_find_prog_unit_error

597: ,p_language_code => p_language_code -- 2733966
598: );
599: exception
600: when hr_api.cannot_find_prog_unit then
601: hr_api.cannot_find_prog_unit_error
602: (p_module_name => 'UPDATE_OFFERING'
603: ,p_hook_type => 'AP'
604: );
605: end;

Line 611: raise hr_api.validate_enabled;

607: --
608: -- When in validation only mode raise the Validate_Enabled exception
609: --
610: if p_validate then
611: raise hr_api.validate_enabled;
612: end if;
613: --
614: -- Set all output arguments
615: --

Line 618: when hr_api.validate_enabled then

614: -- Set all output arguments
615: --
616: hr_utility.set_location(' Leaving:'||l_proc, 70);
617: exception
618: when hr_api.validate_enabled then
619: --
620: -- As the Validate_Enabled exception has been raised
621: -- we must rollback to the savepoint
622: --

Line 676: when hr_api.cannot_find_prog_unit then

672: (p_offering_id => p_offering_id
673: ,p_object_version_number => p_object_version_number
674: );
675: exception
676: when hr_api.cannot_find_prog_unit then
677: hr_api.cannot_find_prog_unit_error
678: (p_module_name => 'DELETE_OFFERING'
679: ,p_hook_type => 'BP'
680: );

Line 677: hr_api.cannot_find_prog_unit_error

673: ,p_object_version_number => p_object_version_number
674: );
675: exception
676: when hr_api.cannot_find_prog_unit then
677: hr_api.cannot_find_prog_unit_error
678: (p_module_name => 'DELETE_OFFERING'
679: ,p_hook_type => 'BP'
680: );
681: end;

Line 706: when hr_api.cannot_find_prog_unit then

702: (p_offering_id => p_offering_id
703: ,p_object_version_number => p_object_version_number
704: );
705: exception
706: when hr_api.cannot_find_prog_unit then
707: hr_api.cannot_find_prog_unit_error
708: (p_module_name => 'DELETE_OFFERING'
709: ,p_hook_type => 'AP'
710: );

Line 707: hr_api.cannot_find_prog_unit_error

703: ,p_object_version_number => p_object_version_number
704: );
705: exception
706: when hr_api.cannot_find_prog_unit then
707: hr_api.cannot_find_prog_unit_error
708: (p_module_name => 'DELETE_OFFERING'
709: ,p_hook_type => 'AP'
710: );
711: end;

Line 717: raise hr_api.validate_enabled;

713: --
714: -- When in validation only mode raise the Validate_Enabled exception
715: --
716: if p_validate then
717: raise hr_api.validate_enabled;
718: end if;
719: --
720: -- Set all output arguments
721: --

Line 725: when hr_api.validate_enabled then

721: --
722: --
723: hr_utility.set_location(' Leaving:'||l_proc, 170);
724: exception
725: when hr_api.validate_enabled then
726: --
727: -- As the Validate_Enabled exception has been raised
728: -- we must rollback to the savepoint
729: --