DBA Data[Home] [Help]

APPS.OTA_LEARNING_PATH_SWI dependencies on HR_API

Line 13: ,p_validate in number default hr_api.g_false_num

9: -- |-------------------------< create_learning_path >-------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_learning_path
12: (p_effective_date in date
13: ,p_validate in number default hr_api.g_false_num
14: ,p_path_name in varchar2 default null
15: ,p_business_group_id in number
16: ,p_duration in number default null
17: ,p_duration_units in varchar2 default null

Line 88: hr_api.constant_to_boolean

84: --
85: -- Convert constant values to their corresponding boolean value
86: --
87: l_validate :=
88: hr_api.constant_to_boolean
89: (p_constant_value => p_validate);
90: --
91: -- Register Surrogate ID or user key values
92: --

Line 225: ,p_validate in number default hr_api.g_false_num

221: -- ----------------------------------------------------------------------------
222: PROCEDURE delete_learning_path
223: (p_learning_path_id in number
224: ,p_object_version_number in number
225: ,p_validate in number default hr_api.g_false_num
226: ,p_return_status out nocopy varchar2
227: ) is
228: --
229: -- Variables for API Boolean parameters

Line 253: hr_api.constant_to_boolean

249: --
250: -- Convert constant values to their corresponding boolean value
251: --
252: l_validate :=
253: hr_api.constant_to_boolean
254: (p_constant_value => p_validate);
255: --
256: -- Register Surrogate ID or user key values
257: --

Line 320: ,p_path_name in varchar2 default hr_api.g_varchar2

316: PROCEDURE update_learning_path
317: (p_effective_date in date
318: ,p_learning_path_id in number
319: ,p_object_version_number in out nocopy number
320: ,p_path_name in varchar2 default hr_api.g_varchar2
321: ,p_description in varchar2 default hr_api.g_varchar2
322: ,p_objectives in varchar2 default hr_api.g_varchar2
323: ,p_keywords in varchar2 default hr_api.g_varchar2
324: ,p_purpose in varchar2 default hr_api.g_varchar2

Line 321: ,p_description in varchar2 default hr_api.g_varchar2

317: (p_effective_date in date
318: ,p_learning_path_id in number
319: ,p_object_version_number in out nocopy number
320: ,p_path_name in varchar2 default hr_api.g_varchar2
321: ,p_description in varchar2 default hr_api.g_varchar2
322: ,p_objectives in varchar2 default hr_api.g_varchar2
323: ,p_keywords in varchar2 default hr_api.g_varchar2
324: ,p_purpose in varchar2 default hr_api.g_varchar2
325: ,p_duration in number default hr_api.g_number

Line 322: ,p_objectives in varchar2 default hr_api.g_varchar2

318: ,p_learning_path_id in number
319: ,p_object_version_number in out nocopy number
320: ,p_path_name in varchar2 default hr_api.g_varchar2
321: ,p_description in varchar2 default hr_api.g_varchar2
322: ,p_objectives in varchar2 default hr_api.g_varchar2
323: ,p_keywords in varchar2 default hr_api.g_varchar2
324: ,p_purpose in varchar2 default hr_api.g_varchar2
325: ,p_duration in number default hr_api.g_number
326: ,p_duration_units in varchar2 default hr_api.g_varchar2

Line 323: ,p_keywords in varchar2 default hr_api.g_varchar2

319: ,p_object_version_number in out nocopy number
320: ,p_path_name in varchar2 default hr_api.g_varchar2
321: ,p_description in varchar2 default hr_api.g_varchar2
322: ,p_objectives in varchar2 default hr_api.g_varchar2
323: ,p_keywords in varchar2 default hr_api.g_varchar2
324: ,p_purpose in varchar2 default hr_api.g_varchar2
325: ,p_duration in number default hr_api.g_number
326: ,p_duration_units in varchar2 default hr_api.g_varchar2
327: ,p_start_date_active in date default hr_api.g_date

Line 324: ,p_purpose in varchar2 default hr_api.g_varchar2

320: ,p_path_name in varchar2 default hr_api.g_varchar2
321: ,p_description in varchar2 default hr_api.g_varchar2
322: ,p_objectives in varchar2 default hr_api.g_varchar2
323: ,p_keywords in varchar2 default hr_api.g_varchar2
324: ,p_purpose in varchar2 default hr_api.g_varchar2
325: ,p_duration in number default hr_api.g_number
326: ,p_duration_units in varchar2 default hr_api.g_varchar2
327: ,p_start_date_active in date default hr_api.g_date
328: ,p_end_date_active in date default hr_api.g_date

Line 325: ,p_duration in number default hr_api.g_number

321: ,p_description in varchar2 default hr_api.g_varchar2
322: ,p_objectives in varchar2 default hr_api.g_varchar2
323: ,p_keywords in varchar2 default hr_api.g_varchar2
324: ,p_purpose in varchar2 default hr_api.g_varchar2
325: ,p_duration in number default hr_api.g_number
326: ,p_duration_units in varchar2 default hr_api.g_varchar2
327: ,p_start_date_active in date default hr_api.g_date
328: ,p_end_date_active in date default hr_api.g_date
329: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 326: ,p_duration_units in varchar2 default hr_api.g_varchar2

322: ,p_objectives in varchar2 default hr_api.g_varchar2
323: ,p_keywords in varchar2 default hr_api.g_varchar2
324: ,p_purpose in varchar2 default hr_api.g_varchar2
325: ,p_duration in number default hr_api.g_number
326: ,p_duration_units in varchar2 default hr_api.g_varchar2
327: ,p_start_date_active in date default hr_api.g_date
328: ,p_end_date_active in date default hr_api.g_date
329: ,p_attribute_category in varchar2 default hr_api.g_varchar2
330: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 327: ,p_start_date_active in date default hr_api.g_date

323: ,p_keywords in varchar2 default hr_api.g_varchar2
324: ,p_purpose in varchar2 default hr_api.g_varchar2
325: ,p_duration in number default hr_api.g_number
326: ,p_duration_units in varchar2 default hr_api.g_varchar2
327: ,p_start_date_active in date default hr_api.g_date
328: ,p_end_date_active in date default hr_api.g_date
329: ,p_attribute_category in varchar2 default hr_api.g_varchar2
330: ,p_attribute1 in varchar2 default hr_api.g_varchar2
331: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 328: ,p_end_date_active in date default hr_api.g_date

324: ,p_purpose in varchar2 default hr_api.g_varchar2
325: ,p_duration in number default hr_api.g_number
326: ,p_duration_units in varchar2 default hr_api.g_varchar2
327: ,p_start_date_active in date default hr_api.g_date
328: ,p_end_date_active in date default hr_api.g_date
329: ,p_attribute_category in varchar2 default hr_api.g_varchar2
330: ,p_attribute1 in varchar2 default hr_api.g_varchar2
331: ,p_attribute2 in varchar2 default hr_api.g_varchar2
332: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 329: ,p_attribute_category in varchar2 default hr_api.g_varchar2

325: ,p_duration in number default hr_api.g_number
326: ,p_duration_units in varchar2 default hr_api.g_varchar2
327: ,p_start_date_active in date default hr_api.g_date
328: ,p_end_date_active in date default hr_api.g_date
329: ,p_attribute_category in varchar2 default hr_api.g_varchar2
330: ,p_attribute1 in varchar2 default hr_api.g_varchar2
331: ,p_attribute2 in varchar2 default hr_api.g_varchar2
332: ,p_attribute3 in varchar2 default hr_api.g_varchar2
333: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 330: ,p_attribute1 in varchar2 default hr_api.g_varchar2

326: ,p_duration_units in varchar2 default hr_api.g_varchar2
327: ,p_start_date_active in date default hr_api.g_date
328: ,p_end_date_active in date default hr_api.g_date
329: ,p_attribute_category in varchar2 default hr_api.g_varchar2
330: ,p_attribute1 in varchar2 default hr_api.g_varchar2
331: ,p_attribute2 in varchar2 default hr_api.g_varchar2
332: ,p_attribute3 in varchar2 default hr_api.g_varchar2
333: ,p_attribute4 in varchar2 default hr_api.g_varchar2
334: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 331: ,p_attribute2 in varchar2 default hr_api.g_varchar2

327: ,p_start_date_active in date default hr_api.g_date
328: ,p_end_date_active in date default hr_api.g_date
329: ,p_attribute_category in varchar2 default hr_api.g_varchar2
330: ,p_attribute1 in varchar2 default hr_api.g_varchar2
331: ,p_attribute2 in varchar2 default hr_api.g_varchar2
332: ,p_attribute3 in varchar2 default hr_api.g_varchar2
333: ,p_attribute4 in varchar2 default hr_api.g_varchar2
334: ,p_attribute5 in varchar2 default hr_api.g_varchar2
335: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 332: ,p_attribute3 in varchar2 default hr_api.g_varchar2

328: ,p_end_date_active in date default hr_api.g_date
329: ,p_attribute_category in varchar2 default hr_api.g_varchar2
330: ,p_attribute1 in varchar2 default hr_api.g_varchar2
331: ,p_attribute2 in varchar2 default hr_api.g_varchar2
332: ,p_attribute3 in varchar2 default hr_api.g_varchar2
333: ,p_attribute4 in varchar2 default hr_api.g_varchar2
334: ,p_attribute5 in varchar2 default hr_api.g_varchar2
335: ,p_attribute6 in varchar2 default hr_api.g_varchar2
336: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 333: ,p_attribute4 in varchar2 default hr_api.g_varchar2

329: ,p_attribute_category in varchar2 default hr_api.g_varchar2
330: ,p_attribute1 in varchar2 default hr_api.g_varchar2
331: ,p_attribute2 in varchar2 default hr_api.g_varchar2
332: ,p_attribute3 in varchar2 default hr_api.g_varchar2
333: ,p_attribute4 in varchar2 default hr_api.g_varchar2
334: ,p_attribute5 in varchar2 default hr_api.g_varchar2
335: ,p_attribute6 in varchar2 default hr_api.g_varchar2
336: ,p_attribute7 in varchar2 default hr_api.g_varchar2
337: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 334: ,p_attribute5 in varchar2 default hr_api.g_varchar2

330: ,p_attribute1 in varchar2 default hr_api.g_varchar2
331: ,p_attribute2 in varchar2 default hr_api.g_varchar2
332: ,p_attribute3 in varchar2 default hr_api.g_varchar2
333: ,p_attribute4 in varchar2 default hr_api.g_varchar2
334: ,p_attribute5 in varchar2 default hr_api.g_varchar2
335: ,p_attribute6 in varchar2 default hr_api.g_varchar2
336: ,p_attribute7 in varchar2 default hr_api.g_varchar2
337: ,p_attribute8 in varchar2 default hr_api.g_varchar2
338: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 335: ,p_attribute6 in varchar2 default hr_api.g_varchar2

331: ,p_attribute2 in varchar2 default hr_api.g_varchar2
332: ,p_attribute3 in varchar2 default hr_api.g_varchar2
333: ,p_attribute4 in varchar2 default hr_api.g_varchar2
334: ,p_attribute5 in varchar2 default hr_api.g_varchar2
335: ,p_attribute6 in varchar2 default hr_api.g_varchar2
336: ,p_attribute7 in varchar2 default hr_api.g_varchar2
337: ,p_attribute8 in varchar2 default hr_api.g_varchar2
338: ,p_attribute9 in varchar2 default hr_api.g_varchar2
339: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 336: ,p_attribute7 in varchar2 default hr_api.g_varchar2

332: ,p_attribute3 in varchar2 default hr_api.g_varchar2
333: ,p_attribute4 in varchar2 default hr_api.g_varchar2
334: ,p_attribute5 in varchar2 default hr_api.g_varchar2
335: ,p_attribute6 in varchar2 default hr_api.g_varchar2
336: ,p_attribute7 in varchar2 default hr_api.g_varchar2
337: ,p_attribute8 in varchar2 default hr_api.g_varchar2
338: ,p_attribute9 in varchar2 default hr_api.g_varchar2
339: ,p_attribute10 in varchar2 default hr_api.g_varchar2
340: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 337: ,p_attribute8 in varchar2 default hr_api.g_varchar2

333: ,p_attribute4 in varchar2 default hr_api.g_varchar2
334: ,p_attribute5 in varchar2 default hr_api.g_varchar2
335: ,p_attribute6 in varchar2 default hr_api.g_varchar2
336: ,p_attribute7 in varchar2 default hr_api.g_varchar2
337: ,p_attribute8 in varchar2 default hr_api.g_varchar2
338: ,p_attribute9 in varchar2 default hr_api.g_varchar2
339: ,p_attribute10 in varchar2 default hr_api.g_varchar2
340: ,p_attribute11 in varchar2 default hr_api.g_varchar2
341: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 338: ,p_attribute9 in varchar2 default hr_api.g_varchar2

334: ,p_attribute5 in varchar2 default hr_api.g_varchar2
335: ,p_attribute6 in varchar2 default hr_api.g_varchar2
336: ,p_attribute7 in varchar2 default hr_api.g_varchar2
337: ,p_attribute8 in varchar2 default hr_api.g_varchar2
338: ,p_attribute9 in varchar2 default hr_api.g_varchar2
339: ,p_attribute10 in varchar2 default hr_api.g_varchar2
340: ,p_attribute11 in varchar2 default hr_api.g_varchar2
341: ,p_attribute12 in varchar2 default hr_api.g_varchar2
342: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 339: ,p_attribute10 in varchar2 default hr_api.g_varchar2

335: ,p_attribute6 in varchar2 default hr_api.g_varchar2
336: ,p_attribute7 in varchar2 default hr_api.g_varchar2
337: ,p_attribute8 in varchar2 default hr_api.g_varchar2
338: ,p_attribute9 in varchar2 default hr_api.g_varchar2
339: ,p_attribute10 in varchar2 default hr_api.g_varchar2
340: ,p_attribute11 in varchar2 default hr_api.g_varchar2
341: ,p_attribute12 in varchar2 default hr_api.g_varchar2
342: ,p_attribute13 in varchar2 default hr_api.g_varchar2
343: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 340: ,p_attribute11 in varchar2 default hr_api.g_varchar2

336: ,p_attribute7 in varchar2 default hr_api.g_varchar2
337: ,p_attribute8 in varchar2 default hr_api.g_varchar2
338: ,p_attribute9 in varchar2 default hr_api.g_varchar2
339: ,p_attribute10 in varchar2 default hr_api.g_varchar2
340: ,p_attribute11 in varchar2 default hr_api.g_varchar2
341: ,p_attribute12 in varchar2 default hr_api.g_varchar2
342: ,p_attribute13 in varchar2 default hr_api.g_varchar2
343: ,p_attribute14 in varchar2 default hr_api.g_varchar2
344: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 341: ,p_attribute12 in varchar2 default hr_api.g_varchar2

337: ,p_attribute8 in varchar2 default hr_api.g_varchar2
338: ,p_attribute9 in varchar2 default hr_api.g_varchar2
339: ,p_attribute10 in varchar2 default hr_api.g_varchar2
340: ,p_attribute11 in varchar2 default hr_api.g_varchar2
341: ,p_attribute12 in varchar2 default hr_api.g_varchar2
342: ,p_attribute13 in varchar2 default hr_api.g_varchar2
343: ,p_attribute14 in varchar2 default hr_api.g_varchar2
344: ,p_attribute15 in varchar2 default hr_api.g_varchar2
345: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 342: ,p_attribute13 in varchar2 default hr_api.g_varchar2

338: ,p_attribute9 in varchar2 default hr_api.g_varchar2
339: ,p_attribute10 in varchar2 default hr_api.g_varchar2
340: ,p_attribute11 in varchar2 default hr_api.g_varchar2
341: ,p_attribute12 in varchar2 default hr_api.g_varchar2
342: ,p_attribute13 in varchar2 default hr_api.g_varchar2
343: ,p_attribute14 in varchar2 default hr_api.g_varchar2
344: ,p_attribute15 in varchar2 default hr_api.g_varchar2
345: ,p_attribute16 in varchar2 default hr_api.g_varchar2
346: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 343: ,p_attribute14 in varchar2 default hr_api.g_varchar2

339: ,p_attribute10 in varchar2 default hr_api.g_varchar2
340: ,p_attribute11 in varchar2 default hr_api.g_varchar2
341: ,p_attribute12 in varchar2 default hr_api.g_varchar2
342: ,p_attribute13 in varchar2 default hr_api.g_varchar2
343: ,p_attribute14 in varchar2 default hr_api.g_varchar2
344: ,p_attribute15 in varchar2 default hr_api.g_varchar2
345: ,p_attribute16 in varchar2 default hr_api.g_varchar2
346: ,p_attribute17 in varchar2 default hr_api.g_varchar2
347: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 344: ,p_attribute15 in varchar2 default hr_api.g_varchar2

340: ,p_attribute11 in varchar2 default hr_api.g_varchar2
341: ,p_attribute12 in varchar2 default hr_api.g_varchar2
342: ,p_attribute13 in varchar2 default hr_api.g_varchar2
343: ,p_attribute14 in varchar2 default hr_api.g_varchar2
344: ,p_attribute15 in varchar2 default hr_api.g_varchar2
345: ,p_attribute16 in varchar2 default hr_api.g_varchar2
346: ,p_attribute17 in varchar2 default hr_api.g_varchar2
347: ,p_attribute18 in varchar2 default hr_api.g_varchar2
348: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 345: ,p_attribute16 in varchar2 default hr_api.g_varchar2

341: ,p_attribute12 in varchar2 default hr_api.g_varchar2
342: ,p_attribute13 in varchar2 default hr_api.g_varchar2
343: ,p_attribute14 in varchar2 default hr_api.g_varchar2
344: ,p_attribute15 in varchar2 default hr_api.g_varchar2
345: ,p_attribute16 in varchar2 default hr_api.g_varchar2
346: ,p_attribute17 in varchar2 default hr_api.g_varchar2
347: ,p_attribute18 in varchar2 default hr_api.g_varchar2
348: ,p_attribute19 in varchar2 default hr_api.g_varchar2
349: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 346: ,p_attribute17 in varchar2 default hr_api.g_varchar2

342: ,p_attribute13 in varchar2 default hr_api.g_varchar2
343: ,p_attribute14 in varchar2 default hr_api.g_varchar2
344: ,p_attribute15 in varchar2 default hr_api.g_varchar2
345: ,p_attribute16 in varchar2 default hr_api.g_varchar2
346: ,p_attribute17 in varchar2 default hr_api.g_varchar2
347: ,p_attribute18 in varchar2 default hr_api.g_varchar2
348: ,p_attribute19 in varchar2 default hr_api.g_varchar2
349: ,p_attribute20 in varchar2 default hr_api.g_varchar2
350: ,p_path_source_code in varchar2 default hr_api.g_varchar2

Line 347: ,p_attribute18 in varchar2 default hr_api.g_varchar2

343: ,p_attribute14 in varchar2 default hr_api.g_varchar2
344: ,p_attribute15 in varchar2 default hr_api.g_varchar2
345: ,p_attribute16 in varchar2 default hr_api.g_varchar2
346: ,p_attribute17 in varchar2 default hr_api.g_varchar2
347: ,p_attribute18 in varchar2 default hr_api.g_varchar2
348: ,p_attribute19 in varchar2 default hr_api.g_varchar2
349: ,p_attribute20 in varchar2 default hr_api.g_varchar2
350: ,p_path_source_code in varchar2 default hr_api.g_varchar2
351: ,p_source_function_code in varchar2 default hr_api.g_varchar2

Line 348: ,p_attribute19 in varchar2 default hr_api.g_varchar2

344: ,p_attribute15 in varchar2 default hr_api.g_varchar2
345: ,p_attribute16 in varchar2 default hr_api.g_varchar2
346: ,p_attribute17 in varchar2 default hr_api.g_varchar2
347: ,p_attribute18 in varchar2 default hr_api.g_varchar2
348: ,p_attribute19 in varchar2 default hr_api.g_varchar2
349: ,p_attribute20 in varchar2 default hr_api.g_varchar2
350: ,p_path_source_code in varchar2 default hr_api.g_varchar2
351: ,p_source_function_code in varchar2 default hr_api.g_varchar2
352: ,p_assignment_id in number default hr_api.g_number

Line 349: ,p_attribute20 in varchar2 default hr_api.g_varchar2

345: ,p_attribute16 in varchar2 default hr_api.g_varchar2
346: ,p_attribute17 in varchar2 default hr_api.g_varchar2
347: ,p_attribute18 in varchar2 default hr_api.g_varchar2
348: ,p_attribute19 in varchar2 default hr_api.g_varchar2
349: ,p_attribute20 in varchar2 default hr_api.g_varchar2
350: ,p_path_source_code in varchar2 default hr_api.g_varchar2
351: ,p_source_function_code in varchar2 default hr_api.g_varchar2
352: ,p_assignment_id in number default hr_api.g_number
353: ,p_source_id in number default hr_api.g_number

Line 350: ,p_path_source_code in varchar2 default hr_api.g_varchar2

346: ,p_attribute17 in varchar2 default hr_api.g_varchar2
347: ,p_attribute18 in varchar2 default hr_api.g_varchar2
348: ,p_attribute19 in varchar2 default hr_api.g_varchar2
349: ,p_attribute20 in varchar2 default hr_api.g_varchar2
350: ,p_path_source_code in varchar2 default hr_api.g_varchar2
351: ,p_source_function_code in varchar2 default hr_api.g_varchar2
352: ,p_assignment_id in number default hr_api.g_number
353: ,p_source_id in number default hr_api.g_number
354: ,p_notify_days_before_target in number default hr_api.g_number

Line 351: ,p_source_function_code in varchar2 default hr_api.g_varchar2

347: ,p_attribute18 in varchar2 default hr_api.g_varchar2
348: ,p_attribute19 in varchar2 default hr_api.g_varchar2
349: ,p_attribute20 in varchar2 default hr_api.g_varchar2
350: ,p_path_source_code in varchar2 default hr_api.g_varchar2
351: ,p_source_function_code in varchar2 default hr_api.g_varchar2
352: ,p_assignment_id in number default hr_api.g_number
353: ,p_source_id in number default hr_api.g_number
354: ,p_notify_days_before_target in number default hr_api.g_number
355: ,p_person_id in number default hr_api.g_number

Line 352: ,p_assignment_id in number default hr_api.g_number

348: ,p_attribute19 in varchar2 default hr_api.g_varchar2
349: ,p_attribute20 in varchar2 default hr_api.g_varchar2
350: ,p_path_source_code in varchar2 default hr_api.g_varchar2
351: ,p_source_function_code in varchar2 default hr_api.g_varchar2
352: ,p_assignment_id in number default hr_api.g_number
353: ,p_source_id in number default hr_api.g_number
354: ,p_notify_days_before_target in number default hr_api.g_number
355: ,p_person_id in number default hr_api.g_number
356: ,p_contact_id in number default hr_api.g_number

Line 353: ,p_source_id in number default hr_api.g_number

349: ,p_attribute20 in varchar2 default hr_api.g_varchar2
350: ,p_path_source_code in varchar2 default hr_api.g_varchar2
351: ,p_source_function_code in varchar2 default hr_api.g_varchar2
352: ,p_assignment_id in number default hr_api.g_number
353: ,p_source_id in number default hr_api.g_number
354: ,p_notify_days_before_target in number default hr_api.g_number
355: ,p_person_id in number default hr_api.g_number
356: ,p_contact_id in number default hr_api.g_number
357: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2

Line 354: ,p_notify_days_before_target in number default hr_api.g_number

350: ,p_path_source_code in varchar2 default hr_api.g_varchar2
351: ,p_source_function_code in varchar2 default hr_api.g_varchar2
352: ,p_assignment_id in number default hr_api.g_number
353: ,p_source_id in number default hr_api.g_number
354: ,p_notify_days_before_target in number default hr_api.g_number
355: ,p_person_id in number default hr_api.g_number
356: ,p_contact_id in number default hr_api.g_number
357: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
358: ,p_public_flag in varchar2 default hr_api.g_varchar2

Line 355: ,p_person_id in number default hr_api.g_number

351: ,p_source_function_code in varchar2 default hr_api.g_varchar2
352: ,p_assignment_id in number default hr_api.g_number
353: ,p_source_id in number default hr_api.g_number
354: ,p_notify_days_before_target in number default hr_api.g_number
355: ,p_person_id in number default hr_api.g_number
356: ,p_contact_id in number default hr_api.g_number
357: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
358: ,p_public_flag in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number

Line 356: ,p_contact_id in number default hr_api.g_number

352: ,p_assignment_id in number default hr_api.g_number
353: ,p_source_id in number default hr_api.g_number
354: ,p_notify_days_before_target in number default hr_api.g_number
355: ,p_person_id in number default hr_api.g_number
356: ,p_contact_id in number default hr_api.g_number
357: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
358: ,p_public_flag in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_validate in number default hr_api.g_false_num

Line 357: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2

353: ,p_source_id in number default hr_api.g_number
354: ,p_notify_days_before_target in number default hr_api.g_number
355: ,p_person_id in number default hr_api.g_number
356: ,p_contact_id in number default hr_api.g_number
357: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
358: ,p_public_flag in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_validate in number default hr_api.g_false_num
361: ,p_competency_update_level in varchar2 default hr_api.g_varchar2

Line 358: ,p_public_flag in varchar2 default hr_api.g_varchar2

354: ,p_notify_days_before_target in number default hr_api.g_number
355: ,p_person_id in number default hr_api.g_number
356: ,p_contact_id in number default hr_api.g_number
357: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
358: ,p_public_flag in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_validate in number default hr_api.g_false_num
361: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
362: ,p_return_status out nocopy varchar2

Line 359: ,p_business_group_id in number default hr_api.g_number

355: ,p_person_id in number default hr_api.g_number
356: ,p_contact_id in number default hr_api.g_number
357: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
358: ,p_public_flag in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_validate in number default hr_api.g_false_num
361: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
362: ,p_return_status out nocopy varchar2
363: ) is

Line 360: ,p_validate in number default hr_api.g_false_num

356: ,p_contact_id in number default hr_api.g_number
357: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
358: ,p_public_flag in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_validate in number default hr_api.g_false_num
361: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
362: ,p_return_status out nocopy varchar2
363: ) is
364: --

Line 361: ,p_competency_update_level in varchar2 default hr_api.g_varchar2

357: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
358: ,p_public_flag in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_validate in number default hr_api.g_false_num
361: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
362: ,p_return_status out nocopy varchar2
363: ) is
364: --
365: -- Variables for API Boolean parameters

Line 391: hr_api.constant_to_boolean

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

Line 397: IF p_path_name <> hr_api.g_varchar2 THEN

393: --
394: -- Register Surrogate ID or user key values
395: --
396:
397: IF p_path_name <> hr_api.g_varchar2 THEN
398: check_duplicate_name
399: ( p_name => p_path_name
400: ,p_learning_path_id => p_learning_path_id
401: ,p_business_group_id=> p_business_group_id