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

Line 13: (p_validate IN NUMBER DEFAULT hr_api.g_false_num

9: -- ----------------------------------------------------------------------------
10: -- |----------------------< create_training_plan_member >---------------------|
11: -- ----------------------------------------------------------------------------
12: PROCEDURE create_training_plan_member
13: (p_validate IN NUMBER DEFAULT hr_api.g_false_num
14: ,p_effective_date IN date
15: ,p_business_group_id IN number
16: ,p_training_plan_id IN number DEFAULT NULL
17: ,p_activity_version_id IN NUMBER

Line 113: hr_api.constant_to_boolean

109: --
110: -- Convert constant values to their corresponding boolean value
111: --
112: l_validate :=
113: hr_api.constant_to_boolean
114: (p_constant_value => p_validate);
115:
116: --
117: -- Check if the call is from SSHR - Appraisal / Suitability Matching / Succession Planning

Line 122: hr_api.mandatory_arg_error

118: --
119: if (p_training_plan_id is null) then
120:
121: -- SSHR call should have person Id. Mandatory check for personId.
122: hr_api.mandatory_arg_error
123: (p_api_name => l_proc
124: ,p_argument => 'p_person_id'
125: ,p_argument_value => p_person_id
126: );

Line 153: ,p_end_date => hr_api.g_eot

149: ,p_budget_currency => hr_general.default_currency_code(p_business_group_id => p_business_group_id)
150: ,p_name => l_person_full_name ||' Talent Management '||nvl(p_plan_start_date,p_earliest_start_date)
151: ,p_plan_source => 'TALENT_MGMT'
152: ,p_start_date => nvl(p_plan_start_date,p_earliest_start_date)
153: ,p_end_date => hr_api.g_eot
154: ,p_training_plan_id => l_training_plan_id
155: ,p_creator_person_id => p_creator_person_id
156: ,p_object_version_NUMBER => l_object_version_number
157: ,p_return_status => l_return_status

Line 319: (p_validate IN NUMBER DEFAULT hr_api.g_false_num

315: -- ----------------------------------------------------------------------------
316: -- |----------------------< delete_training_plan_member >---------------------|
317: -- ----------------------------------------------------------------------------
318: PROCEDURE delete_training_plan_member
319: (p_validate IN NUMBER DEFAULT hr_api.g_false_num
320: ,p_training_plan_member_id IN number
321: ,p_object_version_NUMBER IN number
322: ,p_return_status OUT NOCOPY VARCHAR2
323: ) IS

Line 349: hr_api.constant_to_boolean

345: --
346: -- Convert constant values to their corresponding boolean value
347: --
348: l_validate :=
349: hr_api.constant_to_boolean
350: (p_constant_value => p_validate);
351: --
352: -- Register Surrogate ID or user key values
353: --

Line 413: (p_validate IN NUMBER DEFAULT hr_api.g_false_num

409: -- ----------------------------------------------------------------------------
410: -- |----------------------< update_training_plan_member >---------------------|
411: -- ----------------------------------------------------------------------------
412: PROCEDURE update_training_plan_member
413: (p_validate IN NUMBER DEFAULT hr_api.g_false_num
414: ,p_effective_date IN date
415: ,p_training_plan_member_id IN number
416: ,p_object_version_NUMBER IN OUT NOCOPY number
417: ,p_activity_version_id IN NUMBER DEFAULT hr_api.g_number

Line 417: ,p_activity_version_id IN NUMBER DEFAULT hr_api.g_number

413: (p_validate IN NUMBER DEFAULT hr_api.g_false_num
414: ,p_effective_date IN date
415: ,p_training_plan_member_id IN number
416: ,p_object_version_NUMBER IN OUT NOCOPY number
417: ,p_activity_version_id IN NUMBER DEFAULT hr_api.g_number
418: ,p_activity_definition_id IN NUMBER DEFAULT hr_api.g_number
419: ,p_member_status_type_id IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
420: ,p_target_completion_date IN date DEFAULT hr_api.g_date
421: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 418: ,p_activity_definition_id IN NUMBER DEFAULT hr_api.g_number

414: ,p_effective_date IN date
415: ,p_training_plan_member_id IN number
416: ,p_object_version_NUMBER IN OUT NOCOPY number
417: ,p_activity_version_id IN NUMBER DEFAULT hr_api.g_number
418: ,p_activity_definition_id IN NUMBER DEFAULT hr_api.g_number
419: ,p_member_status_type_id IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
420: ,p_target_completion_date IN date DEFAULT hr_api.g_date
421: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
422: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 419: ,p_member_status_type_id IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

415: ,p_training_plan_member_id IN number
416: ,p_object_version_NUMBER IN OUT NOCOPY number
417: ,p_activity_version_id IN NUMBER DEFAULT hr_api.g_number
418: ,p_activity_definition_id IN NUMBER DEFAULT hr_api.g_number
419: ,p_member_status_type_id IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
420: ,p_target_completion_date IN date DEFAULT hr_api.g_date
421: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
422: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
423: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 420: ,p_target_completion_date IN date DEFAULT hr_api.g_date

416: ,p_object_version_NUMBER IN OUT NOCOPY number
417: ,p_activity_version_id IN NUMBER DEFAULT hr_api.g_number
418: ,p_activity_definition_id IN NUMBER DEFAULT hr_api.g_number
419: ,p_member_status_type_id IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
420: ,p_target_completion_date IN date DEFAULT hr_api.g_date
421: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
422: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
423: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
424: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 421: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

417: ,p_activity_version_id IN NUMBER DEFAULT hr_api.g_number
418: ,p_activity_definition_id IN NUMBER DEFAULT hr_api.g_number
419: ,p_member_status_type_id IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
420: ,p_target_completion_date IN date DEFAULT hr_api.g_date
421: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
422: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
423: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
424: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
425: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 422: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

418: ,p_activity_definition_id IN NUMBER DEFAULT hr_api.g_number
419: ,p_member_status_type_id IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
420: ,p_target_completion_date IN date DEFAULT hr_api.g_date
421: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
422: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
423: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
424: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
425: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
426: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 423: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

419: ,p_member_status_type_id IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
420: ,p_target_completion_date IN date DEFAULT hr_api.g_date
421: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
422: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
423: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
424: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
425: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
426: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
427: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 424: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

420: ,p_target_completion_date IN date DEFAULT hr_api.g_date
421: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
422: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
423: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
424: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
425: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
426: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
427: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
428: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 425: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

421: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
422: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
423: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
424: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
425: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
426: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
427: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
428: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
429: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 426: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

422: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
423: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
424: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
425: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
426: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
427: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
428: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
429: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
430: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 427: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

423: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
424: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
425: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
426: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
427: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
428: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
429: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
430: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
431: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 428: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

424: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
425: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
426: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
427: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
428: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
429: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
430: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
431: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
432: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 429: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

425: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
426: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
427: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
428: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
429: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
430: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
431: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
432: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
433: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 430: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

426: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
427: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
428: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
429: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
430: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
431: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
432: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
433: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
434: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 431: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

427: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
428: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
429: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
430: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
431: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
432: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
433: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
434: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
435: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 432: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

428: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
429: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
430: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
431: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
432: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
433: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
434: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
435: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
436: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 433: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

429: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
430: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
431: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
432: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
433: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
434: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
435: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
436: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
437: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 434: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

430: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
431: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
432: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
433: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
434: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
435: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
436: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
437: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
438: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 435: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

431: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
432: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
433: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
434: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
435: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
436: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
437: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
438: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
439: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 436: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

432: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
433: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
434: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
435: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
436: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
437: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
438: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
439: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
440: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 437: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

433: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
434: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
435: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
436: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
437: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
438: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
439: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
440: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
441: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 438: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

434: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
435: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
436: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
437: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
438: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
439: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
440: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
441: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
442: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 439: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

435: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
436: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
437: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
438: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
439: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
440: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
441: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
442: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
443: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 440: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

436: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
437: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
438: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
439: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
440: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
441: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
442: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
443: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
444: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 441: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

437: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
438: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
439: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
440: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
441: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
442: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
443: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
444: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
445: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 442: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

438: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
439: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
440: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
441: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
442: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
443: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
444: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
445: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
446: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 443: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

439: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
440: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
441: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
442: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
443: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
444: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
445: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
446: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
447: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 444: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

440: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
441: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
442: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
443: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
444: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
445: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
446: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
447: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
448: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 445: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

441: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
442: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
443: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
444: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
445: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
446: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
447: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
448: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
449: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 446: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

442: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
443: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
444: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
445: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
446: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
447: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
448: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
449: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
450: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 447: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

443: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
444: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
445: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
446: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
447: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
448: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
449: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
450: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
451: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 448: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

444: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
445: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
446: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
447: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
448: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
449: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
450: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
451: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
452: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number

Line 449: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

445: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
446: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
447: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
448: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
449: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
450: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
451: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
452: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
453: ,p_source_id IN NUMBER DEFAULT hr_api.g_number

Line 450: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

446: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
447: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
448: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
449: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
450: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
451: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
452: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
453: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
454: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 451: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

447: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
448: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
449: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
450: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
451: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
452: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
453: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
454: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
455: ,p_cancellation_reason IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 452: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number

448: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
449: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
450: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
451: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
452: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
453: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
454: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
455: ,p_cancellation_reason IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
456: ,p_earliest_start_date IN date DEFAULT hr_api.g_date

Line 453: ,p_source_id IN NUMBER DEFAULT hr_api.g_number

449: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
450: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
451: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
452: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
453: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
454: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
455: ,p_cancellation_reason IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
456: ,p_earliest_start_date IN date DEFAULT hr_api.g_date
457: ,p_creator_person_id IN NUMBER

Line 454: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

450: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
451: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
452: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
453: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
454: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
455: ,p_cancellation_reason IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
456: ,p_earliest_start_date IN date DEFAULT hr_api.g_date
457: ,p_creator_person_id IN NUMBER
458: ,p_return_status OUT NOCOPY VARCHAR2

Line 455: ,p_cancellation_reason IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

451: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
452: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
453: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
454: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
455: ,p_cancellation_reason IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
456: ,p_earliest_start_date IN date DEFAULT hr_api.g_date
457: ,p_creator_person_id IN NUMBER
458: ,p_return_status OUT NOCOPY VARCHAR2
459: ) IS

Line 456: ,p_earliest_start_date IN date DEFAULT hr_api.g_date

452: ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
453: ,p_source_id IN NUMBER DEFAULT hr_api.g_number
454: ,p_source_function IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
455: ,p_cancellation_reason IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
456: ,p_earliest_start_date IN date DEFAULT hr_api.g_date
457: ,p_creator_person_id IN NUMBER
458: ,p_return_status OUT NOCOPY VARCHAR2
459: ) IS
460: --

Line 488: hr_api.constant_to_boolean

484: --
485: -- Convert constant values to their corresponding boolean value
486: --
487: l_validate :=
488: hr_api.constant_to_boolean
489: (p_constant_value => p_validate);
490: --
491: -- Register Surrogate ID or user key values
492: --