8: -- ----------------------------------------------------------------------------
9: -- |---------------------------< create_hierarchy >---------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_hierarchy
12: (p_validate in number default hr_api.g_false_num
13: ,p_hierarchy_id out nocopy number
14: ,p_business_group_id in number default null
15: ,p_name in varchar2 default null
16: ,p_type in varchar2 default null
110: --
111: -- Convert constant values to their corresponding boolean value
112: --
113: l_validate :=
114: hr_api.constant_to_boolean
115: (p_constant_value => p_validate);
116: --
117: -- Register Surrogate ID or user key values
118: --
248: -- ----------------------------------------------------------------------------
249: -- |---------------------------< delete_hierarchy >---------------------------|
250: -- ----------------------------------------------------------------------------
251: PROCEDURE delete_hierarchy
252: (p_validate in number default hr_api.g_false_num
253: ,p_hierarchy_id in number
254: ,p_object_version_number in out nocopy number
255: ,p_return_status out nocopy varchar2
256: ) is
280: --
281: -- Convert constant values to their corresponding boolean value
282: --
283: l_validate :=
284: hr_api.constant_to_boolean
285: (p_constant_value => p_validate);
286: --
287: -- Register Surrogate ID or user key values
288: --
434: -- ----------------------------------------------------------------------------
435: -- |---------------------------< update_hierarchy >---------------------------|
436: -- ----------------------------------------------------------------------------
437: PROCEDURE update_hierarchy
438: (p_validate in number default hr_api.g_false_num
439: ,p_hierarchy_id in number
440: ,p_name in varchar2 default hr_api.g_varchar2
441: ,p_request_id in number default hr_api.g_number
442: ,p_program_application_id in number default hr_api.g_number
436: -- ----------------------------------------------------------------------------
437: PROCEDURE update_hierarchy
438: (p_validate in number default hr_api.g_false_num
439: ,p_hierarchy_id in number
440: ,p_name in varchar2 default hr_api.g_varchar2
441: ,p_request_id in number default hr_api.g_number
442: ,p_program_application_id in number default hr_api.g_number
443: ,p_program_id in number default hr_api.g_number
444: ,p_program_update_date in date default hr_api.g_date
437: PROCEDURE update_hierarchy
438: (p_validate in number default hr_api.g_false_num
439: ,p_hierarchy_id in number
440: ,p_name in varchar2 default hr_api.g_varchar2
441: ,p_request_id in number default hr_api.g_number
442: ,p_program_application_id in number default hr_api.g_number
443: ,p_program_id in number default hr_api.g_number
444: ,p_program_update_date in date default hr_api.g_date
445: ,p_object_version_number in out nocopy number
438: (p_validate in number default hr_api.g_false_num
439: ,p_hierarchy_id in number
440: ,p_name in varchar2 default hr_api.g_varchar2
441: ,p_request_id in number default hr_api.g_number
442: ,p_program_application_id in number default hr_api.g_number
443: ,p_program_id in number default hr_api.g_number
444: ,p_program_update_date in date default hr_api.g_date
445: ,p_object_version_number in out nocopy number
446: ,p_attribute_category in varchar2 default hr_api.g_varchar2
439: ,p_hierarchy_id in number
440: ,p_name in varchar2 default hr_api.g_varchar2
441: ,p_request_id in number default hr_api.g_number
442: ,p_program_application_id in number default hr_api.g_number
443: ,p_program_id in number default hr_api.g_number
444: ,p_program_update_date in date default hr_api.g_date
445: ,p_object_version_number in out nocopy number
446: ,p_attribute_category in varchar2 default hr_api.g_varchar2
447: ,p_attribute1 in varchar2 default hr_api.g_varchar2
440: ,p_name in varchar2 default hr_api.g_varchar2
441: ,p_request_id in number default hr_api.g_number
442: ,p_program_application_id in number default hr_api.g_number
443: ,p_program_id in number default hr_api.g_number
444: ,p_program_update_date in date default hr_api.g_date
445: ,p_object_version_number in out nocopy number
446: ,p_attribute_category in varchar2 default hr_api.g_varchar2
447: ,p_attribute1 in varchar2 default hr_api.g_varchar2
448: ,p_attribute2 in varchar2 default hr_api.g_varchar2
442: ,p_program_application_id in number default hr_api.g_number
443: ,p_program_id in number default hr_api.g_number
444: ,p_program_update_date in date default hr_api.g_date
445: ,p_object_version_number in out nocopy number
446: ,p_attribute_category in varchar2 default hr_api.g_varchar2
447: ,p_attribute1 in varchar2 default hr_api.g_varchar2
448: ,p_attribute2 in varchar2 default hr_api.g_varchar2
449: ,p_attribute3 in varchar2 default hr_api.g_varchar2
450: ,p_attribute4 in varchar2 default hr_api.g_varchar2
443: ,p_program_id in number default hr_api.g_number
444: ,p_program_update_date in date default hr_api.g_date
445: ,p_object_version_number in out nocopy number
446: ,p_attribute_category in varchar2 default hr_api.g_varchar2
447: ,p_attribute1 in varchar2 default hr_api.g_varchar2
448: ,p_attribute2 in varchar2 default hr_api.g_varchar2
449: ,p_attribute3 in varchar2 default hr_api.g_varchar2
450: ,p_attribute4 in varchar2 default hr_api.g_varchar2
451: ,p_attribute5 in varchar2 default hr_api.g_varchar2
444: ,p_program_update_date in date default hr_api.g_date
445: ,p_object_version_number in out nocopy number
446: ,p_attribute_category in varchar2 default hr_api.g_varchar2
447: ,p_attribute1 in varchar2 default hr_api.g_varchar2
448: ,p_attribute2 in varchar2 default hr_api.g_varchar2
449: ,p_attribute3 in varchar2 default hr_api.g_varchar2
450: ,p_attribute4 in varchar2 default hr_api.g_varchar2
451: ,p_attribute5 in varchar2 default hr_api.g_varchar2
452: ,p_attribute6 in varchar2 default hr_api.g_varchar2
445: ,p_object_version_number in out nocopy number
446: ,p_attribute_category in varchar2 default hr_api.g_varchar2
447: ,p_attribute1 in varchar2 default hr_api.g_varchar2
448: ,p_attribute2 in varchar2 default hr_api.g_varchar2
449: ,p_attribute3 in varchar2 default hr_api.g_varchar2
450: ,p_attribute4 in varchar2 default hr_api.g_varchar2
451: ,p_attribute5 in varchar2 default hr_api.g_varchar2
452: ,p_attribute6 in varchar2 default hr_api.g_varchar2
453: ,p_attribute7 in varchar2 default hr_api.g_varchar2
446: ,p_attribute_category in varchar2 default hr_api.g_varchar2
447: ,p_attribute1 in varchar2 default hr_api.g_varchar2
448: ,p_attribute2 in varchar2 default hr_api.g_varchar2
449: ,p_attribute3 in varchar2 default hr_api.g_varchar2
450: ,p_attribute4 in varchar2 default hr_api.g_varchar2
451: ,p_attribute5 in varchar2 default hr_api.g_varchar2
452: ,p_attribute6 in varchar2 default hr_api.g_varchar2
453: ,p_attribute7 in varchar2 default hr_api.g_varchar2
454: ,p_attribute8 in varchar2 default hr_api.g_varchar2
447: ,p_attribute1 in varchar2 default hr_api.g_varchar2
448: ,p_attribute2 in varchar2 default hr_api.g_varchar2
449: ,p_attribute3 in varchar2 default hr_api.g_varchar2
450: ,p_attribute4 in varchar2 default hr_api.g_varchar2
451: ,p_attribute5 in varchar2 default hr_api.g_varchar2
452: ,p_attribute6 in varchar2 default hr_api.g_varchar2
453: ,p_attribute7 in varchar2 default hr_api.g_varchar2
454: ,p_attribute8 in varchar2 default hr_api.g_varchar2
455: ,p_attribute9 in varchar2 default hr_api.g_varchar2
448: ,p_attribute2 in varchar2 default hr_api.g_varchar2
449: ,p_attribute3 in varchar2 default hr_api.g_varchar2
450: ,p_attribute4 in varchar2 default hr_api.g_varchar2
451: ,p_attribute5 in varchar2 default hr_api.g_varchar2
452: ,p_attribute6 in varchar2 default hr_api.g_varchar2
453: ,p_attribute7 in varchar2 default hr_api.g_varchar2
454: ,p_attribute8 in varchar2 default hr_api.g_varchar2
455: ,p_attribute9 in varchar2 default hr_api.g_varchar2
456: ,p_attribute10 in varchar2 default hr_api.g_varchar2
449: ,p_attribute3 in varchar2 default hr_api.g_varchar2
450: ,p_attribute4 in varchar2 default hr_api.g_varchar2
451: ,p_attribute5 in varchar2 default hr_api.g_varchar2
452: ,p_attribute6 in varchar2 default hr_api.g_varchar2
453: ,p_attribute7 in varchar2 default hr_api.g_varchar2
454: ,p_attribute8 in varchar2 default hr_api.g_varchar2
455: ,p_attribute9 in varchar2 default hr_api.g_varchar2
456: ,p_attribute10 in varchar2 default hr_api.g_varchar2
457: ,p_attribute11 in varchar2 default hr_api.g_varchar2
450: ,p_attribute4 in varchar2 default hr_api.g_varchar2
451: ,p_attribute5 in varchar2 default hr_api.g_varchar2
452: ,p_attribute6 in varchar2 default hr_api.g_varchar2
453: ,p_attribute7 in varchar2 default hr_api.g_varchar2
454: ,p_attribute8 in varchar2 default hr_api.g_varchar2
455: ,p_attribute9 in varchar2 default hr_api.g_varchar2
456: ,p_attribute10 in varchar2 default hr_api.g_varchar2
457: ,p_attribute11 in varchar2 default hr_api.g_varchar2
458: ,p_attribute12 in varchar2 default hr_api.g_varchar2
451: ,p_attribute5 in varchar2 default hr_api.g_varchar2
452: ,p_attribute6 in varchar2 default hr_api.g_varchar2
453: ,p_attribute7 in varchar2 default hr_api.g_varchar2
454: ,p_attribute8 in varchar2 default hr_api.g_varchar2
455: ,p_attribute9 in varchar2 default hr_api.g_varchar2
456: ,p_attribute10 in varchar2 default hr_api.g_varchar2
457: ,p_attribute11 in varchar2 default hr_api.g_varchar2
458: ,p_attribute12 in varchar2 default hr_api.g_varchar2
459: ,p_attribute13 in varchar2 default hr_api.g_varchar2
452: ,p_attribute6 in varchar2 default hr_api.g_varchar2
453: ,p_attribute7 in varchar2 default hr_api.g_varchar2
454: ,p_attribute8 in varchar2 default hr_api.g_varchar2
455: ,p_attribute9 in varchar2 default hr_api.g_varchar2
456: ,p_attribute10 in varchar2 default hr_api.g_varchar2
457: ,p_attribute11 in varchar2 default hr_api.g_varchar2
458: ,p_attribute12 in varchar2 default hr_api.g_varchar2
459: ,p_attribute13 in varchar2 default hr_api.g_varchar2
460: ,p_attribute14 in varchar2 default hr_api.g_varchar2
453: ,p_attribute7 in varchar2 default hr_api.g_varchar2
454: ,p_attribute8 in varchar2 default hr_api.g_varchar2
455: ,p_attribute9 in varchar2 default hr_api.g_varchar2
456: ,p_attribute10 in varchar2 default hr_api.g_varchar2
457: ,p_attribute11 in varchar2 default hr_api.g_varchar2
458: ,p_attribute12 in varchar2 default hr_api.g_varchar2
459: ,p_attribute13 in varchar2 default hr_api.g_varchar2
460: ,p_attribute14 in varchar2 default hr_api.g_varchar2
461: ,p_attribute15 in varchar2 default hr_api.g_varchar2
454: ,p_attribute8 in varchar2 default hr_api.g_varchar2
455: ,p_attribute9 in varchar2 default hr_api.g_varchar2
456: ,p_attribute10 in varchar2 default hr_api.g_varchar2
457: ,p_attribute11 in varchar2 default hr_api.g_varchar2
458: ,p_attribute12 in varchar2 default hr_api.g_varchar2
459: ,p_attribute13 in varchar2 default hr_api.g_varchar2
460: ,p_attribute14 in varchar2 default hr_api.g_varchar2
461: ,p_attribute15 in varchar2 default hr_api.g_varchar2
462: ,p_attribute16 in varchar2 default hr_api.g_varchar2
455: ,p_attribute9 in varchar2 default hr_api.g_varchar2
456: ,p_attribute10 in varchar2 default hr_api.g_varchar2
457: ,p_attribute11 in varchar2 default hr_api.g_varchar2
458: ,p_attribute12 in varchar2 default hr_api.g_varchar2
459: ,p_attribute13 in varchar2 default hr_api.g_varchar2
460: ,p_attribute14 in varchar2 default hr_api.g_varchar2
461: ,p_attribute15 in varchar2 default hr_api.g_varchar2
462: ,p_attribute16 in varchar2 default hr_api.g_varchar2
463: ,p_attribute17 in varchar2 default hr_api.g_varchar2
456: ,p_attribute10 in varchar2 default hr_api.g_varchar2
457: ,p_attribute11 in varchar2 default hr_api.g_varchar2
458: ,p_attribute12 in varchar2 default hr_api.g_varchar2
459: ,p_attribute13 in varchar2 default hr_api.g_varchar2
460: ,p_attribute14 in varchar2 default hr_api.g_varchar2
461: ,p_attribute15 in varchar2 default hr_api.g_varchar2
462: ,p_attribute16 in varchar2 default hr_api.g_varchar2
463: ,p_attribute17 in varchar2 default hr_api.g_varchar2
464: ,p_attribute18 in varchar2 default hr_api.g_varchar2
457: ,p_attribute11 in varchar2 default hr_api.g_varchar2
458: ,p_attribute12 in varchar2 default hr_api.g_varchar2
459: ,p_attribute13 in varchar2 default hr_api.g_varchar2
460: ,p_attribute14 in varchar2 default hr_api.g_varchar2
461: ,p_attribute15 in varchar2 default hr_api.g_varchar2
462: ,p_attribute16 in varchar2 default hr_api.g_varchar2
463: ,p_attribute17 in varchar2 default hr_api.g_varchar2
464: ,p_attribute18 in varchar2 default hr_api.g_varchar2
465: ,p_attribute19 in varchar2 default hr_api.g_varchar2
458: ,p_attribute12 in varchar2 default hr_api.g_varchar2
459: ,p_attribute13 in varchar2 default hr_api.g_varchar2
460: ,p_attribute14 in varchar2 default hr_api.g_varchar2
461: ,p_attribute15 in varchar2 default hr_api.g_varchar2
462: ,p_attribute16 in varchar2 default hr_api.g_varchar2
463: ,p_attribute17 in varchar2 default hr_api.g_varchar2
464: ,p_attribute18 in varchar2 default hr_api.g_varchar2
465: ,p_attribute19 in varchar2 default hr_api.g_varchar2
466: ,p_attribute20 in varchar2 default hr_api.g_varchar2
459: ,p_attribute13 in varchar2 default hr_api.g_varchar2
460: ,p_attribute14 in varchar2 default hr_api.g_varchar2
461: ,p_attribute15 in varchar2 default hr_api.g_varchar2
462: ,p_attribute16 in varchar2 default hr_api.g_varchar2
463: ,p_attribute17 in varchar2 default hr_api.g_varchar2
464: ,p_attribute18 in varchar2 default hr_api.g_varchar2
465: ,p_attribute19 in varchar2 default hr_api.g_varchar2
466: ,p_attribute20 in varchar2 default hr_api.g_varchar2
467: ,p_attribute21 in varchar2 default hr_api.g_varchar2
460: ,p_attribute14 in varchar2 default hr_api.g_varchar2
461: ,p_attribute15 in varchar2 default hr_api.g_varchar2
462: ,p_attribute16 in varchar2 default hr_api.g_varchar2
463: ,p_attribute17 in varchar2 default hr_api.g_varchar2
464: ,p_attribute18 in varchar2 default hr_api.g_varchar2
465: ,p_attribute19 in varchar2 default hr_api.g_varchar2
466: ,p_attribute20 in varchar2 default hr_api.g_varchar2
467: ,p_attribute21 in varchar2 default hr_api.g_varchar2
468: ,p_attribute22 in varchar2 default hr_api.g_varchar2
461: ,p_attribute15 in varchar2 default hr_api.g_varchar2
462: ,p_attribute16 in varchar2 default hr_api.g_varchar2
463: ,p_attribute17 in varchar2 default hr_api.g_varchar2
464: ,p_attribute18 in varchar2 default hr_api.g_varchar2
465: ,p_attribute19 in varchar2 default hr_api.g_varchar2
466: ,p_attribute20 in varchar2 default hr_api.g_varchar2
467: ,p_attribute21 in varchar2 default hr_api.g_varchar2
468: ,p_attribute22 in varchar2 default hr_api.g_varchar2
469: ,p_attribute23 in varchar2 default hr_api.g_varchar2
462: ,p_attribute16 in varchar2 default hr_api.g_varchar2
463: ,p_attribute17 in varchar2 default hr_api.g_varchar2
464: ,p_attribute18 in varchar2 default hr_api.g_varchar2
465: ,p_attribute19 in varchar2 default hr_api.g_varchar2
466: ,p_attribute20 in varchar2 default hr_api.g_varchar2
467: ,p_attribute21 in varchar2 default hr_api.g_varchar2
468: ,p_attribute22 in varchar2 default hr_api.g_varchar2
469: ,p_attribute23 in varchar2 default hr_api.g_varchar2
470: ,p_attribute24 in varchar2 default hr_api.g_varchar2
463: ,p_attribute17 in varchar2 default hr_api.g_varchar2
464: ,p_attribute18 in varchar2 default hr_api.g_varchar2
465: ,p_attribute19 in varchar2 default hr_api.g_varchar2
466: ,p_attribute20 in varchar2 default hr_api.g_varchar2
467: ,p_attribute21 in varchar2 default hr_api.g_varchar2
468: ,p_attribute22 in varchar2 default hr_api.g_varchar2
469: ,p_attribute23 in varchar2 default hr_api.g_varchar2
470: ,p_attribute24 in varchar2 default hr_api.g_varchar2
471: ,p_attribute25 in varchar2 default hr_api.g_varchar2
464: ,p_attribute18 in varchar2 default hr_api.g_varchar2
465: ,p_attribute19 in varchar2 default hr_api.g_varchar2
466: ,p_attribute20 in varchar2 default hr_api.g_varchar2
467: ,p_attribute21 in varchar2 default hr_api.g_varchar2
468: ,p_attribute22 in varchar2 default hr_api.g_varchar2
469: ,p_attribute23 in varchar2 default hr_api.g_varchar2
470: ,p_attribute24 in varchar2 default hr_api.g_varchar2
471: ,p_attribute25 in varchar2 default hr_api.g_varchar2
472: ,p_attribute26 in varchar2 default hr_api.g_varchar2
465: ,p_attribute19 in varchar2 default hr_api.g_varchar2
466: ,p_attribute20 in varchar2 default hr_api.g_varchar2
467: ,p_attribute21 in varchar2 default hr_api.g_varchar2
468: ,p_attribute22 in varchar2 default hr_api.g_varchar2
469: ,p_attribute23 in varchar2 default hr_api.g_varchar2
470: ,p_attribute24 in varchar2 default hr_api.g_varchar2
471: ,p_attribute25 in varchar2 default hr_api.g_varchar2
472: ,p_attribute26 in varchar2 default hr_api.g_varchar2
473: ,p_attribute27 in varchar2 default hr_api.g_varchar2
466: ,p_attribute20 in varchar2 default hr_api.g_varchar2
467: ,p_attribute21 in varchar2 default hr_api.g_varchar2
468: ,p_attribute22 in varchar2 default hr_api.g_varchar2
469: ,p_attribute23 in varchar2 default hr_api.g_varchar2
470: ,p_attribute24 in varchar2 default hr_api.g_varchar2
471: ,p_attribute25 in varchar2 default hr_api.g_varchar2
472: ,p_attribute26 in varchar2 default hr_api.g_varchar2
473: ,p_attribute27 in varchar2 default hr_api.g_varchar2
474: ,p_attribute28 in varchar2 default hr_api.g_varchar2
467: ,p_attribute21 in varchar2 default hr_api.g_varchar2
468: ,p_attribute22 in varchar2 default hr_api.g_varchar2
469: ,p_attribute23 in varchar2 default hr_api.g_varchar2
470: ,p_attribute24 in varchar2 default hr_api.g_varchar2
471: ,p_attribute25 in varchar2 default hr_api.g_varchar2
472: ,p_attribute26 in varchar2 default hr_api.g_varchar2
473: ,p_attribute27 in varchar2 default hr_api.g_varchar2
474: ,p_attribute28 in varchar2 default hr_api.g_varchar2
475: ,p_attribute29 in varchar2 default hr_api.g_varchar2
468: ,p_attribute22 in varchar2 default hr_api.g_varchar2
469: ,p_attribute23 in varchar2 default hr_api.g_varchar2
470: ,p_attribute24 in varchar2 default hr_api.g_varchar2
471: ,p_attribute25 in varchar2 default hr_api.g_varchar2
472: ,p_attribute26 in varchar2 default hr_api.g_varchar2
473: ,p_attribute27 in varchar2 default hr_api.g_varchar2
474: ,p_attribute28 in varchar2 default hr_api.g_varchar2
475: ,p_attribute29 in varchar2 default hr_api.g_varchar2
476: ,p_attribute30 in varchar2 default hr_api.g_varchar2
469: ,p_attribute23 in varchar2 default hr_api.g_varchar2
470: ,p_attribute24 in varchar2 default hr_api.g_varchar2
471: ,p_attribute25 in varchar2 default hr_api.g_varchar2
472: ,p_attribute26 in varchar2 default hr_api.g_varchar2
473: ,p_attribute27 in varchar2 default hr_api.g_varchar2
474: ,p_attribute28 in varchar2 default hr_api.g_varchar2
475: ,p_attribute29 in varchar2 default hr_api.g_varchar2
476: ,p_attribute30 in varchar2 default hr_api.g_varchar2
477: ,p_information_category in varchar2 default hr_api.g_varchar2
470: ,p_attribute24 in varchar2 default hr_api.g_varchar2
471: ,p_attribute25 in varchar2 default hr_api.g_varchar2
472: ,p_attribute26 in varchar2 default hr_api.g_varchar2
473: ,p_attribute27 in varchar2 default hr_api.g_varchar2
474: ,p_attribute28 in varchar2 default hr_api.g_varchar2
475: ,p_attribute29 in varchar2 default hr_api.g_varchar2
476: ,p_attribute30 in varchar2 default hr_api.g_varchar2
477: ,p_information_category in varchar2 default hr_api.g_varchar2
478: ,p_information1 in varchar2 default hr_api.g_varchar2
471: ,p_attribute25 in varchar2 default hr_api.g_varchar2
472: ,p_attribute26 in varchar2 default hr_api.g_varchar2
473: ,p_attribute27 in varchar2 default hr_api.g_varchar2
474: ,p_attribute28 in varchar2 default hr_api.g_varchar2
475: ,p_attribute29 in varchar2 default hr_api.g_varchar2
476: ,p_attribute30 in varchar2 default hr_api.g_varchar2
477: ,p_information_category in varchar2 default hr_api.g_varchar2
478: ,p_information1 in varchar2 default hr_api.g_varchar2
479: ,p_information2 in varchar2 default hr_api.g_varchar2
472: ,p_attribute26 in varchar2 default hr_api.g_varchar2
473: ,p_attribute27 in varchar2 default hr_api.g_varchar2
474: ,p_attribute28 in varchar2 default hr_api.g_varchar2
475: ,p_attribute29 in varchar2 default hr_api.g_varchar2
476: ,p_attribute30 in varchar2 default hr_api.g_varchar2
477: ,p_information_category in varchar2 default hr_api.g_varchar2
478: ,p_information1 in varchar2 default hr_api.g_varchar2
479: ,p_information2 in varchar2 default hr_api.g_varchar2
480: ,p_information3 in varchar2 default hr_api.g_varchar2
473: ,p_attribute27 in varchar2 default hr_api.g_varchar2
474: ,p_attribute28 in varchar2 default hr_api.g_varchar2
475: ,p_attribute29 in varchar2 default hr_api.g_varchar2
476: ,p_attribute30 in varchar2 default hr_api.g_varchar2
477: ,p_information_category in varchar2 default hr_api.g_varchar2
478: ,p_information1 in varchar2 default hr_api.g_varchar2
479: ,p_information2 in varchar2 default hr_api.g_varchar2
480: ,p_information3 in varchar2 default hr_api.g_varchar2
481: ,p_information4 in varchar2 default hr_api.g_varchar2
474: ,p_attribute28 in varchar2 default hr_api.g_varchar2
475: ,p_attribute29 in varchar2 default hr_api.g_varchar2
476: ,p_attribute30 in varchar2 default hr_api.g_varchar2
477: ,p_information_category in varchar2 default hr_api.g_varchar2
478: ,p_information1 in varchar2 default hr_api.g_varchar2
479: ,p_information2 in varchar2 default hr_api.g_varchar2
480: ,p_information3 in varchar2 default hr_api.g_varchar2
481: ,p_information4 in varchar2 default hr_api.g_varchar2
482: ,p_information5 in varchar2 default hr_api.g_varchar2
475: ,p_attribute29 in varchar2 default hr_api.g_varchar2
476: ,p_attribute30 in varchar2 default hr_api.g_varchar2
477: ,p_information_category in varchar2 default hr_api.g_varchar2
478: ,p_information1 in varchar2 default hr_api.g_varchar2
479: ,p_information2 in varchar2 default hr_api.g_varchar2
480: ,p_information3 in varchar2 default hr_api.g_varchar2
481: ,p_information4 in varchar2 default hr_api.g_varchar2
482: ,p_information5 in varchar2 default hr_api.g_varchar2
483: ,p_information6 in varchar2 default hr_api.g_varchar2
476: ,p_attribute30 in varchar2 default hr_api.g_varchar2
477: ,p_information_category in varchar2 default hr_api.g_varchar2
478: ,p_information1 in varchar2 default hr_api.g_varchar2
479: ,p_information2 in varchar2 default hr_api.g_varchar2
480: ,p_information3 in varchar2 default hr_api.g_varchar2
481: ,p_information4 in varchar2 default hr_api.g_varchar2
482: ,p_information5 in varchar2 default hr_api.g_varchar2
483: ,p_information6 in varchar2 default hr_api.g_varchar2
484: ,p_information7 in varchar2 default hr_api.g_varchar2
477: ,p_information_category in varchar2 default hr_api.g_varchar2
478: ,p_information1 in varchar2 default hr_api.g_varchar2
479: ,p_information2 in varchar2 default hr_api.g_varchar2
480: ,p_information3 in varchar2 default hr_api.g_varchar2
481: ,p_information4 in varchar2 default hr_api.g_varchar2
482: ,p_information5 in varchar2 default hr_api.g_varchar2
483: ,p_information6 in varchar2 default hr_api.g_varchar2
484: ,p_information7 in varchar2 default hr_api.g_varchar2
485: ,p_information8 in varchar2 default hr_api.g_varchar2
478: ,p_information1 in varchar2 default hr_api.g_varchar2
479: ,p_information2 in varchar2 default hr_api.g_varchar2
480: ,p_information3 in varchar2 default hr_api.g_varchar2
481: ,p_information4 in varchar2 default hr_api.g_varchar2
482: ,p_information5 in varchar2 default hr_api.g_varchar2
483: ,p_information6 in varchar2 default hr_api.g_varchar2
484: ,p_information7 in varchar2 default hr_api.g_varchar2
485: ,p_information8 in varchar2 default hr_api.g_varchar2
486: ,p_information9 in varchar2 default hr_api.g_varchar2
479: ,p_information2 in varchar2 default hr_api.g_varchar2
480: ,p_information3 in varchar2 default hr_api.g_varchar2
481: ,p_information4 in varchar2 default hr_api.g_varchar2
482: ,p_information5 in varchar2 default hr_api.g_varchar2
483: ,p_information6 in varchar2 default hr_api.g_varchar2
484: ,p_information7 in varchar2 default hr_api.g_varchar2
485: ,p_information8 in varchar2 default hr_api.g_varchar2
486: ,p_information9 in varchar2 default hr_api.g_varchar2
487: ,p_information10 in varchar2 default hr_api.g_varchar2
480: ,p_information3 in varchar2 default hr_api.g_varchar2
481: ,p_information4 in varchar2 default hr_api.g_varchar2
482: ,p_information5 in varchar2 default hr_api.g_varchar2
483: ,p_information6 in varchar2 default hr_api.g_varchar2
484: ,p_information7 in varchar2 default hr_api.g_varchar2
485: ,p_information8 in varchar2 default hr_api.g_varchar2
486: ,p_information9 in varchar2 default hr_api.g_varchar2
487: ,p_information10 in varchar2 default hr_api.g_varchar2
488: ,p_information11 in varchar2 default hr_api.g_varchar2
481: ,p_information4 in varchar2 default hr_api.g_varchar2
482: ,p_information5 in varchar2 default hr_api.g_varchar2
483: ,p_information6 in varchar2 default hr_api.g_varchar2
484: ,p_information7 in varchar2 default hr_api.g_varchar2
485: ,p_information8 in varchar2 default hr_api.g_varchar2
486: ,p_information9 in varchar2 default hr_api.g_varchar2
487: ,p_information10 in varchar2 default hr_api.g_varchar2
488: ,p_information11 in varchar2 default hr_api.g_varchar2
489: ,p_information12 in varchar2 default hr_api.g_varchar2
482: ,p_information5 in varchar2 default hr_api.g_varchar2
483: ,p_information6 in varchar2 default hr_api.g_varchar2
484: ,p_information7 in varchar2 default hr_api.g_varchar2
485: ,p_information8 in varchar2 default hr_api.g_varchar2
486: ,p_information9 in varchar2 default hr_api.g_varchar2
487: ,p_information10 in varchar2 default hr_api.g_varchar2
488: ,p_information11 in varchar2 default hr_api.g_varchar2
489: ,p_information12 in varchar2 default hr_api.g_varchar2
490: ,p_information13 in varchar2 default hr_api.g_varchar2
483: ,p_information6 in varchar2 default hr_api.g_varchar2
484: ,p_information7 in varchar2 default hr_api.g_varchar2
485: ,p_information8 in varchar2 default hr_api.g_varchar2
486: ,p_information9 in varchar2 default hr_api.g_varchar2
487: ,p_information10 in varchar2 default hr_api.g_varchar2
488: ,p_information11 in varchar2 default hr_api.g_varchar2
489: ,p_information12 in varchar2 default hr_api.g_varchar2
490: ,p_information13 in varchar2 default hr_api.g_varchar2
491: ,p_information14 in varchar2 default hr_api.g_varchar2
484: ,p_information7 in varchar2 default hr_api.g_varchar2
485: ,p_information8 in varchar2 default hr_api.g_varchar2
486: ,p_information9 in varchar2 default hr_api.g_varchar2
487: ,p_information10 in varchar2 default hr_api.g_varchar2
488: ,p_information11 in varchar2 default hr_api.g_varchar2
489: ,p_information12 in varchar2 default hr_api.g_varchar2
490: ,p_information13 in varchar2 default hr_api.g_varchar2
491: ,p_information14 in varchar2 default hr_api.g_varchar2
492: ,p_information15 in varchar2 default hr_api.g_varchar2
485: ,p_information8 in varchar2 default hr_api.g_varchar2
486: ,p_information9 in varchar2 default hr_api.g_varchar2
487: ,p_information10 in varchar2 default hr_api.g_varchar2
488: ,p_information11 in varchar2 default hr_api.g_varchar2
489: ,p_information12 in varchar2 default hr_api.g_varchar2
490: ,p_information13 in varchar2 default hr_api.g_varchar2
491: ,p_information14 in varchar2 default hr_api.g_varchar2
492: ,p_information15 in varchar2 default hr_api.g_varchar2
493: ,p_information16 in varchar2 default hr_api.g_varchar2
486: ,p_information9 in varchar2 default hr_api.g_varchar2
487: ,p_information10 in varchar2 default hr_api.g_varchar2
488: ,p_information11 in varchar2 default hr_api.g_varchar2
489: ,p_information12 in varchar2 default hr_api.g_varchar2
490: ,p_information13 in varchar2 default hr_api.g_varchar2
491: ,p_information14 in varchar2 default hr_api.g_varchar2
492: ,p_information15 in varchar2 default hr_api.g_varchar2
493: ,p_information16 in varchar2 default hr_api.g_varchar2
494: ,p_information17 in varchar2 default hr_api.g_varchar2
487: ,p_information10 in varchar2 default hr_api.g_varchar2
488: ,p_information11 in varchar2 default hr_api.g_varchar2
489: ,p_information12 in varchar2 default hr_api.g_varchar2
490: ,p_information13 in varchar2 default hr_api.g_varchar2
491: ,p_information14 in varchar2 default hr_api.g_varchar2
492: ,p_information15 in varchar2 default hr_api.g_varchar2
493: ,p_information16 in varchar2 default hr_api.g_varchar2
494: ,p_information17 in varchar2 default hr_api.g_varchar2
495: ,p_information18 in varchar2 default hr_api.g_varchar2
488: ,p_information11 in varchar2 default hr_api.g_varchar2
489: ,p_information12 in varchar2 default hr_api.g_varchar2
490: ,p_information13 in varchar2 default hr_api.g_varchar2
491: ,p_information14 in varchar2 default hr_api.g_varchar2
492: ,p_information15 in varchar2 default hr_api.g_varchar2
493: ,p_information16 in varchar2 default hr_api.g_varchar2
494: ,p_information17 in varchar2 default hr_api.g_varchar2
495: ,p_information18 in varchar2 default hr_api.g_varchar2
496: ,p_information19 in varchar2 default hr_api.g_varchar2
489: ,p_information12 in varchar2 default hr_api.g_varchar2
490: ,p_information13 in varchar2 default hr_api.g_varchar2
491: ,p_information14 in varchar2 default hr_api.g_varchar2
492: ,p_information15 in varchar2 default hr_api.g_varchar2
493: ,p_information16 in varchar2 default hr_api.g_varchar2
494: ,p_information17 in varchar2 default hr_api.g_varchar2
495: ,p_information18 in varchar2 default hr_api.g_varchar2
496: ,p_information19 in varchar2 default hr_api.g_varchar2
497: ,p_information20 in varchar2 default hr_api.g_varchar2
490: ,p_information13 in varchar2 default hr_api.g_varchar2
491: ,p_information14 in varchar2 default hr_api.g_varchar2
492: ,p_information15 in varchar2 default hr_api.g_varchar2
493: ,p_information16 in varchar2 default hr_api.g_varchar2
494: ,p_information17 in varchar2 default hr_api.g_varchar2
495: ,p_information18 in varchar2 default hr_api.g_varchar2
496: ,p_information19 in varchar2 default hr_api.g_varchar2
497: ,p_information20 in varchar2 default hr_api.g_varchar2
498: ,p_information21 in varchar2 default hr_api.g_varchar2
491: ,p_information14 in varchar2 default hr_api.g_varchar2
492: ,p_information15 in varchar2 default hr_api.g_varchar2
493: ,p_information16 in varchar2 default hr_api.g_varchar2
494: ,p_information17 in varchar2 default hr_api.g_varchar2
495: ,p_information18 in varchar2 default hr_api.g_varchar2
496: ,p_information19 in varchar2 default hr_api.g_varchar2
497: ,p_information20 in varchar2 default hr_api.g_varchar2
498: ,p_information21 in varchar2 default hr_api.g_varchar2
499: ,p_information22 in varchar2 default hr_api.g_varchar2
492: ,p_information15 in varchar2 default hr_api.g_varchar2
493: ,p_information16 in varchar2 default hr_api.g_varchar2
494: ,p_information17 in varchar2 default hr_api.g_varchar2
495: ,p_information18 in varchar2 default hr_api.g_varchar2
496: ,p_information19 in varchar2 default hr_api.g_varchar2
497: ,p_information20 in varchar2 default hr_api.g_varchar2
498: ,p_information21 in varchar2 default hr_api.g_varchar2
499: ,p_information22 in varchar2 default hr_api.g_varchar2
500: ,p_information23 in varchar2 default hr_api.g_varchar2
493: ,p_information16 in varchar2 default hr_api.g_varchar2
494: ,p_information17 in varchar2 default hr_api.g_varchar2
495: ,p_information18 in varchar2 default hr_api.g_varchar2
496: ,p_information19 in varchar2 default hr_api.g_varchar2
497: ,p_information20 in varchar2 default hr_api.g_varchar2
498: ,p_information21 in varchar2 default hr_api.g_varchar2
499: ,p_information22 in varchar2 default hr_api.g_varchar2
500: ,p_information23 in varchar2 default hr_api.g_varchar2
501: ,p_information24 in varchar2 default hr_api.g_varchar2
494: ,p_information17 in varchar2 default hr_api.g_varchar2
495: ,p_information18 in varchar2 default hr_api.g_varchar2
496: ,p_information19 in varchar2 default hr_api.g_varchar2
497: ,p_information20 in varchar2 default hr_api.g_varchar2
498: ,p_information21 in varchar2 default hr_api.g_varchar2
499: ,p_information22 in varchar2 default hr_api.g_varchar2
500: ,p_information23 in varchar2 default hr_api.g_varchar2
501: ,p_information24 in varchar2 default hr_api.g_varchar2
502: ,p_information25 in varchar2 default hr_api.g_varchar2
495: ,p_information18 in varchar2 default hr_api.g_varchar2
496: ,p_information19 in varchar2 default hr_api.g_varchar2
497: ,p_information20 in varchar2 default hr_api.g_varchar2
498: ,p_information21 in varchar2 default hr_api.g_varchar2
499: ,p_information22 in varchar2 default hr_api.g_varchar2
500: ,p_information23 in varchar2 default hr_api.g_varchar2
501: ,p_information24 in varchar2 default hr_api.g_varchar2
502: ,p_information25 in varchar2 default hr_api.g_varchar2
503: ,p_information26 in varchar2 default hr_api.g_varchar2
496: ,p_information19 in varchar2 default hr_api.g_varchar2
497: ,p_information20 in varchar2 default hr_api.g_varchar2
498: ,p_information21 in varchar2 default hr_api.g_varchar2
499: ,p_information22 in varchar2 default hr_api.g_varchar2
500: ,p_information23 in varchar2 default hr_api.g_varchar2
501: ,p_information24 in varchar2 default hr_api.g_varchar2
502: ,p_information25 in varchar2 default hr_api.g_varchar2
503: ,p_information26 in varchar2 default hr_api.g_varchar2
504: ,p_information27 in varchar2 default hr_api.g_varchar2
497: ,p_information20 in varchar2 default hr_api.g_varchar2
498: ,p_information21 in varchar2 default hr_api.g_varchar2
499: ,p_information22 in varchar2 default hr_api.g_varchar2
500: ,p_information23 in varchar2 default hr_api.g_varchar2
501: ,p_information24 in varchar2 default hr_api.g_varchar2
502: ,p_information25 in varchar2 default hr_api.g_varchar2
503: ,p_information26 in varchar2 default hr_api.g_varchar2
504: ,p_information27 in varchar2 default hr_api.g_varchar2
505: ,p_information28 in varchar2 default hr_api.g_varchar2
498: ,p_information21 in varchar2 default hr_api.g_varchar2
499: ,p_information22 in varchar2 default hr_api.g_varchar2
500: ,p_information23 in varchar2 default hr_api.g_varchar2
501: ,p_information24 in varchar2 default hr_api.g_varchar2
502: ,p_information25 in varchar2 default hr_api.g_varchar2
503: ,p_information26 in varchar2 default hr_api.g_varchar2
504: ,p_information27 in varchar2 default hr_api.g_varchar2
505: ,p_information28 in varchar2 default hr_api.g_varchar2
506: ,p_information29 in varchar2 default hr_api.g_varchar2
499: ,p_information22 in varchar2 default hr_api.g_varchar2
500: ,p_information23 in varchar2 default hr_api.g_varchar2
501: ,p_information24 in varchar2 default hr_api.g_varchar2
502: ,p_information25 in varchar2 default hr_api.g_varchar2
503: ,p_information26 in varchar2 default hr_api.g_varchar2
504: ,p_information27 in varchar2 default hr_api.g_varchar2
505: ,p_information28 in varchar2 default hr_api.g_varchar2
506: ,p_information29 in varchar2 default hr_api.g_varchar2
507: ,p_information30 in varchar2 default hr_api.g_varchar2
500: ,p_information23 in varchar2 default hr_api.g_varchar2
501: ,p_information24 in varchar2 default hr_api.g_varchar2
502: ,p_information25 in varchar2 default hr_api.g_varchar2
503: ,p_information26 in varchar2 default hr_api.g_varchar2
504: ,p_information27 in varchar2 default hr_api.g_varchar2
505: ,p_information28 in varchar2 default hr_api.g_varchar2
506: ,p_information29 in varchar2 default hr_api.g_varchar2
507: ,p_information30 in varchar2 default hr_api.g_varchar2
508: ,p_effective_date in date
501: ,p_information24 in varchar2 default hr_api.g_varchar2
502: ,p_information25 in varchar2 default hr_api.g_varchar2
503: ,p_information26 in varchar2 default hr_api.g_varchar2
504: ,p_information27 in varchar2 default hr_api.g_varchar2
505: ,p_information28 in varchar2 default hr_api.g_varchar2
506: ,p_information29 in varchar2 default hr_api.g_varchar2
507: ,p_information30 in varchar2 default hr_api.g_varchar2
508: ,p_effective_date in date
509: ,p_return_status out nocopy varchar2
502: ,p_information25 in varchar2 default hr_api.g_varchar2
503: ,p_information26 in varchar2 default hr_api.g_varchar2
504: ,p_information27 in varchar2 default hr_api.g_varchar2
505: ,p_information28 in varchar2 default hr_api.g_varchar2
506: ,p_information29 in varchar2 default hr_api.g_varchar2
507: ,p_information30 in varchar2 default hr_api.g_varchar2
508: ,p_effective_date in date
509: ,p_return_status out nocopy varchar2
510: ) is
503: ,p_information26 in varchar2 default hr_api.g_varchar2
504: ,p_information27 in varchar2 default hr_api.g_varchar2
505: ,p_information28 in varchar2 default hr_api.g_varchar2
506: ,p_information29 in varchar2 default hr_api.g_varchar2
507: ,p_information30 in varchar2 default hr_api.g_varchar2
508: ,p_effective_date in date
509: ,p_return_status out nocopy varchar2
510: ) is
511: --
534: --
535: -- Convert constant values to their corresponding boolean value
536: --
537: l_validate :=
538: hr_api.constant_to_boolean
539: (p_constant_value => p_validate);
540: --
541: -- Register Surrogate ID or user key values
542: --