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

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |----------------------------< create_offering >---------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_offering
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_business_group_id in number
15: ,p_name in varchar2
16: ,p_start_date in date

Line 94: hr_api.constant_to_boolean

90: --
91: -- Convert constant values to their corresponding boolean value
92: --
93: l_validate :=
94: hr_api.constant_to_boolean
95: (p_constant_value => p_validate);
96: --
97: -- Register Surrogate ID or user key values
98: --

Line 211: (p_validate in number default hr_api.g_false_num

207: -- ----------------------------------------------------------------------------
208: -- |----------------------------< delete_offering >---------------------------|
209: -- ----------------------------------------------------------------------------
210: PROCEDURE delete_offering
211: (p_validate in number default hr_api.g_false_num
212: ,p_offering_id in number
213: ,p_object_version_number in number
214: ,p_return_status out nocopy varchar2
215: ) is

Line 241: hr_api.constant_to_boolean

237: --
238: -- Convert constant values to their corresponding boolean value
239: --
240: l_validate :=
241: hr_api.constant_to_boolean
242: (p_constant_value => p_validate);
243: --
244: -- Register Surrogate ID or user key values
245: --

Line 305: (p_validate in number default hr_api.g_false_num

301: -- ----------------------------------------------------------------------------
302: -- |----------------------------< update_offering >---------------------------|
303: -- ----------------------------------------------------------------------------
304: PROCEDURE update_offering
305: (p_validate in number default hr_api.g_false_num
306: ,p_effective_date in date
307: ,p_offering_id in number
308: ,p_object_version_number in out nocopy number
309: ,p_business_group_id in number default hr_api.g_number

Line 309: ,p_business_group_id in number default hr_api.g_number

305: (p_validate in number default hr_api.g_false_num
306: ,p_effective_date in date
307: ,p_offering_id in number
308: ,p_object_version_number in out nocopy number
309: ,p_business_group_id in number default hr_api.g_number
310: ,p_name in varchar2 default hr_api.g_varchar2
311: ,p_start_date in date default hr_api.g_date
312: ,p_activity_version_id in number default hr_api.g_number
313: ,p_end_date in date default hr_api.g_date

Line 310: ,p_name in varchar2 default hr_api.g_varchar2

306: ,p_effective_date in date
307: ,p_offering_id in number
308: ,p_object_version_number in out nocopy number
309: ,p_business_group_id in number default hr_api.g_number
310: ,p_name in varchar2 default hr_api.g_varchar2
311: ,p_start_date in date default hr_api.g_date
312: ,p_activity_version_id in number default hr_api.g_number
313: ,p_end_date in date default hr_api.g_date
314: ,p_owner_id in number default hr_api.g_number

Line 311: ,p_start_date in date default hr_api.g_date

307: ,p_offering_id in number
308: ,p_object_version_number in out nocopy number
309: ,p_business_group_id in number default hr_api.g_number
310: ,p_name in varchar2 default hr_api.g_varchar2
311: ,p_start_date in date default hr_api.g_date
312: ,p_activity_version_id in number default hr_api.g_number
313: ,p_end_date in date default hr_api.g_date
314: ,p_owner_id in number default hr_api.g_number
315: ,p_delivery_mode_id in number default hr_api.g_number

Line 312: ,p_activity_version_id in number default hr_api.g_number

308: ,p_object_version_number in out nocopy number
309: ,p_business_group_id in number default hr_api.g_number
310: ,p_name in varchar2 default hr_api.g_varchar2
311: ,p_start_date in date default hr_api.g_date
312: ,p_activity_version_id in number default hr_api.g_number
313: ,p_end_date in date default hr_api.g_date
314: ,p_owner_id in number default hr_api.g_number
315: ,p_delivery_mode_id in number default hr_api.g_number
316: ,p_language_id in number default hr_api.g_number

Line 313: ,p_end_date in date default hr_api.g_date

309: ,p_business_group_id in number default hr_api.g_number
310: ,p_name in varchar2 default hr_api.g_varchar2
311: ,p_start_date in date default hr_api.g_date
312: ,p_activity_version_id in number default hr_api.g_number
313: ,p_end_date in date default hr_api.g_date
314: ,p_owner_id in number default hr_api.g_number
315: ,p_delivery_mode_id in number default hr_api.g_number
316: ,p_language_id in number default hr_api.g_number
317: ,p_duration in number default hr_api.g_number

Line 314: ,p_owner_id in number default hr_api.g_number

310: ,p_name in varchar2 default hr_api.g_varchar2
311: ,p_start_date in date default hr_api.g_date
312: ,p_activity_version_id in number default hr_api.g_number
313: ,p_end_date in date default hr_api.g_date
314: ,p_owner_id in number default hr_api.g_number
315: ,p_delivery_mode_id in number default hr_api.g_number
316: ,p_language_id in number default hr_api.g_number
317: ,p_duration in number default hr_api.g_number
318: ,p_duration_units in varchar2 default hr_api.g_varchar2

Line 315: ,p_delivery_mode_id in number default hr_api.g_number

311: ,p_start_date in date default hr_api.g_date
312: ,p_activity_version_id in number default hr_api.g_number
313: ,p_end_date in date default hr_api.g_date
314: ,p_owner_id in number default hr_api.g_number
315: ,p_delivery_mode_id in number default hr_api.g_number
316: ,p_language_id in number default hr_api.g_number
317: ,p_duration in number default hr_api.g_number
318: ,p_duration_units in varchar2 default hr_api.g_varchar2
319: ,p_learning_object_id in number default hr_api.g_number

Line 316: ,p_language_id in number default hr_api.g_number

312: ,p_activity_version_id in number default hr_api.g_number
313: ,p_end_date in date default hr_api.g_date
314: ,p_owner_id in number default hr_api.g_number
315: ,p_delivery_mode_id in number default hr_api.g_number
316: ,p_language_id in number default hr_api.g_number
317: ,p_duration in number default hr_api.g_number
318: ,p_duration_units in varchar2 default hr_api.g_varchar2
319: ,p_learning_object_id in number default hr_api.g_number
320: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2

Line 317: ,p_duration in number default hr_api.g_number

313: ,p_end_date in date default hr_api.g_date
314: ,p_owner_id in number default hr_api.g_number
315: ,p_delivery_mode_id in number default hr_api.g_number
316: ,p_language_id in number default hr_api.g_number
317: ,p_duration in number default hr_api.g_number
318: ,p_duration_units in varchar2 default hr_api.g_varchar2
319: ,p_learning_object_id in number default hr_api.g_number
320: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
321: ,p_player_toolbar_bitset in number default hr_api.g_number

Line 318: ,p_duration_units in varchar2 default hr_api.g_varchar2

314: ,p_owner_id in number default hr_api.g_number
315: ,p_delivery_mode_id in number default hr_api.g_number
316: ,p_language_id in number default hr_api.g_number
317: ,p_duration in number default hr_api.g_number
318: ,p_duration_units in varchar2 default hr_api.g_varchar2
319: ,p_learning_object_id in number default hr_api.g_number
320: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
321: ,p_player_toolbar_bitset in number default hr_api.g_number
322: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2

Line 319: ,p_learning_object_id in number default hr_api.g_number

315: ,p_delivery_mode_id in number default hr_api.g_number
316: ,p_language_id in number default hr_api.g_number
317: ,p_duration in number default hr_api.g_number
318: ,p_duration_units in varchar2 default hr_api.g_varchar2
319: ,p_learning_object_id in number default hr_api.g_number
320: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
321: ,p_player_toolbar_bitset in number default hr_api.g_number
322: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
323: ,p_maximum_attendees in number default hr_api.g_number

Line 320: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2

316: ,p_language_id in number default hr_api.g_number
317: ,p_duration in number default hr_api.g_number
318: ,p_duration_units in varchar2 default hr_api.g_varchar2
319: ,p_learning_object_id in number default hr_api.g_number
320: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
321: ,p_player_toolbar_bitset in number default hr_api.g_number
322: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
323: ,p_maximum_attendees in number default hr_api.g_number
324: ,p_maximum_internal_attendees in number default hr_api.g_number

Line 321: ,p_player_toolbar_bitset in number default hr_api.g_number

317: ,p_duration in number default hr_api.g_number
318: ,p_duration_units in varchar2 default hr_api.g_varchar2
319: ,p_learning_object_id in number default hr_api.g_number
320: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
321: ,p_player_toolbar_bitset in number default hr_api.g_number
322: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
323: ,p_maximum_attendees in number default hr_api.g_number
324: ,p_maximum_internal_attendees in number default hr_api.g_number
325: ,p_minimum_attendees in number default hr_api.g_number

Line 322: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2

318: ,p_duration_units in varchar2 default hr_api.g_varchar2
319: ,p_learning_object_id in number default hr_api.g_number
320: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
321: ,p_player_toolbar_bitset in number default hr_api.g_number
322: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
323: ,p_maximum_attendees in number default hr_api.g_number
324: ,p_maximum_internal_attendees in number default hr_api.g_number
325: ,p_minimum_attendees in number default hr_api.g_number
326: ,p_actual_cost in number default hr_api.g_number

Line 323: ,p_maximum_attendees in number default hr_api.g_number

319: ,p_learning_object_id in number default hr_api.g_number
320: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
321: ,p_player_toolbar_bitset in number default hr_api.g_number
322: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
323: ,p_maximum_attendees in number default hr_api.g_number
324: ,p_maximum_internal_attendees in number default hr_api.g_number
325: ,p_minimum_attendees in number default hr_api.g_number
326: ,p_actual_cost in number default hr_api.g_number
327: ,p_budget_cost in number default hr_api.g_number

Line 324: ,p_maximum_internal_attendees in number default hr_api.g_number

320: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
321: ,p_player_toolbar_bitset in number default hr_api.g_number
322: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
323: ,p_maximum_attendees in number default hr_api.g_number
324: ,p_maximum_internal_attendees in number default hr_api.g_number
325: ,p_minimum_attendees in number default hr_api.g_number
326: ,p_actual_cost in number default hr_api.g_number
327: ,p_budget_cost in number default hr_api.g_number
328: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2

Line 325: ,p_minimum_attendees in number default hr_api.g_number

321: ,p_player_toolbar_bitset in number default hr_api.g_number
322: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
323: ,p_maximum_attendees in number default hr_api.g_number
324: ,p_maximum_internal_attendees in number default hr_api.g_number
325: ,p_minimum_attendees in number default hr_api.g_number
326: ,p_actual_cost in number default hr_api.g_number
327: ,p_budget_cost in number default hr_api.g_number
328: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
329: ,p_price_basis in varchar2 default hr_api.g_varchar2

Line 326: ,p_actual_cost in number default hr_api.g_number

322: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
323: ,p_maximum_attendees in number default hr_api.g_number
324: ,p_maximum_internal_attendees in number default hr_api.g_number
325: ,p_minimum_attendees in number default hr_api.g_number
326: ,p_actual_cost in number default hr_api.g_number
327: ,p_budget_cost in number default hr_api.g_number
328: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
329: ,p_price_basis in varchar2 default hr_api.g_varchar2
330: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 327: ,p_budget_cost in number default hr_api.g_number

323: ,p_maximum_attendees in number default hr_api.g_number
324: ,p_maximum_internal_attendees in number default hr_api.g_number
325: ,p_minimum_attendees in number default hr_api.g_number
326: ,p_actual_cost in number default hr_api.g_number
327: ,p_budget_cost in number default hr_api.g_number
328: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
329: ,p_price_basis in varchar2 default hr_api.g_varchar2
330: ,p_currency_code in varchar2 default hr_api.g_varchar2
331: ,p_standard_price in number default hr_api.g_number

Line 328: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2

324: ,p_maximum_internal_attendees in number default hr_api.g_number
325: ,p_minimum_attendees in number default hr_api.g_number
326: ,p_actual_cost in number default hr_api.g_number
327: ,p_budget_cost in number default hr_api.g_number
328: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
329: ,p_price_basis in varchar2 default hr_api.g_varchar2
330: ,p_currency_code in varchar2 default hr_api.g_varchar2
331: ,p_standard_price in number default hr_api.g_number
332: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 329: ,p_price_basis in varchar2 default hr_api.g_varchar2

325: ,p_minimum_attendees in number default hr_api.g_number
326: ,p_actual_cost in number default hr_api.g_number
327: ,p_budget_cost in number default hr_api.g_number
328: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
329: ,p_price_basis in varchar2 default hr_api.g_varchar2
330: ,p_currency_code in varchar2 default hr_api.g_varchar2
331: ,p_standard_price in number default hr_api.g_number
332: ,p_attribute_category in varchar2 default hr_api.g_varchar2
333: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 330: ,p_currency_code in varchar2 default hr_api.g_varchar2

326: ,p_actual_cost in number default hr_api.g_number
327: ,p_budget_cost in number default hr_api.g_number
328: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
329: ,p_price_basis in varchar2 default hr_api.g_varchar2
330: ,p_currency_code in varchar2 default hr_api.g_varchar2
331: ,p_standard_price in number default hr_api.g_number
332: ,p_attribute_category in varchar2 default hr_api.g_varchar2
333: ,p_attribute1 in varchar2 default hr_api.g_varchar2
334: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 331: ,p_standard_price in number default hr_api.g_number

327: ,p_budget_cost in number default hr_api.g_number
328: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
329: ,p_price_basis in varchar2 default hr_api.g_varchar2
330: ,p_currency_code in varchar2 default hr_api.g_varchar2
331: ,p_standard_price in number default hr_api.g_number
332: ,p_attribute_category in varchar2 default hr_api.g_varchar2
333: ,p_attribute1 in varchar2 default hr_api.g_varchar2
334: ,p_attribute2 in varchar2 default hr_api.g_varchar2
335: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 332: ,p_attribute_category in varchar2 default hr_api.g_varchar2

328: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
329: ,p_price_basis in varchar2 default hr_api.g_varchar2
330: ,p_currency_code in varchar2 default hr_api.g_varchar2
331: ,p_standard_price in number default hr_api.g_number
332: ,p_attribute_category in varchar2 default hr_api.g_varchar2
333: ,p_attribute1 in varchar2 default hr_api.g_varchar2
334: ,p_attribute2 in varchar2 default hr_api.g_varchar2
335: ,p_attribute3 in varchar2 default hr_api.g_varchar2
336: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 333: ,p_attribute1 in varchar2 default hr_api.g_varchar2

329: ,p_price_basis in varchar2 default hr_api.g_varchar2
330: ,p_currency_code in varchar2 default hr_api.g_varchar2
331: ,p_standard_price in number default hr_api.g_number
332: ,p_attribute_category in varchar2 default hr_api.g_varchar2
333: ,p_attribute1 in varchar2 default hr_api.g_varchar2
334: ,p_attribute2 in varchar2 default hr_api.g_varchar2
335: ,p_attribute3 in varchar2 default hr_api.g_varchar2
336: ,p_attribute4 in varchar2 default hr_api.g_varchar2
337: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 334: ,p_attribute2 in varchar2 default hr_api.g_varchar2

330: ,p_currency_code in varchar2 default hr_api.g_varchar2
331: ,p_standard_price in number default hr_api.g_number
332: ,p_attribute_category in varchar2 default hr_api.g_varchar2
333: ,p_attribute1 in varchar2 default hr_api.g_varchar2
334: ,p_attribute2 in varchar2 default hr_api.g_varchar2
335: ,p_attribute3 in varchar2 default hr_api.g_varchar2
336: ,p_attribute4 in varchar2 default hr_api.g_varchar2
337: ,p_attribute5 in varchar2 default hr_api.g_varchar2
338: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 335: ,p_attribute3 in varchar2 default hr_api.g_varchar2

331: ,p_standard_price in number default hr_api.g_number
332: ,p_attribute_category in varchar2 default hr_api.g_varchar2
333: ,p_attribute1 in varchar2 default hr_api.g_varchar2
334: ,p_attribute2 in varchar2 default hr_api.g_varchar2
335: ,p_attribute3 in varchar2 default hr_api.g_varchar2
336: ,p_attribute4 in varchar2 default hr_api.g_varchar2
337: ,p_attribute5 in varchar2 default hr_api.g_varchar2
338: ,p_attribute6 in varchar2 default hr_api.g_varchar2
339: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 336: ,p_attribute4 in varchar2 default hr_api.g_varchar2

332: ,p_attribute_category in varchar2 default hr_api.g_varchar2
333: ,p_attribute1 in varchar2 default hr_api.g_varchar2
334: ,p_attribute2 in varchar2 default hr_api.g_varchar2
335: ,p_attribute3 in varchar2 default hr_api.g_varchar2
336: ,p_attribute4 in varchar2 default hr_api.g_varchar2
337: ,p_attribute5 in varchar2 default hr_api.g_varchar2
338: ,p_attribute6 in varchar2 default hr_api.g_varchar2
339: ,p_attribute7 in varchar2 default hr_api.g_varchar2
340: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 337: ,p_attribute5 in varchar2 default hr_api.g_varchar2

333: ,p_attribute1 in varchar2 default hr_api.g_varchar2
334: ,p_attribute2 in varchar2 default hr_api.g_varchar2
335: ,p_attribute3 in varchar2 default hr_api.g_varchar2
336: ,p_attribute4 in varchar2 default hr_api.g_varchar2
337: ,p_attribute5 in varchar2 default hr_api.g_varchar2
338: ,p_attribute6 in varchar2 default hr_api.g_varchar2
339: ,p_attribute7 in varchar2 default hr_api.g_varchar2
340: ,p_attribute8 in varchar2 default hr_api.g_varchar2
341: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 338: ,p_attribute6 in varchar2 default hr_api.g_varchar2

334: ,p_attribute2 in varchar2 default hr_api.g_varchar2
335: ,p_attribute3 in varchar2 default hr_api.g_varchar2
336: ,p_attribute4 in varchar2 default hr_api.g_varchar2
337: ,p_attribute5 in varchar2 default hr_api.g_varchar2
338: ,p_attribute6 in varchar2 default hr_api.g_varchar2
339: ,p_attribute7 in varchar2 default hr_api.g_varchar2
340: ,p_attribute8 in varchar2 default hr_api.g_varchar2
341: ,p_attribute9 in varchar2 default hr_api.g_varchar2
342: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 339: ,p_attribute7 in varchar2 default hr_api.g_varchar2

335: ,p_attribute3 in varchar2 default hr_api.g_varchar2
336: ,p_attribute4 in varchar2 default hr_api.g_varchar2
337: ,p_attribute5 in varchar2 default hr_api.g_varchar2
338: ,p_attribute6 in varchar2 default hr_api.g_varchar2
339: ,p_attribute7 in varchar2 default hr_api.g_varchar2
340: ,p_attribute8 in varchar2 default hr_api.g_varchar2
341: ,p_attribute9 in varchar2 default hr_api.g_varchar2
342: ,p_attribute10 in varchar2 default hr_api.g_varchar2
343: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 340: ,p_attribute8 in varchar2 default hr_api.g_varchar2

336: ,p_attribute4 in varchar2 default hr_api.g_varchar2
337: ,p_attribute5 in varchar2 default hr_api.g_varchar2
338: ,p_attribute6 in varchar2 default hr_api.g_varchar2
339: ,p_attribute7 in varchar2 default hr_api.g_varchar2
340: ,p_attribute8 in varchar2 default hr_api.g_varchar2
341: ,p_attribute9 in varchar2 default hr_api.g_varchar2
342: ,p_attribute10 in varchar2 default hr_api.g_varchar2
343: ,p_attribute11 in varchar2 default hr_api.g_varchar2
344: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 341: ,p_attribute9 in varchar2 default hr_api.g_varchar2

337: ,p_attribute5 in varchar2 default hr_api.g_varchar2
338: ,p_attribute6 in varchar2 default hr_api.g_varchar2
339: ,p_attribute7 in varchar2 default hr_api.g_varchar2
340: ,p_attribute8 in varchar2 default hr_api.g_varchar2
341: ,p_attribute9 in varchar2 default hr_api.g_varchar2
342: ,p_attribute10 in varchar2 default hr_api.g_varchar2
343: ,p_attribute11 in varchar2 default hr_api.g_varchar2
344: ,p_attribute12 in varchar2 default hr_api.g_varchar2
345: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 342: ,p_attribute10 in varchar2 default hr_api.g_varchar2

338: ,p_attribute6 in varchar2 default hr_api.g_varchar2
339: ,p_attribute7 in varchar2 default hr_api.g_varchar2
340: ,p_attribute8 in varchar2 default hr_api.g_varchar2
341: ,p_attribute9 in varchar2 default hr_api.g_varchar2
342: ,p_attribute10 in varchar2 default hr_api.g_varchar2
343: ,p_attribute11 in varchar2 default hr_api.g_varchar2
344: ,p_attribute12 in varchar2 default hr_api.g_varchar2
345: ,p_attribute13 in varchar2 default hr_api.g_varchar2
346: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 343: ,p_attribute11 in varchar2 default hr_api.g_varchar2

339: ,p_attribute7 in varchar2 default hr_api.g_varchar2
340: ,p_attribute8 in varchar2 default hr_api.g_varchar2
341: ,p_attribute9 in varchar2 default hr_api.g_varchar2
342: ,p_attribute10 in varchar2 default hr_api.g_varchar2
343: ,p_attribute11 in varchar2 default hr_api.g_varchar2
344: ,p_attribute12 in varchar2 default hr_api.g_varchar2
345: ,p_attribute13 in varchar2 default hr_api.g_varchar2
346: ,p_attribute14 in varchar2 default hr_api.g_varchar2
347: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 344: ,p_attribute12 in varchar2 default hr_api.g_varchar2

340: ,p_attribute8 in varchar2 default hr_api.g_varchar2
341: ,p_attribute9 in varchar2 default hr_api.g_varchar2
342: ,p_attribute10 in varchar2 default hr_api.g_varchar2
343: ,p_attribute11 in varchar2 default hr_api.g_varchar2
344: ,p_attribute12 in varchar2 default hr_api.g_varchar2
345: ,p_attribute13 in varchar2 default hr_api.g_varchar2
346: ,p_attribute14 in varchar2 default hr_api.g_varchar2
347: ,p_attribute15 in varchar2 default hr_api.g_varchar2
348: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 345: ,p_attribute13 in varchar2 default hr_api.g_varchar2

341: ,p_attribute9 in varchar2 default hr_api.g_varchar2
342: ,p_attribute10 in varchar2 default hr_api.g_varchar2
343: ,p_attribute11 in varchar2 default hr_api.g_varchar2
344: ,p_attribute12 in varchar2 default hr_api.g_varchar2
345: ,p_attribute13 in varchar2 default hr_api.g_varchar2
346: ,p_attribute14 in varchar2 default hr_api.g_varchar2
347: ,p_attribute15 in varchar2 default hr_api.g_varchar2
348: ,p_attribute16 in varchar2 default hr_api.g_varchar2
349: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 346: ,p_attribute14 in varchar2 default hr_api.g_varchar2

342: ,p_attribute10 in varchar2 default hr_api.g_varchar2
343: ,p_attribute11 in varchar2 default hr_api.g_varchar2
344: ,p_attribute12 in varchar2 default hr_api.g_varchar2
345: ,p_attribute13 in varchar2 default hr_api.g_varchar2
346: ,p_attribute14 in varchar2 default hr_api.g_varchar2
347: ,p_attribute15 in varchar2 default hr_api.g_varchar2
348: ,p_attribute16 in varchar2 default hr_api.g_varchar2
349: ,p_attribute17 in varchar2 default hr_api.g_varchar2
350: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 347: ,p_attribute15 in varchar2 default hr_api.g_varchar2

343: ,p_attribute11 in varchar2 default hr_api.g_varchar2
344: ,p_attribute12 in varchar2 default hr_api.g_varchar2
345: ,p_attribute13 in varchar2 default hr_api.g_varchar2
346: ,p_attribute14 in varchar2 default hr_api.g_varchar2
347: ,p_attribute15 in varchar2 default hr_api.g_varchar2
348: ,p_attribute16 in varchar2 default hr_api.g_varchar2
349: ,p_attribute17 in varchar2 default hr_api.g_varchar2
350: ,p_attribute18 in varchar2 default hr_api.g_varchar2
351: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 348: ,p_attribute16 in varchar2 default hr_api.g_varchar2

344: ,p_attribute12 in varchar2 default hr_api.g_varchar2
345: ,p_attribute13 in varchar2 default hr_api.g_varchar2
346: ,p_attribute14 in varchar2 default hr_api.g_varchar2
347: ,p_attribute15 in varchar2 default hr_api.g_varchar2
348: ,p_attribute16 in varchar2 default hr_api.g_varchar2
349: ,p_attribute17 in varchar2 default hr_api.g_varchar2
350: ,p_attribute18 in varchar2 default hr_api.g_varchar2
351: ,p_attribute19 in varchar2 default hr_api.g_varchar2
352: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 349: ,p_attribute17 in varchar2 default hr_api.g_varchar2

345: ,p_attribute13 in varchar2 default hr_api.g_varchar2
346: ,p_attribute14 in varchar2 default hr_api.g_varchar2
347: ,p_attribute15 in varchar2 default hr_api.g_varchar2
348: ,p_attribute16 in varchar2 default hr_api.g_varchar2
349: ,p_attribute17 in varchar2 default hr_api.g_varchar2
350: ,p_attribute18 in varchar2 default hr_api.g_varchar2
351: ,p_attribute19 in varchar2 default hr_api.g_varchar2
352: ,p_attribute20 in varchar2 default hr_api.g_varchar2
353: ,p_return_status out nocopy varchar2

Line 350: ,p_attribute18 in varchar2 default hr_api.g_varchar2

346: ,p_attribute14 in varchar2 default hr_api.g_varchar2
347: ,p_attribute15 in varchar2 default hr_api.g_varchar2
348: ,p_attribute16 in varchar2 default hr_api.g_varchar2
349: ,p_attribute17 in varchar2 default hr_api.g_varchar2
350: ,p_attribute18 in varchar2 default hr_api.g_varchar2
351: ,p_attribute19 in varchar2 default hr_api.g_varchar2
352: ,p_attribute20 in varchar2 default hr_api.g_varchar2
353: ,p_return_status out nocopy varchar2
354: ,p_data_source in varchar2 default hr_api.g_varchar2

Line 351: ,p_attribute19 in varchar2 default hr_api.g_varchar2

347: ,p_attribute15 in varchar2 default hr_api.g_varchar2
348: ,p_attribute16 in varchar2 default hr_api.g_varchar2
349: ,p_attribute17 in varchar2 default hr_api.g_varchar2
350: ,p_attribute18 in varchar2 default hr_api.g_varchar2
351: ,p_attribute19 in varchar2 default hr_api.g_varchar2
352: ,p_attribute20 in varchar2 default hr_api.g_varchar2
353: ,p_return_status out nocopy varchar2
354: ,p_data_source in varchar2 default hr_api.g_varchar2
355: ,p_vendor_id in number default hr_api.g_number

Line 352: ,p_attribute20 in varchar2 default hr_api.g_varchar2

348: ,p_attribute16 in varchar2 default hr_api.g_varchar2
349: ,p_attribute17 in varchar2 default hr_api.g_varchar2
350: ,p_attribute18 in varchar2 default hr_api.g_varchar2
351: ,p_attribute19 in varchar2 default hr_api.g_varchar2
352: ,p_attribute20 in varchar2 default hr_api.g_varchar2
353: ,p_return_status out nocopy varchar2
354: ,p_data_source in varchar2 default hr_api.g_varchar2
355: ,p_vendor_id in number default hr_api.g_number
356: ,p_description in varchar2 default hr_api.g_varchar2

Line 354: ,p_data_source in varchar2 default hr_api.g_varchar2

350: ,p_attribute18 in varchar2 default hr_api.g_varchar2
351: ,p_attribute19 in varchar2 default hr_api.g_varchar2
352: ,p_attribute20 in varchar2 default hr_api.g_varchar2
353: ,p_return_status out nocopy varchar2
354: ,p_data_source in varchar2 default hr_api.g_varchar2
355: ,p_vendor_id in number default hr_api.g_number
356: ,p_description in varchar2 default hr_api.g_varchar2
357: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966

Line 355: ,p_vendor_id in number default hr_api.g_number

351: ,p_attribute19 in varchar2 default hr_api.g_varchar2
352: ,p_attribute20 in varchar2 default hr_api.g_varchar2
353: ,p_return_status out nocopy varchar2
354: ,p_data_source in varchar2 default hr_api.g_varchar2
355: ,p_vendor_id in number default hr_api.g_number
356: ,p_description in varchar2 default hr_api.g_varchar2
357: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966
359:

Line 356: ,p_description in varchar2 default hr_api.g_varchar2

352: ,p_attribute20 in varchar2 default hr_api.g_varchar2
353: ,p_return_status out nocopy varchar2
354: ,p_data_source in varchar2 default hr_api.g_varchar2
355: ,p_vendor_id in number default hr_api.g_number
356: ,p_description in varchar2 default hr_api.g_varchar2
357: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966
359:
360: ) is

Line 357: ,p_competency_update_level in varchar2 default hr_api.g_varchar2

353: ,p_return_status out nocopy varchar2
354: ,p_data_source in varchar2 default hr_api.g_varchar2
355: ,p_vendor_id in number default hr_api.g_number
356: ,p_description in varchar2 default hr_api.g_varchar2
357: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966
359:
360: ) is
361: --

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

354: ,p_data_source in varchar2 default hr_api.g_varchar2
355: ,p_vendor_id in number default hr_api.g_number
356: ,p_description in varchar2 default hr_api.g_varchar2
357: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966
359:
360: ) is
361: --
362: -- Variables for API Boolean parameters

Line 388: hr_api.constant_to_boolean

384: --
385: -- Convert constant values to their corresponding boolean value
386: --
387: l_validate :=
388: hr_api.constant_to_boolean
389: (p_constant_value => p_validate);
390: --
391: -- Register Surrogate ID or user key values
392: --