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
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
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: );
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
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
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: --
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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: --