8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< create_secondary_apl_asg >-----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_secondary_apl_asg
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_person_id in number
15: ,p_organization_id in number
16: ,p_recruiter_id in number default null
134: --
135: -- Convert constant values to their corresponding boolean value
136: --
137: l_validate :=
138: hr_api.constant_to_boolean
139: (p_constant_value => p_validate);
140: --
141: -- Register Surrogate ID or user key values
142: --
312: -- ----------------------------------------------------------------------------
313: -- |----------------------------< accept_apl_asg >----------------------------|
314: -- ----------------------------------------------------------------------------
315: PROCEDURE accept_apl_asg
316: (p_validate in number default hr_api.g_false_num
317: ,p_effective_date in date
318: ,p_datetrack_update_mode in varchar2
319: ,p_assignment_id in number
320: ,p_object_version_number in out nocopy number
317: ,p_effective_date in date
318: ,p_datetrack_update_mode in varchar2
319: ,p_assignment_id in number
320: ,p_object_version_number in out nocopy number
321: ,p_assignment_status_type_id in number default hr_api.g_number
322: ,p_change_reason in varchar2 default hr_api.g_varchar2
323: ,p_effective_start_date out nocopy date
324: ,p_effective_end_date out nocopy date
325: ,p_return_status out nocopy varchar2
318: ,p_datetrack_update_mode in varchar2
319: ,p_assignment_id in number
320: ,p_object_version_number in out nocopy number
321: ,p_assignment_status_type_id in number default hr_api.g_number
322: ,p_change_reason in varchar2 default hr_api.g_varchar2
323: ,p_effective_start_date out nocopy date
324: ,p_effective_end_date out nocopy date
325: ,p_return_status out nocopy varchar2
326: ) is
350: --
351: -- Convert constant values to their corresponding boolean value
352: --
353: l_validate :=
354: hr_api.constant_to_boolean
355: (p_constant_value => p_validate);
356: --
357: -- Register Surrogate ID or user key values
358: --
426: -- ----------------------------------------------------------------------------
427: -- |---------------------------< activate_apl_asg >---------------------------|
428: -- ----------------------------------------------------------------------------
429: PROCEDURE activate_apl_asg
430: (p_validate in number default hr_api.g_false_num
431: ,p_effective_date in date
432: ,p_datetrack_update_mode in varchar2
433: ,p_assignment_id in number
434: ,p_object_version_number in out nocopy number
431: ,p_effective_date in date
432: ,p_datetrack_update_mode in varchar2
433: ,p_assignment_id in number
434: ,p_object_version_number in out nocopy number
435: ,p_assignment_status_type_id in number default hr_api.g_number
436: ,p_change_reason in varchar2 default hr_api.g_varchar2
437: ,p_effective_start_date out nocopy date
438: ,p_effective_end_date out nocopy date
439: ,p_return_status out nocopy varchar2
432: ,p_datetrack_update_mode in varchar2
433: ,p_assignment_id in number
434: ,p_object_version_number in out nocopy number
435: ,p_assignment_status_type_id in number default hr_api.g_number
436: ,p_change_reason in varchar2 default hr_api.g_varchar2
437: ,p_effective_start_date out nocopy date
438: ,p_effective_end_date out nocopy date
439: ,p_return_status out nocopy varchar2
440: ) is
464: --
465: -- Convert constant values to their corresponding boolean value
466: --
467: l_validate :=
468: hr_api.constant_to_boolean
469: (p_constant_value => p_validate);
470: --
471: -- Register Surrogate ID or user key values
472: --
540: -- ----------------------------------------------------------------------------
541: -- |-----------------------------< offer_apl_asg >----------------------------|
542: -- ----------------------------------------------------------------------------
543: PROCEDURE offer_apl_asg
544: (p_validate in number default hr_api.g_false_num
545: ,p_effective_date in date
546: ,p_datetrack_update_mode in varchar2
547: ,p_assignment_id in number
548: ,p_object_version_number in out nocopy number
545: ,p_effective_date in date
546: ,p_datetrack_update_mode in varchar2
547: ,p_assignment_id in number
548: ,p_object_version_number in out nocopy number
549: ,p_assignment_status_type_id in number default hr_api.g_number
550: ,p_change_reason in varchar2 default hr_api.g_varchar2
551: ,p_effective_start_date out nocopy date
552: ,p_effective_end_date out nocopy date
553: ,p_return_status out nocopy varchar2
546: ,p_datetrack_update_mode in varchar2
547: ,p_assignment_id in number
548: ,p_object_version_number in out nocopy number
549: ,p_assignment_status_type_id in number default hr_api.g_number
550: ,p_change_reason in varchar2 default hr_api.g_varchar2
551: ,p_effective_start_date out nocopy date
552: ,p_effective_end_date out nocopy date
553: ,p_return_status out nocopy varchar2
554: ) is
578: --
579: -- Convert constant values to their corresponding boolean value
580: --
581: l_validate :=
582: hr_api.constant_to_boolean
583: (p_constant_value => p_validate);
584: --
585: -- Register Surrogate ID or user key values
586: --
654: -- ----------------------------------------------------------------------------
655: -- |---------------------------< terminate_apl_asg >--------------------------|
656: -- ----------------------------------------------------------------------------
657: PROCEDURE terminate_apl_asg
658: (p_validate in number default hr_api.g_false_num
659: ,p_effective_date in date
660: ,p_assignment_id in number
661: ,p_object_version_number in out nocopy number
662: ,p_effective_start_date out nocopy date
689: --
690: -- Convert constant values to their corresponding boolean value
691: --
692: l_validate :=
693: hr_api.constant_to_boolean
694: (p_constant_value => p_validate);
695: --
696: -- Register Surrogate ID or user key values
697: --
762: -- ----------------------------------------------------------------------------
763: -- |----------------------------< update_apl_asg >----------------------------|
764: -- ----------------------------------------------------------------------------
765: PROCEDURE update_apl_asg
766: (p_validate in number default hr_api.g_false_num
767: ,p_effective_date in date
768: ,p_datetrack_update_mode in varchar2
769: ,p_assignment_id in number
770: ,p_object_version_number in out nocopy number
767: ,p_effective_date in date
768: ,p_datetrack_update_mode in varchar2
769: ,p_assignment_id in number
770: ,p_object_version_number in out nocopy number
771: ,p_recruiter_id in number default hr_api.g_number
772: ,p_grade_id in number default hr_api.g_number
773: ,p_position_id in number default hr_api.g_number
774: ,p_job_id in number default hr_api.g_number
775: ,p_payroll_id in number default hr_api.g_number
768: ,p_datetrack_update_mode in varchar2
769: ,p_assignment_id in number
770: ,p_object_version_number in out nocopy number
771: ,p_recruiter_id in number default hr_api.g_number
772: ,p_grade_id in number default hr_api.g_number
773: ,p_position_id in number default hr_api.g_number
774: ,p_job_id in number default hr_api.g_number
775: ,p_payroll_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
769: ,p_assignment_id in number
770: ,p_object_version_number in out nocopy number
771: ,p_recruiter_id in number default hr_api.g_number
772: ,p_grade_id in number default hr_api.g_number
773: ,p_position_id in number default hr_api.g_number
774: ,p_job_id in number default hr_api.g_number
775: ,p_payroll_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
777: ,p_person_referred_by_id in number default hr_api.g_number
770: ,p_object_version_number in out nocopy number
771: ,p_recruiter_id in number default hr_api.g_number
772: ,p_grade_id in number default hr_api.g_number
773: ,p_position_id in number default hr_api.g_number
774: ,p_job_id in number default hr_api.g_number
775: ,p_payroll_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
777: ,p_person_referred_by_id in number default hr_api.g_number
778: ,p_supervisor_id in number default hr_api.g_number
771: ,p_recruiter_id in number default hr_api.g_number
772: ,p_grade_id in number default hr_api.g_number
773: ,p_position_id in number default hr_api.g_number
774: ,p_job_id in number default hr_api.g_number
775: ,p_payroll_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
777: ,p_person_referred_by_id in number default hr_api.g_number
778: ,p_supervisor_id in number default hr_api.g_number
779: ,p_special_ceiling_step_id in number default hr_api.g_number
772: ,p_grade_id in number default hr_api.g_number
773: ,p_position_id in number default hr_api.g_number
774: ,p_job_id in number default hr_api.g_number
775: ,p_payroll_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
777: ,p_person_referred_by_id in number default hr_api.g_number
778: ,p_supervisor_id in number default hr_api.g_number
779: ,p_special_ceiling_step_id in number default hr_api.g_number
780: ,p_recruitment_activity_id in number default hr_api.g_number
773: ,p_position_id in number default hr_api.g_number
774: ,p_job_id in number default hr_api.g_number
775: ,p_payroll_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
777: ,p_person_referred_by_id in number default hr_api.g_number
778: ,p_supervisor_id in number default hr_api.g_number
779: ,p_special_ceiling_step_id in number default hr_api.g_number
780: ,p_recruitment_activity_id in number default hr_api.g_number
781: ,p_source_organization_id in number default hr_api.g_number
774: ,p_job_id in number default hr_api.g_number
775: ,p_payroll_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
777: ,p_person_referred_by_id in number default hr_api.g_number
778: ,p_supervisor_id in number default hr_api.g_number
779: ,p_special_ceiling_step_id in number default hr_api.g_number
780: ,p_recruitment_activity_id in number default hr_api.g_number
781: ,p_source_organization_id in number default hr_api.g_number
782: ,p_organization_id in number default hr_api.g_number
775: ,p_payroll_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
777: ,p_person_referred_by_id in number default hr_api.g_number
778: ,p_supervisor_id in number default hr_api.g_number
779: ,p_special_ceiling_step_id in number default hr_api.g_number
780: ,p_recruitment_activity_id in number default hr_api.g_number
781: ,p_source_organization_id in number default hr_api.g_number
782: ,p_organization_id in number default hr_api.g_number
783: ,p_vacancy_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
777: ,p_person_referred_by_id in number default hr_api.g_number
778: ,p_supervisor_id in number default hr_api.g_number
779: ,p_special_ceiling_step_id in number default hr_api.g_number
780: ,p_recruitment_activity_id in number default hr_api.g_number
781: ,p_source_organization_id in number default hr_api.g_number
782: ,p_organization_id in number default hr_api.g_number
783: ,p_vacancy_id in number default hr_api.g_number
784: ,p_pay_basis_id in number default hr_api.g_number
777: ,p_person_referred_by_id in number default hr_api.g_number
778: ,p_supervisor_id in number default hr_api.g_number
779: ,p_special_ceiling_step_id in number default hr_api.g_number
780: ,p_recruitment_activity_id in number default hr_api.g_number
781: ,p_source_organization_id in number default hr_api.g_number
782: ,p_organization_id in number default hr_api.g_number
783: ,p_vacancy_id in number default hr_api.g_number
784: ,p_pay_basis_id in number default hr_api.g_number
785: ,p_application_id in number default hr_api.g_number
778: ,p_supervisor_id in number default hr_api.g_number
779: ,p_special_ceiling_step_id in number default hr_api.g_number
780: ,p_recruitment_activity_id in number default hr_api.g_number
781: ,p_source_organization_id in number default hr_api.g_number
782: ,p_organization_id in number default hr_api.g_number
783: ,p_vacancy_id in number default hr_api.g_number
784: ,p_pay_basis_id in number default hr_api.g_number
785: ,p_application_id in number default hr_api.g_number
786: ,p_change_reason in varchar2 default hr_api.g_varchar2
779: ,p_special_ceiling_step_id in number default hr_api.g_number
780: ,p_recruitment_activity_id in number default hr_api.g_number
781: ,p_source_organization_id in number default hr_api.g_number
782: ,p_organization_id in number default hr_api.g_number
783: ,p_vacancy_id in number default hr_api.g_number
784: ,p_pay_basis_id in number default hr_api.g_number
785: ,p_application_id in number default hr_api.g_number
786: ,p_change_reason in varchar2 default hr_api.g_varchar2
787: ,p_assignment_status_type_id in number default hr_api.g_number
780: ,p_recruitment_activity_id in number default hr_api.g_number
781: ,p_source_organization_id in number default hr_api.g_number
782: ,p_organization_id in number default hr_api.g_number
783: ,p_vacancy_id in number default hr_api.g_number
784: ,p_pay_basis_id in number default hr_api.g_number
785: ,p_application_id in number default hr_api.g_number
786: ,p_change_reason in varchar2 default hr_api.g_varchar2
787: ,p_assignment_status_type_id in number default hr_api.g_number
788: ,p_comments in varchar2 default hr_api.g_varchar2
781: ,p_source_organization_id in number default hr_api.g_number
782: ,p_organization_id in number default hr_api.g_number
783: ,p_vacancy_id in number default hr_api.g_number
784: ,p_pay_basis_id in number default hr_api.g_number
785: ,p_application_id in number default hr_api.g_number
786: ,p_change_reason in varchar2 default hr_api.g_varchar2
787: ,p_assignment_status_type_id in number default hr_api.g_number
788: ,p_comments in varchar2 default hr_api.g_varchar2
789: ,p_date_probation_end in date default hr_api.g_date
782: ,p_organization_id in number default hr_api.g_number
783: ,p_vacancy_id in number default hr_api.g_number
784: ,p_pay_basis_id in number default hr_api.g_number
785: ,p_application_id in number default hr_api.g_number
786: ,p_change_reason in varchar2 default hr_api.g_varchar2
787: ,p_assignment_status_type_id in number default hr_api.g_number
788: ,p_comments in varchar2 default hr_api.g_varchar2
789: ,p_date_probation_end in date default hr_api.g_date
790: ,p_default_code_comb_id in number default hr_api.g_number
783: ,p_vacancy_id in number default hr_api.g_number
784: ,p_pay_basis_id in number default hr_api.g_number
785: ,p_application_id in number default hr_api.g_number
786: ,p_change_reason in varchar2 default hr_api.g_varchar2
787: ,p_assignment_status_type_id in number default hr_api.g_number
788: ,p_comments in varchar2 default hr_api.g_varchar2
789: ,p_date_probation_end in date default hr_api.g_date
790: ,p_default_code_comb_id in number default hr_api.g_number
791: ,p_employment_category in varchar2 default hr_api.g_varchar2
784: ,p_pay_basis_id in number default hr_api.g_number
785: ,p_application_id in number default hr_api.g_number
786: ,p_change_reason in varchar2 default hr_api.g_varchar2
787: ,p_assignment_status_type_id in number default hr_api.g_number
788: ,p_comments in varchar2 default hr_api.g_varchar2
789: ,p_date_probation_end in date default hr_api.g_date
790: ,p_default_code_comb_id in number default hr_api.g_number
791: ,p_employment_category in varchar2 default hr_api.g_varchar2
792: ,p_frequency in varchar2 default hr_api.g_varchar2
785: ,p_application_id in number default hr_api.g_number
786: ,p_change_reason in varchar2 default hr_api.g_varchar2
787: ,p_assignment_status_type_id in number default hr_api.g_number
788: ,p_comments in varchar2 default hr_api.g_varchar2
789: ,p_date_probation_end in date default hr_api.g_date
790: ,p_default_code_comb_id in number default hr_api.g_number
791: ,p_employment_category in varchar2 default hr_api.g_varchar2
792: ,p_frequency in varchar2 default hr_api.g_varchar2
793: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
786: ,p_change_reason in varchar2 default hr_api.g_varchar2
787: ,p_assignment_status_type_id in number default hr_api.g_number
788: ,p_comments in varchar2 default hr_api.g_varchar2
789: ,p_date_probation_end in date default hr_api.g_date
790: ,p_default_code_comb_id in number default hr_api.g_number
791: ,p_employment_category in varchar2 default hr_api.g_varchar2
792: ,p_frequency in varchar2 default hr_api.g_varchar2
793: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
794: ,p_manager_flag in varchar2 default hr_api.g_varchar2
787: ,p_assignment_status_type_id in number default hr_api.g_number
788: ,p_comments in varchar2 default hr_api.g_varchar2
789: ,p_date_probation_end in date default hr_api.g_date
790: ,p_default_code_comb_id in number default hr_api.g_number
791: ,p_employment_category in varchar2 default hr_api.g_varchar2
792: ,p_frequency in varchar2 default hr_api.g_varchar2
793: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
794: ,p_manager_flag in varchar2 default hr_api.g_varchar2
795: ,p_normal_hours in number default hr_api.g_number
788: ,p_comments in varchar2 default hr_api.g_varchar2
789: ,p_date_probation_end in date default hr_api.g_date
790: ,p_default_code_comb_id in number default hr_api.g_number
791: ,p_employment_category in varchar2 default hr_api.g_varchar2
792: ,p_frequency in varchar2 default hr_api.g_varchar2
793: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
794: ,p_manager_flag in varchar2 default hr_api.g_varchar2
795: ,p_normal_hours in number default hr_api.g_number
796: ,p_perf_review_period in number default hr_api.g_number
789: ,p_date_probation_end in date default hr_api.g_date
790: ,p_default_code_comb_id in number default hr_api.g_number
791: ,p_employment_category in varchar2 default hr_api.g_varchar2
792: ,p_frequency in varchar2 default hr_api.g_varchar2
793: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
794: ,p_manager_flag in varchar2 default hr_api.g_varchar2
795: ,p_normal_hours in number default hr_api.g_number
796: ,p_perf_review_period in number default hr_api.g_number
797: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
790: ,p_default_code_comb_id in number default hr_api.g_number
791: ,p_employment_category in varchar2 default hr_api.g_varchar2
792: ,p_frequency in varchar2 default hr_api.g_varchar2
793: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
794: ,p_manager_flag in varchar2 default hr_api.g_varchar2
795: ,p_normal_hours in number default hr_api.g_number
796: ,p_perf_review_period in number default hr_api.g_number
797: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
798: ,p_probation_period in number default hr_api.g_number
791: ,p_employment_category in varchar2 default hr_api.g_varchar2
792: ,p_frequency in varchar2 default hr_api.g_varchar2
793: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
794: ,p_manager_flag in varchar2 default hr_api.g_varchar2
795: ,p_normal_hours in number default hr_api.g_number
796: ,p_perf_review_period in number default hr_api.g_number
797: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
798: ,p_probation_period in number default hr_api.g_number
799: ,p_probation_unit in varchar2 default hr_api.g_varchar2
792: ,p_frequency in varchar2 default hr_api.g_varchar2
793: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
794: ,p_manager_flag in varchar2 default hr_api.g_varchar2
795: ,p_normal_hours in number default hr_api.g_number
796: ,p_perf_review_period in number default hr_api.g_number
797: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
798: ,p_probation_period in number default hr_api.g_number
799: ,p_probation_unit in varchar2 default hr_api.g_varchar2
800: ,p_sal_review_period in number default hr_api.g_number
793: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
794: ,p_manager_flag in varchar2 default hr_api.g_varchar2
795: ,p_normal_hours in number default hr_api.g_number
796: ,p_perf_review_period in number default hr_api.g_number
797: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
798: ,p_probation_period in number default hr_api.g_number
799: ,p_probation_unit in varchar2 default hr_api.g_varchar2
800: ,p_sal_review_period in number default hr_api.g_number
801: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
794: ,p_manager_flag in varchar2 default hr_api.g_varchar2
795: ,p_normal_hours in number default hr_api.g_number
796: ,p_perf_review_period in number default hr_api.g_number
797: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
798: ,p_probation_period in number default hr_api.g_number
799: ,p_probation_unit in varchar2 default hr_api.g_varchar2
800: ,p_sal_review_period in number default hr_api.g_number
801: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
802: ,p_set_of_books_id in number default hr_api.g_number
795: ,p_normal_hours in number default hr_api.g_number
796: ,p_perf_review_period in number default hr_api.g_number
797: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
798: ,p_probation_period in number default hr_api.g_number
799: ,p_probation_unit in varchar2 default hr_api.g_varchar2
800: ,p_sal_review_period in number default hr_api.g_number
801: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
802: ,p_set_of_books_id in number default hr_api.g_number
803: ,p_source_type in varchar2 default hr_api.g_varchar2
796: ,p_perf_review_period in number default hr_api.g_number
797: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
798: ,p_probation_period in number default hr_api.g_number
799: ,p_probation_unit in varchar2 default hr_api.g_varchar2
800: ,p_sal_review_period in number default hr_api.g_number
801: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
802: ,p_set_of_books_id in number default hr_api.g_number
803: ,p_source_type in varchar2 default hr_api.g_varchar2
804: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
797: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
798: ,p_probation_period in number default hr_api.g_number
799: ,p_probation_unit in varchar2 default hr_api.g_varchar2
800: ,p_sal_review_period in number default hr_api.g_number
801: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
802: ,p_set_of_books_id in number default hr_api.g_number
803: ,p_source_type in varchar2 default hr_api.g_varchar2
804: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
805: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
798: ,p_probation_period in number default hr_api.g_number
799: ,p_probation_unit in varchar2 default hr_api.g_varchar2
800: ,p_sal_review_period in number default hr_api.g_number
801: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
802: ,p_set_of_books_id in number default hr_api.g_number
803: ,p_source_type in varchar2 default hr_api.g_varchar2
804: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
805: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
806: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
799: ,p_probation_unit in varchar2 default hr_api.g_varchar2
800: ,p_sal_review_period in number default hr_api.g_number
801: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
802: ,p_set_of_books_id in number default hr_api.g_number
803: ,p_source_type in varchar2 default hr_api.g_varchar2
804: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
805: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
806: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
807: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
800: ,p_sal_review_period in number default hr_api.g_number
801: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
802: ,p_set_of_books_id in number default hr_api.g_number
803: ,p_source_type in varchar2 default hr_api.g_varchar2
804: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
805: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
806: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
807: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
808: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
802: ,p_set_of_books_id in number default hr_api.g_number
803: ,p_source_type in varchar2 default hr_api.g_varchar2
804: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
805: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
806: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
807: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
808: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
809: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_set_of_books_id in number default hr_api.g_number
803: ,p_source_type in varchar2 default hr_api.g_varchar2
804: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
805: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
806: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
807: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
808: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
809: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
810: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_source_type in varchar2 default hr_api.g_varchar2
804: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
805: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
806: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
807: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
808: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
809: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
810: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
811: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
805: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
806: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
807: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
808: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
809: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
810: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
811: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
812: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
806: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
807: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
808: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
809: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
810: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
811: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
812: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
813: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
807: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
808: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
809: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
810: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
811: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
812: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
813: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
814: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
808: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
809: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
810: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
811: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
812: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
813: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
814: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
815: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
809: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
810: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
811: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
812: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
813: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
814: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
815: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
816: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
810: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
811: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
812: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
813: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
814: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
815: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
816: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
817: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
811: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
812: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
813: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
814: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
815: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
816: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
817: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
818: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
812: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
813: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
814: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
815: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
816: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
817: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
818: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
819: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
813: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
814: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
815: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
816: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
817: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
818: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
819: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
820: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
814: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
815: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
816: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
817: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
818: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
819: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
820: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
821: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
815: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
816: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
817: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
818: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
819: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
820: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
821: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
822: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
816: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
817: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
818: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
819: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
820: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
821: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
822: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
823: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
817: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
818: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
819: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
820: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
821: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
822: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
823: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
824: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
818: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
819: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
820: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
821: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
822: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
823: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
824: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
825: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
819: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
820: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
821: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
822: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
823: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
824: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
825: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
826: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
820: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
821: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
822: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
823: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
824: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
825: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
826: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
827: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
821: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
822: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
823: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
824: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
825: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
826: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
827: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
828: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
821: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
822: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
823: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
824: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
825: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
826: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
827: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
828: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
829: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
822: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
823: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
824: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
825: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
826: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
827: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
828: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
829: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
830: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
823: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
824: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
825: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
826: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
827: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
828: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
829: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
830: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
831: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
824: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
825: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
826: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
827: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
828: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
829: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
830: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
831: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
832: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
825: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
826: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
827: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
828: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
829: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
830: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
831: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
832: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
833: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
826: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
827: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
828: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
829: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
830: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
831: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
832: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
833: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
834: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
827: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
828: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
829: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
830: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
831: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
832: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
833: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
834: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
835: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
828: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
829: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
830: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
831: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
832: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
833: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
834: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
835: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
836: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
829: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
830: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
831: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
832: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
833: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
834: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
835: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
836: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
837: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
830: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
831: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
832: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
833: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
834: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
835: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
836: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
837: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
838: ,p_title in varchar2 default hr_api.g_varchar2
831: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
832: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
833: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
834: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
835: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
836: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
837: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
838: ,p_title in varchar2 default hr_api.g_varchar2
839: ,p_concatenated_segments out nocopy varchar2
832: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
833: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
834: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
835: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
836: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
837: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
838: ,p_title in varchar2 default hr_api.g_varchar2
839: ,p_concatenated_segments out nocopy varchar2
840: ,p_contract_id in number default hr_api.g_number
833: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
834: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
835: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
836: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
837: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
838: ,p_title in varchar2 default hr_api.g_varchar2
839: ,p_concatenated_segments out nocopy varchar2
840: ,p_contract_id in number default hr_api.g_number
841: ,p_establishment_id in number default hr_api.g_number
834: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
835: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
836: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
837: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
838: ,p_title in varchar2 default hr_api.g_varchar2
839: ,p_concatenated_segments out nocopy varchar2
840: ,p_contract_id in number default hr_api.g_number
841: ,p_establishment_id in number default hr_api.g_number
842: ,p_collective_agreement_id in number default hr_api.g_number
836: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
837: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
838: ,p_title in varchar2 default hr_api.g_varchar2
839: ,p_concatenated_segments out nocopy varchar2
840: ,p_contract_id in number default hr_api.g_number
841: ,p_establishment_id in number default hr_api.g_number
842: ,p_collective_agreement_id in number default hr_api.g_number
843: ,p_notice_period in number default hr_api.g_number
844: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
837: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
838: ,p_title in varchar2 default hr_api.g_varchar2
839: ,p_concatenated_segments out nocopy varchar2
840: ,p_contract_id in number default hr_api.g_number
841: ,p_establishment_id in number default hr_api.g_number
842: ,p_collective_agreement_id in number default hr_api.g_number
843: ,p_notice_period in number default hr_api.g_number
844: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
845: ,p_employee_category in varchar2 default hr_api.g_varchar2
838: ,p_title in varchar2 default hr_api.g_varchar2
839: ,p_concatenated_segments out nocopy varchar2
840: ,p_contract_id in number default hr_api.g_number
841: ,p_establishment_id in number default hr_api.g_number
842: ,p_collective_agreement_id in number default hr_api.g_number
843: ,p_notice_period in number default hr_api.g_number
844: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
845: ,p_employee_category in varchar2 default hr_api.g_varchar2
846: ,p_work_at_home in varchar2 default hr_api.g_varchar2
839: ,p_concatenated_segments out nocopy varchar2
840: ,p_contract_id in number default hr_api.g_number
841: ,p_establishment_id in number default hr_api.g_number
842: ,p_collective_agreement_id in number default hr_api.g_number
843: ,p_notice_period in number default hr_api.g_number
844: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
845: ,p_employee_category in varchar2 default hr_api.g_varchar2
846: ,p_work_at_home in varchar2 default hr_api.g_varchar2
847: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
840: ,p_contract_id in number default hr_api.g_number
841: ,p_establishment_id in number default hr_api.g_number
842: ,p_collective_agreement_id in number default hr_api.g_number
843: ,p_notice_period in number default hr_api.g_number
844: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
845: ,p_employee_category in varchar2 default hr_api.g_varchar2
846: ,p_work_at_home in varchar2 default hr_api.g_varchar2
847: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
848: ,p_posting_content_id in number default hr_api.g_number
841: ,p_establishment_id in number default hr_api.g_number
842: ,p_collective_agreement_id in number default hr_api.g_number
843: ,p_notice_period in number default hr_api.g_number
844: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
845: ,p_employee_category in varchar2 default hr_api.g_varchar2
846: ,p_work_at_home in varchar2 default hr_api.g_varchar2
847: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
848: ,p_posting_content_id in number default hr_api.g_number
849: ,p_applicant_rank in number default hr_api.g_number
842: ,p_collective_agreement_id in number default hr_api.g_number
843: ,p_notice_period in number default hr_api.g_number
844: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
845: ,p_employee_category in varchar2 default hr_api.g_varchar2
846: ,p_work_at_home in varchar2 default hr_api.g_varchar2
847: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
848: ,p_posting_content_id in number default hr_api.g_number
849: ,p_applicant_rank in number default hr_api.g_number
850: ,p_cagr_grade_def_id in out nocopy number
843: ,p_notice_period in number default hr_api.g_number
844: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
845: ,p_employee_category in varchar2 default hr_api.g_varchar2
846: ,p_work_at_home in varchar2 default hr_api.g_varchar2
847: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
848: ,p_posting_content_id in number default hr_api.g_number
849: ,p_applicant_rank in number default hr_api.g_number
850: ,p_cagr_grade_def_id in out nocopy number
851: ,p_cagr_concatenated_segments out nocopy varchar2
844: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
845: ,p_employee_category in varchar2 default hr_api.g_varchar2
846: ,p_work_at_home in varchar2 default hr_api.g_varchar2
847: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
848: ,p_posting_content_id in number default hr_api.g_number
849: ,p_applicant_rank in number default hr_api.g_number
850: ,p_cagr_grade_def_id in out nocopy number
851: ,p_cagr_concatenated_segments out nocopy varchar2
852: ,p_group_name out nocopy varchar2
845: ,p_employee_category in varchar2 default hr_api.g_varchar2
846: ,p_work_at_home in varchar2 default hr_api.g_varchar2
847: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
848: ,p_posting_content_id in number default hr_api.g_number
849: ,p_applicant_rank in number default hr_api.g_number
850: ,p_cagr_grade_def_id in out nocopy number
851: ,p_cagr_concatenated_segments out nocopy varchar2
852: ,p_group_name out nocopy varchar2
853: ,p_comment_id out nocopy number
889: --
890: -- Convert constant values to their corresponding boolean value
891: --
892: l_validate :=
893: hr_api.constant_to_boolean
894: (p_constant_value => p_validate);
895: --
896: -- Register Surrogate ID or user key values
897: --
1063: -- ----------------------------------------------------------------------------
1064: -- |----------------------------< update_emp_asg >----------------------------|
1065: -- ----------------------------------------------------------------------------
1066: PROCEDURE update_emp_asg
1067: (p_validate in number default hr_api.g_false_num
1068: ,p_effective_date in date
1069: ,p_datetrack_update_mode in varchar2
1070: ,p_assignment_id in number
1071: ,p_object_version_number in out nocopy number
1068: ,p_effective_date in date
1069: ,p_datetrack_update_mode in varchar2
1070: ,p_assignment_id in number
1071: ,p_object_version_number in out nocopy number
1072: ,p_supervisor_id in number default hr_api.g_number
1073: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1074: ,p_change_reason in varchar2 default hr_api.g_varchar2
1075: ,p_assignment_status_type_id in number default hr_api.g_number
1076: ,p_comments in varchar2 default hr_api.g_varchar2
1069: ,p_datetrack_update_mode in varchar2
1070: ,p_assignment_id in number
1071: ,p_object_version_number in out nocopy number
1072: ,p_supervisor_id in number default hr_api.g_number
1073: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1074: ,p_change_reason in varchar2 default hr_api.g_varchar2
1075: ,p_assignment_status_type_id in number default hr_api.g_number
1076: ,p_comments in varchar2 default hr_api.g_varchar2
1077: ,p_date_probation_end in date default hr_api.g_date
1070: ,p_assignment_id in number
1071: ,p_object_version_number in out nocopy number
1072: ,p_supervisor_id in number default hr_api.g_number
1073: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1074: ,p_change_reason in varchar2 default hr_api.g_varchar2
1075: ,p_assignment_status_type_id in number default hr_api.g_number
1076: ,p_comments in varchar2 default hr_api.g_varchar2
1077: ,p_date_probation_end in date default hr_api.g_date
1078: ,p_default_code_comb_id in number default hr_api.g_number
1071: ,p_object_version_number in out nocopy number
1072: ,p_supervisor_id in number default hr_api.g_number
1073: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1074: ,p_change_reason in varchar2 default hr_api.g_varchar2
1075: ,p_assignment_status_type_id in number default hr_api.g_number
1076: ,p_comments in varchar2 default hr_api.g_varchar2
1077: ,p_date_probation_end in date default hr_api.g_date
1078: ,p_default_code_comb_id in number default hr_api.g_number
1079: ,p_frequency in varchar2 default hr_api.g_varchar2
1072: ,p_supervisor_id in number default hr_api.g_number
1073: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1074: ,p_change_reason in varchar2 default hr_api.g_varchar2
1075: ,p_assignment_status_type_id in number default hr_api.g_number
1076: ,p_comments in varchar2 default hr_api.g_varchar2
1077: ,p_date_probation_end in date default hr_api.g_date
1078: ,p_default_code_comb_id in number default hr_api.g_number
1079: ,p_frequency in varchar2 default hr_api.g_varchar2
1080: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1073: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1074: ,p_change_reason in varchar2 default hr_api.g_varchar2
1075: ,p_assignment_status_type_id in number default hr_api.g_number
1076: ,p_comments in varchar2 default hr_api.g_varchar2
1077: ,p_date_probation_end in date default hr_api.g_date
1078: ,p_default_code_comb_id in number default hr_api.g_number
1079: ,p_frequency in varchar2 default hr_api.g_varchar2
1080: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1081: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1074: ,p_change_reason in varchar2 default hr_api.g_varchar2
1075: ,p_assignment_status_type_id in number default hr_api.g_number
1076: ,p_comments in varchar2 default hr_api.g_varchar2
1077: ,p_date_probation_end in date default hr_api.g_date
1078: ,p_default_code_comb_id in number default hr_api.g_number
1079: ,p_frequency in varchar2 default hr_api.g_varchar2
1080: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1081: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1082: ,p_normal_hours in number default hr_api.g_number
1075: ,p_assignment_status_type_id in number default hr_api.g_number
1076: ,p_comments in varchar2 default hr_api.g_varchar2
1077: ,p_date_probation_end in date default hr_api.g_date
1078: ,p_default_code_comb_id in number default hr_api.g_number
1079: ,p_frequency in varchar2 default hr_api.g_varchar2
1080: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1081: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1082: ,p_normal_hours in number default hr_api.g_number
1083: ,p_perf_review_period in number default hr_api.g_number
1076: ,p_comments in varchar2 default hr_api.g_varchar2
1077: ,p_date_probation_end in date default hr_api.g_date
1078: ,p_default_code_comb_id in number default hr_api.g_number
1079: ,p_frequency in varchar2 default hr_api.g_varchar2
1080: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1081: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1082: ,p_normal_hours in number default hr_api.g_number
1083: ,p_perf_review_period in number default hr_api.g_number
1084: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1077: ,p_date_probation_end in date default hr_api.g_date
1078: ,p_default_code_comb_id in number default hr_api.g_number
1079: ,p_frequency in varchar2 default hr_api.g_varchar2
1080: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1081: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1082: ,p_normal_hours in number default hr_api.g_number
1083: ,p_perf_review_period in number default hr_api.g_number
1084: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1085: ,p_probation_period in number default hr_api.g_number
1078: ,p_default_code_comb_id in number default hr_api.g_number
1079: ,p_frequency in varchar2 default hr_api.g_varchar2
1080: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1081: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1082: ,p_normal_hours in number default hr_api.g_number
1083: ,p_perf_review_period in number default hr_api.g_number
1084: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1085: ,p_probation_period in number default hr_api.g_number
1086: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1079: ,p_frequency in varchar2 default hr_api.g_varchar2
1080: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1081: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1082: ,p_normal_hours in number default hr_api.g_number
1083: ,p_perf_review_period in number default hr_api.g_number
1084: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1085: ,p_probation_period in number default hr_api.g_number
1086: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1087: ,p_sal_review_period in number default hr_api.g_number
1080: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1081: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1082: ,p_normal_hours in number default hr_api.g_number
1083: ,p_perf_review_period in number default hr_api.g_number
1084: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1085: ,p_probation_period in number default hr_api.g_number
1086: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1087: ,p_sal_review_period in number default hr_api.g_number
1088: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1081: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1082: ,p_normal_hours in number default hr_api.g_number
1083: ,p_perf_review_period in number default hr_api.g_number
1084: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1085: ,p_probation_period in number default hr_api.g_number
1086: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1087: ,p_sal_review_period in number default hr_api.g_number
1088: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1089: ,p_set_of_books_id in number default hr_api.g_number
1082: ,p_normal_hours in number default hr_api.g_number
1083: ,p_perf_review_period in number default hr_api.g_number
1084: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1085: ,p_probation_period in number default hr_api.g_number
1086: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1087: ,p_sal_review_period in number default hr_api.g_number
1088: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1089: ,p_set_of_books_id in number default hr_api.g_number
1090: ,p_source_type in varchar2 default hr_api.g_varchar2
1083: ,p_perf_review_period in number default hr_api.g_number
1084: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1085: ,p_probation_period in number default hr_api.g_number
1086: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1087: ,p_sal_review_period in number default hr_api.g_number
1088: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1089: ,p_set_of_books_id in number default hr_api.g_number
1090: ,p_source_type in varchar2 default hr_api.g_varchar2
1091: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1084: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1085: ,p_probation_period in number default hr_api.g_number
1086: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1087: ,p_sal_review_period in number default hr_api.g_number
1088: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1089: ,p_set_of_books_id in number default hr_api.g_number
1090: ,p_source_type in varchar2 default hr_api.g_varchar2
1091: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1092: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1085: ,p_probation_period in number default hr_api.g_number
1086: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1087: ,p_sal_review_period in number default hr_api.g_number
1088: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1089: ,p_set_of_books_id in number default hr_api.g_number
1090: ,p_source_type in varchar2 default hr_api.g_varchar2
1091: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1092: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1093: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1086: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1087: ,p_sal_review_period in number default hr_api.g_number
1088: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1089: ,p_set_of_books_id in number default hr_api.g_number
1090: ,p_source_type in varchar2 default hr_api.g_varchar2
1091: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1092: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1093: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1094: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1087: ,p_sal_review_period in number default hr_api.g_number
1088: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1089: ,p_set_of_books_id in number default hr_api.g_number
1090: ,p_source_type in varchar2 default hr_api.g_varchar2
1091: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1092: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1093: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1094: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1095: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1088: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1089: ,p_set_of_books_id in number default hr_api.g_number
1090: ,p_source_type in varchar2 default hr_api.g_varchar2
1091: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1092: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1093: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1094: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1095: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1096: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1089: ,p_set_of_books_id in number default hr_api.g_number
1090: ,p_source_type in varchar2 default hr_api.g_varchar2
1091: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1092: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1093: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1094: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1095: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1096: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1097: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1090: ,p_source_type in varchar2 default hr_api.g_varchar2
1091: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1092: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1093: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1094: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1095: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1096: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1097: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1098: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1091: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1092: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1093: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1094: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1095: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1096: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1097: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1098: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1099: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1092: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1093: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1094: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1095: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1096: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1097: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1098: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1099: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1100: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1093: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1094: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1095: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1096: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1097: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1098: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1099: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1100: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1101: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1094: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1095: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1096: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1097: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1098: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1099: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1100: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1101: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1102: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1095: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1096: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1097: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1098: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1099: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1100: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1101: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1102: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1103: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1096: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1097: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1098: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1099: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1100: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1101: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1102: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1103: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1104: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1097: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1098: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1099: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1100: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1101: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1102: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1103: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1104: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1105: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1098: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1099: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1100: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1101: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1102: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1103: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1104: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1105: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1106: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1099: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1100: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1101: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1102: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1103: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1104: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1105: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1106: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1107: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1100: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1101: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1102: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1103: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1104: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1105: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1106: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1107: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1108: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1101: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1102: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1103: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1104: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1105: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1106: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1107: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1108: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1109: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1102: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1103: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1104: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1105: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1106: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1107: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1108: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1109: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1110: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1103: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1104: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1105: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1106: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1107: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1108: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1109: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1110: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1111: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1104: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1105: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1106: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1107: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1108: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1109: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1110: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1111: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1112: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1105: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1106: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1107: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1108: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1109: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1110: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1111: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1112: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1113: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1106: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1107: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1108: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1109: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1110: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1111: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1112: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1113: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1114: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1107: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1108: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1109: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1110: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1111: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1112: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1113: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1114: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1115: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1108: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1109: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1110: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1111: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1112: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1113: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1114: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1115: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1116: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1109: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1110: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1111: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1112: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1113: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1114: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1115: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1116: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1117: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1110: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1111: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1112: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1113: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1114: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1115: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1116: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1117: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1118: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1111: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1112: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1113: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1114: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1115: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1116: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1117: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1118: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1119: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1112: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1113: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1114: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1115: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1116: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1117: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1118: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1119: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1120: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1113: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1114: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1115: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1116: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1117: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1118: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1119: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1120: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1121: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1114: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1115: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1116: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1117: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1118: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1119: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1120: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1121: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1122: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1115: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1116: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1117: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1118: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1119: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1120: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1121: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1122: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1123: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1116: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1117: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1118: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1119: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1120: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1121: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1122: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1123: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1124: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1117: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1118: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1119: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1120: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1121: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1122: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1123: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1124: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1125: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1118: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1119: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1120: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1121: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1122: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1123: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1124: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1125: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1126: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1119: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1120: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1121: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1122: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1123: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1124: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1125: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1126: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1127: ,p_title in varchar2 default hr_api.g_varchar2
1120: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1121: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1122: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1123: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1124: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1125: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1126: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1127: ,p_title in varchar2 default hr_api.g_varchar2
1128: ,p_segment1 in varchar2 default hr_api.g_varchar2
1121: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1122: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1123: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1124: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1125: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1126: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1127: ,p_title in varchar2 default hr_api.g_varchar2
1128: ,p_segment1 in varchar2 default hr_api.g_varchar2
1129: ,p_segment2 in varchar2 default hr_api.g_varchar2
1122: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1123: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1124: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1125: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1126: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1127: ,p_title in varchar2 default hr_api.g_varchar2
1128: ,p_segment1 in varchar2 default hr_api.g_varchar2
1129: ,p_segment2 in varchar2 default hr_api.g_varchar2
1130: ,p_segment3 in varchar2 default hr_api.g_varchar2
1123: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1124: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1125: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1126: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1127: ,p_title in varchar2 default hr_api.g_varchar2
1128: ,p_segment1 in varchar2 default hr_api.g_varchar2
1129: ,p_segment2 in varchar2 default hr_api.g_varchar2
1130: ,p_segment3 in varchar2 default hr_api.g_varchar2
1131: ,p_segment4 in varchar2 default hr_api.g_varchar2
1124: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1125: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1126: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1127: ,p_title in varchar2 default hr_api.g_varchar2
1128: ,p_segment1 in varchar2 default hr_api.g_varchar2
1129: ,p_segment2 in varchar2 default hr_api.g_varchar2
1130: ,p_segment3 in varchar2 default hr_api.g_varchar2
1131: ,p_segment4 in varchar2 default hr_api.g_varchar2
1132: ,p_segment5 in varchar2 default hr_api.g_varchar2
1125: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1126: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1127: ,p_title in varchar2 default hr_api.g_varchar2
1128: ,p_segment1 in varchar2 default hr_api.g_varchar2
1129: ,p_segment2 in varchar2 default hr_api.g_varchar2
1130: ,p_segment3 in varchar2 default hr_api.g_varchar2
1131: ,p_segment4 in varchar2 default hr_api.g_varchar2
1132: ,p_segment5 in varchar2 default hr_api.g_varchar2
1133: ,p_segment6 in varchar2 default hr_api.g_varchar2
1126: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1127: ,p_title in varchar2 default hr_api.g_varchar2
1128: ,p_segment1 in varchar2 default hr_api.g_varchar2
1129: ,p_segment2 in varchar2 default hr_api.g_varchar2
1130: ,p_segment3 in varchar2 default hr_api.g_varchar2
1131: ,p_segment4 in varchar2 default hr_api.g_varchar2
1132: ,p_segment5 in varchar2 default hr_api.g_varchar2
1133: ,p_segment6 in varchar2 default hr_api.g_varchar2
1134: ,p_segment7 in varchar2 default hr_api.g_varchar2
1127: ,p_title in varchar2 default hr_api.g_varchar2
1128: ,p_segment1 in varchar2 default hr_api.g_varchar2
1129: ,p_segment2 in varchar2 default hr_api.g_varchar2
1130: ,p_segment3 in varchar2 default hr_api.g_varchar2
1131: ,p_segment4 in varchar2 default hr_api.g_varchar2
1132: ,p_segment5 in varchar2 default hr_api.g_varchar2
1133: ,p_segment6 in varchar2 default hr_api.g_varchar2
1134: ,p_segment7 in varchar2 default hr_api.g_varchar2
1135: ,p_segment8 in varchar2 default hr_api.g_varchar2
1128: ,p_segment1 in varchar2 default hr_api.g_varchar2
1129: ,p_segment2 in varchar2 default hr_api.g_varchar2
1130: ,p_segment3 in varchar2 default hr_api.g_varchar2
1131: ,p_segment4 in varchar2 default hr_api.g_varchar2
1132: ,p_segment5 in varchar2 default hr_api.g_varchar2
1133: ,p_segment6 in varchar2 default hr_api.g_varchar2
1134: ,p_segment7 in varchar2 default hr_api.g_varchar2
1135: ,p_segment8 in varchar2 default hr_api.g_varchar2
1136: ,p_segment9 in varchar2 default hr_api.g_varchar2
1129: ,p_segment2 in varchar2 default hr_api.g_varchar2
1130: ,p_segment3 in varchar2 default hr_api.g_varchar2
1131: ,p_segment4 in varchar2 default hr_api.g_varchar2
1132: ,p_segment5 in varchar2 default hr_api.g_varchar2
1133: ,p_segment6 in varchar2 default hr_api.g_varchar2
1134: ,p_segment7 in varchar2 default hr_api.g_varchar2
1135: ,p_segment8 in varchar2 default hr_api.g_varchar2
1136: ,p_segment9 in varchar2 default hr_api.g_varchar2
1137: ,p_segment10 in varchar2 default hr_api.g_varchar2
1130: ,p_segment3 in varchar2 default hr_api.g_varchar2
1131: ,p_segment4 in varchar2 default hr_api.g_varchar2
1132: ,p_segment5 in varchar2 default hr_api.g_varchar2
1133: ,p_segment6 in varchar2 default hr_api.g_varchar2
1134: ,p_segment7 in varchar2 default hr_api.g_varchar2
1135: ,p_segment8 in varchar2 default hr_api.g_varchar2
1136: ,p_segment9 in varchar2 default hr_api.g_varchar2
1137: ,p_segment10 in varchar2 default hr_api.g_varchar2
1138: ,p_segment11 in varchar2 default hr_api.g_varchar2
1131: ,p_segment4 in varchar2 default hr_api.g_varchar2
1132: ,p_segment5 in varchar2 default hr_api.g_varchar2
1133: ,p_segment6 in varchar2 default hr_api.g_varchar2
1134: ,p_segment7 in varchar2 default hr_api.g_varchar2
1135: ,p_segment8 in varchar2 default hr_api.g_varchar2
1136: ,p_segment9 in varchar2 default hr_api.g_varchar2
1137: ,p_segment10 in varchar2 default hr_api.g_varchar2
1138: ,p_segment11 in varchar2 default hr_api.g_varchar2
1139: ,p_segment12 in varchar2 default hr_api.g_varchar2
1132: ,p_segment5 in varchar2 default hr_api.g_varchar2
1133: ,p_segment6 in varchar2 default hr_api.g_varchar2
1134: ,p_segment7 in varchar2 default hr_api.g_varchar2
1135: ,p_segment8 in varchar2 default hr_api.g_varchar2
1136: ,p_segment9 in varchar2 default hr_api.g_varchar2
1137: ,p_segment10 in varchar2 default hr_api.g_varchar2
1138: ,p_segment11 in varchar2 default hr_api.g_varchar2
1139: ,p_segment12 in varchar2 default hr_api.g_varchar2
1140: ,p_segment13 in varchar2 default hr_api.g_varchar2
1133: ,p_segment6 in varchar2 default hr_api.g_varchar2
1134: ,p_segment7 in varchar2 default hr_api.g_varchar2
1135: ,p_segment8 in varchar2 default hr_api.g_varchar2
1136: ,p_segment9 in varchar2 default hr_api.g_varchar2
1137: ,p_segment10 in varchar2 default hr_api.g_varchar2
1138: ,p_segment11 in varchar2 default hr_api.g_varchar2
1139: ,p_segment12 in varchar2 default hr_api.g_varchar2
1140: ,p_segment13 in varchar2 default hr_api.g_varchar2
1141: ,p_segment14 in varchar2 default hr_api.g_varchar2
1134: ,p_segment7 in varchar2 default hr_api.g_varchar2
1135: ,p_segment8 in varchar2 default hr_api.g_varchar2
1136: ,p_segment9 in varchar2 default hr_api.g_varchar2
1137: ,p_segment10 in varchar2 default hr_api.g_varchar2
1138: ,p_segment11 in varchar2 default hr_api.g_varchar2
1139: ,p_segment12 in varchar2 default hr_api.g_varchar2
1140: ,p_segment13 in varchar2 default hr_api.g_varchar2
1141: ,p_segment14 in varchar2 default hr_api.g_varchar2
1142: ,p_segment15 in varchar2 default hr_api.g_varchar2
1135: ,p_segment8 in varchar2 default hr_api.g_varchar2
1136: ,p_segment9 in varchar2 default hr_api.g_varchar2
1137: ,p_segment10 in varchar2 default hr_api.g_varchar2
1138: ,p_segment11 in varchar2 default hr_api.g_varchar2
1139: ,p_segment12 in varchar2 default hr_api.g_varchar2
1140: ,p_segment13 in varchar2 default hr_api.g_varchar2
1141: ,p_segment14 in varchar2 default hr_api.g_varchar2
1142: ,p_segment15 in varchar2 default hr_api.g_varchar2
1143: ,p_segment16 in varchar2 default hr_api.g_varchar2
1136: ,p_segment9 in varchar2 default hr_api.g_varchar2
1137: ,p_segment10 in varchar2 default hr_api.g_varchar2
1138: ,p_segment11 in varchar2 default hr_api.g_varchar2
1139: ,p_segment12 in varchar2 default hr_api.g_varchar2
1140: ,p_segment13 in varchar2 default hr_api.g_varchar2
1141: ,p_segment14 in varchar2 default hr_api.g_varchar2
1142: ,p_segment15 in varchar2 default hr_api.g_varchar2
1143: ,p_segment16 in varchar2 default hr_api.g_varchar2
1144: ,p_segment17 in varchar2 default hr_api.g_varchar2
1137: ,p_segment10 in varchar2 default hr_api.g_varchar2
1138: ,p_segment11 in varchar2 default hr_api.g_varchar2
1139: ,p_segment12 in varchar2 default hr_api.g_varchar2
1140: ,p_segment13 in varchar2 default hr_api.g_varchar2
1141: ,p_segment14 in varchar2 default hr_api.g_varchar2
1142: ,p_segment15 in varchar2 default hr_api.g_varchar2
1143: ,p_segment16 in varchar2 default hr_api.g_varchar2
1144: ,p_segment17 in varchar2 default hr_api.g_varchar2
1145: ,p_segment18 in varchar2 default hr_api.g_varchar2
1138: ,p_segment11 in varchar2 default hr_api.g_varchar2
1139: ,p_segment12 in varchar2 default hr_api.g_varchar2
1140: ,p_segment13 in varchar2 default hr_api.g_varchar2
1141: ,p_segment14 in varchar2 default hr_api.g_varchar2
1142: ,p_segment15 in varchar2 default hr_api.g_varchar2
1143: ,p_segment16 in varchar2 default hr_api.g_varchar2
1144: ,p_segment17 in varchar2 default hr_api.g_varchar2
1145: ,p_segment18 in varchar2 default hr_api.g_varchar2
1146: ,p_segment19 in varchar2 default hr_api.g_varchar2
1139: ,p_segment12 in varchar2 default hr_api.g_varchar2
1140: ,p_segment13 in varchar2 default hr_api.g_varchar2
1141: ,p_segment14 in varchar2 default hr_api.g_varchar2
1142: ,p_segment15 in varchar2 default hr_api.g_varchar2
1143: ,p_segment16 in varchar2 default hr_api.g_varchar2
1144: ,p_segment17 in varchar2 default hr_api.g_varchar2
1145: ,p_segment18 in varchar2 default hr_api.g_varchar2
1146: ,p_segment19 in varchar2 default hr_api.g_varchar2
1147: ,p_segment20 in varchar2 default hr_api.g_varchar2
1140: ,p_segment13 in varchar2 default hr_api.g_varchar2
1141: ,p_segment14 in varchar2 default hr_api.g_varchar2
1142: ,p_segment15 in varchar2 default hr_api.g_varchar2
1143: ,p_segment16 in varchar2 default hr_api.g_varchar2
1144: ,p_segment17 in varchar2 default hr_api.g_varchar2
1145: ,p_segment18 in varchar2 default hr_api.g_varchar2
1146: ,p_segment19 in varchar2 default hr_api.g_varchar2
1147: ,p_segment20 in varchar2 default hr_api.g_varchar2
1148: ,p_segment21 in varchar2 default hr_api.g_varchar2
1141: ,p_segment14 in varchar2 default hr_api.g_varchar2
1142: ,p_segment15 in varchar2 default hr_api.g_varchar2
1143: ,p_segment16 in varchar2 default hr_api.g_varchar2
1144: ,p_segment17 in varchar2 default hr_api.g_varchar2
1145: ,p_segment18 in varchar2 default hr_api.g_varchar2
1146: ,p_segment19 in varchar2 default hr_api.g_varchar2
1147: ,p_segment20 in varchar2 default hr_api.g_varchar2
1148: ,p_segment21 in varchar2 default hr_api.g_varchar2
1149: ,p_segment22 in varchar2 default hr_api.g_varchar2
1142: ,p_segment15 in varchar2 default hr_api.g_varchar2
1143: ,p_segment16 in varchar2 default hr_api.g_varchar2
1144: ,p_segment17 in varchar2 default hr_api.g_varchar2
1145: ,p_segment18 in varchar2 default hr_api.g_varchar2
1146: ,p_segment19 in varchar2 default hr_api.g_varchar2
1147: ,p_segment20 in varchar2 default hr_api.g_varchar2
1148: ,p_segment21 in varchar2 default hr_api.g_varchar2
1149: ,p_segment22 in varchar2 default hr_api.g_varchar2
1150: ,p_segment23 in varchar2 default hr_api.g_varchar2
1143: ,p_segment16 in varchar2 default hr_api.g_varchar2
1144: ,p_segment17 in varchar2 default hr_api.g_varchar2
1145: ,p_segment18 in varchar2 default hr_api.g_varchar2
1146: ,p_segment19 in varchar2 default hr_api.g_varchar2
1147: ,p_segment20 in varchar2 default hr_api.g_varchar2
1148: ,p_segment21 in varchar2 default hr_api.g_varchar2
1149: ,p_segment22 in varchar2 default hr_api.g_varchar2
1150: ,p_segment23 in varchar2 default hr_api.g_varchar2
1151: ,p_segment24 in varchar2 default hr_api.g_varchar2
1144: ,p_segment17 in varchar2 default hr_api.g_varchar2
1145: ,p_segment18 in varchar2 default hr_api.g_varchar2
1146: ,p_segment19 in varchar2 default hr_api.g_varchar2
1147: ,p_segment20 in varchar2 default hr_api.g_varchar2
1148: ,p_segment21 in varchar2 default hr_api.g_varchar2
1149: ,p_segment22 in varchar2 default hr_api.g_varchar2
1150: ,p_segment23 in varchar2 default hr_api.g_varchar2
1151: ,p_segment24 in varchar2 default hr_api.g_varchar2
1152: ,p_segment25 in varchar2 default hr_api.g_varchar2
1145: ,p_segment18 in varchar2 default hr_api.g_varchar2
1146: ,p_segment19 in varchar2 default hr_api.g_varchar2
1147: ,p_segment20 in varchar2 default hr_api.g_varchar2
1148: ,p_segment21 in varchar2 default hr_api.g_varchar2
1149: ,p_segment22 in varchar2 default hr_api.g_varchar2
1150: ,p_segment23 in varchar2 default hr_api.g_varchar2
1151: ,p_segment24 in varchar2 default hr_api.g_varchar2
1152: ,p_segment25 in varchar2 default hr_api.g_varchar2
1153: ,p_segment26 in varchar2 default hr_api.g_varchar2
1146: ,p_segment19 in varchar2 default hr_api.g_varchar2
1147: ,p_segment20 in varchar2 default hr_api.g_varchar2
1148: ,p_segment21 in varchar2 default hr_api.g_varchar2
1149: ,p_segment22 in varchar2 default hr_api.g_varchar2
1150: ,p_segment23 in varchar2 default hr_api.g_varchar2
1151: ,p_segment24 in varchar2 default hr_api.g_varchar2
1152: ,p_segment25 in varchar2 default hr_api.g_varchar2
1153: ,p_segment26 in varchar2 default hr_api.g_varchar2
1154: ,p_segment27 in varchar2 default hr_api.g_varchar2
1147: ,p_segment20 in varchar2 default hr_api.g_varchar2
1148: ,p_segment21 in varchar2 default hr_api.g_varchar2
1149: ,p_segment22 in varchar2 default hr_api.g_varchar2
1150: ,p_segment23 in varchar2 default hr_api.g_varchar2
1151: ,p_segment24 in varchar2 default hr_api.g_varchar2
1152: ,p_segment25 in varchar2 default hr_api.g_varchar2
1153: ,p_segment26 in varchar2 default hr_api.g_varchar2
1154: ,p_segment27 in varchar2 default hr_api.g_varchar2
1155: ,p_segment28 in varchar2 default hr_api.g_varchar2
1148: ,p_segment21 in varchar2 default hr_api.g_varchar2
1149: ,p_segment22 in varchar2 default hr_api.g_varchar2
1150: ,p_segment23 in varchar2 default hr_api.g_varchar2
1151: ,p_segment24 in varchar2 default hr_api.g_varchar2
1152: ,p_segment25 in varchar2 default hr_api.g_varchar2
1153: ,p_segment26 in varchar2 default hr_api.g_varchar2
1154: ,p_segment27 in varchar2 default hr_api.g_varchar2
1155: ,p_segment28 in varchar2 default hr_api.g_varchar2
1156: ,p_segment29 in varchar2 default hr_api.g_varchar2
1149: ,p_segment22 in varchar2 default hr_api.g_varchar2
1150: ,p_segment23 in varchar2 default hr_api.g_varchar2
1151: ,p_segment24 in varchar2 default hr_api.g_varchar2
1152: ,p_segment25 in varchar2 default hr_api.g_varchar2
1153: ,p_segment26 in varchar2 default hr_api.g_varchar2
1154: ,p_segment27 in varchar2 default hr_api.g_varchar2
1155: ,p_segment28 in varchar2 default hr_api.g_varchar2
1156: ,p_segment29 in varchar2 default hr_api.g_varchar2
1157: ,p_segment30 in varchar2 default hr_api.g_varchar2
1150: ,p_segment23 in varchar2 default hr_api.g_varchar2
1151: ,p_segment24 in varchar2 default hr_api.g_varchar2
1152: ,p_segment25 in varchar2 default hr_api.g_varchar2
1153: ,p_segment26 in varchar2 default hr_api.g_varchar2
1154: ,p_segment27 in varchar2 default hr_api.g_varchar2
1155: ,p_segment28 in varchar2 default hr_api.g_varchar2
1156: ,p_segment29 in varchar2 default hr_api.g_varchar2
1157: ,p_segment30 in varchar2 default hr_api.g_varchar2
1158: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1151: ,p_segment24 in varchar2 default hr_api.g_varchar2
1152: ,p_segment25 in varchar2 default hr_api.g_varchar2
1153: ,p_segment26 in varchar2 default hr_api.g_varchar2
1154: ,p_segment27 in varchar2 default hr_api.g_varchar2
1155: ,p_segment28 in varchar2 default hr_api.g_varchar2
1156: ,p_segment29 in varchar2 default hr_api.g_varchar2
1157: ,p_segment30 in varchar2 default hr_api.g_varchar2
1158: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1159: ,p_contract_id in number default hr_api.g_number
1152: ,p_segment25 in varchar2 default hr_api.g_varchar2
1153: ,p_segment26 in varchar2 default hr_api.g_varchar2
1154: ,p_segment27 in varchar2 default hr_api.g_varchar2
1155: ,p_segment28 in varchar2 default hr_api.g_varchar2
1156: ,p_segment29 in varchar2 default hr_api.g_varchar2
1157: ,p_segment30 in varchar2 default hr_api.g_varchar2
1158: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1159: ,p_contract_id in number default hr_api.g_number
1160: ,p_establishment_id in number default hr_api.g_number
1153: ,p_segment26 in varchar2 default hr_api.g_varchar2
1154: ,p_segment27 in varchar2 default hr_api.g_varchar2
1155: ,p_segment28 in varchar2 default hr_api.g_varchar2
1156: ,p_segment29 in varchar2 default hr_api.g_varchar2
1157: ,p_segment30 in varchar2 default hr_api.g_varchar2
1158: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1159: ,p_contract_id in number default hr_api.g_number
1160: ,p_establishment_id in number default hr_api.g_number
1161: ,p_collective_agreement_id in number default hr_api.g_number
1154: ,p_segment27 in varchar2 default hr_api.g_varchar2
1155: ,p_segment28 in varchar2 default hr_api.g_varchar2
1156: ,p_segment29 in varchar2 default hr_api.g_varchar2
1157: ,p_segment30 in varchar2 default hr_api.g_varchar2
1158: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1159: ,p_contract_id in number default hr_api.g_number
1160: ,p_establishment_id in number default hr_api.g_number
1161: ,p_collective_agreement_id in number default hr_api.g_number
1162: ,p_cagr_id_flex_num in number default hr_api.g_number
1155: ,p_segment28 in varchar2 default hr_api.g_varchar2
1156: ,p_segment29 in varchar2 default hr_api.g_varchar2
1157: ,p_segment30 in varchar2 default hr_api.g_varchar2
1158: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1159: ,p_contract_id in number default hr_api.g_number
1160: ,p_establishment_id in number default hr_api.g_number
1161: ,p_collective_agreement_id in number default hr_api.g_number
1162: ,p_cagr_id_flex_num in number default hr_api.g_number
1163: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1156: ,p_segment29 in varchar2 default hr_api.g_varchar2
1157: ,p_segment30 in varchar2 default hr_api.g_varchar2
1158: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1159: ,p_contract_id in number default hr_api.g_number
1160: ,p_establishment_id in number default hr_api.g_number
1161: ,p_collective_agreement_id in number default hr_api.g_number
1162: ,p_cagr_id_flex_num in number default hr_api.g_number
1163: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1164: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1157: ,p_segment30 in varchar2 default hr_api.g_varchar2
1158: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1159: ,p_contract_id in number default hr_api.g_number
1160: ,p_establishment_id in number default hr_api.g_number
1161: ,p_collective_agreement_id in number default hr_api.g_number
1162: ,p_cagr_id_flex_num in number default hr_api.g_number
1163: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1164: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1165: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1158: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1159: ,p_contract_id in number default hr_api.g_number
1160: ,p_establishment_id in number default hr_api.g_number
1161: ,p_collective_agreement_id in number default hr_api.g_number
1162: ,p_cagr_id_flex_num in number default hr_api.g_number
1163: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1164: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1165: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1166: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1159: ,p_contract_id in number default hr_api.g_number
1160: ,p_establishment_id in number default hr_api.g_number
1161: ,p_collective_agreement_id in number default hr_api.g_number
1162: ,p_cagr_id_flex_num in number default hr_api.g_number
1163: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1164: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1165: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1166: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1167: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1160: ,p_establishment_id in number default hr_api.g_number
1161: ,p_collective_agreement_id in number default hr_api.g_number
1162: ,p_cagr_id_flex_num in number default hr_api.g_number
1163: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1164: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1165: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1166: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1167: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1168: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1161: ,p_collective_agreement_id in number default hr_api.g_number
1162: ,p_cagr_id_flex_num in number default hr_api.g_number
1163: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1164: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1165: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1166: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1167: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1168: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1169: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1162: ,p_cagr_id_flex_num in number default hr_api.g_number
1163: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1164: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1165: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1166: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1167: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1168: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1169: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1170: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1163: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1164: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1165: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1166: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1167: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1168: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1169: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1170: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1171: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1164: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1165: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1166: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1167: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1168: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1169: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1170: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1171: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1172: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1165: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1166: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1167: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1168: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1169: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1170: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1171: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1172: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1173: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1166: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1167: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1168: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1169: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1170: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1171: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1172: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1173: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1174: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1167: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1168: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1169: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1170: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1171: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1172: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1173: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1174: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1175: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1168: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1169: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1170: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1171: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1172: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1173: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1174: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1175: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1176: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1169: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1170: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1171: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1172: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1173: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1174: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1175: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1176: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1177: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1170: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1171: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1172: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1173: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1174: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1175: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1176: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1177: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1178: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1171: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1172: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1173: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1174: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1175: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1176: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1177: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1178: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1179: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1172: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1173: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1174: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1175: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1176: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1177: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1178: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1179: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1180: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1173: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1174: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1175: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1176: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1177: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1178: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1179: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1180: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1181: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1174: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1175: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1176: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1177: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1178: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1179: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1180: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1181: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1182: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1175: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1176: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1177: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1178: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1179: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1180: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1181: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1182: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1183: ,p_notice_period in number default hr_api.g_number
1176: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1177: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1178: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1179: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1180: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1181: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1182: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1183: ,p_notice_period in number default hr_api.g_number
1184: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1177: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1178: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1179: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1180: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1181: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1182: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1183: ,p_notice_period in number default hr_api.g_number
1184: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1185: ,p_employee_category in varchar2 default hr_api.g_varchar2
1178: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1179: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1180: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1181: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1182: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1183: ,p_notice_period in number default hr_api.g_number
1184: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1185: ,p_employee_category in varchar2 default hr_api.g_varchar2
1186: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1179: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1180: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1181: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1182: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1183: ,p_notice_period in number default hr_api.g_number
1184: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1185: ,p_employee_category in varchar2 default hr_api.g_varchar2
1186: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1187: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1180: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1181: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1182: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1183: ,p_notice_period in number default hr_api.g_number
1184: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1185: ,p_employee_category in varchar2 default hr_api.g_varchar2
1186: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1187: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1188: ,p_business_group_id in varchar2 default hr_api.g_number
1181: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1182: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1183: ,p_notice_period in number default hr_api.g_number
1184: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1185: ,p_employee_category in varchar2 default hr_api.g_varchar2
1186: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1187: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1188: ,p_business_group_id in varchar2 default hr_api.g_number
1189: ,p_tax_unit_name in varchar2 default hr_api.g_varchar2
1182: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1183: ,p_notice_period in number default hr_api.g_number
1184: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1185: ,p_employee_category in varchar2 default hr_api.g_varchar2
1186: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1187: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1188: ,p_business_group_id in varchar2 default hr_api.g_number
1189: ,p_tax_unit_name in varchar2 default hr_api.g_varchar2
1190: ,p_scl_flex_struc_code in varchar2 default hr_api.g_varchar2
1183: ,p_notice_period in number default hr_api.g_number
1184: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1185: ,p_employee_category in varchar2 default hr_api.g_varchar2
1186: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1187: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1188: ,p_business_group_id in varchar2 default hr_api.g_number
1189: ,p_tax_unit_name in varchar2 default hr_api.g_varchar2
1190: ,p_scl_flex_struc_code in varchar2 default hr_api.g_varchar2
1191: ,p_scl_concatenated_segments in varchar2 default hr_api.g_varchar2
1184: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1185: ,p_employee_category in varchar2 default hr_api.g_varchar2
1186: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1187: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1188: ,p_business_group_id in varchar2 default hr_api.g_number
1189: ,p_tax_unit_name in varchar2 default hr_api.g_varchar2
1190: ,p_scl_flex_struc_code in varchar2 default hr_api.g_varchar2
1191: ,p_scl_concatenated_segments in varchar2 default hr_api.g_varchar2
1192: ,p_cagr_grade_def_id out nocopy number
1185: ,p_employee_category in varchar2 default hr_api.g_varchar2
1186: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1187: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1188: ,p_business_group_id in varchar2 default hr_api.g_number
1189: ,p_tax_unit_name in varchar2 default hr_api.g_varchar2
1190: ,p_scl_flex_struc_code in varchar2 default hr_api.g_varchar2
1191: ,p_scl_concatenated_segments in varchar2 default hr_api.g_varchar2
1192: ,p_cagr_grade_def_id out nocopy number
1193: ,p_cagr_concatenated_segments out nocopy varchar2
1186: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1187: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1188: ,p_business_group_id in varchar2 default hr_api.g_number
1189: ,p_tax_unit_name in varchar2 default hr_api.g_varchar2
1190: ,p_scl_flex_struc_code in varchar2 default hr_api.g_varchar2
1191: ,p_scl_concatenated_segments in varchar2 default hr_api.g_varchar2
1192: ,p_cagr_grade_def_id out nocopy number
1193: ,p_cagr_concatenated_segments out nocopy varchar2
1194: ,p_concatenated_segments out nocopy varchar2
1187: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1188: ,p_business_group_id in varchar2 default hr_api.g_number
1189: ,p_tax_unit_name in varchar2 default hr_api.g_varchar2
1190: ,p_scl_flex_struc_code in varchar2 default hr_api.g_varchar2
1191: ,p_scl_concatenated_segments in varchar2 default hr_api.g_varchar2
1192: ,p_cagr_grade_def_id out nocopy number
1193: ,p_cagr_concatenated_segments out nocopy varchar2
1194: ,p_concatenated_segments out nocopy varchar2
1195: ,p_soft_coding_keyflex_id out nocopy number
1234: --
1235: -- Convert constant values to their corresponding boolean value
1236: --
1237: l_validate :=
1238: hr_api.constant_to_boolean
1239: (p_constant_value => p_validate);
1240: --
1241: -- call insert_soft_coding_keyflex to insert record into SCL during migration
1242: --
1473: -- ----------------------------------------------------------------------------
1474: -- |------------------------< update_emp_asg_criteria >-----------------------|
1475: -- ----------------------------------------------------------------------------
1476: PROCEDURE update_emp_asg_criteria
1477: (p_validate in number default hr_api.g_false_num
1478: ,p_effective_date in date
1479: ,p_datetrack_update_mode in varchar2
1480: ,p_assignment_id in number
1481: ,p_object_version_number in out nocopy number
1478: ,p_effective_date in date
1479: ,p_datetrack_update_mode in varchar2
1480: ,p_assignment_id in number
1481: ,p_object_version_number in out nocopy number
1482: ,p_grade_id in number default hr_api.g_number
1483: ,p_position_id in number default hr_api.g_number
1484: ,p_job_id in number default hr_api.g_number
1485: ,p_payroll_id in number default hr_api.g_number
1486: ,p_location_id in number default hr_api.g_number
1479: ,p_datetrack_update_mode in varchar2
1480: ,p_assignment_id in number
1481: ,p_object_version_number in out nocopy number
1482: ,p_grade_id in number default hr_api.g_number
1483: ,p_position_id in number default hr_api.g_number
1484: ,p_job_id in number default hr_api.g_number
1485: ,p_payroll_id in number default hr_api.g_number
1486: ,p_location_id in number default hr_api.g_number
1487: ,p_special_ceiling_step_id in out nocopy number
1480: ,p_assignment_id in number
1481: ,p_object_version_number in out nocopy number
1482: ,p_grade_id in number default hr_api.g_number
1483: ,p_position_id in number default hr_api.g_number
1484: ,p_job_id in number default hr_api.g_number
1485: ,p_payroll_id in number default hr_api.g_number
1486: ,p_location_id in number default hr_api.g_number
1487: ,p_special_ceiling_step_id in out nocopy number
1488: ,p_organization_id in number default hr_api.g_number
1481: ,p_object_version_number in out nocopy number
1482: ,p_grade_id in number default hr_api.g_number
1483: ,p_position_id in number default hr_api.g_number
1484: ,p_job_id in number default hr_api.g_number
1485: ,p_payroll_id in number default hr_api.g_number
1486: ,p_location_id in number default hr_api.g_number
1487: ,p_special_ceiling_step_id in out nocopy number
1488: ,p_organization_id in number default hr_api.g_number
1489: ,p_pay_basis_id in number default hr_api.g_number
1482: ,p_grade_id in number default hr_api.g_number
1483: ,p_position_id in number default hr_api.g_number
1484: ,p_job_id in number default hr_api.g_number
1485: ,p_payroll_id in number default hr_api.g_number
1486: ,p_location_id in number default hr_api.g_number
1487: ,p_special_ceiling_step_id in out nocopy number
1488: ,p_organization_id in number default hr_api.g_number
1489: ,p_pay_basis_id in number default hr_api.g_number
1490: ,p_segment1 in varchar2 default hr_api.g_varchar2
1484: ,p_job_id in number default hr_api.g_number
1485: ,p_payroll_id in number default hr_api.g_number
1486: ,p_location_id in number default hr_api.g_number
1487: ,p_special_ceiling_step_id in out nocopy number
1488: ,p_organization_id in number default hr_api.g_number
1489: ,p_pay_basis_id in number default hr_api.g_number
1490: ,p_segment1 in varchar2 default hr_api.g_varchar2
1491: ,p_segment2 in varchar2 default hr_api.g_varchar2
1492: ,p_segment3 in varchar2 default hr_api.g_varchar2
1485: ,p_payroll_id in number default hr_api.g_number
1486: ,p_location_id in number default hr_api.g_number
1487: ,p_special_ceiling_step_id in out nocopy number
1488: ,p_organization_id in number default hr_api.g_number
1489: ,p_pay_basis_id in number default hr_api.g_number
1490: ,p_segment1 in varchar2 default hr_api.g_varchar2
1491: ,p_segment2 in varchar2 default hr_api.g_varchar2
1492: ,p_segment3 in varchar2 default hr_api.g_varchar2
1493: ,p_segment4 in varchar2 default hr_api.g_varchar2
1486: ,p_location_id in number default hr_api.g_number
1487: ,p_special_ceiling_step_id in out nocopy number
1488: ,p_organization_id in number default hr_api.g_number
1489: ,p_pay_basis_id in number default hr_api.g_number
1490: ,p_segment1 in varchar2 default hr_api.g_varchar2
1491: ,p_segment2 in varchar2 default hr_api.g_varchar2
1492: ,p_segment3 in varchar2 default hr_api.g_varchar2
1493: ,p_segment4 in varchar2 default hr_api.g_varchar2
1494: ,p_segment5 in varchar2 default hr_api.g_varchar2
1487: ,p_special_ceiling_step_id in out nocopy number
1488: ,p_organization_id in number default hr_api.g_number
1489: ,p_pay_basis_id in number default hr_api.g_number
1490: ,p_segment1 in varchar2 default hr_api.g_varchar2
1491: ,p_segment2 in varchar2 default hr_api.g_varchar2
1492: ,p_segment3 in varchar2 default hr_api.g_varchar2
1493: ,p_segment4 in varchar2 default hr_api.g_varchar2
1494: ,p_segment5 in varchar2 default hr_api.g_varchar2
1495: ,p_segment6 in varchar2 default hr_api.g_varchar2
1488: ,p_organization_id in number default hr_api.g_number
1489: ,p_pay_basis_id in number default hr_api.g_number
1490: ,p_segment1 in varchar2 default hr_api.g_varchar2
1491: ,p_segment2 in varchar2 default hr_api.g_varchar2
1492: ,p_segment3 in varchar2 default hr_api.g_varchar2
1493: ,p_segment4 in varchar2 default hr_api.g_varchar2
1494: ,p_segment5 in varchar2 default hr_api.g_varchar2
1495: ,p_segment6 in varchar2 default hr_api.g_varchar2
1496: ,p_segment7 in varchar2 default hr_api.g_varchar2
1489: ,p_pay_basis_id in number default hr_api.g_number
1490: ,p_segment1 in varchar2 default hr_api.g_varchar2
1491: ,p_segment2 in varchar2 default hr_api.g_varchar2
1492: ,p_segment3 in varchar2 default hr_api.g_varchar2
1493: ,p_segment4 in varchar2 default hr_api.g_varchar2
1494: ,p_segment5 in varchar2 default hr_api.g_varchar2
1495: ,p_segment6 in varchar2 default hr_api.g_varchar2
1496: ,p_segment7 in varchar2 default hr_api.g_varchar2
1497: ,p_segment8 in varchar2 default hr_api.g_varchar2
1490: ,p_segment1 in varchar2 default hr_api.g_varchar2
1491: ,p_segment2 in varchar2 default hr_api.g_varchar2
1492: ,p_segment3 in varchar2 default hr_api.g_varchar2
1493: ,p_segment4 in varchar2 default hr_api.g_varchar2
1494: ,p_segment5 in varchar2 default hr_api.g_varchar2
1495: ,p_segment6 in varchar2 default hr_api.g_varchar2
1496: ,p_segment7 in varchar2 default hr_api.g_varchar2
1497: ,p_segment8 in varchar2 default hr_api.g_varchar2
1498: ,p_segment9 in varchar2 default hr_api.g_varchar2
1491: ,p_segment2 in varchar2 default hr_api.g_varchar2
1492: ,p_segment3 in varchar2 default hr_api.g_varchar2
1493: ,p_segment4 in varchar2 default hr_api.g_varchar2
1494: ,p_segment5 in varchar2 default hr_api.g_varchar2
1495: ,p_segment6 in varchar2 default hr_api.g_varchar2
1496: ,p_segment7 in varchar2 default hr_api.g_varchar2
1497: ,p_segment8 in varchar2 default hr_api.g_varchar2
1498: ,p_segment9 in varchar2 default hr_api.g_varchar2
1499: ,p_segment10 in varchar2 default hr_api.g_varchar2
1492: ,p_segment3 in varchar2 default hr_api.g_varchar2
1493: ,p_segment4 in varchar2 default hr_api.g_varchar2
1494: ,p_segment5 in varchar2 default hr_api.g_varchar2
1495: ,p_segment6 in varchar2 default hr_api.g_varchar2
1496: ,p_segment7 in varchar2 default hr_api.g_varchar2
1497: ,p_segment8 in varchar2 default hr_api.g_varchar2
1498: ,p_segment9 in varchar2 default hr_api.g_varchar2
1499: ,p_segment10 in varchar2 default hr_api.g_varchar2
1500: ,p_segment11 in varchar2 default hr_api.g_varchar2
1493: ,p_segment4 in varchar2 default hr_api.g_varchar2
1494: ,p_segment5 in varchar2 default hr_api.g_varchar2
1495: ,p_segment6 in varchar2 default hr_api.g_varchar2
1496: ,p_segment7 in varchar2 default hr_api.g_varchar2
1497: ,p_segment8 in varchar2 default hr_api.g_varchar2
1498: ,p_segment9 in varchar2 default hr_api.g_varchar2
1499: ,p_segment10 in varchar2 default hr_api.g_varchar2
1500: ,p_segment11 in varchar2 default hr_api.g_varchar2
1501: ,p_segment12 in varchar2 default hr_api.g_varchar2
1494: ,p_segment5 in varchar2 default hr_api.g_varchar2
1495: ,p_segment6 in varchar2 default hr_api.g_varchar2
1496: ,p_segment7 in varchar2 default hr_api.g_varchar2
1497: ,p_segment8 in varchar2 default hr_api.g_varchar2
1498: ,p_segment9 in varchar2 default hr_api.g_varchar2
1499: ,p_segment10 in varchar2 default hr_api.g_varchar2
1500: ,p_segment11 in varchar2 default hr_api.g_varchar2
1501: ,p_segment12 in varchar2 default hr_api.g_varchar2
1502: ,p_segment13 in varchar2 default hr_api.g_varchar2
1495: ,p_segment6 in varchar2 default hr_api.g_varchar2
1496: ,p_segment7 in varchar2 default hr_api.g_varchar2
1497: ,p_segment8 in varchar2 default hr_api.g_varchar2
1498: ,p_segment9 in varchar2 default hr_api.g_varchar2
1499: ,p_segment10 in varchar2 default hr_api.g_varchar2
1500: ,p_segment11 in varchar2 default hr_api.g_varchar2
1501: ,p_segment12 in varchar2 default hr_api.g_varchar2
1502: ,p_segment13 in varchar2 default hr_api.g_varchar2
1503: ,p_segment14 in varchar2 default hr_api.g_varchar2
1496: ,p_segment7 in varchar2 default hr_api.g_varchar2
1497: ,p_segment8 in varchar2 default hr_api.g_varchar2
1498: ,p_segment9 in varchar2 default hr_api.g_varchar2
1499: ,p_segment10 in varchar2 default hr_api.g_varchar2
1500: ,p_segment11 in varchar2 default hr_api.g_varchar2
1501: ,p_segment12 in varchar2 default hr_api.g_varchar2
1502: ,p_segment13 in varchar2 default hr_api.g_varchar2
1503: ,p_segment14 in varchar2 default hr_api.g_varchar2
1504: ,p_segment15 in varchar2 default hr_api.g_varchar2
1497: ,p_segment8 in varchar2 default hr_api.g_varchar2
1498: ,p_segment9 in varchar2 default hr_api.g_varchar2
1499: ,p_segment10 in varchar2 default hr_api.g_varchar2
1500: ,p_segment11 in varchar2 default hr_api.g_varchar2
1501: ,p_segment12 in varchar2 default hr_api.g_varchar2
1502: ,p_segment13 in varchar2 default hr_api.g_varchar2
1503: ,p_segment14 in varchar2 default hr_api.g_varchar2
1504: ,p_segment15 in varchar2 default hr_api.g_varchar2
1505: ,p_segment16 in varchar2 default hr_api.g_varchar2
1498: ,p_segment9 in varchar2 default hr_api.g_varchar2
1499: ,p_segment10 in varchar2 default hr_api.g_varchar2
1500: ,p_segment11 in varchar2 default hr_api.g_varchar2
1501: ,p_segment12 in varchar2 default hr_api.g_varchar2
1502: ,p_segment13 in varchar2 default hr_api.g_varchar2
1503: ,p_segment14 in varchar2 default hr_api.g_varchar2
1504: ,p_segment15 in varchar2 default hr_api.g_varchar2
1505: ,p_segment16 in varchar2 default hr_api.g_varchar2
1506: ,p_segment17 in varchar2 default hr_api.g_varchar2
1499: ,p_segment10 in varchar2 default hr_api.g_varchar2
1500: ,p_segment11 in varchar2 default hr_api.g_varchar2
1501: ,p_segment12 in varchar2 default hr_api.g_varchar2
1502: ,p_segment13 in varchar2 default hr_api.g_varchar2
1503: ,p_segment14 in varchar2 default hr_api.g_varchar2
1504: ,p_segment15 in varchar2 default hr_api.g_varchar2
1505: ,p_segment16 in varchar2 default hr_api.g_varchar2
1506: ,p_segment17 in varchar2 default hr_api.g_varchar2
1507: ,p_segment18 in varchar2 default hr_api.g_varchar2
1500: ,p_segment11 in varchar2 default hr_api.g_varchar2
1501: ,p_segment12 in varchar2 default hr_api.g_varchar2
1502: ,p_segment13 in varchar2 default hr_api.g_varchar2
1503: ,p_segment14 in varchar2 default hr_api.g_varchar2
1504: ,p_segment15 in varchar2 default hr_api.g_varchar2
1505: ,p_segment16 in varchar2 default hr_api.g_varchar2
1506: ,p_segment17 in varchar2 default hr_api.g_varchar2
1507: ,p_segment18 in varchar2 default hr_api.g_varchar2
1508: ,p_segment19 in varchar2 default hr_api.g_varchar2
1501: ,p_segment12 in varchar2 default hr_api.g_varchar2
1502: ,p_segment13 in varchar2 default hr_api.g_varchar2
1503: ,p_segment14 in varchar2 default hr_api.g_varchar2
1504: ,p_segment15 in varchar2 default hr_api.g_varchar2
1505: ,p_segment16 in varchar2 default hr_api.g_varchar2
1506: ,p_segment17 in varchar2 default hr_api.g_varchar2
1507: ,p_segment18 in varchar2 default hr_api.g_varchar2
1508: ,p_segment19 in varchar2 default hr_api.g_varchar2
1509: ,p_segment20 in varchar2 default hr_api.g_varchar2
1502: ,p_segment13 in varchar2 default hr_api.g_varchar2
1503: ,p_segment14 in varchar2 default hr_api.g_varchar2
1504: ,p_segment15 in varchar2 default hr_api.g_varchar2
1505: ,p_segment16 in varchar2 default hr_api.g_varchar2
1506: ,p_segment17 in varchar2 default hr_api.g_varchar2
1507: ,p_segment18 in varchar2 default hr_api.g_varchar2
1508: ,p_segment19 in varchar2 default hr_api.g_varchar2
1509: ,p_segment20 in varchar2 default hr_api.g_varchar2
1510: ,p_segment21 in varchar2 default hr_api.g_varchar2
1503: ,p_segment14 in varchar2 default hr_api.g_varchar2
1504: ,p_segment15 in varchar2 default hr_api.g_varchar2
1505: ,p_segment16 in varchar2 default hr_api.g_varchar2
1506: ,p_segment17 in varchar2 default hr_api.g_varchar2
1507: ,p_segment18 in varchar2 default hr_api.g_varchar2
1508: ,p_segment19 in varchar2 default hr_api.g_varchar2
1509: ,p_segment20 in varchar2 default hr_api.g_varchar2
1510: ,p_segment21 in varchar2 default hr_api.g_varchar2
1511: ,p_segment22 in varchar2 default hr_api.g_varchar2
1504: ,p_segment15 in varchar2 default hr_api.g_varchar2
1505: ,p_segment16 in varchar2 default hr_api.g_varchar2
1506: ,p_segment17 in varchar2 default hr_api.g_varchar2
1507: ,p_segment18 in varchar2 default hr_api.g_varchar2
1508: ,p_segment19 in varchar2 default hr_api.g_varchar2
1509: ,p_segment20 in varchar2 default hr_api.g_varchar2
1510: ,p_segment21 in varchar2 default hr_api.g_varchar2
1511: ,p_segment22 in varchar2 default hr_api.g_varchar2
1512: ,p_segment23 in varchar2 default hr_api.g_varchar2
1505: ,p_segment16 in varchar2 default hr_api.g_varchar2
1506: ,p_segment17 in varchar2 default hr_api.g_varchar2
1507: ,p_segment18 in varchar2 default hr_api.g_varchar2
1508: ,p_segment19 in varchar2 default hr_api.g_varchar2
1509: ,p_segment20 in varchar2 default hr_api.g_varchar2
1510: ,p_segment21 in varchar2 default hr_api.g_varchar2
1511: ,p_segment22 in varchar2 default hr_api.g_varchar2
1512: ,p_segment23 in varchar2 default hr_api.g_varchar2
1513: ,p_segment24 in varchar2 default hr_api.g_varchar2
1506: ,p_segment17 in varchar2 default hr_api.g_varchar2
1507: ,p_segment18 in varchar2 default hr_api.g_varchar2
1508: ,p_segment19 in varchar2 default hr_api.g_varchar2
1509: ,p_segment20 in varchar2 default hr_api.g_varchar2
1510: ,p_segment21 in varchar2 default hr_api.g_varchar2
1511: ,p_segment22 in varchar2 default hr_api.g_varchar2
1512: ,p_segment23 in varchar2 default hr_api.g_varchar2
1513: ,p_segment24 in varchar2 default hr_api.g_varchar2
1514: ,p_segment25 in varchar2 default hr_api.g_varchar2
1507: ,p_segment18 in varchar2 default hr_api.g_varchar2
1508: ,p_segment19 in varchar2 default hr_api.g_varchar2
1509: ,p_segment20 in varchar2 default hr_api.g_varchar2
1510: ,p_segment21 in varchar2 default hr_api.g_varchar2
1511: ,p_segment22 in varchar2 default hr_api.g_varchar2
1512: ,p_segment23 in varchar2 default hr_api.g_varchar2
1513: ,p_segment24 in varchar2 default hr_api.g_varchar2
1514: ,p_segment25 in varchar2 default hr_api.g_varchar2
1515: ,p_segment26 in varchar2 default hr_api.g_varchar2
1508: ,p_segment19 in varchar2 default hr_api.g_varchar2
1509: ,p_segment20 in varchar2 default hr_api.g_varchar2
1510: ,p_segment21 in varchar2 default hr_api.g_varchar2
1511: ,p_segment22 in varchar2 default hr_api.g_varchar2
1512: ,p_segment23 in varchar2 default hr_api.g_varchar2
1513: ,p_segment24 in varchar2 default hr_api.g_varchar2
1514: ,p_segment25 in varchar2 default hr_api.g_varchar2
1515: ,p_segment26 in varchar2 default hr_api.g_varchar2
1516: ,p_segment27 in varchar2 default hr_api.g_varchar2
1509: ,p_segment20 in varchar2 default hr_api.g_varchar2
1510: ,p_segment21 in varchar2 default hr_api.g_varchar2
1511: ,p_segment22 in varchar2 default hr_api.g_varchar2
1512: ,p_segment23 in varchar2 default hr_api.g_varchar2
1513: ,p_segment24 in varchar2 default hr_api.g_varchar2
1514: ,p_segment25 in varchar2 default hr_api.g_varchar2
1515: ,p_segment26 in varchar2 default hr_api.g_varchar2
1516: ,p_segment27 in varchar2 default hr_api.g_varchar2
1517: ,p_segment28 in varchar2 default hr_api.g_varchar2
1510: ,p_segment21 in varchar2 default hr_api.g_varchar2
1511: ,p_segment22 in varchar2 default hr_api.g_varchar2
1512: ,p_segment23 in varchar2 default hr_api.g_varchar2
1513: ,p_segment24 in varchar2 default hr_api.g_varchar2
1514: ,p_segment25 in varchar2 default hr_api.g_varchar2
1515: ,p_segment26 in varchar2 default hr_api.g_varchar2
1516: ,p_segment27 in varchar2 default hr_api.g_varchar2
1517: ,p_segment28 in varchar2 default hr_api.g_varchar2
1518: ,p_segment29 in varchar2 default hr_api.g_varchar2
1511: ,p_segment22 in varchar2 default hr_api.g_varchar2
1512: ,p_segment23 in varchar2 default hr_api.g_varchar2
1513: ,p_segment24 in varchar2 default hr_api.g_varchar2
1514: ,p_segment25 in varchar2 default hr_api.g_varchar2
1515: ,p_segment26 in varchar2 default hr_api.g_varchar2
1516: ,p_segment27 in varchar2 default hr_api.g_varchar2
1517: ,p_segment28 in varchar2 default hr_api.g_varchar2
1518: ,p_segment29 in varchar2 default hr_api.g_varchar2
1519: ,p_segment30 in varchar2 default hr_api.g_varchar2
1512: ,p_segment23 in varchar2 default hr_api.g_varchar2
1513: ,p_segment24 in varchar2 default hr_api.g_varchar2
1514: ,p_segment25 in varchar2 default hr_api.g_varchar2
1515: ,p_segment26 in varchar2 default hr_api.g_varchar2
1516: ,p_segment27 in varchar2 default hr_api.g_varchar2
1517: ,p_segment28 in varchar2 default hr_api.g_varchar2
1518: ,p_segment29 in varchar2 default hr_api.g_varchar2
1519: ,p_segment30 in varchar2 default hr_api.g_varchar2
1520: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1513: ,p_segment24 in varchar2 default hr_api.g_varchar2
1514: ,p_segment25 in varchar2 default hr_api.g_varchar2
1515: ,p_segment26 in varchar2 default hr_api.g_varchar2
1516: ,p_segment27 in varchar2 default hr_api.g_varchar2
1517: ,p_segment28 in varchar2 default hr_api.g_varchar2
1518: ,p_segment29 in varchar2 default hr_api.g_varchar2
1519: ,p_segment30 in varchar2 default hr_api.g_varchar2
1520: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1521: ,p_group_name out nocopy varchar2
1514: ,p_segment25 in varchar2 default hr_api.g_varchar2
1515: ,p_segment26 in varchar2 default hr_api.g_varchar2
1516: ,p_segment27 in varchar2 default hr_api.g_varchar2
1517: ,p_segment28 in varchar2 default hr_api.g_varchar2
1518: ,p_segment29 in varchar2 default hr_api.g_varchar2
1519: ,p_segment30 in varchar2 default hr_api.g_varchar2
1520: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1521: ,p_group_name out nocopy varchar2
1522: ,p_employment_category in varchar2 default hr_api.g_varchar2
1515: ,p_segment26 in varchar2 default hr_api.g_varchar2
1516: ,p_segment27 in varchar2 default hr_api.g_varchar2
1517: ,p_segment28 in varchar2 default hr_api.g_varchar2
1518: ,p_segment29 in varchar2 default hr_api.g_varchar2
1519: ,p_segment30 in varchar2 default hr_api.g_varchar2
1520: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1521: ,p_group_name out nocopy varchar2
1522: ,p_employment_category in varchar2 default hr_api.g_varchar2
1523: ,p_effective_start_date out nocopy date
1516: ,p_segment27 in varchar2 default hr_api.g_varchar2
1517: ,p_segment28 in varchar2 default hr_api.g_varchar2
1518: ,p_segment29 in varchar2 default hr_api.g_varchar2
1519: ,p_segment30 in varchar2 default hr_api.g_varchar2
1520: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1521: ,p_group_name out nocopy varchar2
1522: ,p_employment_category in varchar2 default hr_api.g_varchar2
1523: ,p_effective_start_date out nocopy date
1524: ,p_effective_end_date out nocopy date
1518: ,p_segment29 in varchar2 default hr_api.g_varchar2
1519: ,p_segment30 in varchar2 default hr_api.g_varchar2
1520: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1521: ,p_group_name out nocopy varchar2
1522: ,p_employment_category in varchar2 default hr_api.g_varchar2
1523: ,p_effective_start_date out nocopy date
1524: ,p_effective_end_date out nocopy date
1525: ,p_people_group_id out nocopy number
1526: ,p_entries_changed_warning out nocopy varchar2
1564: --
1565: -- Convert constant values to their corresponding boolean value
1566: --
1567: l_validate :=
1568: hr_api.constant_to_boolean
1569: (p_constant_value => p_validate);
1570: --
1571: -- Register Surrogate ID or user key values
1572: --