8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_hierarchy_nodes >------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_hierarchy_nodes
12: (p_validate in number default hr_api.g_false_num
13: ,p_hierarchy_node_id out nocopy number
14: ,p_business_group_id in number default null
15: ,p_entity_id in varchar2 default null
16: ,p_hierarchy_version_id in number default null
111: --
112: -- Convert constant values to their corresponding boolean value
113: --
114: l_validate :=
115: hr_api.constant_to_boolean
116: (p_constant_value => p_validate);
117: --
118: -- Register Surrogate ID or user key values
119: --
252: -- ----------------------------------------------------------------------------
253: -- |------------------------< delete_hierarchy_nodes >------------------------|
254: -- ----------------------------------------------------------------------------
255: PROCEDURE delete_hierarchy_nodes
256: (p_validate in number default hr_api.g_false_num
257: ,p_hierarchy_node_id in number
258: ,p_object_version_number in out nocopy number
259: ,p_return_status out nocopy varchar2
260: ) is
284: --
285: -- Convert constant values to their corresponding boolean value
286: --
287: l_validate :=
288: hr_api.constant_to_boolean
289: (p_constant_value => p_validate);
290: --
291: -- Register Surrogate ID or user key values
292: --
438: -- ----------------------------------------------------------------------------
439: -- |------------------------< update_hierarchy_nodes >------------------------|
440: -- ----------------------------------------------------------------------------
441: PROCEDURE update_hierarchy_nodes
442: (p_validate in number default hr_api.g_false_num
443: ,p_hierarchy_node_id in number
444: ,p_entity_id in varchar2 default hr_api.g_varchar2
445: ,p_node_type in varchar2 default hr_api.g_varchar2
446: ,p_seq in number default hr_api.g_number
440: -- ----------------------------------------------------------------------------
441: PROCEDURE update_hierarchy_nodes
442: (p_validate in number default hr_api.g_false_num
443: ,p_hierarchy_node_id in number
444: ,p_entity_id in varchar2 default hr_api.g_varchar2
445: ,p_node_type in varchar2 default hr_api.g_varchar2
446: ,p_seq in number default hr_api.g_number
447: ,p_parent_hierarchy_node_id in number default hr_api.g_number
448: ,p_request_id in number default hr_api.g_number
441: PROCEDURE update_hierarchy_nodes
442: (p_validate in number default hr_api.g_false_num
443: ,p_hierarchy_node_id in number
444: ,p_entity_id in varchar2 default hr_api.g_varchar2
445: ,p_node_type in varchar2 default hr_api.g_varchar2
446: ,p_seq in number default hr_api.g_number
447: ,p_parent_hierarchy_node_id in number default hr_api.g_number
448: ,p_request_id in number default hr_api.g_number
449: ,p_program_application_id in number default hr_api.g_number
442: (p_validate in number default hr_api.g_false_num
443: ,p_hierarchy_node_id in number
444: ,p_entity_id in varchar2 default hr_api.g_varchar2
445: ,p_node_type in varchar2 default hr_api.g_varchar2
446: ,p_seq in number default hr_api.g_number
447: ,p_parent_hierarchy_node_id in number default hr_api.g_number
448: ,p_request_id in number default hr_api.g_number
449: ,p_program_application_id in number default hr_api.g_number
450: ,p_program_id in number default hr_api.g_number
443: ,p_hierarchy_node_id in number
444: ,p_entity_id in varchar2 default hr_api.g_varchar2
445: ,p_node_type in varchar2 default hr_api.g_varchar2
446: ,p_seq in number default hr_api.g_number
447: ,p_parent_hierarchy_node_id in number default hr_api.g_number
448: ,p_request_id in number default hr_api.g_number
449: ,p_program_application_id in number default hr_api.g_number
450: ,p_program_id in number default hr_api.g_number
451: ,p_program_update_date in date default hr_api.g_date
444: ,p_entity_id in varchar2 default hr_api.g_varchar2
445: ,p_node_type in varchar2 default hr_api.g_varchar2
446: ,p_seq in number default hr_api.g_number
447: ,p_parent_hierarchy_node_id in number default hr_api.g_number
448: ,p_request_id in number default hr_api.g_number
449: ,p_program_application_id in number default hr_api.g_number
450: ,p_program_id in number default hr_api.g_number
451: ,p_program_update_date in date default hr_api.g_date
452: ,p_object_version_number in out nocopy number
445: ,p_node_type in varchar2 default hr_api.g_varchar2
446: ,p_seq in number default hr_api.g_number
447: ,p_parent_hierarchy_node_id in number default hr_api.g_number
448: ,p_request_id in number default hr_api.g_number
449: ,p_program_application_id in number default hr_api.g_number
450: ,p_program_id in number default hr_api.g_number
451: ,p_program_update_date in date default hr_api.g_date
452: ,p_object_version_number in out nocopy number
453: ,p_attribute_category in varchar2 default hr_api.g_varchar2
446: ,p_seq in number default hr_api.g_number
447: ,p_parent_hierarchy_node_id in number default hr_api.g_number
448: ,p_request_id in number default hr_api.g_number
449: ,p_program_application_id in number default hr_api.g_number
450: ,p_program_id in number default hr_api.g_number
451: ,p_program_update_date in date default hr_api.g_date
452: ,p_object_version_number in out nocopy number
453: ,p_attribute_category in varchar2 default hr_api.g_varchar2
454: ,p_attribute1 in varchar2 default hr_api.g_varchar2
447: ,p_parent_hierarchy_node_id in number default hr_api.g_number
448: ,p_request_id in number default hr_api.g_number
449: ,p_program_application_id in number default hr_api.g_number
450: ,p_program_id in number default hr_api.g_number
451: ,p_program_update_date in date default hr_api.g_date
452: ,p_object_version_number in out nocopy number
453: ,p_attribute_category in varchar2 default hr_api.g_varchar2
454: ,p_attribute1 in varchar2 default hr_api.g_varchar2
455: ,p_attribute2 in varchar2 default hr_api.g_varchar2
449: ,p_program_application_id in number default hr_api.g_number
450: ,p_program_id in number default hr_api.g_number
451: ,p_program_update_date in date default hr_api.g_date
452: ,p_object_version_number in out nocopy number
453: ,p_attribute_category in varchar2 default hr_api.g_varchar2
454: ,p_attribute1 in varchar2 default hr_api.g_varchar2
455: ,p_attribute2 in varchar2 default hr_api.g_varchar2
456: ,p_attribute3 in varchar2 default hr_api.g_varchar2
457: ,p_attribute4 in varchar2 default hr_api.g_varchar2
450: ,p_program_id in number default hr_api.g_number
451: ,p_program_update_date in date default hr_api.g_date
452: ,p_object_version_number in out nocopy number
453: ,p_attribute_category in varchar2 default hr_api.g_varchar2
454: ,p_attribute1 in varchar2 default hr_api.g_varchar2
455: ,p_attribute2 in varchar2 default hr_api.g_varchar2
456: ,p_attribute3 in varchar2 default hr_api.g_varchar2
457: ,p_attribute4 in varchar2 default hr_api.g_varchar2
458: ,p_attribute5 in varchar2 default hr_api.g_varchar2
451: ,p_program_update_date in date default hr_api.g_date
452: ,p_object_version_number in out nocopy number
453: ,p_attribute_category in varchar2 default hr_api.g_varchar2
454: ,p_attribute1 in varchar2 default hr_api.g_varchar2
455: ,p_attribute2 in varchar2 default hr_api.g_varchar2
456: ,p_attribute3 in varchar2 default hr_api.g_varchar2
457: ,p_attribute4 in varchar2 default hr_api.g_varchar2
458: ,p_attribute5 in varchar2 default hr_api.g_varchar2
459: ,p_attribute6 in varchar2 default hr_api.g_varchar2
452: ,p_object_version_number in out nocopy number
453: ,p_attribute_category in varchar2 default hr_api.g_varchar2
454: ,p_attribute1 in varchar2 default hr_api.g_varchar2
455: ,p_attribute2 in varchar2 default hr_api.g_varchar2
456: ,p_attribute3 in varchar2 default hr_api.g_varchar2
457: ,p_attribute4 in varchar2 default hr_api.g_varchar2
458: ,p_attribute5 in varchar2 default hr_api.g_varchar2
459: ,p_attribute6 in varchar2 default hr_api.g_varchar2
460: ,p_attribute7 in varchar2 default hr_api.g_varchar2
453: ,p_attribute_category in varchar2 default hr_api.g_varchar2
454: ,p_attribute1 in varchar2 default hr_api.g_varchar2
455: ,p_attribute2 in varchar2 default hr_api.g_varchar2
456: ,p_attribute3 in varchar2 default hr_api.g_varchar2
457: ,p_attribute4 in varchar2 default hr_api.g_varchar2
458: ,p_attribute5 in varchar2 default hr_api.g_varchar2
459: ,p_attribute6 in varchar2 default hr_api.g_varchar2
460: ,p_attribute7 in varchar2 default hr_api.g_varchar2
461: ,p_attribute8 in varchar2 default hr_api.g_varchar2
454: ,p_attribute1 in varchar2 default hr_api.g_varchar2
455: ,p_attribute2 in varchar2 default hr_api.g_varchar2
456: ,p_attribute3 in varchar2 default hr_api.g_varchar2
457: ,p_attribute4 in varchar2 default hr_api.g_varchar2
458: ,p_attribute5 in varchar2 default hr_api.g_varchar2
459: ,p_attribute6 in varchar2 default hr_api.g_varchar2
460: ,p_attribute7 in varchar2 default hr_api.g_varchar2
461: ,p_attribute8 in varchar2 default hr_api.g_varchar2
462: ,p_attribute9 in varchar2 default hr_api.g_varchar2
455: ,p_attribute2 in varchar2 default hr_api.g_varchar2
456: ,p_attribute3 in varchar2 default hr_api.g_varchar2
457: ,p_attribute4 in varchar2 default hr_api.g_varchar2
458: ,p_attribute5 in varchar2 default hr_api.g_varchar2
459: ,p_attribute6 in varchar2 default hr_api.g_varchar2
460: ,p_attribute7 in varchar2 default hr_api.g_varchar2
461: ,p_attribute8 in varchar2 default hr_api.g_varchar2
462: ,p_attribute9 in varchar2 default hr_api.g_varchar2
463: ,p_attribute10 in varchar2 default hr_api.g_varchar2
456: ,p_attribute3 in varchar2 default hr_api.g_varchar2
457: ,p_attribute4 in varchar2 default hr_api.g_varchar2
458: ,p_attribute5 in varchar2 default hr_api.g_varchar2
459: ,p_attribute6 in varchar2 default hr_api.g_varchar2
460: ,p_attribute7 in varchar2 default hr_api.g_varchar2
461: ,p_attribute8 in varchar2 default hr_api.g_varchar2
462: ,p_attribute9 in varchar2 default hr_api.g_varchar2
463: ,p_attribute10 in varchar2 default hr_api.g_varchar2
464: ,p_attribute11 in varchar2 default hr_api.g_varchar2
457: ,p_attribute4 in varchar2 default hr_api.g_varchar2
458: ,p_attribute5 in varchar2 default hr_api.g_varchar2
459: ,p_attribute6 in varchar2 default hr_api.g_varchar2
460: ,p_attribute7 in varchar2 default hr_api.g_varchar2
461: ,p_attribute8 in varchar2 default hr_api.g_varchar2
462: ,p_attribute9 in varchar2 default hr_api.g_varchar2
463: ,p_attribute10 in varchar2 default hr_api.g_varchar2
464: ,p_attribute11 in varchar2 default hr_api.g_varchar2
465: ,p_attribute12 in varchar2 default hr_api.g_varchar2
458: ,p_attribute5 in varchar2 default hr_api.g_varchar2
459: ,p_attribute6 in varchar2 default hr_api.g_varchar2
460: ,p_attribute7 in varchar2 default hr_api.g_varchar2
461: ,p_attribute8 in varchar2 default hr_api.g_varchar2
462: ,p_attribute9 in varchar2 default hr_api.g_varchar2
463: ,p_attribute10 in varchar2 default hr_api.g_varchar2
464: ,p_attribute11 in varchar2 default hr_api.g_varchar2
465: ,p_attribute12 in varchar2 default hr_api.g_varchar2
466: ,p_attribute13 in varchar2 default hr_api.g_varchar2
459: ,p_attribute6 in varchar2 default hr_api.g_varchar2
460: ,p_attribute7 in varchar2 default hr_api.g_varchar2
461: ,p_attribute8 in varchar2 default hr_api.g_varchar2
462: ,p_attribute9 in varchar2 default hr_api.g_varchar2
463: ,p_attribute10 in varchar2 default hr_api.g_varchar2
464: ,p_attribute11 in varchar2 default hr_api.g_varchar2
465: ,p_attribute12 in varchar2 default hr_api.g_varchar2
466: ,p_attribute13 in varchar2 default hr_api.g_varchar2
467: ,p_attribute14 in varchar2 default hr_api.g_varchar2
460: ,p_attribute7 in varchar2 default hr_api.g_varchar2
461: ,p_attribute8 in varchar2 default hr_api.g_varchar2
462: ,p_attribute9 in varchar2 default hr_api.g_varchar2
463: ,p_attribute10 in varchar2 default hr_api.g_varchar2
464: ,p_attribute11 in varchar2 default hr_api.g_varchar2
465: ,p_attribute12 in varchar2 default hr_api.g_varchar2
466: ,p_attribute13 in varchar2 default hr_api.g_varchar2
467: ,p_attribute14 in varchar2 default hr_api.g_varchar2
468: ,p_attribute15 in varchar2 default hr_api.g_varchar2
461: ,p_attribute8 in varchar2 default hr_api.g_varchar2
462: ,p_attribute9 in varchar2 default hr_api.g_varchar2
463: ,p_attribute10 in varchar2 default hr_api.g_varchar2
464: ,p_attribute11 in varchar2 default hr_api.g_varchar2
465: ,p_attribute12 in varchar2 default hr_api.g_varchar2
466: ,p_attribute13 in varchar2 default hr_api.g_varchar2
467: ,p_attribute14 in varchar2 default hr_api.g_varchar2
468: ,p_attribute15 in varchar2 default hr_api.g_varchar2
469: ,p_attribute16 in varchar2 default hr_api.g_varchar2
462: ,p_attribute9 in varchar2 default hr_api.g_varchar2
463: ,p_attribute10 in varchar2 default hr_api.g_varchar2
464: ,p_attribute11 in varchar2 default hr_api.g_varchar2
465: ,p_attribute12 in varchar2 default hr_api.g_varchar2
466: ,p_attribute13 in varchar2 default hr_api.g_varchar2
467: ,p_attribute14 in varchar2 default hr_api.g_varchar2
468: ,p_attribute15 in varchar2 default hr_api.g_varchar2
469: ,p_attribute16 in varchar2 default hr_api.g_varchar2
470: ,p_attribute17 in varchar2 default hr_api.g_varchar2
463: ,p_attribute10 in varchar2 default hr_api.g_varchar2
464: ,p_attribute11 in varchar2 default hr_api.g_varchar2
465: ,p_attribute12 in varchar2 default hr_api.g_varchar2
466: ,p_attribute13 in varchar2 default hr_api.g_varchar2
467: ,p_attribute14 in varchar2 default hr_api.g_varchar2
468: ,p_attribute15 in varchar2 default hr_api.g_varchar2
469: ,p_attribute16 in varchar2 default hr_api.g_varchar2
470: ,p_attribute17 in varchar2 default hr_api.g_varchar2
471: ,p_attribute18 in varchar2 default hr_api.g_varchar2
464: ,p_attribute11 in varchar2 default hr_api.g_varchar2
465: ,p_attribute12 in varchar2 default hr_api.g_varchar2
466: ,p_attribute13 in varchar2 default hr_api.g_varchar2
467: ,p_attribute14 in varchar2 default hr_api.g_varchar2
468: ,p_attribute15 in varchar2 default hr_api.g_varchar2
469: ,p_attribute16 in varchar2 default hr_api.g_varchar2
470: ,p_attribute17 in varchar2 default hr_api.g_varchar2
471: ,p_attribute18 in varchar2 default hr_api.g_varchar2
472: ,p_attribute19 in varchar2 default hr_api.g_varchar2
465: ,p_attribute12 in varchar2 default hr_api.g_varchar2
466: ,p_attribute13 in varchar2 default hr_api.g_varchar2
467: ,p_attribute14 in varchar2 default hr_api.g_varchar2
468: ,p_attribute15 in varchar2 default hr_api.g_varchar2
469: ,p_attribute16 in varchar2 default hr_api.g_varchar2
470: ,p_attribute17 in varchar2 default hr_api.g_varchar2
471: ,p_attribute18 in varchar2 default hr_api.g_varchar2
472: ,p_attribute19 in varchar2 default hr_api.g_varchar2
473: ,p_attribute20 in varchar2 default hr_api.g_varchar2
466: ,p_attribute13 in varchar2 default hr_api.g_varchar2
467: ,p_attribute14 in varchar2 default hr_api.g_varchar2
468: ,p_attribute15 in varchar2 default hr_api.g_varchar2
469: ,p_attribute16 in varchar2 default hr_api.g_varchar2
470: ,p_attribute17 in varchar2 default hr_api.g_varchar2
471: ,p_attribute18 in varchar2 default hr_api.g_varchar2
472: ,p_attribute19 in varchar2 default hr_api.g_varchar2
473: ,p_attribute20 in varchar2 default hr_api.g_varchar2
474: ,p_attribute21 in varchar2 default hr_api.g_varchar2
467: ,p_attribute14 in varchar2 default hr_api.g_varchar2
468: ,p_attribute15 in varchar2 default hr_api.g_varchar2
469: ,p_attribute16 in varchar2 default hr_api.g_varchar2
470: ,p_attribute17 in varchar2 default hr_api.g_varchar2
471: ,p_attribute18 in varchar2 default hr_api.g_varchar2
472: ,p_attribute19 in varchar2 default hr_api.g_varchar2
473: ,p_attribute20 in varchar2 default hr_api.g_varchar2
474: ,p_attribute21 in varchar2 default hr_api.g_varchar2
475: ,p_attribute22 in varchar2 default hr_api.g_varchar2
468: ,p_attribute15 in varchar2 default hr_api.g_varchar2
469: ,p_attribute16 in varchar2 default hr_api.g_varchar2
470: ,p_attribute17 in varchar2 default hr_api.g_varchar2
471: ,p_attribute18 in varchar2 default hr_api.g_varchar2
472: ,p_attribute19 in varchar2 default hr_api.g_varchar2
473: ,p_attribute20 in varchar2 default hr_api.g_varchar2
474: ,p_attribute21 in varchar2 default hr_api.g_varchar2
475: ,p_attribute22 in varchar2 default hr_api.g_varchar2
476: ,p_attribute23 in varchar2 default hr_api.g_varchar2
469: ,p_attribute16 in varchar2 default hr_api.g_varchar2
470: ,p_attribute17 in varchar2 default hr_api.g_varchar2
471: ,p_attribute18 in varchar2 default hr_api.g_varchar2
472: ,p_attribute19 in varchar2 default hr_api.g_varchar2
473: ,p_attribute20 in varchar2 default hr_api.g_varchar2
474: ,p_attribute21 in varchar2 default hr_api.g_varchar2
475: ,p_attribute22 in varchar2 default hr_api.g_varchar2
476: ,p_attribute23 in varchar2 default hr_api.g_varchar2
477: ,p_attribute24 in varchar2 default hr_api.g_varchar2
470: ,p_attribute17 in varchar2 default hr_api.g_varchar2
471: ,p_attribute18 in varchar2 default hr_api.g_varchar2
472: ,p_attribute19 in varchar2 default hr_api.g_varchar2
473: ,p_attribute20 in varchar2 default hr_api.g_varchar2
474: ,p_attribute21 in varchar2 default hr_api.g_varchar2
475: ,p_attribute22 in varchar2 default hr_api.g_varchar2
476: ,p_attribute23 in varchar2 default hr_api.g_varchar2
477: ,p_attribute24 in varchar2 default hr_api.g_varchar2
478: ,p_attribute25 in varchar2 default hr_api.g_varchar2
471: ,p_attribute18 in varchar2 default hr_api.g_varchar2
472: ,p_attribute19 in varchar2 default hr_api.g_varchar2
473: ,p_attribute20 in varchar2 default hr_api.g_varchar2
474: ,p_attribute21 in varchar2 default hr_api.g_varchar2
475: ,p_attribute22 in varchar2 default hr_api.g_varchar2
476: ,p_attribute23 in varchar2 default hr_api.g_varchar2
477: ,p_attribute24 in varchar2 default hr_api.g_varchar2
478: ,p_attribute25 in varchar2 default hr_api.g_varchar2
479: ,p_attribute26 in varchar2 default hr_api.g_varchar2
472: ,p_attribute19 in varchar2 default hr_api.g_varchar2
473: ,p_attribute20 in varchar2 default hr_api.g_varchar2
474: ,p_attribute21 in varchar2 default hr_api.g_varchar2
475: ,p_attribute22 in varchar2 default hr_api.g_varchar2
476: ,p_attribute23 in varchar2 default hr_api.g_varchar2
477: ,p_attribute24 in varchar2 default hr_api.g_varchar2
478: ,p_attribute25 in varchar2 default hr_api.g_varchar2
479: ,p_attribute26 in varchar2 default hr_api.g_varchar2
480: ,p_attribute27 in varchar2 default hr_api.g_varchar2
473: ,p_attribute20 in varchar2 default hr_api.g_varchar2
474: ,p_attribute21 in varchar2 default hr_api.g_varchar2
475: ,p_attribute22 in varchar2 default hr_api.g_varchar2
476: ,p_attribute23 in varchar2 default hr_api.g_varchar2
477: ,p_attribute24 in varchar2 default hr_api.g_varchar2
478: ,p_attribute25 in varchar2 default hr_api.g_varchar2
479: ,p_attribute26 in varchar2 default hr_api.g_varchar2
480: ,p_attribute27 in varchar2 default hr_api.g_varchar2
481: ,p_attribute28 in varchar2 default hr_api.g_varchar2
474: ,p_attribute21 in varchar2 default hr_api.g_varchar2
475: ,p_attribute22 in varchar2 default hr_api.g_varchar2
476: ,p_attribute23 in varchar2 default hr_api.g_varchar2
477: ,p_attribute24 in varchar2 default hr_api.g_varchar2
478: ,p_attribute25 in varchar2 default hr_api.g_varchar2
479: ,p_attribute26 in varchar2 default hr_api.g_varchar2
480: ,p_attribute27 in varchar2 default hr_api.g_varchar2
481: ,p_attribute28 in varchar2 default hr_api.g_varchar2
482: ,p_attribute29 in varchar2 default hr_api.g_varchar2
475: ,p_attribute22 in varchar2 default hr_api.g_varchar2
476: ,p_attribute23 in varchar2 default hr_api.g_varchar2
477: ,p_attribute24 in varchar2 default hr_api.g_varchar2
478: ,p_attribute25 in varchar2 default hr_api.g_varchar2
479: ,p_attribute26 in varchar2 default hr_api.g_varchar2
480: ,p_attribute27 in varchar2 default hr_api.g_varchar2
481: ,p_attribute28 in varchar2 default hr_api.g_varchar2
482: ,p_attribute29 in varchar2 default hr_api.g_varchar2
483: ,p_attribute30 in varchar2 default hr_api.g_varchar2
476: ,p_attribute23 in varchar2 default hr_api.g_varchar2
477: ,p_attribute24 in varchar2 default hr_api.g_varchar2
478: ,p_attribute25 in varchar2 default hr_api.g_varchar2
479: ,p_attribute26 in varchar2 default hr_api.g_varchar2
480: ,p_attribute27 in varchar2 default hr_api.g_varchar2
481: ,p_attribute28 in varchar2 default hr_api.g_varchar2
482: ,p_attribute29 in varchar2 default hr_api.g_varchar2
483: ,p_attribute30 in varchar2 default hr_api.g_varchar2
484: ,p_information_category in varchar2 default hr_api.g_varchar2
477: ,p_attribute24 in varchar2 default hr_api.g_varchar2
478: ,p_attribute25 in varchar2 default hr_api.g_varchar2
479: ,p_attribute26 in varchar2 default hr_api.g_varchar2
480: ,p_attribute27 in varchar2 default hr_api.g_varchar2
481: ,p_attribute28 in varchar2 default hr_api.g_varchar2
482: ,p_attribute29 in varchar2 default hr_api.g_varchar2
483: ,p_attribute30 in varchar2 default hr_api.g_varchar2
484: ,p_information_category in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
478: ,p_attribute25 in varchar2 default hr_api.g_varchar2
479: ,p_attribute26 in varchar2 default hr_api.g_varchar2
480: ,p_attribute27 in varchar2 default hr_api.g_varchar2
481: ,p_attribute28 in varchar2 default hr_api.g_varchar2
482: ,p_attribute29 in varchar2 default hr_api.g_varchar2
483: ,p_attribute30 in varchar2 default hr_api.g_varchar2
484: ,p_information_category in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
479: ,p_attribute26 in varchar2 default hr_api.g_varchar2
480: ,p_attribute27 in varchar2 default hr_api.g_varchar2
481: ,p_attribute28 in varchar2 default hr_api.g_varchar2
482: ,p_attribute29 in varchar2 default hr_api.g_varchar2
483: ,p_attribute30 in varchar2 default hr_api.g_varchar2
484: ,p_information_category in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
480: ,p_attribute27 in varchar2 default hr_api.g_varchar2
481: ,p_attribute28 in varchar2 default hr_api.g_varchar2
482: ,p_attribute29 in varchar2 default hr_api.g_varchar2
483: ,p_attribute30 in varchar2 default hr_api.g_varchar2
484: ,p_information_category in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
481: ,p_attribute28 in varchar2 default hr_api.g_varchar2
482: ,p_attribute29 in varchar2 default hr_api.g_varchar2
483: ,p_attribute30 in varchar2 default hr_api.g_varchar2
484: ,p_information_category in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
482: ,p_attribute29 in varchar2 default hr_api.g_varchar2
483: ,p_attribute30 in varchar2 default hr_api.g_varchar2
484: ,p_information_category in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
483: ,p_attribute30 in varchar2 default hr_api.g_varchar2
484: ,p_information_category in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
484: ,p_information_category in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
512: ,p_information28 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
512: ,p_information28 in varchar2 default hr_api.g_varchar2
513: ,p_information29 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
512: ,p_information28 in varchar2 default hr_api.g_varchar2
513: ,p_information29 in varchar2 default hr_api.g_varchar2
514: ,p_information30 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
512: ,p_information28 in varchar2 default hr_api.g_varchar2
513: ,p_information29 in varchar2 default hr_api.g_varchar2
514: ,p_information30 in varchar2 default hr_api.g_varchar2
515: ,p_effective_date in date
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
512: ,p_information28 in varchar2 default hr_api.g_varchar2
513: ,p_information29 in varchar2 default hr_api.g_varchar2
514: ,p_information30 in varchar2 default hr_api.g_varchar2
515: ,p_effective_date in date
516: ,p_return_status out nocopy varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
512: ,p_information28 in varchar2 default hr_api.g_varchar2
513: ,p_information29 in varchar2 default hr_api.g_varchar2
514: ,p_information30 in varchar2 default hr_api.g_varchar2
515: ,p_effective_date in date
516: ,p_return_status out nocopy varchar2
517: ) is
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
512: ,p_information28 in varchar2 default hr_api.g_varchar2
513: ,p_information29 in varchar2 default hr_api.g_varchar2
514: ,p_information30 in varchar2 default hr_api.g_varchar2
515: ,p_effective_date in date
516: ,p_return_status out nocopy varchar2
517: ) is
518: --
541: --
542: -- Convert constant values to their corresponding boolean value
543: --
544: l_validate :=
545: hr_api.constant_to_boolean
546: (p_constant_value => p_validate);
547: --
548: -- Register Surrogate ID or user key values
549: --