eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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_status_change_comments in varchar2 default null
18: ,p_object_version_number in out nocopy number
19: ,p_effective_start_date out nocopy date
20: ,p_effective_end_date out nocopy date

Line 247: (p_validate in number default hr_api.g_false_num

243: -- ----------------------------------------------------------------------------
244: -- |-----------------------< create_secondary_apl_asg >-----------------------|
245: -- ----------------------------------------------------------------------------
246: PROCEDURE create_secondary_apl_asg
247: (p_validate in number default hr_api.g_false_num
248: ,p_effective_date in date
249: ,p_person_id in number
250: ,p_organization_id in number
251: ,p_recruiter_id in number default null

Line 373: hr_api.constant_to_boolean

369: --
370: -- Convert constant values to their corresponding boolean value
371: --
372: l_validate :=
373: hr_api.constant_to_boolean
374: (p_constant_value => p_validate);
375: --
376: -- Register Surrogate ID or user key values
377: --

Line 551: (p_validate in number default hr_api.g_false_num

547: -- ----------------------------------------------------------------------------
548: -- |----------------------------< accept_apl_asg >----------------------------|
549: -- ----------------------------------------------------------------------------
550: PROCEDURE accept_apl_asg
551: (p_validate in number default hr_api.g_false_num
552: ,p_effective_date in date
553: ,p_datetrack_update_mode in varchar2
554: ,p_assignment_id in number
555: ,p_object_version_number in out nocopy number

Line 556: ,p_assignment_status_type_id in number default hr_api.g_number

552: ,p_effective_date in date
553: ,p_datetrack_update_mode in varchar2
554: ,p_assignment_id in number
555: ,p_object_version_number in out nocopy number
556: ,p_assignment_status_type_id in number default hr_api.g_number
557: ,p_change_reason in varchar2 default hr_api.g_varchar2
558: ,p_effective_start_date out nocopy date
559: ,p_effective_end_date out nocopy date
560: ,p_return_status out nocopy varchar2

Line 557: ,p_change_reason in varchar2 default hr_api.g_varchar2

553: ,p_datetrack_update_mode in varchar2
554: ,p_assignment_id in number
555: ,p_object_version_number in out nocopy number
556: ,p_assignment_status_type_id in number default hr_api.g_number
557: ,p_change_reason in varchar2 default hr_api.g_varchar2
558: ,p_effective_start_date out nocopy date
559: ,p_effective_end_date out nocopy date
560: ,p_return_status out nocopy varchar2
561: ) is

Line 589: hr_api.constant_to_boolean

585: --
586: -- Convert constant values to their corresponding boolean value
587: --
588: l_validate :=
589: hr_api.constant_to_boolean
590: (p_constant_value => p_validate);
591: --
592: -- Register Surrogate ID or user key values
593: --

Line 665: (p_validate in number default hr_api.g_false_num

661: -- ----------------------------------------------------------------------------
662: -- |---------------------------< activate_apl_asg >---------------------------|
663: -- ----------------------------------------------------------------------------
664: PROCEDURE activate_apl_asg
665: (p_validate in number default hr_api.g_false_num
666: ,p_effective_date in date
667: ,p_datetrack_update_mode in varchar2
668: ,p_assignment_id in number
669: ,p_object_version_number in out nocopy number

Line 670: ,p_assignment_status_type_id in number default hr_api.g_number

666: ,p_effective_date in date
667: ,p_datetrack_update_mode in varchar2
668: ,p_assignment_id in number
669: ,p_object_version_number in out nocopy number
670: ,p_assignment_status_type_id in number default hr_api.g_number
671: ,p_change_reason in varchar2 default hr_api.g_varchar2
672: ,p_effective_start_date out nocopy date
673: ,p_effective_end_date out nocopy date
674: ,p_return_status out nocopy varchar2

Line 671: ,p_change_reason in varchar2 default hr_api.g_varchar2

667: ,p_datetrack_update_mode in varchar2
668: ,p_assignment_id in number
669: ,p_object_version_number in out nocopy number
670: ,p_assignment_status_type_id in number default hr_api.g_number
671: ,p_change_reason in varchar2 default hr_api.g_varchar2
672: ,p_effective_start_date out nocopy date
673: ,p_effective_end_date out nocopy date
674: ,p_return_status out nocopy varchar2
675: ) is

Line 703: hr_api.constant_to_boolean

699: --
700: -- Convert constant values to their corresponding boolean value
701: --
702: l_validate :=
703: hr_api.constant_to_boolean
704: (p_constant_value => p_validate);
705: --
706: -- Register Surrogate ID or user key values
707: --

Line 779: (p_validate in number default hr_api.g_false_num

775: -- ----------------------------------------------------------------------------
776: -- |-----------------------------< offer_apl_asg >----------------------------|
777: -- ----------------------------------------------------------------------------
778: PROCEDURE offer_apl_asg
779: (p_validate in number default hr_api.g_false_num
780: ,p_effective_date in date
781: ,p_datetrack_update_mode in varchar2
782: ,p_assignment_id in number
783: ,p_object_version_number in out nocopy number

Line 784: ,p_assignment_status_type_id in number default hr_api.g_number

780: ,p_effective_date in date
781: ,p_datetrack_update_mode in varchar2
782: ,p_assignment_id in number
783: ,p_object_version_number in out nocopy number
784: ,p_assignment_status_type_id in number default hr_api.g_number
785: ,p_change_reason in varchar2 default hr_api.g_varchar2
786: ,p_effective_start_date out nocopy date
787: ,p_effective_end_date out nocopy date
788: ,p_return_status out nocopy varchar2

Line 785: ,p_change_reason in varchar2 default hr_api.g_varchar2

781: ,p_datetrack_update_mode in varchar2
782: ,p_assignment_id in number
783: ,p_object_version_number in out nocopy number
784: ,p_assignment_status_type_id in number default hr_api.g_number
785: ,p_change_reason in varchar2 default hr_api.g_varchar2
786: ,p_effective_start_date out nocopy date
787: ,p_effective_end_date out nocopy date
788: ,p_return_status out nocopy varchar2
789: ) is

Line 817: hr_api.constant_to_boolean

813: --
814: -- Convert constant values to their corresponding boolean value
815: --
816: l_validate :=
817: hr_api.constant_to_boolean
818: (p_constant_value => p_validate);
819: --
820: -- Register Surrogate ID or user key values
821: --

Line 893: (p_validate in number default hr_api.g_false_num

889: -- ----------------------------------------------------------------------------
890: -- |---------------------------< terminate_apl_asg >--------------------------|
891: -- ----------------------------------------------------------------------------
892: PROCEDURE terminate_apl_asg
893: (p_validate in number default hr_api.g_false_num
894: ,p_effective_date in date
895: ,p_assignment_id in number
896: ,p_object_version_number in out nocopy number
897: ,p_effective_start_date out nocopy date

Line 928: hr_api.constant_to_boolean

924: --
925: -- Convert constant values to their corresponding boolean value
926: --
927: l_validate :=
928: hr_api.constant_to_boolean
929: (p_constant_value => p_validate);
930: --
931: -- Register Surrogate ID or user key values
932: --

Line 1001: (p_validate in number default hr_api.g_false_num

997: -- ----------------------------------------------------------------------------
998: -- |----------------------------< update_apl_asg >----------------------------|
999: -- ----------------------------------------------------------------------------
1000: PROCEDURE update_apl_asg
1001: (p_validate in number default hr_api.g_false_num
1002: ,p_effective_date in date
1003: ,p_datetrack_update_mode in varchar2
1004: ,p_assignment_id in number
1005: ,p_object_version_number in out nocopy number

Line 1006: ,p_recruiter_id in number default hr_api.g_number

1002: ,p_effective_date in date
1003: ,p_datetrack_update_mode in varchar2
1004: ,p_assignment_id in number
1005: ,p_object_version_number in out nocopy number
1006: ,p_recruiter_id in number default hr_api.g_number
1007: ,p_grade_id in number default hr_api.g_number
1008: ,p_position_id in number default hr_api.g_number
1009: ,p_job_id in number default hr_api.g_number
1010: ,p_payroll_id in number default hr_api.g_number

Line 1007: ,p_grade_id in number default hr_api.g_number

1003: ,p_datetrack_update_mode in varchar2
1004: ,p_assignment_id in number
1005: ,p_object_version_number in out nocopy number
1006: ,p_recruiter_id in number default hr_api.g_number
1007: ,p_grade_id in number default hr_api.g_number
1008: ,p_position_id in number default hr_api.g_number
1009: ,p_job_id in number default hr_api.g_number
1010: ,p_payroll_id in number default hr_api.g_number
1011: ,p_location_id in number default hr_api.g_number

Line 1008: ,p_position_id in number default hr_api.g_number

1004: ,p_assignment_id in number
1005: ,p_object_version_number in out nocopy number
1006: ,p_recruiter_id in number default hr_api.g_number
1007: ,p_grade_id in number default hr_api.g_number
1008: ,p_position_id in number default hr_api.g_number
1009: ,p_job_id in number default hr_api.g_number
1010: ,p_payroll_id in number default hr_api.g_number
1011: ,p_location_id in number default hr_api.g_number
1012: ,p_person_referred_by_id in number default hr_api.g_number

Line 1009: ,p_job_id in number default hr_api.g_number

1005: ,p_object_version_number in out nocopy number
1006: ,p_recruiter_id in number default hr_api.g_number
1007: ,p_grade_id in number default hr_api.g_number
1008: ,p_position_id in number default hr_api.g_number
1009: ,p_job_id in number default hr_api.g_number
1010: ,p_payroll_id in number default hr_api.g_number
1011: ,p_location_id in number default hr_api.g_number
1012: ,p_person_referred_by_id in number default hr_api.g_number
1013: ,p_supervisor_id in number default hr_api.g_number

Line 1010: ,p_payroll_id in number default hr_api.g_number

1006: ,p_recruiter_id in number default hr_api.g_number
1007: ,p_grade_id in number default hr_api.g_number
1008: ,p_position_id in number default hr_api.g_number
1009: ,p_job_id in number default hr_api.g_number
1010: ,p_payroll_id in number default hr_api.g_number
1011: ,p_location_id in number default hr_api.g_number
1012: ,p_person_referred_by_id in number default hr_api.g_number
1013: ,p_supervisor_id in number default hr_api.g_number
1014: ,p_special_ceiling_step_id in number default hr_api.g_number

Line 1011: ,p_location_id in number default hr_api.g_number

1007: ,p_grade_id in number default hr_api.g_number
1008: ,p_position_id in number default hr_api.g_number
1009: ,p_job_id in number default hr_api.g_number
1010: ,p_payroll_id in number default hr_api.g_number
1011: ,p_location_id in number default hr_api.g_number
1012: ,p_person_referred_by_id in number default hr_api.g_number
1013: ,p_supervisor_id in number default hr_api.g_number
1014: ,p_special_ceiling_step_id in number default hr_api.g_number
1015: ,p_recruitment_activity_id in number default hr_api.g_number

Line 1012: ,p_person_referred_by_id in number default hr_api.g_number

1008: ,p_position_id in number default hr_api.g_number
1009: ,p_job_id in number default hr_api.g_number
1010: ,p_payroll_id in number default hr_api.g_number
1011: ,p_location_id in number default hr_api.g_number
1012: ,p_person_referred_by_id in number default hr_api.g_number
1013: ,p_supervisor_id in number default hr_api.g_number
1014: ,p_special_ceiling_step_id in number default hr_api.g_number
1015: ,p_recruitment_activity_id in number default hr_api.g_number
1016: ,p_source_organization_id in number default hr_api.g_number

Line 1013: ,p_supervisor_id in number default hr_api.g_number

1009: ,p_job_id in number default hr_api.g_number
1010: ,p_payroll_id in number default hr_api.g_number
1011: ,p_location_id in number default hr_api.g_number
1012: ,p_person_referred_by_id in number default hr_api.g_number
1013: ,p_supervisor_id in number default hr_api.g_number
1014: ,p_special_ceiling_step_id in number default hr_api.g_number
1015: ,p_recruitment_activity_id in number default hr_api.g_number
1016: ,p_source_organization_id in number default hr_api.g_number
1017: ,p_organization_id in number default hr_api.g_number

Line 1014: ,p_special_ceiling_step_id in number default hr_api.g_number

1010: ,p_payroll_id in number default hr_api.g_number
1011: ,p_location_id in number default hr_api.g_number
1012: ,p_person_referred_by_id in number default hr_api.g_number
1013: ,p_supervisor_id in number default hr_api.g_number
1014: ,p_special_ceiling_step_id in number default hr_api.g_number
1015: ,p_recruitment_activity_id in number default hr_api.g_number
1016: ,p_source_organization_id in number default hr_api.g_number
1017: ,p_organization_id in number default hr_api.g_number
1018: ,p_vacancy_id in number default hr_api.g_number

Line 1015: ,p_recruitment_activity_id in number default hr_api.g_number

1011: ,p_location_id in number default hr_api.g_number
1012: ,p_person_referred_by_id in number default hr_api.g_number
1013: ,p_supervisor_id in number default hr_api.g_number
1014: ,p_special_ceiling_step_id in number default hr_api.g_number
1015: ,p_recruitment_activity_id in number default hr_api.g_number
1016: ,p_source_organization_id in number default hr_api.g_number
1017: ,p_organization_id in number default hr_api.g_number
1018: ,p_vacancy_id in number default hr_api.g_number
1019: ,p_pay_basis_id in number default hr_api.g_number

Line 1016: ,p_source_organization_id in number default hr_api.g_number

1012: ,p_person_referred_by_id in number default hr_api.g_number
1013: ,p_supervisor_id in number default hr_api.g_number
1014: ,p_special_ceiling_step_id in number default hr_api.g_number
1015: ,p_recruitment_activity_id in number default hr_api.g_number
1016: ,p_source_organization_id in number default hr_api.g_number
1017: ,p_organization_id in number default hr_api.g_number
1018: ,p_vacancy_id in number default hr_api.g_number
1019: ,p_pay_basis_id in number default hr_api.g_number
1020: ,p_application_id in number default hr_api.g_number

Line 1017: ,p_organization_id in number default hr_api.g_number

1013: ,p_supervisor_id in number default hr_api.g_number
1014: ,p_special_ceiling_step_id in number default hr_api.g_number
1015: ,p_recruitment_activity_id in number default hr_api.g_number
1016: ,p_source_organization_id in number default hr_api.g_number
1017: ,p_organization_id in number default hr_api.g_number
1018: ,p_vacancy_id in number default hr_api.g_number
1019: ,p_pay_basis_id in number default hr_api.g_number
1020: ,p_application_id in number default hr_api.g_number
1021: ,p_change_reason in varchar2 default hr_api.g_varchar2

Line 1018: ,p_vacancy_id in number default hr_api.g_number

1014: ,p_special_ceiling_step_id in number default hr_api.g_number
1015: ,p_recruitment_activity_id in number default hr_api.g_number
1016: ,p_source_organization_id in number default hr_api.g_number
1017: ,p_organization_id in number default hr_api.g_number
1018: ,p_vacancy_id in number default hr_api.g_number
1019: ,p_pay_basis_id in number default hr_api.g_number
1020: ,p_application_id in number default hr_api.g_number
1021: ,p_change_reason in varchar2 default hr_api.g_varchar2
1022: ,p_assignment_status_type_id in number default hr_api.g_number

Line 1019: ,p_pay_basis_id in number default hr_api.g_number

1015: ,p_recruitment_activity_id in number default hr_api.g_number
1016: ,p_source_organization_id in number default hr_api.g_number
1017: ,p_organization_id in number default hr_api.g_number
1018: ,p_vacancy_id in number default hr_api.g_number
1019: ,p_pay_basis_id in number default hr_api.g_number
1020: ,p_application_id in number default hr_api.g_number
1021: ,p_change_reason in varchar2 default hr_api.g_varchar2
1022: ,p_assignment_status_type_id in number default hr_api.g_number
1023: ,p_comments in varchar2 default hr_api.g_varchar2

Line 1020: ,p_application_id in number default hr_api.g_number

1016: ,p_source_organization_id in number default hr_api.g_number
1017: ,p_organization_id in number default hr_api.g_number
1018: ,p_vacancy_id in number default hr_api.g_number
1019: ,p_pay_basis_id in number default hr_api.g_number
1020: ,p_application_id in number default hr_api.g_number
1021: ,p_change_reason in varchar2 default hr_api.g_varchar2
1022: ,p_assignment_status_type_id in number default hr_api.g_number
1023: ,p_comments in varchar2 default hr_api.g_varchar2
1024: ,p_date_probation_end in date default hr_api.g_date

Line 1021: ,p_change_reason in varchar2 default hr_api.g_varchar2

1017: ,p_organization_id in number default hr_api.g_number
1018: ,p_vacancy_id in number default hr_api.g_number
1019: ,p_pay_basis_id in number default hr_api.g_number
1020: ,p_application_id in number default hr_api.g_number
1021: ,p_change_reason in varchar2 default hr_api.g_varchar2
1022: ,p_assignment_status_type_id in number default hr_api.g_number
1023: ,p_comments in varchar2 default hr_api.g_varchar2
1024: ,p_date_probation_end in date default hr_api.g_date
1025: ,p_default_code_comb_id in number default hr_api.g_number

Line 1022: ,p_assignment_status_type_id in number default hr_api.g_number

1018: ,p_vacancy_id in number default hr_api.g_number
1019: ,p_pay_basis_id in number default hr_api.g_number
1020: ,p_application_id in number default hr_api.g_number
1021: ,p_change_reason in varchar2 default hr_api.g_varchar2
1022: ,p_assignment_status_type_id in number default hr_api.g_number
1023: ,p_comments in varchar2 default hr_api.g_varchar2
1024: ,p_date_probation_end in date default hr_api.g_date
1025: ,p_default_code_comb_id in number default hr_api.g_number
1026: ,p_employment_category in varchar2 default hr_api.g_varchar2

Line 1023: ,p_comments in varchar2 default hr_api.g_varchar2

1019: ,p_pay_basis_id in number default hr_api.g_number
1020: ,p_application_id in number default hr_api.g_number
1021: ,p_change_reason in varchar2 default hr_api.g_varchar2
1022: ,p_assignment_status_type_id in number default hr_api.g_number
1023: ,p_comments in varchar2 default hr_api.g_varchar2
1024: ,p_date_probation_end in date default hr_api.g_date
1025: ,p_default_code_comb_id in number default hr_api.g_number
1026: ,p_employment_category in varchar2 default hr_api.g_varchar2
1027: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 1024: ,p_date_probation_end in date default hr_api.g_date

1020: ,p_application_id in number default hr_api.g_number
1021: ,p_change_reason in varchar2 default hr_api.g_varchar2
1022: ,p_assignment_status_type_id in number default hr_api.g_number
1023: ,p_comments in varchar2 default hr_api.g_varchar2
1024: ,p_date_probation_end in date default hr_api.g_date
1025: ,p_default_code_comb_id in number default hr_api.g_number
1026: ,p_employment_category in varchar2 default hr_api.g_varchar2
1027: ,p_frequency in varchar2 default hr_api.g_varchar2
1028: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

Line 1025: ,p_default_code_comb_id in number default hr_api.g_number

1021: ,p_change_reason in varchar2 default hr_api.g_varchar2
1022: ,p_assignment_status_type_id in number default hr_api.g_number
1023: ,p_comments in varchar2 default hr_api.g_varchar2
1024: ,p_date_probation_end in date default hr_api.g_date
1025: ,p_default_code_comb_id in number default hr_api.g_number
1026: ,p_employment_category in varchar2 default hr_api.g_varchar2
1027: ,p_frequency in varchar2 default hr_api.g_varchar2
1028: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1029: ,p_manager_flag in varchar2 default hr_api.g_varchar2

Line 1026: ,p_employment_category in varchar2 default hr_api.g_varchar2

1022: ,p_assignment_status_type_id in number default hr_api.g_number
1023: ,p_comments in varchar2 default hr_api.g_varchar2
1024: ,p_date_probation_end in date default hr_api.g_date
1025: ,p_default_code_comb_id in number default hr_api.g_number
1026: ,p_employment_category in varchar2 default hr_api.g_varchar2
1027: ,p_frequency in varchar2 default hr_api.g_varchar2
1028: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1029: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1030: ,p_normal_hours in number default hr_api.g_number

Line 1027: ,p_frequency in varchar2 default hr_api.g_varchar2

1023: ,p_comments in varchar2 default hr_api.g_varchar2
1024: ,p_date_probation_end in date default hr_api.g_date
1025: ,p_default_code_comb_id in number default hr_api.g_number
1026: ,p_employment_category in varchar2 default hr_api.g_varchar2
1027: ,p_frequency in varchar2 default hr_api.g_varchar2
1028: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1029: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1030: ,p_normal_hours in number default hr_api.g_number
1031: ,p_perf_review_period in number default hr_api.g_number

Line 1028: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

1024: ,p_date_probation_end in date default hr_api.g_date
1025: ,p_default_code_comb_id in number default hr_api.g_number
1026: ,p_employment_category in varchar2 default hr_api.g_varchar2
1027: ,p_frequency in varchar2 default hr_api.g_varchar2
1028: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1029: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1030: ,p_normal_hours in number default hr_api.g_number
1031: ,p_perf_review_period in number default hr_api.g_number
1032: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 1029: ,p_manager_flag in varchar2 default hr_api.g_varchar2

1025: ,p_default_code_comb_id in number default hr_api.g_number
1026: ,p_employment_category in varchar2 default hr_api.g_varchar2
1027: ,p_frequency in varchar2 default hr_api.g_varchar2
1028: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1029: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1030: ,p_normal_hours in number default hr_api.g_number
1031: ,p_perf_review_period in number default hr_api.g_number
1032: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1033: ,p_probation_period in number default hr_api.g_number

Line 1030: ,p_normal_hours in number default hr_api.g_number

1026: ,p_employment_category in varchar2 default hr_api.g_varchar2
1027: ,p_frequency in varchar2 default hr_api.g_varchar2
1028: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1029: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1030: ,p_normal_hours in number default hr_api.g_number
1031: ,p_perf_review_period in number default hr_api.g_number
1032: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1033: ,p_probation_period in number default hr_api.g_number
1034: ,p_probation_unit in varchar2 default hr_api.g_varchar2

Line 1031: ,p_perf_review_period in number default hr_api.g_number

1027: ,p_frequency in varchar2 default hr_api.g_varchar2
1028: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1029: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1030: ,p_normal_hours in number default hr_api.g_number
1031: ,p_perf_review_period in number default hr_api.g_number
1032: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1033: ,p_probation_period in number default hr_api.g_number
1034: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1035: ,p_sal_review_period in number default hr_api.g_number

Line 1032: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

1028: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1029: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1030: ,p_normal_hours in number default hr_api.g_number
1031: ,p_perf_review_period in number default hr_api.g_number
1032: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1033: ,p_probation_period in number default hr_api.g_number
1034: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1035: ,p_sal_review_period in number default hr_api.g_number
1036: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 1033: ,p_probation_period in number default hr_api.g_number

1029: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1030: ,p_normal_hours in number default hr_api.g_number
1031: ,p_perf_review_period in number default hr_api.g_number
1032: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1033: ,p_probation_period in number default hr_api.g_number
1034: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1035: ,p_sal_review_period in number default hr_api.g_number
1036: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1037: ,p_set_of_books_id in number default hr_api.g_number

Line 1034: ,p_probation_unit in varchar2 default hr_api.g_varchar2

1030: ,p_normal_hours in number default hr_api.g_number
1031: ,p_perf_review_period in number default hr_api.g_number
1032: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1033: ,p_probation_period in number default hr_api.g_number
1034: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1035: ,p_sal_review_period in number default hr_api.g_number
1036: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1037: ,p_set_of_books_id in number default hr_api.g_number
1038: ,p_source_type in varchar2 default hr_api.g_varchar2

Line 1035: ,p_sal_review_period in number default hr_api.g_number

1031: ,p_perf_review_period in number default hr_api.g_number
1032: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1033: ,p_probation_period in number default hr_api.g_number
1034: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1035: ,p_sal_review_period in number default hr_api.g_number
1036: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1037: ,p_set_of_books_id in number default hr_api.g_number
1038: ,p_source_type in varchar2 default hr_api.g_varchar2
1039: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

Line 1036: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

1032: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1033: ,p_probation_period in number default hr_api.g_number
1034: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1035: ,p_sal_review_period in number default hr_api.g_number
1036: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1037: ,p_set_of_books_id in number default hr_api.g_number
1038: ,p_source_type in varchar2 default hr_api.g_varchar2
1039: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1040: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

Line 1037: ,p_set_of_books_id in number default hr_api.g_number

1033: ,p_probation_period in number default hr_api.g_number
1034: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1035: ,p_sal_review_period in number default hr_api.g_number
1036: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1037: ,p_set_of_books_id in number default hr_api.g_number
1038: ,p_source_type in varchar2 default hr_api.g_varchar2
1039: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1040: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1041: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

Line 1038: ,p_source_type in varchar2 default hr_api.g_varchar2

1034: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1035: ,p_sal_review_period in number default hr_api.g_number
1036: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1037: ,p_set_of_books_id in number default hr_api.g_number
1038: ,p_source_type in varchar2 default hr_api.g_varchar2
1039: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1040: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1041: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

Line 1039: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

1035: ,p_sal_review_period in number default hr_api.g_number
1036: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1037: ,p_set_of_books_id in number default hr_api.g_number
1038: ,p_source_type in varchar2 default hr_api.g_varchar2
1039: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1040: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1041: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

Line 1040: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

1036: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1037: ,p_set_of_books_id in number default hr_api.g_number
1038: ,p_source_type in varchar2 default hr_api.g_varchar2
1039: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1040: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1041: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

Line 1041: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

1037: ,p_set_of_books_id in number default hr_api.g_number
1038: ,p_source_type in varchar2 default hr_api.g_varchar2
1039: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1040: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1041: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

Line 1042: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

1038: ,p_source_type in varchar2 default hr_api.g_varchar2
1039: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1040: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1041: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

Line 1043: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

1039: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1040: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1041: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

Line 1044: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

1040: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1041: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

Line 1045: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

1041: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1042: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

Line 1046: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

1042: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1043: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

Line 1047: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

1043: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1044: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

Line 1048: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

1044: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1045: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

Line 1049: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

1045: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1046: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

Line 1050: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

1046: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1047: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

Line 1051: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

1047: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1048: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

Line 1052: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

1048: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1049: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

Line 1053: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

1049: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1050: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

Line 1054: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

1050: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1051: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

Line 1055: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

1051: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1052: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

Line 1056: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

1052: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1053: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

Line 1057: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

1053: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1054: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

Line 1058: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

1054: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1055: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

Line 1059: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

1055: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1056: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1063: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

Line 1060: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

1056: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1057: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1063: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1064: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

Line 1061: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

1057: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1058: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1063: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1064: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1065: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

Line 1062: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

1058: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1059: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1063: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1064: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1065: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1066: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

Line 1063: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

1059: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1060: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1063: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1064: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1065: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1066: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1067: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

Line 1064: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

1060: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1061: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1063: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1064: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1065: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1066: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1067: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1068: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

Line 1065: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

1061: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1062: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1063: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1064: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1065: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1066: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1067: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1068: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1069: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

Line 1066: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

1062: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1063: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1064: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1065: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1066: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1067: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1068: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1069: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1070: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

Line 1067: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

1063: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1064: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1065: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1066: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1067: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1068: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1069: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1070: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1071: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

Line 1068: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

1064: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1065: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1066: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1067: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1068: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1069: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1070: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1071: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1072: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

Line 1069: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

1065: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1066: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1067: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1068: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1069: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1070: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1071: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1072: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1073: ,p_title in varchar2 default hr_api.g_varchar2

Line 1070: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

1066: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1067: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1068: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1069: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1070: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1071: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1072: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1073: ,p_title in varchar2 default hr_api.g_varchar2
1074: ,p_concatenated_segments out nocopy varchar2

Line 1071: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

1067: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1068: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1069: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1070: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1071: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1072: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1073: ,p_title in varchar2 default hr_api.g_varchar2
1074: ,p_concatenated_segments out nocopy varchar2
1075: ,p_contract_id in number default hr_api.g_number

Line 1072: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

1068: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1069: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1070: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1071: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1072: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1073: ,p_title in varchar2 default hr_api.g_varchar2
1074: ,p_concatenated_segments out nocopy varchar2
1075: ,p_contract_id in number default hr_api.g_number
1076: ,p_establishment_id in number default hr_api.g_number

Line 1073: ,p_title in varchar2 default hr_api.g_varchar2

1069: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1070: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1071: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1072: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1073: ,p_title in varchar2 default hr_api.g_varchar2
1074: ,p_concatenated_segments out nocopy varchar2
1075: ,p_contract_id in number default hr_api.g_number
1076: ,p_establishment_id in number default hr_api.g_number
1077: ,p_collective_agreement_id in number default hr_api.g_number

Line 1075: ,p_contract_id in number default hr_api.g_number

1071: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1072: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1073: ,p_title in varchar2 default hr_api.g_varchar2
1074: ,p_concatenated_segments out nocopy varchar2
1075: ,p_contract_id in number default hr_api.g_number
1076: ,p_establishment_id in number default hr_api.g_number
1077: ,p_collective_agreement_id in number default hr_api.g_number
1078: ,p_notice_period in number default hr_api.g_number
1079: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2

Line 1076: ,p_establishment_id in number default hr_api.g_number

1072: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1073: ,p_title in varchar2 default hr_api.g_varchar2
1074: ,p_concatenated_segments out nocopy varchar2
1075: ,p_contract_id in number default hr_api.g_number
1076: ,p_establishment_id in number default hr_api.g_number
1077: ,p_collective_agreement_id in number default hr_api.g_number
1078: ,p_notice_period in number default hr_api.g_number
1079: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1080: ,p_employee_category in varchar2 default hr_api.g_varchar2

Line 1077: ,p_collective_agreement_id in number default hr_api.g_number

1073: ,p_title in varchar2 default hr_api.g_varchar2
1074: ,p_concatenated_segments out nocopy varchar2
1075: ,p_contract_id in number default hr_api.g_number
1076: ,p_establishment_id in number default hr_api.g_number
1077: ,p_collective_agreement_id in number default hr_api.g_number
1078: ,p_notice_period in number default hr_api.g_number
1079: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1080: ,p_employee_category in varchar2 default hr_api.g_varchar2
1081: ,p_work_at_home in varchar2 default hr_api.g_varchar2

Line 1078: ,p_notice_period in number default hr_api.g_number

1074: ,p_concatenated_segments out nocopy varchar2
1075: ,p_contract_id in number default hr_api.g_number
1076: ,p_establishment_id in number default hr_api.g_number
1077: ,p_collective_agreement_id in number default hr_api.g_number
1078: ,p_notice_period in number default hr_api.g_number
1079: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1080: ,p_employee_category in varchar2 default hr_api.g_varchar2
1081: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1082: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

Line 1079: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2

1075: ,p_contract_id in number default hr_api.g_number
1076: ,p_establishment_id in number default hr_api.g_number
1077: ,p_collective_agreement_id in number default hr_api.g_number
1078: ,p_notice_period in number default hr_api.g_number
1079: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1080: ,p_employee_category in varchar2 default hr_api.g_varchar2
1081: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1082: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1083: ,p_posting_content_id in number default hr_api.g_number

Line 1080: ,p_employee_category in varchar2 default hr_api.g_varchar2

1076: ,p_establishment_id in number default hr_api.g_number
1077: ,p_collective_agreement_id in number default hr_api.g_number
1078: ,p_notice_period in number default hr_api.g_number
1079: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1080: ,p_employee_category in varchar2 default hr_api.g_varchar2
1081: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1082: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1083: ,p_posting_content_id in number default hr_api.g_number
1084: ,p_applicant_rank in number default hr_api.g_number

Line 1081: ,p_work_at_home in varchar2 default hr_api.g_varchar2

1077: ,p_collective_agreement_id in number default hr_api.g_number
1078: ,p_notice_period in number default hr_api.g_number
1079: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1080: ,p_employee_category in varchar2 default hr_api.g_varchar2
1081: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1082: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1083: ,p_posting_content_id in number default hr_api.g_number
1084: ,p_applicant_rank in number default hr_api.g_number
1085: ,p_status_change_comments in varchar2 default null

Line 1082: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

1078: ,p_notice_period in number default hr_api.g_number
1079: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1080: ,p_employee_category in varchar2 default hr_api.g_varchar2
1081: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1082: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1083: ,p_posting_content_id in number default hr_api.g_number
1084: ,p_applicant_rank in number default hr_api.g_number
1085: ,p_status_change_comments in varchar2 default null
1086: ,p_cagr_grade_def_id in out nocopy number

Line 1083: ,p_posting_content_id in number default hr_api.g_number

1079: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1080: ,p_employee_category in varchar2 default hr_api.g_varchar2
1081: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1082: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1083: ,p_posting_content_id in number default hr_api.g_number
1084: ,p_applicant_rank in number default hr_api.g_number
1085: ,p_status_change_comments in varchar2 default null
1086: ,p_cagr_grade_def_id in out nocopy number
1087: ,p_cagr_concatenated_segments out nocopy varchar2

Line 1084: ,p_applicant_rank in number default hr_api.g_number

1080: ,p_employee_category in varchar2 default hr_api.g_varchar2
1081: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1082: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1083: ,p_posting_content_id in number default hr_api.g_number
1084: ,p_applicant_rank in number default hr_api.g_number
1085: ,p_status_change_comments in varchar2 default null
1086: ,p_cagr_grade_def_id in out nocopy number
1087: ,p_cagr_concatenated_segments out nocopy varchar2
1088: ,p_group_name out nocopy varchar2

Line 1139: hr_api.constant_to_boolean

1135: --
1136: -- Convert constant values to their corresponding boolean value
1137: --
1138: l_validate :=
1139: hr_api.constant_to_boolean
1140: (p_constant_value => p_validate);
1141: --
1142: -- Added for turn off key flex field validation
1143: l_add_struct.extend(1);

Line 1331: (p_validate in number default hr_api.g_false_num

1327: -- ----------------------------------------------------------------------------
1328: -- |----------------------------< update_emp_asg >----------------------------|
1329: -- ----------------------------------------------------------------------------
1330: PROCEDURE update_emp_asg
1331: (p_validate in number default hr_api.g_false_num
1332: ,p_effective_date in date
1333: ,p_datetrack_update_mode in varchar2
1334: ,p_assignment_id in number
1335: ,p_object_version_number in out nocopy number

Line 1336: ,p_supervisor_id in number default hr_api.g_number

1332: ,p_effective_date in date
1333: ,p_datetrack_update_mode in varchar2
1334: ,p_assignment_id in number
1335: ,p_object_version_number in out nocopy number
1336: ,p_supervisor_id in number default hr_api.g_number
1337: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1338: ,p_change_reason in varchar2 default hr_api.g_varchar2
1339: ,p_assignment_status_type_id in number default hr_api.g_number
1340: ,p_comments in varchar2 default hr_api.g_varchar2

Line 1337: ,p_assignment_number in varchar2 default hr_api.g_varchar2

1333: ,p_datetrack_update_mode in varchar2
1334: ,p_assignment_id in number
1335: ,p_object_version_number in out nocopy number
1336: ,p_supervisor_id in number default hr_api.g_number
1337: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1338: ,p_change_reason in varchar2 default hr_api.g_varchar2
1339: ,p_assignment_status_type_id in number default hr_api.g_number
1340: ,p_comments in varchar2 default hr_api.g_varchar2
1341: ,p_date_probation_end in date default hr_api.g_date

Line 1338: ,p_change_reason in varchar2 default hr_api.g_varchar2

1334: ,p_assignment_id in number
1335: ,p_object_version_number in out nocopy number
1336: ,p_supervisor_id in number default hr_api.g_number
1337: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1338: ,p_change_reason in varchar2 default hr_api.g_varchar2
1339: ,p_assignment_status_type_id in number default hr_api.g_number
1340: ,p_comments in varchar2 default hr_api.g_varchar2
1341: ,p_date_probation_end in date default hr_api.g_date
1342: ,p_default_code_comb_id in number default hr_api.g_number

Line 1339: ,p_assignment_status_type_id in number default hr_api.g_number

1335: ,p_object_version_number in out nocopy number
1336: ,p_supervisor_id in number default hr_api.g_number
1337: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1338: ,p_change_reason in varchar2 default hr_api.g_varchar2
1339: ,p_assignment_status_type_id in number default hr_api.g_number
1340: ,p_comments in varchar2 default hr_api.g_varchar2
1341: ,p_date_probation_end in date default hr_api.g_date
1342: ,p_default_code_comb_id in number default hr_api.g_number
1343: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 1340: ,p_comments in varchar2 default hr_api.g_varchar2

1336: ,p_supervisor_id in number default hr_api.g_number
1337: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1338: ,p_change_reason in varchar2 default hr_api.g_varchar2
1339: ,p_assignment_status_type_id in number default hr_api.g_number
1340: ,p_comments in varchar2 default hr_api.g_varchar2
1341: ,p_date_probation_end in date default hr_api.g_date
1342: ,p_default_code_comb_id in number default hr_api.g_number
1343: ,p_frequency in varchar2 default hr_api.g_varchar2
1344: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

Line 1341: ,p_date_probation_end in date default hr_api.g_date

1337: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1338: ,p_change_reason in varchar2 default hr_api.g_varchar2
1339: ,p_assignment_status_type_id in number default hr_api.g_number
1340: ,p_comments in varchar2 default hr_api.g_varchar2
1341: ,p_date_probation_end in date default hr_api.g_date
1342: ,p_default_code_comb_id in number default hr_api.g_number
1343: ,p_frequency in varchar2 default hr_api.g_varchar2
1344: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1345: ,p_manager_flag in varchar2 default hr_api.g_varchar2

Line 1342: ,p_default_code_comb_id in number default hr_api.g_number

1338: ,p_change_reason in varchar2 default hr_api.g_varchar2
1339: ,p_assignment_status_type_id in number default hr_api.g_number
1340: ,p_comments in varchar2 default hr_api.g_varchar2
1341: ,p_date_probation_end in date default hr_api.g_date
1342: ,p_default_code_comb_id in number default hr_api.g_number
1343: ,p_frequency in varchar2 default hr_api.g_varchar2
1344: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1345: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1346: ,p_normal_hours in number default hr_api.g_number

Line 1343: ,p_frequency in varchar2 default hr_api.g_varchar2

1339: ,p_assignment_status_type_id in number default hr_api.g_number
1340: ,p_comments in varchar2 default hr_api.g_varchar2
1341: ,p_date_probation_end in date default hr_api.g_date
1342: ,p_default_code_comb_id in number default hr_api.g_number
1343: ,p_frequency in varchar2 default hr_api.g_varchar2
1344: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1345: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1346: ,p_normal_hours in number default hr_api.g_number
1347: ,p_perf_review_period in number default hr_api.g_number

Line 1344: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

1340: ,p_comments in varchar2 default hr_api.g_varchar2
1341: ,p_date_probation_end in date default hr_api.g_date
1342: ,p_default_code_comb_id in number default hr_api.g_number
1343: ,p_frequency in varchar2 default hr_api.g_varchar2
1344: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1345: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1346: ,p_normal_hours in number default hr_api.g_number
1347: ,p_perf_review_period in number default hr_api.g_number
1348: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 1345: ,p_manager_flag in varchar2 default hr_api.g_varchar2

1341: ,p_date_probation_end in date default hr_api.g_date
1342: ,p_default_code_comb_id in number default hr_api.g_number
1343: ,p_frequency in varchar2 default hr_api.g_varchar2
1344: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1345: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1346: ,p_normal_hours in number default hr_api.g_number
1347: ,p_perf_review_period in number default hr_api.g_number
1348: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1349: ,p_probation_period in number default hr_api.g_number

Line 1346: ,p_normal_hours in number default hr_api.g_number

1342: ,p_default_code_comb_id in number default hr_api.g_number
1343: ,p_frequency in varchar2 default hr_api.g_varchar2
1344: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1345: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1346: ,p_normal_hours in number default hr_api.g_number
1347: ,p_perf_review_period in number default hr_api.g_number
1348: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1349: ,p_probation_period in number default hr_api.g_number
1350: ,p_probation_unit in varchar2 default hr_api.g_varchar2

Line 1347: ,p_perf_review_period in number default hr_api.g_number

1343: ,p_frequency in varchar2 default hr_api.g_varchar2
1344: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1345: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1346: ,p_normal_hours in number default hr_api.g_number
1347: ,p_perf_review_period in number default hr_api.g_number
1348: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1349: ,p_probation_period in number default hr_api.g_number
1350: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1351: ,p_sal_review_period in number default hr_api.g_number

Line 1348: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

1344: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1345: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1346: ,p_normal_hours in number default hr_api.g_number
1347: ,p_perf_review_period in number default hr_api.g_number
1348: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1349: ,p_probation_period in number default hr_api.g_number
1350: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1351: ,p_sal_review_period in number default hr_api.g_number
1352: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 1349: ,p_probation_period in number default hr_api.g_number

1345: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1346: ,p_normal_hours in number default hr_api.g_number
1347: ,p_perf_review_period in number default hr_api.g_number
1348: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1349: ,p_probation_period in number default hr_api.g_number
1350: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1351: ,p_sal_review_period in number default hr_api.g_number
1352: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1353: ,p_set_of_books_id in number default hr_api.g_number

Line 1350: ,p_probation_unit in varchar2 default hr_api.g_varchar2

1346: ,p_normal_hours in number default hr_api.g_number
1347: ,p_perf_review_period in number default hr_api.g_number
1348: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1349: ,p_probation_period in number default hr_api.g_number
1350: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1351: ,p_sal_review_period in number default hr_api.g_number
1352: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1353: ,p_set_of_books_id in number default hr_api.g_number
1354: ,p_source_type in varchar2 default hr_api.g_varchar2

Line 1351: ,p_sal_review_period in number default hr_api.g_number

1347: ,p_perf_review_period in number default hr_api.g_number
1348: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1349: ,p_probation_period in number default hr_api.g_number
1350: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1351: ,p_sal_review_period in number default hr_api.g_number
1352: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1353: ,p_set_of_books_id in number default hr_api.g_number
1354: ,p_source_type in varchar2 default hr_api.g_varchar2
1355: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

Line 1352: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

1348: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1349: ,p_probation_period in number default hr_api.g_number
1350: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1351: ,p_sal_review_period in number default hr_api.g_number
1352: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1353: ,p_set_of_books_id in number default hr_api.g_number
1354: ,p_source_type in varchar2 default hr_api.g_varchar2
1355: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1356: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

Line 1353: ,p_set_of_books_id in number default hr_api.g_number

1349: ,p_probation_period in number default hr_api.g_number
1350: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1351: ,p_sal_review_period in number default hr_api.g_number
1352: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1353: ,p_set_of_books_id in number default hr_api.g_number
1354: ,p_source_type in varchar2 default hr_api.g_varchar2
1355: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1356: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1357: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

Line 1354: ,p_source_type in varchar2 default hr_api.g_varchar2

1350: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1351: ,p_sal_review_period in number default hr_api.g_number
1352: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1353: ,p_set_of_books_id in number default hr_api.g_number
1354: ,p_source_type in varchar2 default hr_api.g_varchar2
1355: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1356: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1357: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1358: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

Line 1355: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

1351: ,p_sal_review_period in number default hr_api.g_number
1352: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1353: ,p_set_of_books_id in number default hr_api.g_number
1354: ,p_source_type in varchar2 default hr_api.g_varchar2
1355: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1356: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1357: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1358: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1359: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2

Line 1356: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

1352: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1353: ,p_set_of_books_id in number default hr_api.g_number
1354: ,p_source_type in varchar2 default hr_api.g_varchar2
1355: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1356: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1357: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1358: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1359: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

Line 1357: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

1353: ,p_set_of_books_id in number default hr_api.g_number
1354: ,p_source_type in varchar2 default hr_api.g_varchar2
1355: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1356: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1357: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1358: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1359: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

Line 1358: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

1354: ,p_source_type in varchar2 default hr_api.g_varchar2
1355: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1356: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1357: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1358: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1359: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

Line 1359: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2

1355: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1356: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1357: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1358: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1359: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

Line 1360: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

1356: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1357: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1358: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1359: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

Line 1361: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

1357: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1358: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1359: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

Line 1362: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

1358: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1359: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

Line 1363: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

1359: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1360: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

Line 1364: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

1360: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1361: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

Line 1365: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

1361: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1362: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

Line 1366: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

1362: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1363: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

Line 1367: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

1363: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1364: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

Line 1368: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

1364: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1365: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

Line 1369: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

1365: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1366: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

Line 1370: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

1366: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1367: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

Line 1371: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

1367: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1368: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

Line 1372: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

1368: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1369: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

Line 1373: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

1369: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1370: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

Line 1374: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

1370: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1371: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

Line 1375: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

1371: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1372: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

Line 1376: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

1372: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1373: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

Line 1377: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

1373: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1374: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1381: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

Line 1378: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

1374: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1375: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1381: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1382: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

Line 1379: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

1375: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1376: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1381: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1382: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1383: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

Line 1380: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

1376: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1377: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1381: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1382: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1383: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1384: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

Line 1381: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

1377: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1378: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1381: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1382: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1383: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1384: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1385: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

Line 1382: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

1378: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1379: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1381: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1382: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1383: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1384: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1385: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1386: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

Line 1383: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

1379: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1380: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1381: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1382: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1383: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1384: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1385: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1386: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1387: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

Line 1384: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

1380: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1381: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1382: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1383: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1384: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1385: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1386: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1387: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1388: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

Line 1385: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

1381: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1382: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1383: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1384: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1385: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1386: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1387: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1388: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1389: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

Line 1386: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

1382: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1383: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1384: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1385: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1386: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1387: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1388: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1389: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1390: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

Line 1387: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

1383: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1384: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1385: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1386: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1387: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1388: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1389: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1390: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1391: ,p_title in varchar2 default hr_api.g_varchar2

Line 1388: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

1384: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1385: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1386: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1387: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1388: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1389: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1390: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1391: ,p_title in varchar2 default hr_api.g_varchar2
1392: ,p_segment1 in varchar2 default hr_api.g_varchar2

Line 1389: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

1385: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1386: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1387: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1388: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1389: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1390: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1391: ,p_title in varchar2 default hr_api.g_varchar2
1392: ,p_segment1 in varchar2 default hr_api.g_varchar2
1393: ,p_segment2 in varchar2 default hr_api.g_varchar2

Line 1390: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

1386: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1387: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1388: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1389: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1390: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1391: ,p_title in varchar2 default hr_api.g_varchar2
1392: ,p_segment1 in varchar2 default hr_api.g_varchar2
1393: ,p_segment2 in varchar2 default hr_api.g_varchar2
1394: ,p_segment3 in varchar2 default hr_api.g_varchar2

Line 1391: ,p_title in varchar2 default hr_api.g_varchar2

1387: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1388: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1389: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1390: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1391: ,p_title in varchar2 default hr_api.g_varchar2
1392: ,p_segment1 in varchar2 default hr_api.g_varchar2
1393: ,p_segment2 in varchar2 default hr_api.g_varchar2
1394: ,p_segment3 in varchar2 default hr_api.g_varchar2
1395: ,p_segment4 in varchar2 default hr_api.g_varchar2

Line 1392: ,p_segment1 in varchar2 default hr_api.g_varchar2

1388: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1389: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1390: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1391: ,p_title in varchar2 default hr_api.g_varchar2
1392: ,p_segment1 in varchar2 default hr_api.g_varchar2
1393: ,p_segment2 in varchar2 default hr_api.g_varchar2
1394: ,p_segment3 in varchar2 default hr_api.g_varchar2
1395: ,p_segment4 in varchar2 default hr_api.g_varchar2
1396: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 1393: ,p_segment2 in varchar2 default hr_api.g_varchar2

1389: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1390: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1391: ,p_title in varchar2 default hr_api.g_varchar2
1392: ,p_segment1 in varchar2 default hr_api.g_varchar2
1393: ,p_segment2 in varchar2 default hr_api.g_varchar2
1394: ,p_segment3 in varchar2 default hr_api.g_varchar2
1395: ,p_segment4 in varchar2 default hr_api.g_varchar2
1396: ,p_segment5 in varchar2 default hr_api.g_varchar2
1397: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 1394: ,p_segment3 in varchar2 default hr_api.g_varchar2

1390: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1391: ,p_title in varchar2 default hr_api.g_varchar2
1392: ,p_segment1 in varchar2 default hr_api.g_varchar2
1393: ,p_segment2 in varchar2 default hr_api.g_varchar2
1394: ,p_segment3 in varchar2 default hr_api.g_varchar2
1395: ,p_segment4 in varchar2 default hr_api.g_varchar2
1396: ,p_segment5 in varchar2 default hr_api.g_varchar2
1397: ,p_segment6 in varchar2 default hr_api.g_varchar2
1398: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 1395: ,p_segment4 in varchar2 default hr_api.g_varchar2

1391: ,p_title in varchar2 default hr_api.g_varchar2
1392: ,p_segment1 in varchar2 default hr_api.g_varchar2
1393: ,p_segment2 in varchar2 default hr_api.g_varchar2
1394: ,p_segment3 in varchar2 default hr_api.g_varchar2
1395: ,p_segment4 in varchar2 default hr_api.g_varchar2
1396: ,p_segment5 in varchar2 default hr_api.g_varchar2
1397: ,p_segment6 in varchar2 default hr_api.g_varchar2
1398: ,p_segment7 in varchar2 default hr_api.g_varchar2
1399: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 1396: ,p_segment5 in varchar2 default hr_api.g_varchar2

1392: ,p_segment1 in varchar2 default hr_api.g_varchar2
1393: ,p_segment2 in varchar2 default hr_api.g_varchar2
1394: ,p_segment3 in varchar2 default hr_api.g_varchar2
1395: ,p_segment4 in varchar2 default hr_api.g_varchar2
1396: ,p_segment5 in varchar2 default hr_api.g_varchar2
1397: ,p_segment6 in varchar2 default hr_api.g_varchar2
1398: ,p_segment7 in varchar2 default hr_api.g_varchar2
1399: ,p_segment8 in varchar2 default hr_api.g_varchar2
1400: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 1397: ,p_segment6 in varchar2 default hr_api.g_varchar2

1393: ,p_segment2 in varchar2 default hr_api.g_varchar2
1394: ,p_segment3 in varchar2 default hr_api.g_varchar2
1395: ,p_segment4 in varchar2 default hr_api.g_varchar2
1396: ,p_segment5 in varchar2 default hr_api.g_varchar2
1397: ,p_segment6 in varchar2 default hr_api.g_varchar2
1398: ,p_segment7 in varchar2 default hr_api.g_varchar2
1399: ,p_segment8 in varchar2 default hr_api.g_varchar2
1400: ,p_segment9 in varchar2 default hr_api.g_varchar2
1401: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 1398: ,p_segment7 in varchar2 default hr_api.g_varchar2

1394: ,p_segment3 in varchar2 default hr_api.g_varchar2
1395: ,p_segment4 in varchar2 default hr_api.g_varchar2
1396: ,p_segment5 in varchar2 default hr_api.g_varchar2
1397: ,p_segment6 in varchar2 default hr_api.g_varchar2
1398: ,p_segment7 in varchar2 default hr_api.g_varchar2
1399: ,p_segment8 in varchar2 default hr_api.g_varchar2
1400: ,p_segment9 in varchar2 default hr_api.g_varchar2
1401: ,p_segment10 in varchar2 default hr_api.g_varchar2
1402: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 1399: ,p_segment8 in varchar2 default hr_api.g_varchar2

1395: ,p_segment4 in varchar2 default hr_api.g_varchar2
1396: ,p_segment5 in varchar2 default hr_api.g_varchar2
1397: ,p_segment6 in varchar2 default hr_api.g_varchar2
1398: ,p_segment7 in varchar2 default hr_api.g_varchar2
1399: ,p_segment8 in varchar2 default hr_api.g_varchar2
1400: ,p_segment9 in varchar2 default hr_api.g_varchar2
1401: ,p_segment10 in varchar2 default hr_api.g_varchar2
1402: ,p_segment11 in varchar2 default hr_api.g_varchar2
1403: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 1400: ,p_segment9 in varchar2 default hr_api.g_varchar2

1396: ,p_segment5 in varchar2 default hr_api.g_varchar2
1397: ,p_segment6 in varchar2 default hr_api.g_varchar2
1398: ,p_segment7 in varchar2 default hr_api.g_varchar2
1399: ,p_segment8 in varchar2 default hr_api.g_varchar2
1400: ,p_segment9 in varchar2 default hr_api.g_varchar2
1401: ,p_segment10 in varchar2 default hr_api.g_varchar2
1402: ,p_segment11 in varchar2 default hr_api.g_varchar2
1403: ,p_segment12 in varchar2 default hr_api.g_varchar2
1404: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 1401: ,p_segment10 in varchar2 default hr_api.g_varchar2

1397: ,p_segment6 in varchar2 default hr_api.g_varchar2
1398: ,p_segment7 in varchar2 default hr_api.g_varchar2
1399: ,p_segment8 in varchar2 default hr_api.g_varchar2
1400: ,p_segment9 in varchar2 default hr_api.g_varchar2
1401: ,p_segment10 in varchar2 default hr_api.g_varchar2
1402: ,p_segment11 in varchar2 default hr_api.g_varchar2
1403: ,p_segment12 in varchar2 default hr_api.g_varchar2
1404: ,p_segment13 in varchar2 default hr_api.g_varchar2
1405: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 1402: ,p_segment11 in varchar2 default hr_api.g_varchar2

1398: ,p_segment7 in varchar2 default hr_api.g_varchar2
1399: ,p_segment8 in varchar2 default hr_api.g_varchar2
1400: ,p_segment9 in varchar2 default hr_api.g_varchar2
1401: ,p_segment10 in varchar2 default hr_api.g_varchar2
1402: ,p_segment11 in varchar2 default hr_api.g_varchar2
1403: ,p_segment12 in varchar2 default hr_api.g_varchar2
1404: ,p_segment13 in varchar2 default hr_api.g_varchar2
1405: ,p_segment14 in varchar2 default hr_api.g_varchar2
1406: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 1403: ,p_segment12 in varchar2 default hr_api.g_varchar2

1399: ,p_segment8 in varchar2 default hr_api.g_varchar2
1400: ,p_segment9 in varchar2 default hr_api.g_varchar2
1401: ,p_segment10 in varchar2 default hr_api.g_varchar2
1402: ,p_segment11 in varchar2 default hr_api.g_varchar2
1403: ,p_segment12 in varchar2 default hr_api.g_varchar2
1404: ,p_segment13 in varchar2 default hr_api.g_varchar2
1405: ,p_segment14 in varchar2 default hr_api.g_varchar2
1406: ,p_segment15 in varchar2 default hr_api.g_varchar2
1407: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 1404: ,p_segment13 in varchar2 default hr_api.g_varchar2

1400: ,p_segment9 in varchar2 default hr_api.g_varchar2
1401: ,p_segment10 in varchar2 default hr_api.g_varchar2
1402: ,p_segment11 in varchar2 default hr_api.g_varchar2
1403: ,p_segment12 in varchar2 default hr_api.g_varchar2
1404: ,p_segment13 in varchar2 default hr_api.g_varchar2
1405: ,p_segment14 in varchar2 default hr_api.g_varchar2
1406: ,p_segment15 in varchar2 default hr_api.g_varchar2
1407: ,p_segment16 in varchar2 default hr_api.g_varchar2
1408: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 1405: ,p_segment14 in varchar2 default hr_api.g_varchar2

1401: ,p_segment10 in varchar2 default hr_api.g_varchar2
1402: ,p_segment11 in varchar2 default hr_api.g_varchar2
1403: ,p_segment12 in varchar2 default hr_api.g_varchar2
1404: ,p_segment13 in varchar2 default hr_api.g_varchar2
1405: ,p_segment14 in varchar2 default hr_api.g_varchar2
1406: ,p_segment15 in varchar2 default hr_api.g_varchar2
1407: ,p_segment16 in varchar2 default hr_api.g_varchar2
1408: ,p_segment17 in varchar2 default hr_api.g_varchar2
1409: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 1406: ,p_segment15 in varchar2 default hr_api.g_varchar2

1402: ,p_segment11 in varchar2 default hr_api.g_varchar2
1403: ,p_segment12 in varchar2 default hr_api.g_varchar2
1404: ,p_segment13 in varchar2 default hr_api.g_varchar2
1405: ,p_segment14 in varchar2 default hr_api.g_varchar2
1406: ,p_segment15 in varchar2 default hr_api.g_varchar2
1407: ,p_segment16 in varchar2 default hr_api.g_varchar2
1408: ,p_segment17 in varchar2 default hr_api.g_varchar2
1409: ,p_segment18 in varchar2 default hr_api.g_varchar2
1410: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 1407: ,p_segment16 in varchar2 default hr_api.g_varchar2

1403: ,p_segment12 in varchar2 default hr_api.g_varchar2
1404: ,p_segment13 in varchar2 default hr_api.g_varchar2
1405: ,p_segment14 in varchar2 default hr_api.g_varchar2
1406: ,p_segment15 in varchar2 default hr_api.g_varchar2
1407: ,p_segment16 in varchar2 default hr_api.g_varchar2
1408: ,p_segment17 in varchar2 default hr_api.g_varchar2
1409: ,p_segment18 in varchar2 default hr_api.g_varchar2
1410: ,p_segment19 in varchar2 default hr_api.g_varchar2
1411: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 1408: ,p_segment17 in varchar2 default hr_api.g_varchar2

1404: ,p_segment13 in varchar2 default hr_api.g_varchar2
1405: ,p_segment14 in varchar2 default hr_api.g_varchar2
1406: ,p_segment15 in varchar2 default hr_api.g_varchar2
1407: ,p_segment16 in varchar2 default hr_api.g_varchar2
1408: ,p_segment17 in varchar2 default hr_api.g_varchar2
1409: ,p_segment18 in varchar2 default hr_api.g_varchar2
1410: ,p_segment19 in varchar2 default hr_api.g_varchar2
1411: ,p_segment20 in varchar2 default hr_api.g_varchar2
1412: ,p_segment21 in varchar2 default hr_api.g_varchar2

Line 1409: ,p_segment18 in varchar2 default hr_api.g_varchar2

1405: ,p_segment14 in varchar2 default hr_api.g_varchar2
1406: ,p_segment15 in varchar2 default hr_api.g_varchar2
1407: ,p_segment16 in varchar2 default hr_api.g_varchar2
1408: ,p_segment17 in varchar2 default hr_api.g_varchar2
1409: ,p_segment18 in varchar2 default hr_api.g_varchar2
1410: ,p_segment19 in varchar2 default hr_api.g_varchar2
1411: ,p_segment20 in varchar2 default hr_api.g_varchar2
1412: ,p_segment21 in varchar2 default hr_api.g_varchar2
1413: ,p_segment22 in varchar2 default hr_api.g_varchar2

Line 1410: ,p_segment19 in varchar2 default hr_api.g_varchar2

1406: ,p_segment15 in varchar2 default hr_api.g_varchar2
1407: ,p_segment16 in varchar2 default hr_api.g_varchar2
1408: ,p_segment17 in varchar2 default hr_api.g_varchar2
1409: ,p_segment18 in varchar2 default hr_api.g_varchar2
1410: ,p_segment19 in varchar2 default hr_api.g_varchar2
1411: ,p_segment20 in varchar2 default hr_api.g_varchar2
1412: ,p_segment21 in varchar2 default hr_api.g_varchar2
1413: ,p_segment22 in varchar2 default hr_api.g_varchar2
1414: ,p_segment23 in varchar2 default hr_api.g_varchar2

Line 1411: ,p_segment20 in varchar2 default hr_api.g_varchar2

1407: ,p_segment16 in varchar2 default hr_api.g_varchar2
1408: ,p_segment17 in varchar2 default hr_api.g_varchar2
1409: ,p_segment18 in varchar2 default hr_api.g_varchar2
1410: ,p_segment19 in varchar2 default hr_api.g_varchar2
1411: ,p_segment20 in varchar2 default hr_api.g_varchar2
1412: ,p_segment21 in varchar2 default hr_api.g_varchar2
1413: ,p_segment22 in varchar2 default hr_api.g_varchar2
1414: ,p_segment23 in varchar2 default hr_api.g_varchar2
1415: ,p_segment24 in varchar2 default hr_api.g_varchar2

Line 1412: ,p_segment21 in varchar2 default hr_api.g_varchar2

1408: ,p_segment17 in varchar2 default hr_api.g_varchar2
1409: ,p_segment18 in varchar2 default hr_api.g_varchar2
1410: ,p_segment19 in varchar2 default hr_api.g_varchar2
1411: ,p_segment20 in varchar2 default hr_api.g_varchar2
1412: ,p_segment21 in varchar2 default hr_api.g_varchar2
1413: ,p_segment22 in varchar2 default hr_api.g_varchar2
1414: ,p_segment23 in varchar2 default hr_api.g_varchar2
1415: ,p_segment24 in varchar2 default hr_api.g_varchar2
1416: ,p_segment25 in varchar2 default hr_api.g_varchar2

Line 1413: ,p_segment22 in varchar2 default hr_api.g_varchar2

1409: ,p_segment18 in varchar2 default hr_api.g_varchar2
1410: ,p_segment19 in varchar2 default hr_api.g_varchar2
1411: ,p_segment20 in varchar2 default hr_api.g_varchar2
1412: ,p_segment21 in varchar2 default hr_api.g_varchar2
1413: ,p_segment22 in varchar2 default hr_api.g_varchar2
1414: ,p_segment23 in varchar2 default hr_api.g_varchar2
1415: ,p_segment24 in varchar2 default hr_api.g_varchar2
1416: ,p_segment25 in varchar2 default hr_api.g_varchar2
1417: ,p_segment26 in varchar2 default hr_api.g_varchar2

Line 1414: ,p_segment23 in varchar2 default hr_api.g_varchar2

1410: ,p_segment19 in varchar2 default hr_api.g_varchar2
1411: ,p_segment20 in varchar2 default hr_api.g_varchar2
1412: ,p_segment21 in varchar2 default hr_api.g_varchar2
1413: ,p_segment22 in varchar2 default hr_api.g_varchar2
1414: ,p_segment23 in varchar2 default hr_api.g_varchar2
1415: ,p_segment24 in varchar2 default hr_api.g_varchar2
1416: ,p_segment25 in varchar2 default hr_api.g_varchar2
1417: ,p_segment26 in varchar2 default hr_api.g_varchar2
1418: ,p_segment27 in varchar2 default hr_api.g_varchar2

Line 1415: ,p_segment24 in varchar2 default hr_api.g_varchar2

1411: ,p_segment20 in varchar2 default hr_api.g_varchar2
1412: ,p_segment21 in varchar2 default hr_api.g_varchar2
1413: ,p_segment22 in varchar2 default hr_api.g_varchar2
1414: ,p_segment23 in varchar2 default hr_api.g_varchar2
1415: ,p_segment24 in varchar2 default hr_api.g_varchar2
1416: ,p_segment25 in varchar2 default hr_api.g_varchar2
1417: ,p_segment26 in varchar2 default hr_api.g_varchar2
1418: ,p_segment27 in varchar2 default hr_api.g_varchar2
1419: ,p_segment28 in varchar2 default hr_api.g_varchar2

Line 1416: ,p_segment25 in varchar2 default hr_api.g_varchar2

1412: ,p_segment21 in varchar2 default hr_api.g_varchar2
1413: ,p_segment22 in varchar2 default hr_api.g_varchar2
1414: ,p_segment23 in varchar2 default hr_api.g_varchar2
1415: ,p_segment24 in varchar2 default hr_api.g_varchar2
1416: ,p_segment25 in varchar2 default hr_api.g_varchar2
1417: ,p_segment26 in varchar2 default hr_api.g_varchar2
1418: ,p_segment27 in varchar2 default hr_api.g_varchar2
1419: ,p_segment28 in varchar2 default hr_api.g_varchar2
1420: ,p_segment29 in varchar2 default hr_api.g_varchar2

Line 1417: ,p_segment26 in varchar2 default hr_api.g_varchar2

1413: ,p_segment22 in varchar2 default hr_api.g_varchar2
1414: ,p_segment23 in varchar2 default hr_api.g_varchar2
1415: ,p_segment24 in varchar2 default hr_api.g_varchar2
1416: ,p_segment25 in varchar2 default hr_api.g_varchar2
1417: ,p_segment26 in varchar2 default hr_api.g_varchar2
1418: ,p_segment27 in varchar2 default hr_api.g_varchar2
1419: ,p_segment28 in varchar2 default hr_api.g_varchar2
1420: ,p_segment29 in varchar2 default hr_api.g_varchar2
1421: ,p_segment30 in varchar2 default hr_api.g_varchar2

Line 1418: ,p_segment27 in varchar2 default hr_api.g_varchar2

1414: ,p_segment23 in varchar2 default hr_api.g_varchar2
1415: ,p_segment24 in varchar2 default hr_api.g_varchar2
1416: ,p_segment25 in varchar2 default hr_api.g_varchar2
1417: ,p_segment26 in varchar2 default hr_api.g_varchar2
1418: ,p_segment27 in varchar2 default hr_api.g_varchar2
1419: ,p_segment28 in varchar2 default hr_api.g_varchar2
1420: ,p_segment29 in varchar2 default hr_api.g_varchar2
1421: ,p_segment30 in varchar2 default hr_api.g_varchar2
1422: ,p_concat_segments in varchar2 default hr_api.g_varchar2

Line 1419: ,p_segment28 in varchar2 default hr_api.g_varchar2

1415: ,p_segment24 in varchar2 default hr_api.g_varchar2
1416: ,p_segment25 in varchar2 default hr_api.g_varchar2
1417: ,p_segment26 in varchar2 default hr_api.g_varchar2
1418: ,p_segment27 in varchar2 default hr_api.g_varchar2
1419: ,p_segment28 in varchar2 default hr_api.g_varchar2
1420: ,p_segment29 in varchar2 default hr_api.g_varchar2
1421: ,p_segment30 in varchar2 default hr_api.g_varchar2
1422: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1423: ,p_contract_id in number default hr_api.g_number

Line 1420: ,p_segment29 in varchar2 default hr_api.g_varchar2

1416: ,p_segment25 in varchar2 default hr_api.g_varchar2
1417: ,p_segment26 in varchar2 default hr_api.g_varchar2
1418: ,p_segment27 in varchar2 default hr_api.g_varchar2
1419: ,p_segment28 in varchar2 default hr_api.g_varchar2
1420: ,p_segment29 in varchar2 default hr_api.g_varchar2
1421: ,p_segment30 in varchar2 default hr_api.g_varchar2
1422: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1423: ,p_contract_id in number default hr_api.g_number
1424: ,p_establishment_id in number default hr_api.g_number

Line 1421: ,p_segment30 in varchar2 default hr_api.g_varchar2

1417: ,p_segment26 in varchar2 default hr_api.g_varchar2
1418: ,p_segment27 in varchar2 default hr_api.g_varchar2
1419: ,p_segment28 in varchar2 default hr_api.g_varchar2
1420: ,p_segment29 in varchar2 default hr_api.g_varchar2
1421: ,p_segment30 in varchar2 default hr_api.g_varchar2
1422: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1423: ,p_contract_id in number default hr_api.g_number
1424: ,p_establishment_id in number default hr_api.g_number
1425: ,p_collective_agreement_id in number default hr_api.g_number

Line 1422: ,p_concat_segments in varchar2 default hr_api.g_varchar2

1418: ,p_segment27 in varchar2 default hr_api.g_varchar2
1419: ,p_segment28 in varchar2 default hr_api.g_varchar2
1420: ,p_segment29 in varchar2 default hr_api.g_varchar2
1421: ,p_segment30 in varchar2 default hr_api.g_varchar2
1422: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1423: ,p_contract_id in number default hr_api.g_number
1424: ,p_establishment_id in number default hr_api.g_number
1425: ,p_collective_agreement_id in number default hr_api.g_number
1426: ,p_cagr_id_flex_num in number default hr_api.g_number

Line 1423: ,p_contract_id in number default hr_api.g_number

1419: ,p_segment28 in varchar2 default hr_api.g_varchar2
1420: ,p_segment29 in varchar2 default hr_api.g_varchar2
1421: ,p_segment30 in varchar2 default hr_api.g_varchar2
1422: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1423: ,p_contract_id in number default hr_api.g_number
1424: ,p_establishment_id in number default hr_api.g_number
1425: ,p_collective_agreement_id in number default hr_api.g_number
1426: ,p_cagr_id_flex_num in number default hr_api.g_number
1427: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2

Line 1424: ,p_establishment_id in number default hr_api.g_number

1420: ,p_segment29 in varchar2 default hr_api.g_varchar2
1421: ,p_segment30 in varchar2 default hr_api.g_varchar2
1422: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1423: ,p_contract_id in number default hr_api.g_number
1424: ,p_establishment_id in number default hr_api.g_number
1425: ,p_collective_agreement_id in number default hr_api.g_number
1426: ,p_cagr_id_flex_num in number default hr_api.g_number
1427: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2

Line 1425: ,p_collective_agreement_id in number default hr_api.g_number

1421: ,p_segment30 in varchar2 default hr_api.g_varchar2
1422: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1423: ,p_contract_id in number default hr_api.g_number
1424: ,p_establishment_id in number default hr_api.g_number
1425: ,p_collective_agreement_id in number default hr_api.g_number
1426: ,p_cagr_id_flex_num in number default hr_api.g_number
1427: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2

Line 1426: ,p_cagr_id_flex_num in number default hr_api.g_number

1422: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1423: ,p_contract_id in number default hr_api.g_number
1424: ,p_establishment_id in number default hr_api.g_number
1425: ,p_collective_agreement_id in number default hr_api.g_number
1426: ,p_cagr_id_flex_num in number default hr_api.g_number
1427: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2

Line 1427: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2

1423: ,p_contract_id in number default hr_api.g_number
1424: ,p_establishment_id in number default hr_api.g_number
1425: ,p_collective_agreement_id in number default hr_api.g_number
1426: ,p_cagr_id_flex_num in number default hr_api.g_number
1427: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2

Line 1428: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2

1424: ,p_establishment_id in number default hr_api.g_number
1425: ,p_collective_agreement_id in number default hr_api.g_number
1426: ,p_cagr_id_flex_num in number default hr_api.g_number
1427: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2

Line 1429: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2

1425: ,p_collective_agreement_id in number default hr_api.g_number
1426: ,p_cagr_id_flex_num in number default hr_api.g_number
1427: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2

Line 1430: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2

1426: ,p_cagr_id_flex_num in number default hr_api.g_number
1427: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2

Line 1431: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2

1427: ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
1428: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2

Line 1432: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2

1428: ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
1429: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2

Line 1433: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2

1429: ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
1430: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1437: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2

Line 1434: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2

1430: ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
1431: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1437: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1438: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2

Line 1435: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2

1431: ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
1432: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1437: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1438: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1439: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2

Line 1436: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2

1432: ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
1433: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1437: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1438: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1439: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1440: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2

Line 1437: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2

1433: ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
1434: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1437: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1438: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1439: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1440: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1441: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2

Line 1438: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2

1434: ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
1435: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1437: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1438: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1439: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1440: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1441: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1442: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2

Line 1439: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2

1435: ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
1436: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1437: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1438: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1439: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1440: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1441: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1442: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1443: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2

Line 1440: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2

1436: ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
1437: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1438: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1439: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1440: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1441: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1442: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1443: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1444: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2

Line 1441: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2

1437: ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
1438: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1439: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1440: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1441: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1442: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1443: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1444: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1445: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2

Line 1442: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2

1438: ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
1439: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1440: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1441: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1442: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1443: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1444: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1445: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1446: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2

Line 1443: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2

1439: ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
1440: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1441: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1442: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1443: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1444: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1445: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1446: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1447: ,p_notice_period in number default hr_api.g_number

Line 1444: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2

1440: ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
1441: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1442: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1443: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1444: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1445: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1446: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1447: ,p_notice_period in number default hr_api.g_number
1448: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2

Line 1445: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2

1441: ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
1442: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1443: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1444: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1445: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1446: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1447: ,p_notice_period in number default hr_api.g_number
1448: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1449: ,p_employee_category in varchar2 default hr_api.g_varchar2

Line 1446: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2

1442: ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
1443: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1444: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1445: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1446: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1447: ,p_notice_period in number default hr_api.g_number
1448: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1449: ,p_employee_category in varchar2 default hr_api.g_varchar2
1450: ,p_work_at_home in varchar2 default hr_api.g_varchar2

Line 1447: ,p_notice_period in number default hr_api.g_number

1443: ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
1444: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1445: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1446: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1447: ,p_notice_period in number default hr_api.g_number
1448: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1449: ,p_employee_category in varchar2 default hr_api.g_varchar2
1450: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1451: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

Line 1448: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2

1444: ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
1445: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1446: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1447: ,p_notice_period in number default hr_api.g_number
1448: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1449: ,p_employee_category in varchar2 default hr_api.g_varchar2
1450: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1451: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1452: ,p_cagr_grade_def_id out nocopy number

Line 1449: ,p_employee_category in varchar2 default hr_api.g_varchar2

1445: ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
1446: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1447: ,p_notice_period in number default hr_api.g_number
1448: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1449: ,p_employee_category in varchar2 default hr_api.g_varchar2
1450: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1451: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1452: ,p_cagr_grade_def_id out nocopy number
1453: ,p_cagr_concatenated_segments out nocopy varchar2

Line 1450: ,p_work_at_home in varchar2 default hr_api.g_varchar2

1446: ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
1447: ,p_notice_period in number default hr_api.g_number
1448: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1449: ,p_employee_category in varchar2 default hr_api.g_varchar2
1450: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1451: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1452: ,p_cagr_grade_def_id out nocopy number
1453: ,p_cagr_concatenated_segments out nocopy varchar2
1454: ,p_concatenated_segments out nocopy varchar2

Line 1451: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

1447: ,p_notice_period in number default hr_api.g_number
1448: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1449: ,p_employee_category in varchar2 default hr_api.g_varchar2
1450: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1451: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1452: ,p_cagr_grade_def_id out nocopy number
1453: ,p_cagr_concatenated_segments out nocopy varchar2
1454: ,p_concatenated_segments out nocopy varchar2
1455: ,p_soft_coding_keyflex_id out nocopy number

Line 1491: hr_api.constant_to_boolean

1487: --
1488: -- Convert constant values to their corresponding boolean value
1489: --
1490: l_validate :=
1491: hr_api.constant_to_boolean
1492: (p_constant_value => p_validate);
1493: --
1494: -- Register Surrogate ID or user key values
1495: --

Line 1719: (p_validate in number default hr_api.g_false_num

1715: -- ----------------------------------------------------------------------------
1716: -- |------------------------< update_emp_asg_criteria >-----------------------|
1717: -- ----------------------------------------------------------------------------
1718: PROCEDURE update_emp_asg_criteria
1719: (p_validate in number default hr_api.g_false_num
1720: ,p_effective_date in date
1721: ,p_datetrack_update_mode in varchar2
1722: ,p_assignment_id in number
1723: ,p_object_version_number in out nocopy number

Line 1724: ,p_grade_id in number default hr_api.g_number

1720: ,p_effective_date in date
1721: ,p_datetrack_update_mode in varchar2
1722: ,p_assignment_id in number
1723: ,p_object_version_number in out nocopy number
1724: ,p_grade_id in number default hr_api.g_number
1725: ,p_position_id in number default hr_api.g_number
1726: ,p_job_id in number default hr_api.g_number
1727: ,p_payroll_id in number default hr_api.g_number
1728: ,p_location_id in number default hr_api.g_number

Line 1725: ,p_position_id in number default hr_api.g_number

1721: ,p_datetrack_update_mode in varchar2
1722: ,p_assignment_id in number
1723: ,p_object_version_number in out nocopy number
1724: ,p_grade_id in number default hr_api.g_number
1725: ,p_position_id in number default hr_api.g_number
1726: ,p_job_id in number default hr_api.g_number
1727: ,p_payroll_id in number default hr_api.g_number
1728: ,p_location_id in number default hr_api.g_number
1729: ,p_special_ceiling_step_id in out nocopy number

Line 1726: ,p_job_id in number default hr_api.g_number

1722: ,p_assignment_id in number
1723: ,p_object_version_number in out nocopy number
1724: ,p_grade_id in number default hr_api.g_number
1725: ,p_position_id in number default hr_api.g_number
1726: ,p_job_id in number default hr_api.g_number
1727: ,p_payroll_id in number default hr_api.g_number
1728: ,p_location_id in number default hr_api.g_number
1729: ,p_special_ceiling_step_id in out nocopy number
1730: ,p_organization_id in number default hr_api.g_number

Line 1727: ,p_payroll_id in number default hr_api.g_number

1723: ,p_object_version_number in out nocopy number
1724: ,p_grade_id in number default hr_api.g_number
1725: ,p_position_id in number default hr_api.g_number
1726: ,p_job_id in number default hr_api.g_number
1727: ,p_payroll_id in number default hr_api.g_number
1728: ,p_location_id in number default hr_api.g_number
1729: ,p_special_ceiling_step_id in out nocopy number
1730: ,p_organization_id in number default hr_api.g_number
1731: ,p_pay_basis_id in number default hr_api.g_number

Line 1728: ,p_location_id in number default hr_api.g_number

1724: ,p_grade_id in number default hr_api.g_number
1725: ,p_position_id in number default hr_api.g_number
1726: ,p_job_id in number default hr_api.g_number
1727: ,p_payroll_id in number default hr_api.g_number
1728: ,p_location_id in number default hr_api.g_number
1729: ,p_special_ceiling_step_id in out nocopy number
1730: ,p_organization_id in number default hr_api.g_number
1731: ,p_pay_basis_id in number default hr_api.g_number
1732: ,p_segment1 in varchar2 default hr_api.g_varchar2

Line 1730: ,p_organization_id in number default hr_api.g_number

1726: ,p_job_id in number default hr_api.g_number
1727: ,p_payroll_id in number default hr_api.g_number
1728: ,p_location_id in number default hr_api.g_number
1729: ,p_special_ceiling_step_id in out nocopy number
1730: ,p_organization_id in number default hr_api.g_number
1731: ,p_pay_basis_id in number default hr_api.g_number
1732: ,p_segment1 in varchar2 default hr_api.g_varchar2
1733: ,p_segment2 in varchar2 default hr_api.g_varchar2
1734: ,p_segment3 in varchar2 default hr_api.g_varchar2

Line 1731: ,p_pay_basis_id in number default hr_api.g_number

1727: ,p_payroll_id in number default hr_api.g_number
1728: ,p_location_id in number default hr_api.g_number
1729: ,p_special_ceiling_step_id in out nocopy number
1730: ,p_organization_id in number default hr_api.g_number
1731: ,p_pay_basis_id in number default hr_api.g_number
1732: ,p_segment1 in varchar2 default hr_api.g_varchar2
1733: ,p_segment2 in varchar2 default hr_api.g_varchar2
1734: ,p_segment3 in varchar2 default hr_api.g_varchar2
1735: ,p_segment4 in varchar2 default hr_api.g_varchar2

Line 1732: ,p_segment1 in varchar2 default hr_api.g_varchar2

1728: ,p_location_id in number default hr_api.g_number
1729: ,p_special_ceiling_step_id in out nocopy number
1730: ,p_organization_id in number default hr_api.g_number
1731: ,p_pay_basis_id in number default hr_api.g_number
1732: ,p_segment1 in varchar2 default hr_api.g_varchar2
1733: ,p_segment2 in varchar2 default hr_api.g_varchar2
1734: ,p_segment3 in varchar2 default hr_api.g_varchar2
1735: ,p_segment4 in varchar2 default hr_api.g_varchar2
1736: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 1733: ,p_segment2 in varchar2 default hr_api.g_varchar2

1729: ,p_special_ceiling_step_id in out nocopy number
1730: ,p_organization_id in number default hr_api.g_number
1731: ,p_pay_basis_id in number default hr_api.g_number
1732: ,p_segment1 in varchar2 default hr_api.g_varchar2
1733: ,p_segment2 in varchar2 default hr_api.g_varchar2
1734: ,p_segment3 in varchar2 default hr_api.g_varchar2
1735: ,p_segment4 in varchar2 default hr_api.g_varchar2
1736: ,p_segment5 in varchar2 default hr_api.g_varchar2
1737: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 1734: ,p_segment3 in varchar2 default hr_api.g_varchar2

1730: ,p_organization_id in number default hr_api.g_number
1731: ,p_pay_basis_id in number default hr_api.g_number
1732: ,p_segment1 in varchar2 default hr_api.g_varchar2
1733: ,p_segment2 in varchar2 default hr_api.g_varchar2
1734: ,p_segment3 in varchar2 default hr_api.g_varchar2
1735: ,p_segment4 in varchar2 default hr_api.g_varchar2
1736: ,p_segment5 in varchar2 default hr_api.g_varchar2
1737: ,p_segment6 in varchar2 default hr_api.g_varchar2
1738: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 1735: ,p_segment4 in varchar2 default hr_api.g_varchar2

1731: ,p_pay_basis_id in number default hr_api.g_number
1732: ,p_segment1 in varchar2 default hr_api.g_varchar2
1733: ,p_segment2 in varchar2 default hr_api.g_varchar2
1734: ,p_segment3 in varchar2 default hr_api.g_varchar2
1735: ,p_segment4 in varchar2 default hr_api.g_varchar2
1736: ,p_segment5 in varchar2 default hr_api.g_varchar2
1737: ,p_segment6 in varchar2 default hr_api.g_varchar2
1738: ,p_segment7 in varchar2 default hr_api.g_varchar2
1739: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 1736: ,p_segment5 in varchar2 default hr_api.g_varchar2

1732: ,p_segment1 in varchar2 default hr_api.g_varchar2
1733: ,p_segment2 in varchar2 default hr_api.g_varchar2
1734: ,p_segment3 in varchar2 default hr_api.g_varchar2
1735: ,p_segment4 in varchar2 default hr_api.g_varchar2
1736: ,p_segment5 in varchar2 default hr_api.g_varchar2
1737: ,p_segment6 in varchar2 default hr_api.g_varchar2
1738: ,p_segment7 in varchar2 default hr_api.g_varchar2
1739: ,p_segment8 in varchar2 default hr_api.g_varchar2
1740: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 1737: ,p_segment6 in varchar2 default hr_api.g_varchar2

1733: ,p_segment2 in varchar2 default hr_api.g_varchar2
1734: ,p_segment3 in varchar2 default hr_api.g_varchar2
1735: ,p_segment4 in varchar2 default hr_api.g_varchar2
1736: ,p_segment5 in varchar2 default hr_api.g_varchar2
1737: ,p_segment6 in varchar2 default hr_api.g_varchar2
1738: ,p_segment7 in varchar2 default hr_api.g_varchar2
1739: ,p_segment8 in varchar2 default hr_api.g_varchar2
1740: ,p_segment9 in varchar2 default hr_api.g_varchar2
1741: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 1738: ,p_segment7 in varchar2 default hr_api.g_varchar2

1734: ,p_segment3 in varchar2 default hr_api.g_varchar2
1735: ,p_segment4 in varchar2 default hr_api.g_varchar2
1736: ,p_segment5 in varchar2 default hr_api.g_varchar2
1737: ,p_segment6 in varchar2 default hr_api.g_varchar2
1738: ,p_segment7 in varchar2 default hr_api.g_varchar2
1739: ,p_segment8 in varchar2 default hr_api.g_varchar2
1740: ,p_segment9 in varchar2 default hr_api.g_varchar2
1741: ,p_segment10 in varchar2 default hr_api.g_varchar2
1742: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 1739: ,p_segment8 in varchar2 default hr_api.g_varchar2

1735: ,p_segment4 in varchar2 default hr_api.g_varchar2
1736: ,p_segment5 in varchar2 default hr_api.g_varchar2
1737: ,p_segment6 in varchar2 default hr_api.g_varchar2
1738: ,p_segment7 in varchar2 default hr_api.g_varchar2
1739: ,p_segment8 in varchar2 default hr_api.g_varchar2
1740: ,p_segment9 in varchar2 default hr_api.g_varchar2
1741: ,p_segment10 in varchar2 default hr_api.g_varchar2
1742: ,p_segment11 in varchar2 default hr_api.g_varchar2
1743: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 1740: ,p_segment9 in varchar2 default hr_api.g_varchar2

1736: ,p_segment5 in varchar2 default hr_api.g_varchar2
1737: ,p_segment6 in varchar2 default hr_api.g_varchar2
1738: ,p_segment7 in varchar2 default hr_api.g_varchar2
1739: ,p_segment8 in varchar2 default hr_api.g_varchar2
1740: ,p_segment9 in varchar2 default hr_api.g_varchar2
1741: ,p_segment10 in varchar2 default hr_api.g_varchar2
1742: ,p_segment11 in varchar2 default hr_api.g_varchar2
1743: ,p_segment12 in varchar2 default hr_api.g_varchar2
1744: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 1741: ,p_segment10 in varchar2 default hr_api.g_varchar2

1737: ,p_segment6 in varchar2 default hr_api.g_varchar2
1738: ,p_segment7 in varchar2 default hr_api.g_varchar2
1739: ,p_segment8 in varchar2 default hr_api.g_varchar2
1740: ,p_segment9 in varchar2 default hr_api.g_varchar2
1741: ,p_segment10 in varchar2 default hr_api.g_varchar2
1742: ,p_segment11 in varchar2 default hr_api.g_varchar2
1743: ,p_segment12 in varchar2 default hr_api.g_varchar2
1744: ,p_segment13 in varchar2 default hr_api.g_varchar2
1745: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 1742: ,p_segment11 in varchar2 default hr_api.g_varchar2

1738: ,p_segment7 in varchar2 default hr_api.g_varchar2
1739: ,p_segment8 in varchar2 default hr_api.g_varchar2
1740: ,p_segment9 in varchar2 default hr_api.g_varchar2
1741: ,p_segment10 in varchar2 default hr_api.g_varchar2
1742: ,p_segment11 in varchar2 default hr_api.g_varchar2
1743: ,p_segment12 in varchar2 default hr_api.g_varchar2
1744: ,p_segment13 in varchar2 default hr_api.g_varchar2
1745: ,p_segment14 in varchar2 default hr_api.g_varchar2
1746: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 1743: ,p_segment12 in varchar2 default hr_api.g_varchar2

1739: ,p_segment8 in varchar2 default hr_api.g_varchar2
1740: ,p_segment9 in varchar2 default hr_api.g_varchar2
1741: ,p_segment10 in varchar2 default hr_api.g_varchar2
1742: ,p_segment11 in varchar2 default hr_api.g_varchar2
1743: ,p_segment12 in varchar2 default hr_api.g_varchar2
1744: ,p_segment13 in varchar2 default hr_api.g_varchar2
1745: ,p_segment14 in varchar2 default hr_api.g_varchar2
1746: ,p_segment15 in varchar2 default hr_api.g_varchar2
1747: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 1744: ,p_segment13 in varchar2 default hr_api.g_varchar2

1740: ,p_segment9 in varchar2 default hr_api.g_varchar2
1741: ,p_segment10 in varchar2 default hr_api.g_varchar2
1742: ,p_segment11 in varchar2 default hr_api.g_varchar2
1743: ,p_segment12 in varchar2 default hr_api.g_varchar2
1744: ,p_segment13 in varchar2 default hr_api.g_varchar2
1745: ,p_segment14 in varchar2 default hr_api.g_varchar2
1746: ,p_segment15 in varchar2 default hr_api.g_varchar2
1747: ,p_segment16 in varchar2 default hr_api.g_varchar2
1748: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 1745: ,p_segment14 in varchar2 default hr_api.g_varchar2

1741: ,p_segment10 in varchar2 default hr_api.g_varchar2
1742: ,p_segment11 in varchar2 default hr_api.g_varchar2
1743: ,p_segment12 in varchar2 default hr_api.g_varchar2
1744: ,p_segment13 in varchar2 default hr_api.g_varchar2
1745: ,p_segment14 in varchar2 default hr_api.g_varchar2
1746: ,p_segment15 in varchar2 default hr_api.g_varchar2
1747: ,p_segment16 in varchar2 default hr_api.g_varchar2
1748: ,p_segment17 in varchar2 default hr_api.g_varchar2
1749: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 1746: ,p_segment15 in varchar2 default hr_api.g_varchar2

1742: ,p_segment11 in varchar2 default hr_api.g_varchar2
1743: ,p_segment12 in varchar2 default hr_api.g_varchar2
1744: ,p_segment13 in varchar2 default hr_api.g_varchar2
1745: ,p_segment14 in varchar2 default hr_api.g_varchar2
1746: ,p_segment15 in varchar2 default hr_api.g_varchar2
1747: ,p_segment16 in varchar2 default hr_api.g_varchar2
1748: ,p_segment17 in varchar2 default hr_api.g_varchar2
1749: ,p_segment18 in varchar2 default hr_api.g_varchar2
1750: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 1747: ,p_segment16 in varchar2 default hr_api.g_varchar2

1743: ,p_segment12 in varchar2 default hr_api.g_varchar2
1744: ,p_segment13 in varchar2 default hr_api.g_varchar2
1745: ,p_segment14 in varchar2 default hr_api.g_varchar2
1746: ,p_segment15 in varchar2 default hr_api.g_varchar2
1747: ,p_segment16 in varchar2 default hr_api.g_varchar2
1748: ,p_segment17 in varchar2 default hr_api.g_varchar2
1749: ,p_segment18 in varchar2 default hr_api.g_varchar2
1750: ,p_segment19 in varchar2 default hr_api.g_varchar2
1751: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 1748: ,p_segment17 in varchar2 default hr_api.g_varchar2

1744: ,p_segment13 in varchar2 default hr_api.g_varchar2
1745: ,p_segment14 in varchar2 default hr_api.g_varchar2
1746: ,p_segment15 in varchar2 default hr_api.g_varchar2
1747: ,p_segment16 in varchar2 default hr_api.g_varchar2
1748: ,p_segment17 in varchar2 default hr_api.g_varchar2
1749: ,p_segment18 in varchar2 default hr_api.g_varchar2
1750: ,p_segment19 in varchar2 default hr_api.g_varchar2
1751: ,p_segment20 in varchar2 default hr_api.g_varchar2
1752: ,p_segment21 in varchar2 default hr_api.g_varchar2

Line 1749: ,p_segment18 in varchar2 default hr_api.g_varchar2

1745: ,p_segment14 in varchar2 default hr_api.g_varchar2
1746: ,p_segment15 in varchar2 default hr_api.g_varchar2
1747: ,p_segment16 in varchar2 default hr_api.g_varchar2
1748: ,p_segment17 in varchar2 default hr_api.g_varchar2
1749: ,p_segment18 in varchar2 default hr_api.g_varchar2
1750: ,p_segment19 in varchar2 default hr_api.g_varchar2
1751: ,p_segment20 in varchar2 default hr_api.g_varchar2
1752: ,p_segment21 in varchar2 default hr_api.g_varchar2
1753: ,p_segment22 in varchar2 default hr_api.g_varchar2

Line 1750: ,p_segment19 in varchar2 default hr_api.g_varchar2

1746: ,p_segment15 in varchar2 default hr_api.g_varchar2
1747: ,p_segment16 in varchar2 default hr_api.g_varchar2
1748: ,p_segment17 in varchar2 default hr_api.g_varchar2
1749: ,p_segment18 in varchar2 default hr_api.g_varchar2
1750: ,p_segment19 in varchar2 default hr_api.g_varchar2
1751: ,p_segment20 in varchar2 default hr_api.g_varchar2
1752: ,p_segment21 in varchar2 default hr_api.g_varchar2
1753: ,p_segment22 in varchar2 default hr_api.g_varchar2
1754: ,p_segment23 in varchar2 default hr_api.g_varchar2

Line 1751: ,p_segment20 in varchar2 default hr_api.g_varchar2

1747: ,p_segment16 in varchar2 default hr_api.g_varchar2
1748: ,p_segment17 in varchar2 default hr_api.g_varchar2
1749: ,p_segment18 in varchar2 default hr_api.g_varchar2
1750: ,p_segment19 in varchar2 default hr_api.g_varchar2
1751: ,p_segment20 in varchar2 default hr_api.g_varchar2
1752: ,p_segment21 in varchar2 default hr_api.g_varchar2
1753: ,p_segment22 in varchar2 default hr_api.g_varchar2
1754: ,p_segment23 in varchar2 default hr_api.g_varchar2
1755: ,p_segment24 in varchar2 default hr_api.g_varchar2

Line 1752: ,p_segment21 in varchar2 default hr_api.g_varchar2

1748: ,p_segment17 in varchar2 default hr_api.g_varchar2
1749: ,p_segment18 in varchar2 default hr_api.g_varchar2
1750: ,p_segment19 in varchar2 default hr_api.g_varchar2
1751: ,p_segment20 in varchar2 default hr_api.g_varchar2
1752: ,p_segment21 in varchar2 default hr_api.g_varchar2
1753: ,p_segment22 in varchar2 default hr_api.g_varchar2
1754: ,p_segment23 in varchar2 default hr_api.g_varchar2
1755: ,p_segment24 in varchar2 default hr_api.g_varchar2
1756: ,p_segment25 in varchar2 default hr_api.g_varchar2

Line 1753: ,p_segment22 in varchar2 default hr_api.g_varchar2

1749: ,p_segment18 in varchar2 default hr_api.g_varchar2
1750: ,p_segment19 in varchar2 default hr_api.g_varchar2
1751: ,p_segment20 in varchar2 default hr_api.g_varchar2
1752: ,p_segment21 in varchar2 default hr_api.g_varchar2
1753: ,p_segment22 in varchar2 default hr_api.g_varchar2
1754: ,p_segment23 in varchar2 default hr_api.g_varchar2
1755: ,p_segment24 in varchar2 default hr_api.g_varchar2
1756: ,p_segment25 in varchar2 default hr_api.g_varchar2
1757: ,p_segment26 in varchar2 default hr_api.g_varchar2

Line 1754: ,p_segment23 in varchar2 default hr_api.g_varchar2

1750: ,p_segment19 in varchar2 default hr_api.g_varchar2
1751: ,p_segment20 in varchar2 default hr_api.g_varchar2
1752: ,p_segment21 in varchar2 default hr_api.g_varchar2
1753: ,p_segment22 in varchar2 default hr_api.g_varchar2
1754: ,p_segment23 in varchar2 default hr_api.g_varchar2
1755: ,p_segment24 in varchar2 default hr_api.g_varchar2
1756: ,p_segment25 in varchar2 default hr_api.g_varchar2
1757: ,p_segment26 in varchar2 default hr_api.g_varchar2
1758: ,p_segment27 in varchar2 default hr_api.g_varchar2

Line 1755: ,p_segment24 in varchar2 default hr_api.g_varchar2

1751: ,p_segment20 in varchar2 default hr_api.g_varchar2
1752: ,p_segment21 in varchar2 default hr_api.g_varchar2
1753: ,p_segment22 in varchar2 default hr_api.g_varchar2
1754: ,p_segment23 in varchar2 default hr_api.g_varchar2
1755: ,p_segment24 in varchar2 default hr_api.g_varchar2
1756: ,p_segment25 in varchar2 default hr_api.g_varchar2
1757: ,p_segment26 in varchar2 default hr_api.g_varchar2
1758: ,p_segment27 in varchar2 default hr_api.g_varchar2
1759: ,p_segment28 in varchar2 default hr_api.g_varchar2

Line 1756: ,p_segment25 in varchar2 default hr_api.g_varchar2

1752: ,p_segment21 in varchar2 default hr_api.g_varchar2
1753: ,p_segment22 in varchar2 default hr_api.g_varchar2
1754: ,p_segment23 in varchar2 default hr_api.g_varchar2
1755: ,p_segment24 in varchar2 default hr_api.g_varchar2
1756: ,p_segment25 in varchar2 default hr_api.g_varchar2
1757: ,p_segment26 in varchar2 default hr_api.g_varchar2
1758: ,p_segment27 in varchar2 default hr_api.g_varchar2
1759: ,p_segment28 in varchar2 default hr_api.g_varchar2
1760: ,p_segment29 in varchar2 default hr_api.g_varchar2

Line 1757: ,p_segment26 in varchar2 default hr_api.g_varchar2

1753: ,p_segment22 in varchar2 default hr_api.g_varchar2
1754: ,p_segment23 in varchar2 default hr_api.g_varchar2
1755: ,p_segment24 in varchar2 default hr_api.g_varchar2
1756: ,p_segment25 in varchar2 default hr_api.g_varchar2
1757: ,p_segment26 in varchar2 default hr_api.g_varchar2
1758: ,p_segment27 in varchar2 default hr_api.g_varchar2
1759: ,p_segment28 in varchar2 default hr_api.g_varchar2
1760: ,p_segment29 in varchar2 default hr_api.g_varchar2
1761: ,p_segment30 in varchar2 default hr_api.g_varchar2

Line 1758: ,p_segment27 in varchar2 default hr_api.g_varchar2

1754: ,p_segment23 in varchar2 default hr_api.g_varchar2
1755: ,p_segment24 in varchar2 default hr_api.g_varchar2
1756: ,p_segment25 in varchar2 default hr_api.g_varchar2
1757: ,p_segment26 in varchar2 default hr_api.g_varchar2
1758: ,p_segment27 in varchar2 default hr_api.g_varchar2
1759: ,p_segment28 in varchar2 default hr_api.g_varchar2
1760: ,p_segment29 in varchar2 default hr_api.g_varchar2
1761: ,p_segment30 in varchar2 default hr_api.g_varchar2
1762: ,p_concat_segments in varchar2 default hr_api.g_varchar2

Line 1759: ,p_segment28 in varchar2 default hr_api.g_varchar2

1755: ,p_segment24 in varchar2 default hr_api.g_varchar2
1756: ,p_segment25 in varchar2 default hr_api.g_varchar2
1757: ,p_segment26 in varchar2 default hr_api.g_varchar2
1758: ,p_segment27 in varchar2 default hr_api.g_varchar2
1759: ,p_segment28 in varchar2 default hr_api.g_varchar2
1760: ,p_segment29 in varchar2 default hr_api.g_varchar2
1761: ,p_segment30 in varchar2 default hr_api.g_varchar2
1762: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1763: ,p_group_name out nocopy varchar2

Line 1760: ,p_segment29 in varchar2 default hr_api.g_varchar2

1756: ,p_segment25 in varchar2 default hr_api.g_varchar2
1757: ,p_segment26 in varchar2 default hr_api.g_varchar2
1758: ,p_segment27 in varchar2 default hr_api.g_varchar2
1759: ,p_segment28 in varchar2 default hr_api.g_varchar2
1760: ,p_segment29 in varchar2 default hr_api.g_varchar2
1761: ,p_segment30 in varchar2 default hr_api.g_varchar2
1762: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1763: ,p_group_name out nocopy varchar2
1764: ,p_employment_category in varchar2 default hr_api.g_varchar2

Line 1761: ,p_segment30 in varchar2 default hr_api.g_varchar2

1757: ,p_segment26 in varchar2 default hr_api.g_varchar2
1758: ,p_segment27 in varchar2 default hr_api.g_varchar2
1759: ,p_segment28 in varchar2 default hr_api.g_varchar2
1760: ,p_segment29 in varchar2 default hr_api.g_varchar2
1761: ,p_segment30 in varchar2 default hr_api.g_varchar2
1762: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1763: ,p_group_name out nocopy varchar2
1764: ,p_employment_category in varchar2 default hr_api.g_varchar2
1765: ,p_effective_start_date out nocopy date

Line 1762: ,p_concat_segments in varchar2 default hr_api.g_varchar2

1758: ,p_segment27 in varchar2 default hr_api.g_varchar2
1759: ,p_segment28 in varchar2 default hr_api.g_varchar2
1760: ,p_segment29 in varchar2 default hr_api.g_varchar2
1761: ,p_segment30 in varchar2 default hr_api.g_varchar2
1762: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1763: ,p_group_name out nocopy varchar2
1764: ,p_employment_category in varchar2 default hr_api.g_varchar2
1765: ,p_effective_start_date out nocopy date
1766: ,p_effective_end_date out nocopy date

Line 1764: ,p_employment_category in varchar2 default hr_api.g_varchar2

1760: ,p_segment29 in varchar2 default hr_api.g_varchar2
1761: ,p_segment30 in varchar2 default hr_api.g_varchar2
1762: ,p_concat_segments in varchar2 default hr_api.g_varchar2
1763: ,p_group_name out nocopy varchar2
1764: ,p_employment_category in varchar2 default hr_api.g_varchar2
1765: ,p_effective_start_date out nocopy date
1766: ,p_effective_end_date out nocopy date
1767: ,p_people_group_id out nocopy number
1768: ,p_entries_changed_warning out nocopy varchar2

Line 1804: hr_api.constant_to_boolean

1800: --
1801: -- Convert constant values to their corresponding boolean value
1802: --
1803: l_validate :=
1804: hr_api.constant_to_boolean
1805: (p_constant_value => p_validate);
1806: --
1807: -- Register Surrogate ID or user key values
1808: --