23: --
24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE create_affectation
27: (p_validate in number default hr_api.g_false_num
28: ,p_effective_date in date
29: ,p_organization_id in number
30: ,p_position_id in number
31: ,p_person_id in number
51: -- ----------------------------------------------------------------------------
52: -- |--------------------------< terminate_affectation >--------------------------|
53: -- ----------------------------------------------------------------------------
54: PROCEDURE terminate_affectation
55: (p_validate in number default hr_api.g_false_num
56: ,p_assignment_id in number
57: ,p_effective_date in date
58: ,p_assignment_status_type_id in number
59: ,p_primary_affectation in varchar2 default null
87: --
88: -- {End of comments}
89: -- ----------------------------------------------------------------------------
90: PROCEDURE update_affectation
91: (p_validate in number default hr_api.g_false_num
92: ,p_datetrack_update_mode in varchar2
93: ,p_effective_date in date
94: ,p_organization_id in number default hr_api.g_number
95: ,p_position_id in number default hr_api.g_number
90: PROCEDURE update_affectation
91: (p_validate in number default hr_api.g_false_num
92: ,p_datetrack_update_mode in varchar2
93: ,p_effective_date in date
94: ,p_organization_id in number default hr_api.g_number
95: ,p_position_id in number default hr_api.g_number
96: ,p_person_id in number
97: ,p_job_id in number default hr_api.g_number
98: ,p_supervisor_id in number default hr_api.g_number
91: (p_validate in number default hr_api.g_false_num
92: ,p_datetrack_update_mode in varchar2
93: ,p_effective_date in date
94: ,p_organization_id in number default hr_api.g_number
95: ,p_position_id in number default hr_api.g_number
96: ,p_person_id in number
97: ,p_job_id in number default hr_api.g_number
98: ,p_supervisor_id in number default hr_api.g_number
99: ,p_assignment_number in varchar2 default hr_api.g_varchar2
93: ,p_effective_date in date
94: ,p_organization_id in number default hr_api.g_number
95: ,p_position_id in number default hr_api.g_number
96: ,p_person_id in number
97: ,p_job_id in number default hr_api.g_number
98: ,p_supervisor_id in number default hr_api.g_number
99: ,p_assignment_number in varchar2 default hr_api.g_varchar2
100: ,p_assignment_status_type_id in number default hr_api.g_number
101: ,p_identifier in varchar2 default hr_api.g_varchar2
94: ,p_organization_id in number default hr_api.g_number
95: ,p_position_id in number default hr_api.g_number
96: ,p_person_id in number
97: ,p_job_id in number default hr_api.g_number
98: ,p_supervisor_id in number default hr_api.g_number
99: ,p_assignment_number in varchar2 default hr_api.g_varchar2
100: ,p_assignment_status_type_id in number default hr_api.g_number
101: ,p_identifier in varchar2 default hr_api.g_varchar2
102: ,p_affectation_type in varchar2 default hr_api.g_varchar2
95: ,p_position_id in number default hr_api.g_number
96: ,p_person_id in number
97: ,p_job_id in number default hr_api.g_number
98: ,p_supervisor_id in number default hr_api.g_number
99: ,p_assignment_number in varchar2 default hr_api.g_varchar2
100: ,p_assignment_status_type_id in number default hr_api.g_number
101: ,p_identifier in varchar2 default hr_api.g_varchar2
102: ,p_affectation_type in varchar2 default hr_api.g_varchar2
103: ,p_percent_effected in varchar2 default hr_api.g_varchar2
96: ,p_person_id in number
97: ,p_job_id in number default hr_api.g_number
98: ,p_supervisor_id in number default hr_api.g_number
99: ,p_assignment_number in varchar2 default hr_api.g_varchar2
100: ,p_assignment_status_type_id in number default hr_api.g_number
101: ,p_identifier in varchar2 default hr_api.g_varchar2
102: ,p_affectation_type in varchar2 default hr_api.g_varchar2
103: ,p_percent_effected in varchar2 default hr_api.g_varchar2
104: ,p_primary_affectation in varchar2 default hr_api.g_varchar2
97: ,p_job_id in number default hr_api.g_number
98: ,p_supervisor_id in number default hr_api.g_number
99: ,p_assignment_number in varchar2 default hr_api.g_varchar2
100: ,p_assignment_status_type_id in number default hr_api.g_number
101: ,p_identifier in varchar2 default hr_api.g_varchar2
102: ,p_affectation_type in varchar2 default hr_api.g_varchar2
103: ,p_percent_effected in varchar2 default hr_api.g_varchar2
104: ,p_primary_affectation in varchar2 default hr_api.g_varchar2
105: ,p_group_name out nocopy varchar2
98: ,p_supervisor_id in number default hr_api.g_number
99: ,p_assignment_number in varchar2 default hr_api.g_varchar2
100: ,p_assignment_status_type_id in number default hr_api.g_number
101: ,p_identifier in varchar2 default hr_api.g_varchar2
102: ,p_affectation_type in varchar2 default hr_api.g_varchar2
103: ,p_percent_effected in varchar2 default hr_api.g_varchar2
104: ,p_primary_affectation in varchar2 default hr_api.g_varchar2
105: ,p_group_name out nocopy varchar2
106: ,p_scl_concat_segments in varchar2 default hr_api.g_varchar2
99: ,p_assignment_number in varchar2 default hr_api.g_varchar2
100: ,p_assignment_status_type_id in number default hr_api.g_number
101: ,p_identifier in varchar2 default hr_api.g_varchar2
102: ,p_affectation_type in varchar2 default hr_api.g_varchar2
103: ,p_percent_effected in varchar2 default hr_api.g_varchar2
104: ,p_primary_affectation in varchar2 default hr_api.g_varchar2
105: ,p_group_name out nocopy varchar2
106: ,p_scl_concat_segments in varchar2 default hr_api.g_varchar2
107: ,p_assignment_id in number
100: ,p_assignment_status_type_id in number default hr_api.g_number
101: ,p_identifier in varchar2 default hr_api.g_varchar2
102: ,p_affectation_type in varchar2 default hr_api.g_varchar2
103: ,p_percent_effected in varchar2 default hr_api.g_varchar2
104: ,p_primary_affectation in varchar2 default hr_api.g_varchar2
105: ,p_group_name out nocopy varchar2
106: ,p_scl_concat_segments in varchar2 default hr_api.g_varchar2
107: ,p_assignment_id in number
108: ,p_soft_coding_keyflex_id out nocopy number
102: ,p_affectation_type in varchar2 default hr_api.g_varchar2
103: ,p_percent_effected in varchar2 default hr_api.g_varchar2
104: ,p_primary_affectation in varchar2 default hr_api.g_varchar2
105: ,p_group_name out nocopy varchar2
106: ,p_scl_concat_segments in varchar2 default hr_api.g_varchar2
107: ,p_assignment_id in number
108: ,p_soft_coding_keyflex_id out nocopy number
109: ,p_object_version_number in out nocopy number
110: ,p_effective_start_date out nocopy date
135: --
136: -- {End of comments}
137: -- ----------------------------------------------------------------------------
138: PROCEDURE update_employment_terms
139: (p_validate in number default hr_api.g_false_num
140: ,p_datetrack_update_mode in varchar2
141: ,p_effective_date in date
142: ,p_assignment_id in number
143: ,p_establishment_id in number
140: ,p_datetrack_update_mode in varchar2
141: ,p_effective_date in date
142: ,p_assignment_id in number
143: ,p_establishment_id in number
144: ,p_comments in varchar2 default hr_api.g_varchar2
145: ,p_assignment_category in varchar2
146: ,p_reason_for_parttime in varchar2 default hr_api.g_varchar2
147: ,p_working_hours_share in varchar2 default hr_api.g_varchar2
148: ,p_contract_id in number default hr_api.g_number
142: ,p_assignment_id in number
143: ,p_establishment_id in number
144: ,p_comments in varchar2 default hr_api.g_varchar2
145: ,p_assignment_category in varchar2
146: ,p_reason_for_parttime in varchar2 default hr_api.g_varchar2
147: ,p_working_hours_share in varchar2 default hr_api.g_varchar2
148: ,p_contract_id in number default hr_api.g_number
149: ,p_change_reason in varchar2 default hr_api.g_varchar2
150: ,p_normal_hours in number default hr_api.g_number
143: ,p_establishment_id in number
144: ,p_comments in varchar2 default hr_api.g_varchar2
145: ,p_assignment_category in varchar2
146: ,p_reason_for_parttime in varchar2 default hr_api.g_varchar2
147: ,p_working_hours_share in varchar2 default hr_api.g_varchar2
148: ,p_contract_id in number default hr_api.g_number
149: ,p_change_reason in varchar2 default hr_api.g_varchar2
150: ,p_normal_hours in number default hr_api.g_number
151: ,p_frequency in varchar2 default hr_api.g_varchar2
144: ,p_comments in varchar2 default hr_api.g_varchar2
145: ,p_assignment_category in varchar2
146: ,p_reason_for_parttime in varchar2 default hr_api.g_varchar2
147: ,p_working_hours_share in varchar2 default hr_api.g_varchar2
148: ,p_contract_id in number default hr_api.g_number
149: ,p_change_reason in varchar2 default hr_api.g_varchar2
150: ,p_normal_hours in number default hr_api.g_number
151: ,p_frequency in varchar2 default hr_api.g_varchar2
152: ,p_soft_coding_keyflex_id out nocopy number
145: ,p_assignment_category in varchar2
146: ,p_reason_for_parttime in varchar2 default hr_api.g_varchar2
147: ,p_working_hours_share in varchar2 default hr_api.g_varchar2
148: ,p_contract_id in number default hr_api.g_number
149: ,p_change_reason in varchar2 default hr_api.g_varchar2
150: ,p_normal_hours in number default hr_api.g_number
151: ,p_frequency in varchar2 default hr_api.g_varchar2
152: ,p_soft_coding_keyflex_id out nocopy number
153: ,p_object_version_number in out nocopy number
146: ,p_reason_for_parttime in varchar2 default hr_api.g_varchar2
147: ,p_working_hours_share in varchar2 default hr_api.g_varchar2
148: ,p_contract_id in number default hr_api.g_number
149: ,p_change_reason in varchar2 default hr_api.g_varchar2
150: ,p_normal_hours in number default hr_api.g_number
151: ,p_frequency in varchar2 default hr_api.g_varchar2
152: ,p_soft_coding_keyflex_id out nocopy number
153: ,p_object_version_number in out nocopy number
154: ,p_effective_start_date out nocopy date
147: ,p_working_hours_share in varchar2 default hr_api.g_varchar2
148: ,p_contract_id in number default hr_api.g_number
149: ,p_change_reason in varchar2 default hr_api.g_varchar2
150: ,p_normal_hours in number default hr_api.g_number
151: ,p_frequency in varchar2 default hr_api.g_varchar2
152: ,p_soft_coding_keyflex_id out nocopy number
153: ,p_object_version_number in out nocopy number
154: ,p_effective_start_date out nocopy date
155: ,p_effective_end_date out nocopy date
179: --
180: -- {End of comments}
181: -- ----------------------------------------------------------------------------
182: PROCEDURE update_administrative_career
183: (p_validate in number default hr_api.g_false_num
184: ,p_datetrack_update_mode in varchar2
185: ,p_effective_date in date
186: ,p_assignment_id in number
187: ,p_corps_id in number default hr_api.g_number
183: (p_validate in number default hr_api.g_false_num
184: ,p_datetrack_update_mode in varchar2
185: ,p_effective_date in date
186: ,p_assignment_id in number
187: ,p_corps_id in number default hr_api.g_number
188: ,p_grade_id in number default hr_api.g_number
189: ,p_step_id in number default hr_api.g_number
190: ,p_progression_speed in varchar2
191: ,p_personal_gross_index in varchar2
184: ,p_datetrack_update_mode in varchar2
185: ,p_effective_date in date
186: ,p_assignment_id in number
187: ,p_corps_id in number default hr_api.g_number
188: ,p_grade_id in number default hr_api.g_number
189: ,p_step_id in number default hr_api.g_number
190: ,p_progression_speed in varchar2
191: ,p_personal_gross_index in varchar2
192: ,p_employee_category in varchar2
185: ,p_effective_date in date
186: ,p_assignment_id in number
187: ,p_corps_id in number default hr_api.g_number
188: ,p_grade_id in number default hr_api.g_number
189: ,p_step_id in number default hr_api.g_number
190: ,p_progression_speed in varchar2
191: ,p_personal_gross_index in varchar2
192: ,p_employee_category in varchar2
193: ,p_soft_coding_keyflex_id out nocopy number
198: ,p_return_status out nocopy varchar2
199: );
200:
201: PROCEDURE suspend_affectation
202: (p_validate in number default hr_api.g_false_num
203: ,p_assignment_id in number
204: ,p_effective_date in date
205: ,p_assignment_status_type_id in number
206: ,p_object_version_number in out nocopy number
209: ,p_return_status out nocopy varchar2
210: );
211:
212: PROCEDURE activate_affectation
213: (p_validate in number default hr_api.g_false_num
214: ,p_assignment_id in number
215: ,p_effective_date in date
216: ,p_assignment_status_type_id in number
217: ,p_object_version_number in out nocopy number