DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_SWI dependencies on HR_API

Line 16: ,p_change_reason in varchar2 default hr_api.g_varchar2

12: (p_effective_date in date
13: ,p_datetrack_update_mode in out nocopy varchar2
14: ,p_assignment_status_type_id in number
15: ,p_assignment_id in number
16: ,p_change_reason in varchar2 default hr_api.g_varchar2
17: ,p_object_version_number in out nocopy number
18: ,p_effective_start_date out nocopy date
19: ,p_effective_end_date out nocopy date
20: ) RETURN BOOLEAN is

Line 239: (p_validate in number default hr_api.g_false_num

235: -- ----------------------------------------------------------------------------
236: -- |-----------------------< create_secondary_apl_asg >-----------------------|
237: -- ----------------------------------------------------------------------------
238: PROCEDURE create_secondary_apl_asg
239: (p_validate in number default hr_api.g_false_num
240: ,p_effective_date in date
241: ,p_person_id in number
242: ,p_organization_id in number
243: ,p_recruiter_id in number default null

Line 365: hr_api.constant_to_boolean

361: --
362: -- Convert constant values to their corresponding boolean value
363: --
364: l_validate :=
365: hr_api.constant_to_boolean
366: (p_constant_value => p_validate);
367: --
368: -- Register Surrogate ID or user key values
369: --

Line 543: (p_validate in number default hr_api.g_false_num

539: -- ----------------------------------------------------------------------------
540: -- |----------------------------< accept_apl_asg >----------------------------|
541: -- ----------------------------------------------------------------------------
542: PROCEDURE accept_apl_asg
543: (p_validate in number default hr_api.g_false_num
544: ,p_effective_date in date
545: ,p_datetrack_update_mode in varchar2
546: ,p_assignment_id in number
547: ,p_object_version_number in out nocopy number

Line 548: ,p_assignment_status_type_id in number default hr_api.g_number

544: ,p_effective_date in date
545: ,p_datetrack_update_mode in varchar2
546: ,p_assignment_id in number
547: ,p_object_version_number in out nocopy number
548: ,p_assignment_status_type_id in number default hr_api.g_number
549: ,p_change_reason in varchar2 default hr_api.g_varchar2
550: ,p_effective_start_date out nocopy date
551: ,p_effective_end_date out nocopy date
552: ,p_return_status out nocopy varchar2

Line 549: ,p_change_reason in varchar2 default hr_api.g_varchar2

545: ,p_datetrack_update_mode in varchar2
546: ,p_assignment_id in number
547: ,p_object_version_number in out nocopy number
548: ,p_assignment_status_type_id in number default hr_api.g_number
549: ,p_change_reason in varchar2 default hr_api.g_varchar2
550: ,p_effective_start_date out nocopy date
551: ,p_effective_end_date out nocopy date
552: ,p_return_status out nocopy varchar2
553: ) is

Line 581: hr_api.constant_to_boolean

577: --
578: -- Convert constant values to their corresponding boolean value
579: --
580: l_validate :=
581: hr_api.constant_to_boolean
582: (p_constant_value => p_validate);
583: --
584: -- Register Surrogate ID or user key values
585: --

Line 657: (p_validate in number default hr_api.g_false_num

653: -- ----------------------------------------------------------------------------
654: -- |---------------------------< activate_apl_asg >---------------------------|
655: -- ----------------------------------------------------------------------------
656: PROCEDURE activate_apl_asg
657: (p_validate in number default hr_api.g_false_num
658: ,p_effective_date in date
659: ,p_datetrack_update_mode in varchar2
660: ,p_assignment_id in number
661: ,p_object_version_number in out nocopy number

Line 662: ,p_assignment_status_type_id in number default hr_api.g_number

658: ,p_effective_date in date
659: ,p_datetrack_update_mode in varchar2
660: ,p_assignment_id in number
661: ,p_object_version_number in out nocopy number
662: ,p_assignment_status_type_id in number default hr_api.g_number
663: ,p_change_reason in varchar2 default hr_api.g_varchar2
664: ,p_effective_start_date out nocopy date
665: ,p_effective_end_date out nocopy date
666: ,p_return_status out nocopy varchar2

Line 663: ,p_change_reason in varchar2 default hr_api.g_varchar2

659: ,p_datetrack_update_mode in varchar2
660: ,p_assignment_id in number
661: ,p_object_version_number in out nocopy number
662: ,p_assignment_status_type_id in number default hr_api.g_number
663: ,p_change_reason in varchar2 default hr_api.g_varchar2
664: ,p_effective_start_date out nocopy date
665: ,p_effective_end_date out nocopy date
666: ,p_return_status out nocopy varchar2
667: ) is

Line 695: hr_api.constant_to_boolean

691: --
692: -- Convert constant values to their corresponding boolean value
693: --
694: l_validate :=
695: hr_api.constant_to_boolean
696: (p_constant_value => p_validate);
697: --
698: -- Register Surrogate ID or user key values
699: --

Line 771: (p_validate in number default hr_api.g_false_num

767: -- ----------------------------------------------------------------------------
768: -- |-----------------------------< offer_apl_asg >----------------------------|
769: -- ----------------------------------------------------------------------------
770: PROCEDURE offer_apl_asg
771: (p_validate in number default hr_api.g_false_num
772: ,p_effective_date in date
773: ,p_datetrack_update_mode in varchar2
774: ,p_assignment_id in number
775: ,p_object_version_number in out nocopy number

Line 776: ,p_assignment_status_type_id in number default hr_api.g_number

772: ,p_effective_date in date
773: ,p_datetrack_update_mode in varchar2
774: ,p_assignment_id in number
775: ,p_object_version_number in out nocopy number
776: ,p_assignment_status_type_id in number default hr_api.g_number
777: ,p_change_reason in varchar2 default hr_api.g_varchar2
778: ,p_effective_start_date out nocopy date
779: ,p_effective_end_date out nocopy date
780: ,p_return_status out nocopy varchar2

Line 777: ,p_change_reason in varchar2 default hr_api.g_varchar2

773: ,p_datetrack_update_mode in varchar2
774: ,p_assignment_id in number
775: ,p_object_version_number in out nocopy number
776: ,p_assignment_status_type_id in number default hr_api.g_number
777: ,p_change_reason in varchar2 default hr_api.g_varchar2
778: ,p_effective_start_date out nocopy date
779: ,p_effective_end_date out nocopy date
780: ,p_return_status out nocopy varchar2
781: ) is

Line 809: hr_api.constant_to_boolean

805: --
806: -- Convert constant values to their corresponding boolean value
807: --
808: l_validate :=
809: hr_api.constant_to_boolean
810: (p_constant_value => p_validate);
811: --
812: -- Register Surrogate ID or user key values
813: --

Line 885: (p_validate in number default hr_api.g_false_num

881: -- ----------------------------------------------------------------------------
882: -- |---------------------------< terminate_apl_asg >--------------------------|
883: -- ----------------------------------------------------------------------------
884: PROCEDURE terminate_apl_asg
885: (p_validate in number default hr_api.g_false_num
886: ,p_effective_date in date
887: ,p_assignment_id in number
888: ,p_object_version_number in out nocopy number
889: ,p_effective_start_date out nocopy date

Line 920: hr_api.constant_to_boolean

916: --
917: -- Convert constant values to their corresponding boolean value
918: --
919: l_validate :=
920: hr_api.constant_to_boolean
921: (p_constant_value => p_validate);
922: --
923: -- Register Surrogate ID or user key values
924: --

Line 993: (p_validate in number default hr_api.g_false_num

989: -- ----------------------------------------------------------------------------
990: -- |----------------------------< update_apl_asg >----------------------------|
991: -- ----------------------------------------------------------------------------
992: PROCEDURE update_apl_asg
993: (p_validate in number default hr_api.g_false_num
994: ,p_effective_date in date
995: ,p_datetrack_update_mode in varchar2
996: ,p_assignment_id in number
997: ,p_object_version_number in out nocopy number

Line 998: ,p_recruiter_id in number default hr_api.g_number

994: ,p_effective_date in date
995: ,p_datetrack_update_mode in varchar2
996: ,p_assignment_id in number
997: ,p_object_version_number in out nocopy number
998: ,p_recruiter_id in number default hr_api.g_number
999: ,p_grade_id in number default hr_api.g_number
1000: ,p_position_id in number default hr_api.g_number
1001: ,p_job_id in number default hr_api.g_number
1002: ,p_payroll_id in number default hr_api.g_number

Line 999: ,p_grade_id in number default hr_api.g_number

995: ,p_datetrack_update_mode in varchar2
996: ,p_assignment_id in number
997: ,p_object_version_number in out nocopy number
998: ,p_recruiter_id in number default hr_api.g_number
999: ,p_grade_id in number default hr_api.g_number
1000: ,p_position_id in number default hr_api.g_number
1001: ,p_job_id in number default hr_api.g_number
1002: ,p_payroll_id in number default hr_api.g_number
1003: ,p_location_id in number default hr_api.g_number

Line 1000: ,p_position_id in number default hr_api.g_number

996: ,p_assignment_id in number
997: ,p_object_version_number in out nocopy number
998: ,p_recruiter_id in number default hr_api.g_number
999: ,p_grade_id in number default hr_api.g_number
1000: ,p_position_id in number default hr_api.g_number
1001: ,p_job_id in number default hr_api.g_number
1002: ,p_payroll_id in number default hr_api.g_number
1003: ,p_location_id in number default hr_api.g_number
1004: ,p_person_referred_by_id in number default hr_api.g_number

Line 1001: ,p_job_id in number default hr_api.g_number

997: ,p_object_version_number in out nocopy number
998: ,p_recruiter_id in number default hr_api.g_number
999: ,p_grade_id in number default hr_api.g_number
1000: ,p_position_id in number default hr_api.g_number
1001: ,p_job_id in number default hr_api.g_number
1002: ,p_payroll_id in number default hr_api.g_number
1003: ,p_location_id in number default hr_api.g_number
1004: ,p_person_referred_by_id in number default hr_api.g_number
1005: ,p_supervisor_id in number default hr_api.g_number

Line 1002: ,p_payroll_id in number default hr_api.g_number

998: ,p_recruiter_id in number default hr_api.g_number
999: ,p_grade_id in number default hr_api.g_number
1000: ,p_position_id in number default hr_api.g_number
1001: ,p_job_id in number default hr_api.g_number
1002: ,p_payroll_id in number default hr_api.g_number
1003: ,p_location_id in number default hr_api.g_number
1004: ,p_person_referred_by_id in number default hr_api.g_number
1005: ,p_supervisor_id in number default hr_api.g_number
1006: ,p_special_ceiling_step_id in number default hr_api.g_number

Line 1003: ,p_location_id in number default hr_api.g_number

999: ,p_grade_id in number default hr_api.g_number
1000: ,p_position_id in number default hr_api.g_number
1001: ,p_job_id in number default hr_api.g_number
1002: ,p_payroll_id in number default hr_api.g_number
1003: ,p_location_id in number default hr_api.g_number
1004: ,p_person_referred_by_id in number default hr_api.g_number
1005: ,p_supervisor_id in number default hr_api.g_number
1006: ,p_special_ceiling_step_id in number default hr_api.g_number
1007: ,p_recruitment_activity_id in number default hr_api.g_number

Line 1004: ,p_person_referred_by_id in number default hr_api.g_number

1000: ,p_position_id in number default hr_api.g_number
1001: ,p_job_id in number default hr_api.g_number
1002: ,p_payroll_id in number default hr_api.g_number
1003: ,p_location_id in number default hr_api.g_number
1004: ,p_person_referred_by_id in number default hr_api.g_number
1005: ,p_supervisor_id in number default hr_api.g_number
1006: ,p_special_ceiling_step_id in number default hr_api.g_number
1007: ,p_recruitment_activity_id in number default hr_api.g_number
1008: ,p_source_organization_id in number default hr_api.g_number

Line 1005: ,p_supervisor_id in number default hr_api.g_number

1001: ,p_job_id in number default hr_api.g_number
1002: ,p_payroll_id in number default hr_api.g_number
1003: ,p_location_id in number default hr_api.g_number
1004: ,p_person_referred_by_id in number default hr_api.g_number
1005: ,p_supervisor_id in number default hr_api.g_number
1006: ,p_special_ceiling_step_id in number default hr_api.g_number
1007: ,p_recruitment_activity_id in number default hr_api.g_number
1008: ,p_source_organization_id in number default hr_api.g_number
1009: ,p_organization_id in number default hr_api.g_number

Line 1006: ,p_special_ceiling_step_id in number default hr_api.g_number

1002: ,p_payroll_id in number default hr_api.g_number
1003: ,p_location_id in number default hr_api.g_number
1004: ,p_person_referred_by_id in number default hr_api.g_number
1005: ,p_supervisor_id in number default hr_api.g_number
1006: ,p_special_ceiling_step_id in number default hr_api.g_number
1007: ,p_recruitment_activity_id in number default hr_api.g_number
1008: ,p_source_organization_id in number default hr_api.g_number
1009: ,p_organization_id in number default hr_api.g_number
1010: ,p_vacancy_id in number default hr_api.g_number

Line 1007: ,p_recruitment_activity_id in number default hr_api.g_number

1003: ,p_location_id in number default hr_api.g_number
1004: ,p_person_referred_by_id in number default hr_api.g_number
1005: ,p_supervisor_id in number default hr_api.g_number
1006: ,p_special_ceiling_step_id in number default hr_api.g_number
1007: ,p_recruitment_activity_id in number default hr_api.g_number
1008: ,p_source_organization_id in number default hr_api.g_number
1009: ,p_organization_id in number default hr_api.g_number
1010: ,p_vacancy_id in number default hr_api.g_number
1011: ,p_pay_basis_id in number default hr_api.g_number

Line 1008: ,p_source_organization_id in number default hr_api.g_number

1004: ,p_person_referred_by_id in number default hr_api.g_number
1005: ,p_supervisor_id in number default hr_api.g_number
1006: ,p_special_ceiling_step_id in number default hr_api.g_number
1007: ,p_recruitment_activity_id in number default hr_api.g_number
1008: ,p_source_organization_id in number default hr_api.g_number
1009: ,p_organization_id in number default hr_api.g_number
1010: ,p_vacancy_id in number default hr_api.g_number
1011: ,p_pay_basis_id in number default hr_api.g_number
1012: ,p_application_id in number default hr_api.g_number

Line 1009: ,p_organization_id in number default hr_api.g_number

1005: ,p_supervisor_id in number default hr_api.g_number
1006: ,p_special_ceiling_step_id in number default hr_api.g_number
1007: ,p_recruitment_activity_id in number default hr_api.g_number
1008: ,p_source_organization_id in number default hr_api.g_number
1009: ,p_organization_id in number default hr_api.g_number
1010: ,p_vacancy_id in number default hr_api.g_number
1011: ,p_pay_basis_id in number default hr_api.g_number
1012: ,p_application_id in number default hr_api.g_number
1013: ,p_change_reason in varchar2 default hr_api.g_varchar2

Line 1010: ,p_vacancy_id in number default hr_api.g_number

1006: ,p_special_ceiling_step_id in number default hr_api.g_number
1007: ,p_recruitment_activity_id in number default hr_api.g_number
1008: ,p_source_organization_id in number default hr_api.g_number
1009: ,p_organization_id in number default hr_api.g_number
1010: ,p_vacancy_id in number default hr_api.g_number
1011: ,p_pay_basis_id in number default hr_api.g_number
1012: ,p_application_id in number default hr_api.g_number
1013: ,p_change_reason in varchar2 default hr_api.g_varchar2
1014: ,p_assignment_status_type_id in number default hr_api.g_number

Line 1011: ,p_pay_basis_id in number default hr_api.g_number

1007: ,p_recruitment_activity_id in number default hr_api.g_number
1008: ,p_source_organization_id in number default hr_api.g_number
1009: ,p_organization_id in number default hr_api.g_number
1010: ,p_vacancy_id in number default hr_api.g_number
1011: ,p_pay_basis_id in number default hr_api.g_number
1012: ,p_application_id in number default hr_api.g_number
1013: ,p_change_reason in varchar2 default hr_api.g_varchar2
1014: ,p_assignment_status_type_id in number default hr_api.g_number
1015: ,p_comments in varchar2 default hr_api.g_varchar2

Line 1012: ,p_application_id in number default hr_api.g_number

1008: ,p_source_organization_id in number default hr_api.g_number
1009: ,p_organization_id in number default hr_api.g_number
1010: ,p_vacancy_id in number default hr_api.g_number
1011: ,p_pay_basis_id in number default hr_api.g_number
1012: ,p_application_id in number default hr_api.g_number
1013: ,p_change_reason in varchar2 default hr_api.g_varchar2
1014: ,p_assignment_status_type_id in number default hr_api.g_number
1015: ,p_comments in varchar2 default hr_api.g_varchar2
1016: ,p_date_probation_end in date default hr_api.g_date

Line 1013: ,p_change_reason in varchar2 default hr_api.g_varchar2

1009: ,p_organization_id in number default hr_api.g_number
1010: ,p_vacancy_id in number default hr_api.g_number
1011: ,p_pay_basis_id in number default hr_api.g_number
1012: ,p_application_id in number default hr_api.g_number
1013: ,p_change_reason in varchar2 default hr_api.g_varchar2
1014: ,p_assignment_status_type_id in number default hr_api.g_number
1015: ,p_comments in varchar2 default hr_api.g_varchar2
1016: ,p_date_probation_end in date default hr_api.g_date
1017: ,p_default_code_comb_id in number default hr_api.g_number

Line 1014: ,p_assignment_status_type_id in number default hr_api.g_number

1010: ,p_vacancy_id in number default hr_api.g_number
1011: ,p_pay_basis_id in number default hr_api.g_number
1012: ,p_application_id in number default hr_api.g_number
1013: ,p_change_reason in varchar2 default hr_api.g_varchar2
1014: ,p_assignment_status_type_id in number default hr_api.g_number
1015: ,p_comments in varchar2 default hr_api.g_varchar2
1016: ,p_date_probation_end in date default hr_api.g_date
1017: ,p_default_code_comb_id in number default hr_api.g_number
1018: ,p_employment_category in varchar2 default hr_api.g_varchar2

Line 1015: ,p_comments in varchar2 default hr_api.g_varchar2

1011: ,p_pay_basis_id in number default hr_api.g_number
1012: ,p_application_id in number default hr_api.g_number
1013: ,p_change_reason in varchar2 default hr_api.g_varchar2
1014: ,p_assignment_status_type_id in number default hr_api.g_number
1015: ,p_comments in varchar2 default hr_api.g_varchar2
1016: ,p_date_probation_end in date default hr_api.g_date
1017: ,p_default_code_comb_id in number default hr_api.g_number
1018: ,p_employment_category in varchar2 default hr_api.g_varchar2
1019: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 1016: ,p_date_probation_end in date default hr_api.g_date

1012: ,p_application_id in number default hr_api.g_number
1013: ,p_change_reason in varchar2 default hr_api.g_varchar2
1014: ,p_assignment_status_type_id in number default hr_api.g_number
1015: ,p_comments in varchar2 default hr_api.g_varchar2
1016: ,p_date_probation_end in date default hr_api.g_date
1017: ,p_default_code_comb_id in number default hr_api.g_number
1018: ,p_employment_category in varchar2 default hr_api.g_varchar2
1019: ,p_frequency in varchar2 default hr_api.g_varchar2
1020: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

Line 1017: ,p_default_code_comb_id in number default hr_api.g_number

1013: ,p_change_reason in varchar2 default hr_api.g_varchar2
1014: ,p_assignment_status_type_id in number default hr_api.g_number
1015: ,p_comments in varchar2 default hr_api.g_varchar2
1016: ,p_date_probation_end in date default hr_api.g_date
1017: ,p_default_code_comb_id in number default hr_api.g_number
1018: ,p_employment_category in varchar2 default hr_api.g_varchar2
1019: ,p_frequency in varchar2 default hr_api.g_varchar2
1020: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1021: ,p_manager_flag in varchar2 default hr_api.g_varchar2

Line 1018: ,p_employment_category in varchar2 default hr_api.g_varchar2

1014: ,p_assignment_status_type_id in number default hr_api.g_number
1015: ,p_comments in varchar2 default hr_api.g_varchar2
1016: ,p_date_probation_end in date default hr_api.g_date
1017: ,p_default_code_comb_id in number default hr_api.g_number
1018: ,p_employment_category in varchar2 default hr_api.g_varchar2
1019: ,p_frequency in varchar2 default hr_api.g_varchar2
1020: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1021: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1022: ,p_normal_hours in number default hr_api.g_number

Line 1019: ,p_frequency in varchar2 default hr_api.g_varchar2

1015: ,p_comments in varchar2 default hr_api.g_varchar2
1016: ,p_date_probation_end in date default hr_api.g_date
1017: ,p_default_code_comb_id in number default hr_api.g_number
1018: ,p_employment_category in varchar2 default hr_api.g_varchar2
1019: ,p_frequency in varchar2 default hr_api.g_varchar2
1020: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1021: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1022: ,p_normal_hours in number default hr_api.g_number
1023: ,p_perf_review_period in number default hr_api.g_number

Line 1020: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

1016: ,p_date_probation_end in date default hr_api.g_date
1017: ,p_default_code_comb_id in number default hr_api.g_number
1018: ,p_employment_category in varchar2 default hr_api.g_varchar2
1019: ,p_frequency in varchar2 default hr_api.g_varchar2
1020: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1021: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1022: ,p_normal_hours in number default hr_api.g_number
1023: ,p_perf_review_period in number default hr_api.g_number
1024: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 1021: ,p_manager_flag in varchar2 default hr_api.g_varchar2

1017: ,p_default_code_comb_id in number default hr_api.g_number
1018: ,p_employment_category in varchar2 default hr_api.g_varchar2
1019: ,p_frequency in varchar2 default hr_api.g_varchar2
1020: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1021: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1022: ,p_normal_hours in number default hr_api.g_number
1023: ,p_perf_review_period in number default hr_api.g_number
1024: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1025: ,p_probation_period in number default hr_api.g_number

Line 1022: ,p_normal_hours in number default hr_api.g_number

1018: ,p_employment_category in varchar2 default hr_api.g_varchar2
1019: ,p_frequency in varchar2 default hr_api.g_varchar2
1020: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1021: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1022: ,p_normal_hours in number default hr_api.g_number
1023: ,p_perf_review_period in number default hr_api.g_number
1024: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1025: ,p_probation_period in number default hr_api.g_number
1026: ,p_probation_unit in varchar2 default hr_api.g_varchar2

Line 1023: ,p_perf_review_period in number default hr_api.g_number

1019: ,p_frequency in varchar2 default hr_api.g_varchar2
1020: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1021: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1022: ,p_normal_hours in number default hr_api.g_number
1023: ,p_perf_review_period in number default hr_api.g_number
1024: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1025: ,p_probation_period in number default hr_api.g_number
1026: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1027: ,p_sal_review_period in number default hr_api.g_number

Line 1024: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

1020: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1021: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1022: ,p_normal_hours in number default hr_api.g_number
1023: ,p_perf_review_period in number default hr_api.g_number
1024: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1025: ,p_probation_period in number default hr_api.g_number
1026: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1027: ,p_sal_review_period in number default hr_api.g_number
1028: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 1025: ,p_probation_period in number default hr_api.g_number

1021: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1022: ,p_normal_hours in number default hr_api.g_number
1023: ,p_perf_review_period in number default hr_api.g_number
1024: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1025: ,p_probation_period in number default hr_api.g_number
1026: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1027: ,p_sal_review_period in number default hr_api.g_number
1028: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1029: ,p_set_of_books_id in number default hr_api.g_number

Line 1026: ,p_probation_unit in varchar2 default hr_api.g_varchar2

1022: ,p_normal_hours in number default hr_api.g_number
1023: ,p_perf_review_period in number default hr_api.g_number
1024: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1025: ,p_probation_period in number default hr_api.g_number
1026: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1027: ,p_sal_review_period in number default hr_api.g_number
1028: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1029: ,p_set_of_books_id in number default hr_api.g_number
1030: ,p_source_type in varchar2 default hr_api.g_varchar2

Line 1027: ,p_sal_review_period in number default hr_api.g_number

1023: ,p_perf_review_period in number default hr_api.g_number
1024: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1025: ,p_probation_period in number default hr_api.g_number
1026: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1027: ,p_sal_review_period in number default hr_api.g_number
1028: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1029: ,p_set_of_books_id in number default hr_api.g_number
1030: ,p_source_type in varchar2 default hr_api.g_varchar2
1031: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

Line 1028: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

1024: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1025: ,p_probation_period in number default hr_api.g_number
1026: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1027: ,p_sal_review_period in number default hr_api.g_number
1028: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1029: ,p_set_of_books_id in number default hr_api.g_number
1030: ,p_source_type in varchar2 default hr_api.g_varchar2
1031: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1032: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

Line 1029: ,p_set_of_books_id in number default hr_api.g_number

1025: ,p_probation_period in number default hr_api.g_number
1026: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1027: ,p_sal_review_period in number default hr_api.g_number
1028: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1029: ,p_set_of_books_id in number default hr_api.g_number
1030: ,p_source_type in varchar2 default hr_api.g_varchar2
1031: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1032: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1033: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

Line 1030: ,p_source_type in varchar2 default hr_api.g_varchar2

1026: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1027: ,p_sal_review_period in number default hr_api.g_number
1028: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1029: ,p_set_of_books_id in number default hr_api.g_number
1030: ,p_source_type in varchar2 default hr_api.g_varchar2
1031: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1032: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1033: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1034: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

Line 1031: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

1027: ,p_sal_review_period in number default hr_api.g_number
1028: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1029: ,p_set_of_books_id in number default hr_api.g_number
1030: ,p_source_type in varchar2 default hr_api.g_varchar2
1031: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1032: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1033: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1034: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1035: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

Line 1032: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

1028: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1029: ,p_set_of_books_id in number default hr_api.g_number
1030: ,p_source_type in varchar2 default hr_api.g_varchar2
1031: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1032: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1033: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1034: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1035: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1036: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

Line 1033: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

1029: ,p_set_of_books_id in number default hr_api.g_number
1030: ,p_source_type in varchar2 default hr_api.g_varchar2
1031: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1032: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1033: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1034: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1035: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1036: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1037: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

Line 1034: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

1030: ,p_source_type in varchar2 default hr_api.g_varchar2
1031: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1032: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1033: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1034: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1035: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1036: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1037: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1038: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

Line 1035: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

1031: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1032: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1033: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1034: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1035: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1036: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1037: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1038: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1039: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

Line 1036: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

1032: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1033: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1034: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1035: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1036: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1037: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1038: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1039: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1040: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

Line 1037: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

1033: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1034: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1035: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1036: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1037: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1038: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1039: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1040: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1041: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

Line 1038: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

1034: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1035: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1036: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1037: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1038: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1039: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1040: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1041: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

Line 1039: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

1035: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1036: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1037: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1038: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1039: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1040: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1041: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

Line 1040: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

1036: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1037: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1038: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1039: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1040: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1041: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

Line 1041: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

1037: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1038: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1039: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1040: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1041: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

Line 1042: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

1038: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1039: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1040: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1041: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

Line 1043: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

1039: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1040: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1041: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

Line 1044: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

1040: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1041: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

Line 1045: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

1041: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

Line 1046: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

1042: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

Line 1047: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

1043: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

Line 1048: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

1044: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

Line 1049: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

1045: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

Line 1050: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

1046: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

Line 1051: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

1047: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

Line 1052: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

1048: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

Line 1053: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

1049: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

Line 1054: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

1050: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

Line 1055: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

1051: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

Line 1056: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

1052: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

Line 1057: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

1053: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

Line 1058: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

1054: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

Line 1059: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

1055: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1063: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

Line 1060: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

1056: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1063: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1064: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

Line 1061: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

1057: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1063: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1064: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1065: ,p_title in varchar2 default hr_api.g_varchar2

Line 1062: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

1058: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1063: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1064: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1065: ,p_title in varchar2 default hr_api.g_varchar2
1066: ,p_concatenated_segments out nocopy varchar2

Line 1063: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

1059: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1063: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1064: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1065: ,p_title in varchar2 default hr_api.g_varchar2
1066: ,p_concatenated_segments out nocopy varchar2
1067: ,p_contract_id in number default hr_api.g_number

Line 1064: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

1060: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1063: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1064: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1065: ,p_title in varchar2 default hr_api.g_varchar2
1066: ,p_concatenated_segments out nocopy varchar2
1067: ,p_contract_id in number default hr_api.g_number
1068: ,p_establishment_id in number default hr_api.g_number

Line 1065: ,p_title in varchar2 default hr_api.g_varchar2

1061: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1063: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1064: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1065: ,p_title in varchar2 default hr_api.g_varchar2
1066: ,p_concatenated_segments out nocopy varchar2
1067: ,p_contract_id in number default hr_api.g_number
1068: ,p_establishment_id in number default hr_api.g_number
1069: ,p_collective_agreement_id in number default hr_api.g_number

Line 1067: ,p_contract_id in number default hr_api.g_number

1063: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1064: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1065: ,p_title in varchar2 default hr_api.g_varchar2
1066: ,p_concatenated_segments out nocopy varchar2
1067: ,p_contract_id in number default hr_api.g_number
1068: ,p_establishment_id in number default hr_api.g_number
1069: ,p_collective_agreement_id in number default hr_api.g_number
1070: ,p_notice_period in number default hr_api.g_number
1071: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2

Line 1068: ,p_establishment_id in number default hr_api.g_number

1064: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1065: ,p_title in varchar2 default hr_api.g_varchar2
1066: ,p_concatenated_segments out nocopy varchar2
1067: ,p_contract_id in number default hr_api.g_number
1068: ,p_establishment_id in number default hr_api.g_number
1069: ,p_collective_agreement_id in number default hr_api.g_number
1070: ,p_notice_period in number default hr_api.g_number
1071: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1072: ,p_employee_category in varchar2 default hr_api.g_varchar2

Line 1069: ,p_collective_agreement_id in number default hr_api.g_number

1065: ,p_title in varchar2 default hr_api.g_varchar2
1066: ,p_concatenated_segments out nocopy varchar2
1067: ,p_contract_id in number default hr_api.g_number
1068: ,p_establishment_id in number default hr_api.g_number
1069: ,p_collective_agreement_id in number default hr_api.g_number
1070: ,p_notice_period in number default hr_api.g_number
1071: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1072: ,p_employee_category in varchar2 default hr_api.g_varchar2
1073: ,p_work_at_home in varchar2 default hr_api.g_varchar2

Line 1070: ,p_notice_period in number default hr_api.g_number

1066: ,p_concatenated_segments out nocopy varchar2
1067: ,p_contract_id in number default hr_api.g_number
1068: ,p_establishment_id in number default hr_api.g_number
1069: ,p_collective_agreement_id in number default hr_api.g_number
1070: ,p_notice_period in number default hr_api.g_number
1071: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1072: ,p_employee_category in varchar2 default hr_api.g_varchar2
1073: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1074: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

Line 1071: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2

1067: ,p_contract_id in number default hr_api.g_number
1068: ,p_establishment_id in number default hr_api.g_number
1069: ,p_collective_agreement_id in number default hr_api.g_number
1070: ,p_notice_period in number default hr_api.g_number
1071: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1072: ,p_employee_category in varchar2 default hr_api.g_varchar2
1073: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1074: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1075: ,p_posting_content_id in number default hr_api.g_number

Line 1072: ,p_employee_category in varchar2 default hr_api.g_varchar2

1068: ,p_establishment_id in number default hr_api.g_number
1069: ,p_collective_agreement_id in number default hr_api.g_number
1070: ,p_notice_period in number default hr_api.g_number
1071: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1072: ,p_employee_category in varchar2 default hr_api.g_varchar2
1073: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1074: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1075: ,p_posting_content_id in number default hr_api.g_number
1076: ,p_applicant_rank in number default hr_api.g_number

Line 1073: ,p_work_at_home in varchar2 default hr_api.g_varchar2

1069: ,p_collective_agreement_id in number default hr_api.g_number
1070: ,p_notice_period in number default hr_api.g_number
1071: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1072: ,p_employee_category in varchar2 default hr_api.g_varchar2
1073: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1074: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1075: ,p_posting_content_id in number default hr_api.g_number
1076: ,p_applicant_rank in number default hr_api.g_number
1077: ,p_cagr_grade_def_id in out nocopy number

Line 1074: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

1070: ,p_notice_period in number default hr_api.g_number
1071: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1072: ,p_employee_category in varchar2 default hr_api.g_varchar2
1073: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1074: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1075: ,p_posting_content_id in number default hr_api.g_number
1076: ,p_applicant_rank in number default hr_api.g_number
1077: ,p_cagr_grade_def_id in out nocopy number
1078: ,p_cagr_concatenated_segments out nocopy varchar2

Line 1075: ,p_posting_content_id in number default hr_api.g_number

1071: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1072: ,p_employee_category in varchar2 default hr_api.g_varchar2
1073: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1074: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1075: ,p_posting_content_id in number default hr_api.g_number
1076: ,p_applicant_rank in number default hr_api.g_number
1077: ,p_cagr_grade_def_id in out nocopy number
1078: ,p_cagr_concatenated_segments out nocopy varchar2
1079: ,p_group_name out nocopy varchar2

Line 1076: ,p_applicant_rank in number default hr_api.g_number

1072: ,p_employee_category in varchar2 default hr_api.g_varchar2
1073: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1074: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1075: ,p_posting_content_id in number default hr_api.g_number
1076: ,p_applicant_rank in number default hr_api.g_number
1077: ,p_cagr_grade_def_id in out nocopy number
1078: ,p_cagr_concatenated_segments out nocopy varchar2
1079: ,p_group_name out nocopy varchar2
1080: ,p_comment_id out nocopy number

Line 1130: hr_api.constant_to_boolean

1126: --
1127: -- Convert constant values to their corresponding boolean value
1128: --
1129: l_validate :=
1130: hr_api.constant_to_boolean
1131: (p_constant_value => p_validate);
1132: --
1133: -- Added for turn off key flex field validation
1134: l_add_struct.extend(1);

Line 1321: (p_validate in number default hr_api.g_false_num

1317: -- ----------------------------------------------------------------------------
1318: -- |----------------------------< update_emp_asg >----------------------------|
1319: -- ----------------------------------------------------------------------------
1320: PROCEDURE update_emp_asg
1321: (p_validate in number default hr_api.g_false_num
1322: ,p_effective_date in date
1323: ,p_datetrack_update_mode in varchar2
1324: ,p_assignment_id in number
1325: ,p_object_version_number in out nocopy number

Line 1326: ,p_supervisor_id in number default hr_api.g_number

1322: ,p_effective_date in date
1323: ,p_datetrack_update_mode in varchar2
1324: ,p_assignment_id in number
1325: ,p_object_version_number in out nocopy number
1326: ,p_supervisor_id in number default hr_api.g_number
1327: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1328: ,p_change_reason in varchar2 default hr_api.g_varchar2
1329: ,p_assignment_status_type_id in number default hr_api.g_number
1330: ,p_comments in varchar2 default hr_api.g_varchar2

Line 1327: ,p_assignment_number in varchar2 default hr_api.g_varchar2

1323: ,p_datetrack_update_mode in varchar2
1324: ,p_assignment_id in number
1325: ,p_object_version_number in out nocopy number
1326: ,p_supervisor_id in number default hr_api.g_number
1327: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1328: ,p_change_reason in varchar2 default hr_api.g_varchar2
1329: ,p_assignment_status_type_id in number default hr_api.g_number
1330: ,p_comments in varchar2 default hr_api.g_varchar2
1331: ,p_date_probation_end in date default hr_api.g_date

Line 1328: ,p_change_reason in varchar2 default hr_api.g_varchar2

1324: ,p_assignment_id in number
1325: ,p_object_version_number in out nocopy number
1326: ,p_supervisor_id in number default hr_api.g_number
1327: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1328: ,p_change_reason in varchar2 default hr_api.g_varchar2
1329: ,p_assignment_status_type_id in number default hr_api.g_number
1330: ,p_comments in varchar2 default hr_api.g_varchar2
1331: ,p_date_probation_end in date default hr_api.g_date
1332: ,p_default_code_comb_id in number default hr_api.g_number

Line 1329: ,p_assignment_status_type_id in number default hr_api.g_number

1325: ,p_object_version_number in out nocopy number
1326: ,p_supervisor_id in number default hr_api.g_number
1327: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1328: ,p_change_reason in varchar2 default hr_api.g_varchar2
1329: ,p_assignment_status_type_id in number default hr_api.g_number
1330: ,p_comments in varchar2 default hr_api.g_varchar2
1331: ,p_date_probation_end in date default hr_api.g_date
1332: ,p_default_code_comb_id in number default hr_api.g_number
1333: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 1330: ,p_comments in varchar2 default hr_api.g_varchar2

1326: ,p_supervisor_id in number default hr_api.g_number
1327: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1328: ,p_change_reason in varchar2 default hr_api.g_varchar2
1329: ,p_assignment_status_type_id in number default hr_api.g_number
1330: ,p_comments in varchar2 default hr_api.g_varchar2
1331: ,p_date_probation_end in date default hr_api.g_date
1332: ,p_default_code_comb_id in number default hr_api.g_number
1333: ,p_frequency in varchar2 default hr_api.g_varchar2
1334: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

Line 1331: ,p_date_probation_end in date default hr_api.g_date

1327: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1328: ,p_change_reason in varchar2 default hr_api.g_varchar2
1329: ,p_assignment_status_type_id in number default hr_api.g_number
1330: ,p_comments in varchar2 default hr_api.g_varchar2
1331: ,p_date_probation_end in date default hr_api.g_date
1332: ,p_default_code_comb_id in number default hr_api.g_number
1333: ,p_frequency in varchar2 default hr_api.g_varchar2
1334: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1335: ,p_manager_flag in varchar2 default hr_api.g_varchar2

Line 1332: ,p_default_code_comb_id in number default hr_api.g_number

1328: ,p_change_reason in varchar2 default hr_api.g_varchar2
1329: ,p_assignment_status_type_id in number default hr_api.g_number
1330: ,p_comments in varchar2 default hr_api.g_varchar2
1331: ,p_date_probation_end in date default hr_api.g_date
1332: ,p_default_code_comb_id in number default hr_api.g_number
1333: ,p_frequency in varchar2 default hr_api.g_varchar2
1334: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1335: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1336: ,p_normal_hours in number default hr_api.g_number

Line 1333: ,p_frequency in varchar2 default hr_api.g_varchar2

1329: ,p_assignment_status_type_id in number default hr_api.g_number
1330: ,p_comments in varchar2 default hr_api.g_varchar2
1331: ,p_date_probation_end in date default hr_api.g_date
1332: ,p_default_code_comb_id in number default hr_api.g_number
1333: ,p_frequency in varchar2 default hr_api.g_varchar2
1334: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1335: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1336: ,p_normal_hours in number default hr_api.g_number
1337: ,p_perf_review_period in number default hr_api.g_number

Line 1334: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

1330: ,p_comments in varchar2 default hr_api.g_varchar2
1331: ,p_date_probation_end in date default hr_api.g_date
1332: ,p_default_code_comb_id in number default hr_api.g_number
1333: ,p_frequency in varchar2 default hr_api.g_varchar2
1334: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1335: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1336: ,p_normal_hours in number default hr_api.g_number
1337: ,p_perf_review_period in number default hr_api.g_number
1338: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 1335: ,p_manager_flag in varchar2 default hr_api.g_varchar2

1331: ,p_date_probation_end in date default hr_api.g_date
1332: ,p_default_code_comb_id in number default hr_api.g_number
1333: ,p_frequency in varchar2 default hr_api.g_varchar2
1334: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1335: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1336: ,p_normal_hours in number default hr_api.g_number
1337: ,p_perf_review_period in number default hr_api.g_number
1338: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1339: ,p_probation_period in number default hr_api.g_number

Line 1336: ,p_normal_hours in number default hr_api.g_number

1332: ,p_default_code_comb_id in number default hr_api.g_number
1333: ,p_frequency in varchar2 default hr_api.g_varchar2
1334: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1335: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1336: ,p_normal_hours in number default hr_api.g_number
1337: ,p_perf_review_period in number default hr_api.g_number
1338: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1339: ,p_probation_period in number default hr_api.g_number
1340: ,p_probation_unit in varchar2 default hr_api.g_varchar2

Line 1337: ,p_perf_review_period in number default hr_api.g_number

1333: ,p_frequency in varchar2 default hr_api.g_varchar2
1334: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1335: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1336: ,p_normal_hours in number default hr_api.g_number
1337: ,p_perf_review_period in number default hr_api.g_number
1338: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1339: ,p_probation_period in number default hr_api.g_number
1340: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1341: ,p_sal_review_period in number default hr_api.g_number

Line 1338: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

1334: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1335: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1336: ,p_normal_hours in number default hr_api.g_number
1337: ,p_perf_review_period in number default hr_api.g_number
1338: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1339: ,p_probation_period in number default hr_api.g_number
1340: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1341: ,p_sal_review_period in number default hr_api.g_number
1342: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 1339: ,p_probation_period in number default hr_api.g_number

1335: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1336: ,p_normal_hours in number default hr_api.g_number
1337: ,p_perf_review_period in number default hr_api.g_number
1338: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1339: ,p_probation_period in number default hr_api.g_number
1340: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1341: ,p_sal_review_period in number default hr_api.g_number
1342: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1343: ,p_set_of_books_id in number default hr_api.g_number

Line 1340: ,p_probation_unit in varchar2 default hr_api.g_varchar2

1336: ,p_normal_hours in number default hr_api.g_number
1337: ,p_perf_review_period in number default hr_api.g_number
1338: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1339: ,p_probation_period in number default hr_api.g_number
1340: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1341: ,p_sal_review_period in number default hr_api.g_number
1342: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1343: ,p_set_of_books_id in number default hr_api.g_number
1344: ,p_source_type in varchar2 default hr_api.g_varchar2

Line 1341: ,p_sal_review_period in number default hr_api.g_number

1337: ,p_perf_review_period in number default hr_api.g_number
1338: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1339: ,p_probation_period in number default hr_api.g_number
1340: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1341: ,p_sal_review_period in number default hr_api.g_number
1342: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1343: ,p_set_of_books_id in number default hr_api.g_number
1344: ,p_source_type in varchar2 default hr_api.g_varchar2
1345: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

Line 1342: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

1338: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1339: ,p_probation_period in number default hr_api.g_number
1340: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1341: ,p_sal_review_period in number default hr_api.g_number
1342: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1343: ,p_set_of_books_id in number default hr_api.g_number
1344: ,p_source_type in varchar2 default hr_api.g_varchar2
1345: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1346: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

Line 1343: ,p_set_of_books_id in number default hr_api.g_number

1339: ,p_probation_period in number default hr_api.g_number
1340: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1341: ,p_sal_review_period in number default hr_api.g_number
1342: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1343: ,p_set_of_books_id in number default hr_api.g_number
1344: ,p_source_type in varchar2 default hr_api.g_varchar2
1345: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1346: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1347: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

Line 1344: ,p_source_type in varchar2 default hr_api.g_varchar2

1340: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1341: ,p_sal_review_period in number default hr_api.g_number
1342: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1343: ,p_set_of_books_id in number default hr_api.g_number
1344: ,p_source_type in varchar2 default hr_api.g_varchar2
1345: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1346: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1347: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1348: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

Line 1345: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

1341: ,p_sal_review_period in number default hr_api.g_number
1342: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1343: ,p_set_of_books_id in number default hr_api.g_number
1344: ,p_source_type in varchar2 default hr_api.g_varchar2
1345: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1346: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1347: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1348: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1349: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2

Line 1346: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

1342: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1343: ,p_set_of_books_id in number default hr_api.g_number
1344: ,p_source_type in varchar2 default hr_api.g_varchar2
1345: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1346: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1347: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1348: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1349: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1350: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

Line 1347: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

1343: ,p_set_of_books_id in number default hr_api.g_number
1344: ,p_source_type in varchar2 default hr_api.g_varchar2
1345: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1346: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1347: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1348: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1349: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1350: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1351: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

Line 1348: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

1344: ,p_source_type in varchar2 default hr_api.g_varchar2
1345: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1346: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1347: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1348: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1349: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1350: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1351: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1352: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

Line 1349: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2

1345: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1346: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1347: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1348: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1349: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1350: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1351: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1352: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1353: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

Line 1350: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

1346: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1347: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1348: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1349: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1350: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1351: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1352: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1353: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1354: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

Line 1351: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

1347: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1348: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1349: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1350: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1351: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1352: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1353: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1354: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1355: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

Line 1352: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

1348: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1349: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1350: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1351: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1352: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1353: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1354: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1355: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1356: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

Line 1353: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

1349: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1350: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1351: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1352: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1353: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1354: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1355: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1356: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1357: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

Line 1354: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

1350: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1351: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1352: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1353: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1354: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1355: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1356: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1357: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1358: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

Line 1355: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

1351: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1352: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1353: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1354: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1355: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1356: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1357: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1358: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1359: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

Line 1356: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

1352: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1353: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1354: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1355: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1356: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1357: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1358: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1359: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

Line 1357: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

1353: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1354: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1355: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1356: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1357: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1358: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1359: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

Line 1358: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

1354: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1355: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1356: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1357: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1358: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1359: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

Line 1359: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

1355: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1356: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1357: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1358: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1359: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

Line 1360: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

1356: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1357: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1358: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1359: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

Line 1361: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

1357: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1358: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1359: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

Line 1362: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

1358: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1359: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

Line 1363: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

1359: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

Line 1364: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

1360: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

Line 1365: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

1361: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

Line 1366: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

1362: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

Line 1367: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

1363: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

Line 1368: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

1364: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

Line 1369: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

1365: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

Line 1370: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

1366: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

Line 1371: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

1367: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

Line 1372: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

1368: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

Line 1373: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

1369: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

Line 1374: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

1370: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

Line 1375: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

1371: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

Line 1376: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

1372: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

Line 1377: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

1373: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1381: ,p_title in varchar2 default hr_api.g_varchar2

Line 1378: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

1374: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1381: ,p_title in varchar2 default hr_api.g_varchar2
1382: ,p_segment1 in varchar2 default hr_api.g_varchar2

Line 1379: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

1375: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1381: ,p_title in varchar2 default hr_api.g_varchar2
1382: ,p_segment1 in varchar2 default hr_api.g_varchar2
1383: ,p_segment2 in varchar2 default hr_api.g_varchar2

Line 1380: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

1376: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1381: ,p_title in varchar2 default hr_api.g_varchar2
1382: ,p_segment1 in varchar2 default hr_api.g_varchar2
1383: ,p_segment2 in varchar2 default hr_api.g_varchar2
1384: ,p_segment3 in varchar2 default hr_api.g_varchar2

Line 1381: ,p_title in varchar2 default hr_api.g_varchar2

1377: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1381: ,p_title in varchar2 default hr_api.g_varchar2
1382: ,p_segment1 in varchar2 default hr_api.g_varchar2
1383: ,p_segment2 in varchar2 default hr_api.g_varchar2
1384: ,p_segment3 in varchar2 default hr_api.g_varchar2
1385: ,p_segment4 in varchar2 default hr_api.g_varchar2

Line 1382: ,p_segment1 in varchar2 default hr_api.g_varchar2

1378: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1381: ,p_title in varchar2 default hr_api.g_varchar2
1382: ,p_segment1 in varchar2 default hr_api.g_varchar2
1383: ,p_segment2 in varchar2 default hr_api.g_varchar2
1384: ,p_segment3 in varchar2 default hr_api.g_varchar2
1385: ,p_segment4 in varchar2 default hr_api.g_varchar2
1386: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 1383: ,p_segment2 in varchar2 default hr_api.g_varchar2

1379: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1381: ,p_title in varchar2 default hr_api.g_varchar2
1382: ,p_segment1 in varchar2 default hr_api.g_varchar2
1383: ,p_segment2 in varchar2 default hr_api.g_varchar2
1384: ,p_segment3 in varchar2 default hr_api.g_varchar2
1385: ,p_segment4 in varchar2 default hr_api.g_varchar2
1386: ,p_segment5 in varchar2 default hr_api.g_varchar2
1387: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 1384: ,p_segment3 in varchar2 default hr_api.g_varchar2

1380: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1381: ,p_title in varchar2 default hr_api.g_varchar2
1382: ,p_segment1 in varchar2 default hr_api.g_varchar2
1383: ,p_segment2 in varchar2 default hr_api.g_varchar2
1384: ,p_segment3 in varchar2 default hr_api.g_varchar2
1385: ,p_segment4 in varchar2 default hr_api.g_varchar2
1386: ,p_segment5 in varchar2 default hr_api.g_varchar2
1387: ,p_segment6 in varchar2 default hr_api.g_varchar2
1388: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 1385: ,p_segment4 in varchar2 default hr_api.g_varchar2

1381: ,p_title in varchar2 default hr_api.g_varchar2
1382: ,p_segment1 in varchar2 default hr_api.g_varchar2
1383: ,p_segment2 in varchar2 default hr_api.g_varchar2
1384: ,p_segment3 in varchar2 default hr_api.g_varchar2
1385: ,p_segment4 in varchar2 default hr_api.g_varchar2
1386: ,p_segment5 in varchar2 default hr_api.g_varchar2
1387: ,p_segment6 in varchar2 default hr_api.g_varchar2
1388: ,p_segment7 in varchar2 default hr_api.g_varchar2
1389: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 1386: ,p_segment5 in varchar2 default hr_api.g_varchar2

1382: ,p_segment1 in varchar2 default hr_api.g_varchar2
1383: ,p_segment2 in varchar2 default hr_api.g_varchar2
1384: ,p_segment3 in varchar2 default hr_api.g_varchar2
1385: ,p_segment4 in varchar2 default hr_api.g_varchar2
1386: ,p_segment5 in varchar2 default hr_api.g_varchar2
1387: ,p_segment6 in varchar2 default hr_api.g_varchar2
1388: ,p_segment7 in varchar2 default hr_api.g_varchar2
1389: ,p_segment8 in varchar2 default hr_api.g_varchar2
1390: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 1387: ,p_segment6 in varchar2 default hr_api.g_varchar2

1383: ,p_segment2 in varchar2 default hr_api.g_varchar2
1384: ,p_segment3 in varchar2 default hr_api.g_varchar2
1385: ,p_segment4 in varchar2 default hr_api.g_varchar2
1386: ,p_segment5 in varchar2 default hr_api.g_varchar2
1387: ,p_segment6 in varchar2 default hr_api.g_varchar2
1388: ,p_segment7 in varchar2 default hr_api.g_varchar2
1389: ,p_segment8 in varchar2 default hr_api.g_varchar2
1390: ,p_segment9 in varchar2 default hr_api.g_varchar2
1391: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 1388: ,p_segment7 in varchar2 default hr_api.g_varchar2

1384: ,p_segment3 in varchar2 default hr_api.g_varchar2
1385: ,p_segment4 in varchar2 default hr_api.g_varchar2
1386: ,p_segment5 in varchar2 default hr_api.g_varchar2
1387: ,p_segment6 in varchar2 default hr_api.g_varchar2
1388: ,p_segment7 in varchar2 default hr_api.g_varchar2
1389: ,p_segment8 in varchar2 default hr_api.g_varchar2
1390: ,p_segment9 in varchar2 default hr_api.g_varchar2
1391: ,p_segment10 in varchar2 default hr_api.g_varchar2
1392: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 1389: ,p_segment8 in varchar2 default hr_api.g_varchar2

1385: ,p_segment4 in varchar2 default hr_api.g_varchar2
1386: ,p_segment5 in varchar2 default hr_api.g_varchar2
1387: ,p_segment6 in varchar2 default hr_api.g_varchar2
1388: ,p_segment7 in varchar2 default hr_api.g_varchar2
1389: ,p_segment8 in varchar2 default hr_api.g_varchar2
1390: ,p_segment9 in varchar2 default hr_api.g_varchar2
1391: ,p_segment10 in varchar2 default hr_api.g_varchar2
1392: ,p_segment11 in varchar2 default hr_api.g_varchar2
1393: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 1390: ,p_segment9 in varchar2 default hr_api.g_varchar2

1386: ,p_segment5 in varchar2 default hr_api.g_varchar2
1387: ,p_segment6 in varchar2 default hr_api.g_varchar2
1388: ,p_segment7 in varchar2 default hr_api.g_varchar2
1389: ,p_segment8 in varchar2 default hr_api.g_varchar2
1390: ,p_segment9 in varchar2 default hr_api.g_varchar2
1391: ,p_segment10 in varchar2 default hr_api.g_varchar2
1392: ,p_segment11 in varchar2 default hr_api.g_varchar2
1393: ,p_segment12 in varchar2 default hr_api.g_varchar2
1394: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 1391: ,p_segment10 in varchar2 default hr_api.g_varchar2

1387: ,p_segment6 in varchar2 default hr_api.g_varchar2
1388: ,p_segment7 in varchar2 default hr_api.g_varchar2
1389: ,p_segment8 in varchar2 default hr_api.g_varchar2
1390: ,p_segment9 in varchar2 default hr_api.g_varchar2
1391: ,p_segment10 in varchar2 default hr_api.g_varchar2
1392: ,p_segment11 in varchar2 default hr_api.g_varchar2
1393: ,p_segment12 in varchar2 default hr_api.g_varchar2
1394: ,p_segment13 in varchar2 default hr_api.g_varchar2
1395: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 1392: ,p_segment11 in varchar2 default hr_api.g_varchar2

1388: ,p_segment7 in varchar2 default hr_api.g_varchar2
1389: ,p_segment8 in varchar2 default hr_api.g_varchar2
1390: ,p_segment9 in varchar2 default hr_api.g_varchar2
1391: ,p_segment10 in varchar2 default hr_api.g_varchar2
1392: ,p_segment11 in varchar2 default hr_api.g_varchar2
1393: ,p_segment12 in varchar2 default hr_api.g_varchar2
1394: ,p_segment13 in varchar2 default hr_api.g_varchar2
1395: ,p_segment14 in varchar2 default hr_api.g_varchar2
1396: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 1393: ,p_segment12 in varchar2 default hr_api.g_varchar2

1389: ,p_segment8 in varchar2 default hr_api.g_varchar2
1390: ,p_segment9 in varchar2 default hr_api.g_varchar2
1391: ,p_segment10 in varchar2 default hr_api.g_varchar2
1392: ,p_segment11 in varchar2 default hr_api.g_varchar2
1393: ,p_segment12 in varchar2 default hr_api.g_varchar2
1394: ,p_segment13 in varchar2 default hr_api.g_varchar2
1395: ,p_segment14 in varchar2 default hr_api.g_varchar2
1396: ,p_segment15 in varchar2 default hr_api.g_varchar2
1397: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 1394: ,p_segment13 in varchar2 default hr_api.g_varchar2

1390: ,p_segment9 in varchar2 default hr_api.g_varchar2
1391: ,p_segment10 in varchar2 default hr_api.g_varchar2
1392: ,p_segment11 in varchar2 default hr_api.g_varchar2
1393: ,p_segment12 in varchar2 default hr_api.g_varchar2
1394: ,p_segment13 in varchar2 default hr_api.g_varchar2
1395: ,p_segment14 in varchar2 default hr_api.g_varchar2
1396: ,p_segment15 in varchar2 default hr_api.g_varchar2
1397: ,p_segment16 in varchar2 default hr_api.g_varchar2
1398: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 1395: ,p_segment14 in varchar2 default hr_api.g_varchar2

1391: ,p_segment10 in varchar2 default hr_api.g_varchar2
1392: ,p_segment11 in varchar2 default hr_api.g_varchar2
1393: ,p_segment12 in varchar2 default hr_api.g_varchar2
1394: ,p_segment13 in varchar2 default hr_api.g_varchar2
1395: ,p_segment14 in varchar2 default hr_api.g_varchar2
1396: ,p_segment15 in varchar2 default hr_api.g_varchar2
1397: ,p_segment16 in varchar2 default hr_api.g_varchar2
1398: ,p_segment17 in varchar2 default hr_api.g_varchar2
1399: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 1396: ,p_segment15 in varchar2 default hr_api.g_varchar2

1392: ,p_segment11 in varchar2 default hr_api.g_varchar2
1393: ,p_segment12 in varchar2 default hr_api.g_varchar2
1394: ,p_segment13 in varchar2 default hr_api.g_varchar2
1395: ,p_segment14 in varchar2 default hr_api.g_varchar2
1396: ,p_segment15 in varchar2 default hr_api.g_varchar2
1397: ,p_segment16 in varchar2 default hr_api.g_varchar2
1398: ,p_segment17 in varchar2 default hr_api.g_varchar2
1399: ,p_segment18 in varchar2 default hr_api.g_varchar2
1400: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 1397: ,p_segment16 in varchar2 default hr_api.g_varchar2

1393: ,p_segment12 in varchar2 default hr_api.g_varchar2
1394: ,p_segment13 in varchar2 default hr_api.g_varchar2
1395: ,p_segment14 in varchar2 default hr_api.g_varchar2
1396: ,p_segment15 in varchar2 default hr_api.g_varchar2
1397: ,p_segment16 in varchar2 default hr_api.g_varchar2
1398: ,p_segment17 in varchar2 default hr_api.g_varchar2
1399: ,p_segment18 in varchar2 default hr_api.g_varchar2
1400: ,p_segment19 in varchar2 default hr_api.g_varchar2
1401: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 1398: ,p_segment17 in varchar2 default hr_api.g_varchar2

1394: ,p_segment13 in varchar2 default hr_api.g_varchar2
1395: ,p_segment14 in varchar2 default hr_api.g_varchar2
1396: ,p_segment15 in varchar2 default hr_api.g_varchar2
1397: ,p_segment16 in varchar2 default hr_api.g_varchar2
1398: ,p_segment17 in varchar2 default hr_api.g_varchar2
1399: ,p_segment18 in varchar2 default hr_api.g_varchar2
1400: ,p_segment19 in varchar2 default hr_api.g_varchar2
1401: ,p_segment20 in varchar2 default hr_api.g_varchar2
1402: ,p_segment21 in varchar2 default hr_api.g_varchar2

Line 1399: ,p_segment18 in varchar2 default hr_api.g_varchar2

1395: ,p_segment14 in varchar2 default hr_api.g_varchar2
1396: ,p_segment15 in varchar2 default hr_api.g_varchar2
1397: ,p_segment16 in varchar2 default hr_api.g_varchar2
1398: ,p_segment17 in varchar2 default hr_api.g_varchar2
1399: ,p_segment18 in varchar2 default hr_api.g_varchar2
1400: ,p_segment19 in varchar2 default hr_api.g_varchar2
1401: ,p_segment20 in varchar2 default hr_api.g_varchar2
1402: ,p_segment21 in varchar2 default hr_api.g_varchar2
1403: ,p_segment22 in varchar2 default hr_api.g_varchar2

Line 1400: ,p_segment19 in varchar2 default hr_api.g_varchar2

1396: ,p_segment15 in varchar2 default hr_api.g_varchar2
1397: ,p_segment16 in varchar2 default hr_api.g_varchar2
1398: ,p_segment17 in varchar2 default hr_api.g_varchar2
1399: ,p_segment18 in varchar2 default hr_api.g_varchar2
1400: ,p_segment19 in varchar2 default hr_api.g_varchar2
1401: ,p_segment20 in varchar2 default hr_api.g_varchar2
1402: ,p_segment21 in varchar2 default hr_api.g_varchar2
1403: ,p_segment22 in varchar2 default hr_api.g_varchar2
1404: ,p_segment23 in varchar2 default hr_api.g_varchar2

Line 1401: ,p_segment20 in varchar2 default hr_api.g_varchar2

1397: ,p_segment16 in varchar2 default hr_api.g_varchar2
1398: ,p_segment17 in varchar2 default hr_api.g_varchar2
1399: ,p_segment18 in varchar2 default hr_api.g_varchar2
1400: ,p_segment19 in varchar2 default hr_api.g_varchar2
1401: ,p_segment20 in varchar2 default hr_api.g_varchar2
1402: ,p_segment21 in varchar2 default hr_api.g_varchar2
1403: ,p_segment22 in varchar2 default hr_api.g_varchar2
1404: ,p_segment23 in varchar2 default hr_api.g_varchar2
1405: ,p_segment24 in varchar2 default hr_api.g_varchar2

Line 1402: ,p_segment21 in varchar2 default hr_api.g_varchar2

1398: ,p_segment17 in varchar2 default hr_api.g_varchar2
1399: ,p_segment18 in varchar2 default hr_api.g_varchar2
1400: ,p_segment19 in varchar2 default hr_api.g_varchar2
1401: ,p_segment20 in varchar2 default hr_api.g_varchar2
1402: ,p_segment21 in varchar2 default hr_api.g_varchar2
1403: ,p_segment22 in varchar2 default hr_api.g_varchar2
1404: ,p_segment23 in varchar2 default hr_api.g_varchar2
1405: ,p_segment24 in varchar2 default hr_api.g_varchar2
1406: ,p_segment25 in varchar2 default hr_api.g_varchar2

Line 1403: ,p_segment22 in varchar2 default hr_api.g_varchar2

1399: ,p_segment18 in varchar2 default hr_api.g_varchar2
1400: ,p_segment19 in varchar2 default hr_api.g_varchar2
1401: ,p_segment20 in varchar2 default hr_api.g_varchar2
1402: ,p_segment21 in varchar2 default hr_api.g_varchar2
1403: ,p_segment22 in varchar2 default hr_api.g_varchar2
1404: ,p_segment23 in varchar2 default hr_api.g_varchar2
1405: ,p_segment24 in varchar2 default hr_api.g_varchar2
1406: ,p_segment25 in varchar2 default hr_api.g_varchar2
1407: ,p_segment26 in varchar2 default hr_api.g_varchar2

Line 1404: ,p_segment23 in varchar2 default hr_api.g_varchar2

1400: ,p_segment19 in varchar2 default hr_api.g_varchar2
1401: ,p_segment20 in varchar2 default hr_api.g_varchar2
1402: ,p_segment21 in varchar2 default hr_api.g_varchar2
1403: ,p_segment22 in varchar2 default hr_api.g_varchar2
1404: ,p_segment23 in varchar2 default hr_api.g_varchar2
1405: ,p_segment24 in varchar2 default hr_api.g_varchar2
1406: ,p_segment25 in varchar2 default hr_api.g_varchar2
1407: ,p_segment26 in varchar2 default hr_api.g_varchar2
1408: ,p_segment27 in varchar2 default hr_api.g_varchar2

Line 1405: ,p_segment24 in varchar2 default hr_api.g_varchar2

1401: ,p_segment20 in varchar2 default hr_api.g_varchar2
1402: ,p_segment21 in varchar2 default hr_api.g_varchar2
1403: ,p_segment22 in varchar2 default hr_api.g_varchar2
1404: ,p_segment23 in varchar2 default hr_api.g_varchar2
1405: ,p_segment24 in varchar2 default hr_api.g_varchar2
1406: ,p_segment25 in varchar2 default hr_api.g_varchar2
1407: ,p_segment26 in varchar2 default hr_api.g_varchar2
1408: ,p_segment27 in varchar2 default hr_api.g_varchar2
1409: ,p_segment28 in varchar2 default hr_api.g_varchar2

Line 1406: ,p_segment25 in varchar2 default hr_api.g_varchar2

1402: ,p_segment21 in varchar2 default hr_api.g_varchar2
1403: ,p_segment22 in varchar2 default hr_api.g_varchar2
1404: ,p_segment23 in varchar2 default hr_api.g_varchar2
1405: ,p_segment24 in varchar2 default hr_api.g_varchar2
1406: ,p_segment25 in varchar2 default hr_api.g_varchar2
1407: ,p_segment26 in varchar2 default hr_api.g_varchar2
1408: ,p_segment27 in varchar2 default hr_api.g_varchar2
1409: ,p_segment28 in varchar2 default hr_api.g_varchar2
1410: ,p_segment29 in varchar2 default hr_api.g_varchar2

Line 1407: ,p_segment26 in varchar2 default hr_api.g_varchar2

1403: ,p_segment22 in varchar2 default hr_api.g_varchar2
1404: ,p_segment23 in varchar2 default hr_api.g_varchar2
1405: ,p_segment24 in varchar2 default hr_api.g_varchar2
1406: ,p_segment25 in varchar2 default hr_api.g_varchar2
1407: ,p_segment26 in varchar2 default hr_api.g_varchar2
1408: ,p_segment27 in varchar2 default hr_api.g_varchar2
1409: ,p_segment28 in varchar2 default hr_api.g_varchar2
1410: ,p_segment29 in varchar2 default hr_api.g_varchar2
1411: ,p_segment30 in varchar2 default hr_api.g_varchar2

Line 1408: ,p_segment27 in varchar2 default hr_api.g_varchar2

1404: ,p_segment23 in varchar2 default hr_api.g_varchar2
1405: ,p_segment24 in varchar2 default hr_api.g_varchar2
1406: ,p_segment25 in varchar2 default hr_api.g_varchar2
1407: ,p_segment26 in varchar2 default hr_api.g_varchar2
1408: ,p_segment27 in varchar2 default hr_api.g_varchar2
1409: ,p_segment28 in varchar2 default hr_api.g_varchar2
1410: ,p_segment29 in varchar2 default hr_api.g_varchar2
1411: ,p_segment30 in varchar2 default hr_api.g_varchar2
1412: ,p_concat_segments in varchar2 default hr_api.g_varchar2

Line 1409: ,p_segment28 in varchar2 default hr_api.g_varchar2

1405: ,p_segment24 in varchar2 default hr_api.g_varchar2
1406: ,p_segment25 in varchar2 default hr_api.g_varchar2
1407: ,p_segment26 in varchar2 default hr_api.g_varchar2
1408: ,p_segment27 in varchar2 default hr_api.g_varchar2
1409: ,p_segment28 in varchar2 default hr_api.g_varchar2
1410: ,p_segment29 in varchar2 default hr_api.g_varchar2
1411: ,p_segment30 in varchar2 default hr_api.g_varchar2
1412: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1413: ,p_contract_id in number default hr_api.g_number

Line 1410: ,p_segment29 in varchar2 default hr_api.g_varchar2

1406: ,p_segment25 in varchar2 default hr_api.g_varchar2
1407: ,p_segment26 in varchar2 default hr_api.g_varchar2
1408: ,p_segment27 in varchar2 default hr_api.g_varchar2
1409: ,p_segment28 in varchar2 default hr_api.g_varchar2
1410: ,p_segment29 in varchar2 default hr_api.g_varchar2
1411: ,p_segment30 in varchar2 default hr_api.g_varchar2
1412: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1413: ,p_contract_id in number default hr_api.g_number
1414: ,p_establishment_id in number default hr_api.g_number

Line 1411: ,p_segment30 in varchar2 default hr_api.g_varchar2

1407: ,p_segment26 in varchar2 default hr_api.g_varchar2
1408: ,p_segment27 in varchar2 default hr_api.g_varchar2
1409: ,p_segment28 in varchar2 default hr_api.g_varchar2
1410: ,p_segment29 in varchar2 default hr_api.g_varchar2
1411: ,p_segment30 in varchar2 default hr_api.g_varchar2
1412: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1413: ,p_contract_id in number default hr_api.g_number
1414: ,p_establishment_id in number default hr_api.g_number
1415: ,p_collective_agreement_id in number default hr_api.g_number

Line 1412: ,p_concat_segments in varchar2 default hr_api.g_varchar2

1408: ,p_segment27 in varchar2 default hr_api.g_varchar2
1409: ,p_segment28 in varchar2 default hr_api.g_varchar2
1410: ,p_segment29 in varchar2 default hr_api.g_varchar2
1411: ,p_segment30 in varchar2 default hr_api.g_varchar2
1412: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1413: ,p_contract_id in number default hr_api.g_number
1414: ,p_establishment_id in number default hr_api.g_number
1415: ,p_collective_agreement_id in number default hr_api.g_number
1416: ,p_cagr_id_flex_num in number default hr_api.g_number

Line 1413: ,p_contract_id in number default hr_api.g_number

1409: ,p_segment28 in varchar2 default hr_api.g_varchar2
1410: ,p_segment29 in varchar2 default hr_api.g_varchar2
1411: ,p_segment30 in varchar2 default hr_api.g_varchar2
1412: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1413: ,p_contract_id in number default hr_api.g_number
1414: ,p_establishment_id in number default hr_api.g_number
1415: ,p_collective_agreement_id in number default hr_api.g_number
1416: ,p_cagr_id_flex_num in number default hr_api.g_number
1417: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2

Line 1414: ,p_establishment_id in number default hr_api.g_number

1410: ,p_segment29 in varchar2 default hr_api.g_varchar2
1411: ,p_segment30 in varchar2 default hr_api.g_varchar2
1412: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1413: ,p_contract_id in number default hr_api.g_number
1414: ,p_establishment_id in number default hr_api.g_number
1415: ,p_collective_agreement_id in number default hr_api.g_number
1416: ,p_cagr_id_flex_num in number default hr_api.g_number
1417: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1418: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2

Line 1415: ,p_collective_agreement_id in number default hr_api.g_number

1411: ,p_segment30 in varchar2 default hr_api.g_varchar2
1412: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1413: ,p_contract_id in number default hr_api.g_number
1414: ,p_establishment_id in number default hr_api.g_number
1415: ,p_collective_agreement_id in number default hr_api.g_number
1416: ,p_cagr_id_flex_num in number default hr_api.g_number
1417: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1418: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1419: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2

Line 1416: ,p_cagr_id_flex_num in number default hr_api.g_number

1412: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1413: ,p_contract_id in number default hr_api.g_number
1414: ,p_establishment_id in number default hr_api.g_number
1415: ,p_collective_agreement_id in number default hr_api.g_number
1416: ,p_cagr_id_flex_num in number default hr_api.g_number
1417: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1418: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1419: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1420: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2

Line 1417: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2

1413: ,p_contract_id in number default hr_api.g_number
1414: ,p_establishment_id in number default hr_api.g_number
1415: ,p_collective_agreement_id in number default hr_api.g_number
1416: ,p_cagr_id_flex_num in number default hr_api.g_number
1417: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1418: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1419: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1420: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1421: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2

Line 1418: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2

1414: ,p_establishment_id in number default hr_api.g_number
1415: ,p_collective_agreement_id in number default hr_api.g_number
1416: ,p_cagr_id_flex_num in number default hr_api.g_number
1417: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1418: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1419: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1420: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1421: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1422: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2

Line 1419: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2

1415: ,p_collective_agreement_id in number default hr_api.g_number
1416: ,p_cagr_id_flex_num in number default hr_api.g_number
1417: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1418: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1419: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1420: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1421: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1422: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1423: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2

Line 1420: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2

1416: ,p_cagr_id_flex_num in number default hr_api.g_number
1417: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1418: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1419: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1420: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1421: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1422: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1423: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1424: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2

Line 1421: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2

1417: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1418: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1419: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1420: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1421: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1422: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1423: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1424: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1425: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2

Line 1422: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2

1418: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1419: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1420: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1421: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1422: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1423: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1424: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1425: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1426: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2

Line 1423: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2

1419: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1420: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1421: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1422: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1423: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1424: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1425: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1426: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1427: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2

Line 1424: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2

1420: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1421: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1422: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1423: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1424: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1425: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1426: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1427: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2

Line 1425: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2

1421: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1422: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1423: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1424: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1425: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1426: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1427: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2

Line 1426: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2

1422: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1423: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1424: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1425: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1426: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1427: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2

Line 1427: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2

1423: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1424: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1425: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1426: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1427: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2

Line 1428: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2

1424: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1425: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1426: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1427: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2

Line 1429: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2

1425: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1426: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1427: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2

Line 1430: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2

1426: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1427: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2

Line 1431: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2

1427: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2

Line 1432: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2

1428: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2

Line 1433: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2

1429: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1437: ,p_notice_period in number default hr_api.g_number

Line 1434: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2

1430: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1437: ,p_notice_period in number default hr_api.g_number
1438: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2

Line 1435: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2

1431: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1437: ,p_notice_period in number default hr_api.g_number
1438: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1439: ,p_employee_category in varchar2 default hr_api.g_varchar2

Line 1436: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2

1432: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1437: ,p_notice_period in number default hr_api.g_number
1438: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1439: ,p_employee_category in varchar2 default hr_api.g_varchar2
1440: ,p_work_at_home in varchar2 default hr_api.g_varchar2

Line 1437: ,p_notice_period in number default hr_api.g_number

1433: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1437: ,p_notice_period in number default hr_api.g_number
1438: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1439: ,p_employee_category in varchar2 default hr_api.g_varchar2
1440: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1441: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

Line 1438: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2

1434: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1437: ,p_notice_period in number default hr_api.g_number
1438: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1439: ,p_employee_category in varchar2 default hr_api.g_varchar2
1440: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1441: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1442: ,p_cagr_grade_def_id out nocopy number

Line 1439: ,p_employee_category in varchar2 default hr_api.g_varchar2

1435: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1437: ,p_notice_period in number default hr_api.g_number
1438: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1439: ,p_employee_category in varchar2 default hr_api.g_varchar2
1440: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1441: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1442: ,p_cagr_grade_def_id out nocopy number
1443: ,p_cagr_concatenated_segments out nocopy varchar2

Line 1440: ,p_work_at_home in varchar2 default hr_api.g_varchar2

1436: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1437: ,p_notice_period in number default hr_api.g_number
1438: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1439: ,p_employee_category in varchar2 default hr_api.g_varchar2
1440: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1441: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1442: ,p_cagr_grade_def_id out nocopy number
1443: ,p_cagr_concatenated_segments out nocopy varchar2
1444: ,p_concatenated_segments out nocopy varchar2

Line 1441: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

1437: ,p_notice_period in number default hr_api.g_number
1438: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1439: ,p_employee_category in varchar2 default hr_api.g_varchar2
1440: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1441: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1442: ,p_cagr_grade_def_id out nocopy number
1443: ,p_cagr_concatenated_segments out nocopy varchar2
1444: ,p_concatenated_segments out nocopy varchar2
1445: ,p_soft_coding_keyflex_id out nocopy number

Line 1481: hr_api.constant_to_boolean

1477: --
1478: -- Convert constant values to their corresponding boolean value
1479: --
1480: l_validate :=
1481: hr_api.constant_to_boolean
1482: (p_constant_value => p_validate);
1483: --
1484: -- Register Surrogate ID or user key values
1485: --

Line 1709: (p_validate in number default hr_api.g_false_num

1705: -- ----------------------------------------------------------------------------
1706: -- |------------------------< update_emp_asg_criteria >-----------------------|
1707: -- ----------------------------------------------------------------------------
1708: PROCEDURE update_emp_asg_criteria
1709: (p_validate in number default hr_api.g_false_num
1710: ,p_effective_date in date
1711: ,p_datetrack_update_mode in varchar2
1712: ,p_assignment_id in number
1713: ,p_object_version_number in out nocopy number

Line 1714: ,p_grade_id in number default hr_api.g_number

1710: ,p_effective_date in date
1711: ,p_datetrack_update_mode in varchar2
1712: ,p_assignment_id in number
1713: ,p_object_version_number in out nocopy number
1714: ,p_grade_id in number default hr_api.g_number
1715: ,p_position_id in number default hr_api.g_number
1716: ,p_job_id in number default hr_api.g_number
1717: ,p_payroll_id in number default hr_api.g_number
1718: ,p_location_id in number default hr_api.g_number

Line 1715: ,p_position_id in number default hr_api.g_number

1711: ,p_datetrack_update_mode in varchar2
1712: ,p_assignment_id in number
1713: ,p_object_version_number in out nocopy number
1714: ,p_grade_id in number default hr_api.g_number
1715: ,p_position_id in number default hr_api.g_number
1716: ,p_job_id in number default hr_api.g_number
1717: ,p_payroll_id in number default hr_api.g_number
1718: ,p_location_id in number default hr_api.g_number
1719: ,p_special_ceiling_step_id in out nocopy number

Line 1716: ,p_job_id in number default hr_api.g_number

1712: ,p_assignment_id in number
1713: ,p_object_version_number in out nocopy number
1714: ,p_grade_id in number default hr_api.g_number
1715: ,p_position_id in number default hr_api.g_number
1716: ,p_job_id in number default hr_api.g_number
1717: ,p_payroll_id in number default hr_api.g_number
1718: ,p_location_id in number default hr_api.g_number
1719: ,p_special_ceiling_step_id in out nocopy number
1720: ,p_organization_id in number default hr_api.g_number

Line 1717: ,p_payroll_id in number default hr_api.g_number

1713: ,p_object_version_number in out nocopy number
1714: ,p_grade_id in number default hr_api.g_number
1715: ,p_position_id in number default hr_api.g_number
1716: ,p_job_id in number default hr_api.g_number
1717: ,p_payroll_id in number default hr_api.g_number
1718: ,p_location_id in number default hr_api.g_number
1719: ,p_special_ceiling_step_id in out nocopy number
1720: ,p_organization_id in number default hr_api.g_number
1721: ,p_pay_basis_id in number default hr_api.g_number

Line 1718: ,p_location_id in number default hr_api.g_number

1714: ,p_grade_id in number default hr_api.g_number
1715: ,p_position_id in number default hr_api.g_number
1716: ,p_job_id in number default hr_api.g_number
1717: ,p_payroll_id in number default hr_api.g_number
1718: ,p_location_id in number default hr_api.g_number
1719: ,p_special_ceiling_step_id in out nocopy number
1720: ,p_organization_id in number default hr_api.g_number
1721: ,p_pay_basis_id in number default hr_api.g_number
1722: ,p_segment1 in varchar2 default hr_api.g_varchar2

Line 1720: ,p_organization_id in number default hr_api.g_number

1716: ,p_job_id in number default hr_api.g_number
1717: ,p_payroll_id in number default hr_api.g_number
1718: ,p_location_id in number default hr_api.g_number
1719: ,p_special_ceiling_step_id in out nocopy number
1720: ,p_organization_id in number default hr_api.g_number
1721: ,p_pay_basis_id in number default hr_api.g_number
1722: ,p_segment1 in varchar2 default hr_api.g_varchar2
1723: ,p_segment2 in varchar2 default hr_api.g_varchar2
1724: ,p_segment3 in varchar2 default hr_api.g_varchar2

Line 1721: ,p_pay_basis_id in number default hr_api.g_number

1717: ,p_payroll_id in number default hr_api.g_number
1718: ,p_location_id in number default hr_api.g_number
1719: ,p_special_ceiling_step_id in out nocopy number
1720: ,p_organization_id in number default hr_api.g_number
1721: ,p_pay_basis_id in number default hr_api.g_number
1722: ,p_segment1 in varchar2 default hr_api.g_varchar2
1723: ,p_segment2 in varchar2 default hr_api.g_varchar2
1724: ,p_segment3 in varchar2 default hr_api.g_varchar2
1725: ,p_segment4 in varchar2 default hr_api.g_varchar2

Line 1722: ,p_segment1 in varchar2 default hr_api.g_varchar2

1718: ,p_location_id in number default hr_api.g_number
1719: ,p_special_ceiling_step_id in out nocopy number
1720: ,p_organization_id in number default hr_api.g_number
1721: ,p_pay_basis_id in number default hr_api.g_number
1722: ,p_segment1 in varchar2 default hr_api.g_varchar2
1723: ,p_segment2 in varchar2 default hr_api.g_varchar2
1724: ,p_segment3 in varchar2 default hr_api.g_varchar2
1725: ,p_segment4 in varchar2 default hr_api.g_varchar2
1726: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 1723: ,p_segment2 in varchar2 default hr_api.g_varchar2

1719: ,p_special_ceiling_step_id in out nocopy number
1720: ,p_organization_id in number default hr_api.g_number
1721: ,p_pay_basis_id in number default hr_api.g_number
1722: ,p_segment1 in varchar2 default hr_api.g_varchar2
1723: ,p_segment2 in varchar2 default hr_api.g_varchar2
1724: ,p_segment3 in varchar2 default hr_api.g_varchar2
1725: ,p_segment4 in varchar2 default hr_api.g_varchar2
1726: ,p_segment5 in varchar2 default hr_api.g_varchar2
1727: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 1724: ,p_segment3 in varchar2 default hr_api.g_varchar2

1720: ,p_organization_id in number default hr_api.g_number
1721: ,p_pay_basis_id in number default hr_api.g_number
1722: ,p_segment1 in varchar2 default hr_api.g_varchar2
1723: ,p_segment2 in varchar2 default hr_api.g_varchar2
1724: ,p_segment3 in varchar2 default hr_api.g_varchar2
1725: ,p_segment4 in varchar2 default hr_api.g_varchar2
1726: ,p_segment5 in varchar2 default hr_api.g_varchar2
1727: ,p_segment6 in varchar2 default hr_api.g_varchar2
1728: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 1725: ,p_segment4 in varchar2 default hr_api.g_varchar2

1721: ,p_pay_basis_id in number default hr_api.g_number
1722: ,p_segment1 in varchar2 default hr_api.g_varchar2
1723: ,p_segment2 in varchar2 default hr_api.g_varchar2
1724: ,p_segment3 in varchar2 default hr_api.g_varchar2
1725: ,p_segment4 in varchar2 default hr_api.g_varchar2
1726: ,p_segment5 in varchar2 default hr_api.g_varchar2
1727: ,p_segment6 in varchar2 default hr_api.g_varchar2
1728: ,p_segment7 in varchar2 default hr_api.g_varchar2
1729: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 1726: ,p_segment5 in varchar2 default hr_api.g_varchar2

1722: ,p_segment1 in varchar2 default hr_api.g_varchar2
1723: ,p_segment2 in varchar2 default hr_api.g_varchar2
1724: ,p_segment3 in varchar2 default hr_api.g_varchar2
1725: ,p_segment4 in varchar2 default hr_api.g_varchar2
1726: ,p_segment5 in varchar2 default hr_api.g_varchar2
1727: ,p_segment6 in varchar2 default hr_api.g_varchar2
1728: ,p_segment7 in varchar2 default hr_api.g_varchar2
1729: ,p_segment8 in varchar2 default hr_api.g_varchar2
1730: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 1727: ,p_segment6 in varchar2 default hr_api.g_varchar2

1723: ,p_segment2 in varchar2 default hr_api.g_varchar2
1724: ,p_segment3 in varchar2 default hr_api.g_varchar2
1725: ,p_segment4 in varchar2 default hr_api.g_varchar2
1726: ,p_segment5 in varchar2 default hr_api.g_varchar2
1727: ,p_segment6 in varchar2 default hr_api.g_varchar2
1728: ,p_segment7 in varchar2 default hr_api.g_varchar2
1729: ,p_segment8 in varchar2 default hr_api.g_varchar2
1730: ,p_segment9 in varchar2 default hr_api.g_varchar2
1731: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 1728: ,p_segment7 in varchar2 default hr_api.g_varchar2

1724: ,p_segment3 in varchar2 default hr_api.g_varchar2
1725: ,p_segment4 in varchar2 default hr_api.g_varchar2
1726: ,p_segment5 in varchar2 default hr_api.g_varchar2
1727: ,p_segment6 in varchar2 default hr_api.g_varchar2
1728: ,p_segment7 in varchar2 default hr_api.g_varchar2
1729: ,p_segment8 in varchar2 default hr_api.g_varchar2
1730: ,p_segment9 in varchar2 default hr_api.g_varchar2
1731: ,p_segment10 in varchar2 default hr_api.g_varchar2
1732: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 1729: ,p_segment8 in varchar2 default hr_api.g_varchar2

1725: ,p_segment4 in varchar2 default hr_api.g_varchar2
1726: ,p_segment5 in varchar2 default hr_api.g_varchar2
1727: ,p_segment6 in varchar2 default hr_api.g_varchar2
1728: ,p_segment7 in varchar2 default hr_api.g_varchar2
1729: ,p_segment8 in varchar2 default hr_api.g_varchar2
1730: ,p_segment9 in varchar2 default hr_api.g_varchar2
1731: ,p_segment10 in varchar2 default hr_api.g_varchar2
1732: ,p_segment11 in varchar2 default hr_api.g_varchar2
1733: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 1730: ,p_segment9 in varchar2 default hr_api.g_varchar2

1726: ,p_segment5 in varchar2 default hr_api.g_varchar2
1727: ,p_segment6 in varchar2 default hr_api.g_varchar2
1728: ,p_segment7 in varchar2 default hr_api.g_varchar2
1729: ,p_segment8 in varchar2 default hr_api.g_varchar2
1730: ,p_segment9 in varchar2 default hr_api.g_varchar2
1731: ,p_segment10 in varchar2 default hr_api.g_varchar2
1732: ,p_segment11 in varchar2 default hr_api.g_varchar2
1733: ,p_segment12 in varchar2 default hr_api.g_varchar2
1734: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 1731: ,p_segment10 in varchar2 default hr_api.g_varchar2

1727: ,p_segment6 in varchar2 default hr_api.g_varchar2
1728: ,p_segment7 in varchar2 default hr_api.g_varchar2
1729: ,p_segment8 in varchar2 default hr_api.g_varchar2
1730: ,p_segment9 in varchar2 default hr_api.g_varchar2
1731: ,p_segment10 in varchar2 default hr_api.g_varchar2
1732: ,p_segment11 in varchar2 default hr_api.g_varchar2
1733: ,p_segment12 in varchar2 default hr_api.g_varchar2
1734: ,p_segment13 in varchar2 default hr_api.g_varchar2
1735: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 1732: ,p_segment11 in varchar2 default hr_api.g_varchar2

1728: ,p_segment7 in varchar2 default hr_api.g_varchar2
1729: ,p_segment8 in varchar2 default hr_api.g_varchar2
1730: ,p_segment9 in varchar2 default hr_api.g_varchar2
1731: ,p_segment10 in varchar2 default hr_api.g_varchar2
1732: ,p_segment11 in varchar2 default hr_api.g_varchar2
1733: ,p_segment12 in varchar2 default hr_api.g_varchar2
1734: ,p_segment13 in varchar2 default hr_api.g_varchar2
1735: ,p_segment14 in varchar2 default hr_api.g_varchar2
1736: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 1733: ,p_segment12 in varchar2 default hr_api.g_varchar2

1729: ,p_segment8 in varchar2 default hr_api.g_varchar2
1730: ,p_segment9 in varchar2 default hr_api.g_varchar2
1731: ,p_segment10 in varchar2 default hr_api.g_varchar2
1732: ,p_segment11 in varchar2 default hr_api.g_varchar2
1733: ,p_segment12 in varchar2 default hr_api.g_varchar2
1734: ,p_segment13 in varchar2 default hr_api.g_varchar2
1735: ,p_segment14 in varchar2 default hr_api.g_varchar2
1736: ,p_segment15 in varchar2 default hr_api.g_varchar2
1737: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 1734: ,p_segment13 in varchar2 default hr_api.g_varchar2

1730: ,p_segment9 in varchar2 default hr_api.g_varchar2
1731: ,p_segment10 in varchar2 default hr_api.g_varchar2
1732: ,p_segment11 in varchar2 default hr_api.g_varchar2
1733: ,p_segment12 in varchar2 default hr_api.g_varchar2
1734: ,p_segment13 in varchar2 default hr_api.g_varchar2
1735: ,p_segment14 in varchar2 default hr_api.g_varchar2
1736: ,p_segment15 in varchar2 default hr_api.g_varchar2
1737: ,p_segment16 in varchar2 default hr_api.g_varchar2
1738: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 1735: ,p_segment14 in varchar2 default hr_api.g_varchar2

1731: ,p_segment10 in varchar2 default hr_api.g_varchar2
1732: ,p_segment11 in varchar2 default hr_api.g_varchar2
1733: ,p_segment12 in varchar2 default hr_api.g_varchar2
1734: ,p_segment13 in varchar2 default hr_api.g_varchar2
1735: ,p_segment14 in varchar2 default hr_api.g_varchar2
1736: ,p_segment15 in varchar2 default hr_api.g_varchar2
1737: ,p_segment16 in varchar2 default hr_api.g_varchar2
1738: ,p_segment17 in varchar2 default hr_api.g_varchar2
1739: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 1736: ,p_segment15 in varchar2 default hr_api.g_varchar2

1732: ,p_segment11 in varchar2 default hr_api.g_varchar2
1733: ,p_segment12 in varchar2 default hr_api.g_varchar2
1734: ,p_segment13 in varchar2 default hr_api.g_varchar2
1735: ,p_segment14 in varchar2 default hr_api.g_varchar2
1736: ,p_segment15 in varchar2 default hr_api.g_varchar2
1737: ,p_segment16 in varchar2 default hr_api.g_varchar2
1738: ,p_segment17 in varchar2 default hr_api.g_varchar2
1739: ,p_segment18 in varchar2 default hr_api.g_varchar2
1740: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 1737: ,p_segment16 in varchar2 default hr_api.g_varchar2

1733: ,p_segment12 in varchar2 default hr_api.g_varchar2
1734: ,p_segment13 in varchar2 default hr_api.g_varchar2
1735: ,p_segment14 in varchar2 default hr_api.g_varchar2
1736: ,p_segment15 in varchar2 default hr_api.g_varchar2
1737: ,p_segment16 in varchar2 default hr_api.g_varchar2
1738: ,p_segment17 in varchar2 default hr_api.g_varchar2
1739: ,p_segment18 in varchar2 default hr_api.g_varchar2
1740: ,p_segment19 in varchar2 default hr_api.g_varchar2
1741: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 1738: ,p_segment17 in varchar2 default hr_api.g_varchar2

1734: ,p_segment13 in varchar2 default hr_api.g_varchar2
1735: ,p_segment14 in varchar2 default hr_api.g_varchar2
1736: ,p_segment15 in varchar2 default hr_api.g_varchar2
1737: ,p_segment16 in varchar2 default hr_api.g_varchar2
1738: ,p_segment17 in varchar2 default hr_api.g_varchar2
1739: ,p_segment18 in varchar2 default hr_api.g_varchar2
1740: ,p_segment19 in varchar2 default hr_api.g_varchar2
1741: ,p_segment20 in varchar2 default hr_api.g_varchar2
1742: ,p_segment21 in varchar2 default hr_api.g_varchar2

Line 1739: ,p_segment18 in varchar2 default hr_api.g_varchar2

1735: ,p_segment14 in varchar2 default hr_api.g_varchar2
1736: ,p_segment15 in varchar2 default hr_api.g_varchar2
1737: ,p_segment16 in varchar2 default hr_api.g_varchar2
1738: ,p_segment17 in varchar2 default hr_api.g_varchar2
1739: ,p_segment18 in varchar2 default hr_api.g_varchar2
1740: ,p_segment19 in varchar2 default hr_api.g_varchar2
1741: ,p_segment20 in varchar2 default hr_api.g_varchar2
1742: ,p_segment21 in varchar2 default hr_api.g_varchar2
1743: ,p_segment22 in varchar2 default hr_api.g_varchar2

Line 1740: ,p_segment19 in varchar2 default hr_api.g_varchar2

1736: ,p_segment15 in varchar2 default hr_api.g_varchar2
1737: ,p_segment16 in varchar2 default hr_api.g_varchar2
1738: ,p_segment17 in varchar2 default hr_api.g_varchar2
1739: ,p_segment18 in varchar2 default hr_api.g_varchar2
1740: ,p_segment19 in varchar2 default hr_api.g_varchar2
1741: ,p_segment20 in varchar2 default hr_api.g_varchar2
1742: ,p_segment21 in varchar2 default hr_api.g_varchar2
1743: ,p_segment22 in varchar2 default hr_api.g_varchar2
1744: ,p_segment23 in varchar2 default hr_api.g_varchar2

Line 1741: ,p_segment20 in varchar2 default hr_api.g_varchar2

1737: ,p_segment16 in varchar2 default hr_api.g_varchar2
1738: ,p_segment17 in varchar2 default hr_api.g_varchar2
1739: ,p_segment18 in varchar2 default hr_api.g_varchar2
1740: ,p_segment19 in varchar2 default hr_api.g_varchar2
1741: ,p_segment20 in varchar2 default hr_api.g_varchar2
1742: ,p_segment21 in varchar2 default hr_api.g_varchar2
1743: ,p_segment22 in varchar2 default hr_api.g_varchar2
1744: ,p_segment23 in varchar2 default hr_api.g_varchar2
1745: ,p_segment24 in varchar2 default hr_api.g_varchar2

Line 1742: ,p_segment21 in varchar2 default hr_api.g_varchar2

1738: ,p_segment17 in varchar2 default hr_api.g_varchar2
1739: ,p_segment18 in varchar2 default hr_api.g_varchar2
1740: ,p_segment19 in varchar2 default hr_api.g_varchar2
1741: ,p_segment20 in varchar2 default hr_api.g_varchar2
1742: ,p_segment21 in varchar2 default hr_api.g_varchar2
1743: ,p_segment22 in varchar2 default hr_api.g_varchar2
1744: ,p_segment23 in varchar2 default hr_api.g_varchar2
1745: ,p_segment24 in varchar2 default hr_api.g_varchar2
1746: ,p_segment25 in varchar2 default hr_api.g_varchar2

Line 1743: ,p_segment22 in varchar2 default hr_api.g_varchar2

1739: ,p_segment18 in varchar2 default hr_api.g_varchar2
1740: ,p_segment19 in varchar2 default hr_api.g_varchar2
1741: ,p_segment20 in varchar2 default hr_api.g_varchar2
1742: ,p_segment21 in varchar2 default hr_api.g_varchar2
1743: ,p_segment22 in varchar2 default hr_api.g_varchar2
1744: ,p_segment23 in varchar2 default hr_api.g_varchar2
1745: ,p_segment24 in varchar2 default hr_api.g_varchar2
1746: ,p_segment25 in varchar2 default hr_api.g_varchar2
1747: ,p_segment26 in varchar2 default hr_api.g_varchar2

Line 1744: ,p_segment23 in varchar2 default hr_api.g_varchar2

1740: ,p_segment19 in varchar2 default hr_api.g_varchar2
1741: ,p_segment20 in varchar2 default hr_api.g_varchar2
1742: ,p_segment21 in varchar2 default hr_api.g_varchar2
1743: ,p_segment22 in varchar2 default hr_api.g_varchar2
1744: ,p_segment23 in varchar2 default hr_api.g_varchar2
1745: ,p_segment24 in varchar2 default hr_api.g_varchar2
1746: ,p_segment25 in varchar2 default hr_api.g_varchar2
1747: ,p_segment26 in varchar2 default hr_api.g_varchar2
1748: ,p_segment27 in varchar2 default hr_api.g_varchar2

Line 1745: ,p_segment24 in varchar2 default hr_api.g_varchar2

1741: ,p_segment20 in varchar2 default hr_api.g_varchar2
1742: ,p_segment21 in varchar2 default hr_api.g_varchar2
1743: ,p_segment22 in varchar2 default hr_api.g_varchar2
1744: ,p_segment23 in varchar2 default hr_api.g_varchar2
1745: ,p_segment24 in varchar2 default hr_api.g_varchar2
1746: ,p_segment25 in varchar2 default hr_api.g_varchar2
1747: ,p_segment26 in varchar2 default hr_api.g_varchar2
1748: ,p_segment27 in varchar2 default hr_api.g_varchar2
1749: ,p_segment28 in varchar2 default hr_api.g_varchar2

Line 1746: ,p_segment25 in varchar2 default hr_api.g_varchar2

1742: ,p_segment21 in varchar2 default hr_api.g_varchar2
1743: ,p_segment22 in varchar2 default hr_api.g_varchar2
1744: ,p_segment23 in varchar2 default hr_api.g_varchar2
1745: ,p_segment24 in varchar2 default hr_api.g_varchar2
1746: ,p_segment25 in varchar2 default hr_api.g_varchar2
1747: ,p_segment26 in varchar2 default hr_api.g_varchar2
1748: ,p_segment27 in varchar2 default hr_api.g_varchar2
1749: ,p_segment28 in varchar2 default hr_api.g_varchar2
1750: ,p_segment29 in varchar2 default hr_api.g_varchar2

Line 1747: ,p_segment26 in varchar2 default hr_api.g_varchar2

1743: ,p_segment22 in varchar2 default hr_api.g_varchar2
1744: ,p_segment23 in varchar2 default hr_api.g_varchar2
1745: ,p_segment24 in varchar2 default hr_api.g_varchar2
1746: ,p_segment25 in varchar2 default hr_api.g_varchar2
1747: ,p_segment26 in varchar2 default hr_api.g_varchar2
1748: ,p_segment27 in varchar2 default hr_api.g_varchar2
1749: ,p_segment28 in varchar2 default hr_api.g_varchar2
1750: ,p_segment29 in varchar2 default hr_api.g_varchar2
1751: ,p_segment30 in varchar2 default hr_api.g_varchar2

Line 1748: ,p_segment27 in varchar2 default hr_api.g_varchar2

1744: ,p_segment23 in varchar2 default hr_api.g_varchar2
1745: ,p_segment24 in varchar2 default hr_api.g_varchar2
1746: ,p_segment25 in varchar2 default hr_api.g_varchar2
1747: ,p_segment26 in varchar2 default hr_api.g_varchar2
1748: ,p_segment27 in varchar2 default hr_api.g_varchar2
1749: ,p_segment28 in varchar2 default hr_api.g_varchar2
1750: ,p_segment29 in varchar2 default hr_api.g_varchar2
1751: ,p_segment30 in varchar2 default hr_api.g_varchar2
1752: ,p_concat_segments in varchar2 default hr_api.g_varchar2

Line 1749: ,p_segment28 in varchar2 default hr_api.g_varchar2

1745: ,p_segment24 in varchar2 default hr_api.g_varchar2
1746: ,p_segment25 in varchar2 default hr_api.g_varchar2
1747: ,p_segment26 in varchar2 default hr_api.g_varchar2
1748: ,p_segment27 in varchar2 default hr_api.g_varchar2
1749: ,p_segment28 in varchar2 default hr_api.g_varchar2
1750: ,p_segment29 in varchar2 default hr_api.g_varchar2
1751: ,p_segment30 in varchar2 default hr_api.g_varchar2
1752: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1753: ,p_group_name out nocopy varchar2

Line 1750: ,p_segment29 in varchar2 default hr_api.g_varchar2

1746: ,p_segment25 in varchar2 default hr_api.g_varchar2
1747: ,p_segment26 in varchar2 default hr_api.g_varchar2
1748: ,p_segment27 in varchar2 default hr_api.g_varchar2
1749: ,p_segment28 in varchar2 default hr_api.g_varchar2
1750: ,p_segment29 in varchar2 default hr_api.g_varchar2
1751: ,p_segment30 in varchar2 default hr_api.g_varchar2
1752: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1753: ,p_group_name out nocopy varchar2
1754: ,p_employment_category in varchar2 default hr_api.g_varchar2

Line 1751: ,p_segment30 in varchar2 default hr_api.g_varchar2

1747: ,p_segment26 in varchar2 default hr_api.g_varchar2
1748: ,p_segment27 in varchar2 default hr_api.g_varchar2
1749: ,p_segment28 in varchar2 default hr_api.g_varchar2
1750: ,p_segment29 in varchar2 default hr_api.g_varchar2
1751: ,p_segment30 in varchar2 default hr_api.g_varchar2
1752: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1753: ,p_group_name out nocopy varchar2
1754: ,p_employment_category in varchar2 default hr_api.g_varchar2
1755: ,p_effective_start_date out nocopy date

Line 1752: ,p_concat_segments in varchar2 default hr_api.g_varchar2

1748: ,p_segment27 in varchar2 default hr_api.g_varchar2
1749: ,p_segment28 in varchar2 default hr_api.g_varchar2
1750: ,p_segment29 in varchar2 default hr_api.g_varchar2
1751: ,p_segment30 in varchar2 default hr_api.g_varchar2
1752: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1753: ,p_group_name out nocopy varchar2
1754: ,p_employment_category in varchar2 default hr_api.g_varchar2
1755: ,p_effective_start_date out nocopy date
1756: ,p_effective_end_date out nocopy date

Line 1754: ,p_employment_category in varchar2 default hr_api.g_varchar2

1750: ,p_segment29 in varchar2 default hr_api.g_varchar2
1751: ,p_segment30 in varchar2 default hr_api.g_varchar2
1752: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1753: ,p_group_name out nocopy varchar2
1754: ,p_employment_category in varchar2 default hr_api.g_varchar2
1755: ,p_effective_start_date out nocopy date
1756: ,p_effective_end_date out nocopy date
1757: ,p_people_group_id out nocopy number
1758: ,p_entries_changed_warning out nocopy varchar2

Line 1794: hr_api.constant_to_boolean

1790: --
1791: -- Convert constant values to their corresponding boolean value
1792: --
1793: l_validate :=
1794: hr_api.constant_to_boolean
1795: (p_constant_value => p_validate);
1796: --
1797: -- Register Surrogate ID or user key values
1798: --