8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_affectation >--------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_affectation
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_organization_id in number
15: ,p_position_id in number
16: ,p_person_id in number
60: --
61: -- Convert constant values to their corresponding boolean value
62: --
63: l_validate :=
64: hr_api.constant_to_boolean
65: (p_constant_value => p_validate);
66: --
67: -- Register Surrogate ID or user key values
68: --
158: -- ----------------------------------------------------------------------------
159: -- |--------------------------< update_affectation >--------------------------|
160: -- ----------------------------------------------------------------------------
161: PROCEDURE update_affectation
162: (p_validate in number default hr_api.g_false_num
163: ,p_datetrack_update_mode in varchar2
164: ,p_effective_date in date
165: ,p_organization_id in number default hr_api.g_number
166: ,p_position_id in number default hr_api.g_number
161: PROCEDURE update_affectation
162: (p_validate in number default hr_api.g_false_num
163: ,p_datetrack_update_mode in varchar2
164: ,p_effective_date in date
165: ,p_organization_id in number default hr_api.g_number
166: ,p_position_id in number default hr_api.g_number
167: ,p_person_id in number
168: ,p_job_id in number default hr_api.g_number
169: ,p_supervisor_id in number default hr_api.g_number
162: (p_validate in number default hr_api.g_false_num
163: ,p_datetrack_update_mode in varchar2
164: ,p_effective_date in date
165: ,p_organization_id in number default hr_api.g_number
166: ,p_position_id in number default hr_api.g_number
167: ,p_person_id in number
168: ,p_job_id in number default hr_api.g_number
169: ,p_supervisor_id in number default hr_api.g_number
170: ,p_assignment_number in varchar2 default hr_api.g_varchar2
164: ,p_effective_date in date
165: ,p_organization_id in number default hr_api.g_number
166: ,p_position_id in number default hr_api.g_number
167: ,p_person_id in number
168: ,p_job_id in number default hr_api.g_number
169: ,p_supervisor_id in number default hr_api.g_number
170: ,p_assignment_number in varchar2 default hr_api.g_varchar2
171: ,p_assignment_status_type_id in number default hr_api.g_number
172: ,p_identifier in varchar2 default hr_api.g_varchar2
165: ,p_organization_id in number default hr_api.g_number
166: ,p_position_id in number default hr_api.g_number
167: ,p_person_id in number
168: ,p_job_id in number default hr_api.g_number
169: ,p_supervisor_id in number default hr_api.g_number
170: ,p_assignment_number in varchar2 default hr_api.g_varchar2
171: ,p_assignment_status_type_id in number default hr_api.g_number
172: ,p_identifier in varchar2 default hr_api.g_varchar2
173: ,p_affectation_type in varchar2 default hr_api.g_varchar2
166: ,p_position_id in number default hr_api.g_number
167: ,p_person_id in number
168: ,p_job_id in number default hr_api.g_number
169: ,p_supervisor_id in number default hr_api.g_number
170: ,p_assignment_number in varchar2 default hr_api.g_varchar2
171: ,p_assignment_status_type_id in number default hr_api.g_number
172: ,p_identifier in varchar2 default hr_api.g_varchar2
173: ,p_affectation_type in varchar2 default hr_api.g_varchar2
174: ,p_percent_effected in varchar2 default hr_api.g_varchar2
167: ,p_person_id in number
168: ,p_job_id in number default hr_api.g_number
169: ,p_supervisor_id in number default hr_api.g_number
170: ,p_assignment_number in varchar2 default hr_api.g_varchar2
171: ,p_assignment_status_type_id in number default hr_api.g_number
172: ,p_identifier in varchar2 default hr_api.g_varchar2
173: ,p_affectation_type in varchar2 default hr_api.g_varchar2
174: ,p_percent_effected in varchar2 default hr_api.g_varchar2
175: ,p_primary_affectation in varchar2 default hr_api.g_varchar2
168: ,p_job_id in number default hr_api.g_number
169: ,p_supervisor_id in number default hr_api.g_number
170: ,p_assignment_number in varchar2 default hr_api.g_varchar2
171: ,p_assignment_status_type_id in number default hr_api.g_number
172: ,p_identifier in varchar2 default hr_api.g_varchar2
173: ,p_affectation_type in varchar2 default hr_api.g_varchar2
174: ,p_percent_effected in varchar2 default hr_api.g_varchar2
175: ,p_primary_affectation in varchar2 default hr_api.g_varchar2
176: ,p_group_name out nocopy varchar2
169: ,p_supervisor_id in number default hr_api.g_number
170: ,p_assignment_number in varchar2 default hr_api.g_varchar2
171: ,p_assignment_status_type_id in number default hr_api.g_number
172: ,p_identifier in varchar2 default hr_api.g_varchar2
173: ,p_affectation_type in varchar2 default hr_api.g_varchar2
174: ,p_percent_effected in varchar2 default hr_api.g_varchar2
175: ,p_primary_affectation in varchar2 default hr_api.g_varchar2
176: ,p_group_name out nocopy varchar2
177: ,p_scl_concat_segments in varchar2 default hr_api.g_varchar2
170: ,p_assignment_number in varchar2 default hr_api.g_varchar2
171: ,p_assignment_status_type_id in number default hr_api.g_number
172: ,p_identifier in varchar2 default hr_api.g_varchar2
173: ,p_affectation_type in varchar2 default hr_api.g_varchar2
174: ,p_percent_effected in varchar2 default hr_api.g_varchar2
175: ,p_primary_affectation in varchar2 default hr_api.g_varchar2
176: ,p_group_name out nocopy varchar2
177: ,p_scl_concat_segments in varchar2 default hr_api.g_varchar2
178: ,p_assignment_id in number
171: ,p_assignment_status_type_id in number default hr_api.g_number
172: ,p_identifier in varchar2 default hr_api.g_varchar2
173: ,p_affectation_type in varchar2 default hr_api.g_varchar2
174: ,p_percent_effected in varchar2 default hr_api.g_varchar2
175: ,p_primary_affectation in varchar2 default hr_api.g_varchar2
176: ,p_group_name out nocopy varchar2
177: ,p_scl_concat_segments in varchar2 default hr_api.g_varchar2
178: ,p_assignment_id in number
179: ,p_soft_coding_keyflex_id out nocopy number
173: ,p_affectation_type in varchar2 default hr_api.g_varchar2
174: ,p_percent_effected in varchar2 default hr_api.g_varchar2
175: ,p_primary_affectation in varchar2 default hr_api.g_varchar2
176: ,p_group_name out nocopy varchar2
177: ,p_scl_concat_segments in varchar2 default hr_api.g_varchar2
178: ,p_assignment_id in number
179: ,p_soft_coding_keyflex_id out nocopy number
180: ,p_object_version_number in out nocopy number
181: ,p_effective_start_date out nocopy date
209: --
210: -- Convert constant values to their corresponding boolean value
211: --
212: l_validate :=
213: hr_api.constant_to_boolean
214: (p_constant_value => p_validate);
215: --
216: -- Register Surrogate ID or user key values
217: --
304: -- ----------------------------------------------------------------------------
305: -- |------------------------< update_employment_terms >-----------------------|
306: -- ----------------------------------------------------------------------------
307: PROCEDURE update_employment_terms
308: (p_validate in number default hr_api.g_false_num
309: ,p_datetrack_update_mode in varchar2
310: ,p_effective_date in date
311: ,p_assignment_id in number
312: ,p_establishment_id in number
309: ,p_datetrack_update_mode in varchar2
310: ,p_effective_date in date
311: ,p_assignment_id in number
312: ,p_establishment_id in number
313: ,p_comments in varchar2 default hr_api.g_varchar2
314: ,p_assignment_category in varchar2
315: ,p_reason_for_parttime in varchar2 default hr_api.g_varchar2
316: ,p_working_hours_share in varchar2 default hr_api.g_varchar2
317: ,p_contract_id in number default hr_api.g_number
311: ,p_assignment_id in number
312: ,p_establishment_id in number
313: ,p_comments in varchar2 default hr_api.g_varchar2
314: ,p_assignment_category in varchar2
315: ,p_reason_for_parttime in varchar2 default hr_api.g_varchar2
316: ,p_working_hours_share in varchar2 default hr_api.g_varchar2
317: ,p_contract_id in number default hr_api.g_number
318: ,p_change_reason in varchar2 default hr_api.g_varchar2
319: ,p_normal_hours in number default hr_api.g_number
312: ,p_establishment_id in number
313: ,p_comments in varchar2 default hr_api.g_varchar2
314: ,p_assignment_category in varchar2
315: ,p_reason_for_parttime in varchar2 default hr_api.g_varchar2
316: ,p_working_hours_share in varchar2 default hr_api.g_varchar2
317: ,p_contract_id in number default hr_api.g_number
318: ,p_change_reason in varchar2 default hr_api.g_varchar2
319: ,p_normal_hours in number default hr_api.g_number
320: ,p_frequency in varchar2 default hr_api.g_varchar2
313: ,p_comments in varchar2 default hr_api.g_varchar2
314: ,p_assignment_category in varchar2
315: ,p_reason_for_parttime in varchar2 default hr_api.g_varchar2
316: ,p_working_hours_share in varchar2 default hr_api.g_varchar2
317: ,p_contract_id in number default hr_api.g_number
318: ,p_change_reason in varchar2 default hr_api.g_varchar2
319: ,p_normal_hours in number default hr_api.g_number
320: ,p_frequency in varchar2 default hr_api.g_varchar2
321: ,p_soft_coding_keyflex_id out nocopy number
314: ,p_assignment_category in varchar2
315: ,p_reason_for_parttime in varchar2 default hr_api.g_varchar2
316: ,p_working_hours_share in varchar2 default hr_api.g_varchar2
317: ,p_contract_id in number default hr_api.g_number
318: ,p_change_reason in varchar2 default hr_api.g_varchar2
319: ,p_normal_hours in number default hr_api.g_number
320: ,p_frequency in varchar2 default hr_api.g_varchar2
321: ,p_soft_coding_keyflex_id out nocopy number
322: ,p_object_version_number in out nocopy number
315: ,p_reason_for_parttime in varchar2 default hr_api.g_varchar2
316: ,p_working_hours_share in varchar2 default hr_api.g_varchar2
317: ,p_contract_id in number default hr_api.g_number
318: ,p_change_reason in varchar2 default hr_api.g_varchar2
319: ,p_normal_hours in number default hr_api.g_number
320: ,p_frequency in varchar2 default hr_api.g_varchar2
321: ,p_soft_coding_keyflex_id out nocopy number
322: ,p_object_version_number in out nocopy number
323: ,p_effective_start_date out nocopy date
316: ,p_working_hours_share in varchar2 default hr_api.g_varchar2
317: ,p_contract_id in number default hr_api.g_number
318: ,p_change_reason in varchar2 default hr_api.g_varchar2
319: ,p_normal_hours in number default hr_api.g_number
320: ,p_frequency in varchar2 default hr_api.g_varchar2
321: ,p_soft_coding_keyflex_id out nocopy number
322: ,p_object_version_number in out nocopy number
323: ,p_effective_start_date out nocopy date
324: ,p_effective_end_date out nocopy date
351: --
352: -- Convert constant values to their corresponding boolean value
353: --
354: l_validate :=
355: hr_api.constant_to_boolean
356: (p_constant_value => p_validate);
357: --
358: -- Register Surrogate ID or user key values
359: --
440: -- ----------------------------------------------------------------------------
441: -- |---------------------< update_administrative_career >---------------------|
442: -- ----------------------------------------------------------------------------
443: PROCEDURE update_administrative_career
444: (p_validate in number default hr_api.g_false_num
445: ,p_datetrack_update_mode in varchar2
446: ,p_effective_date in date
447: ,p_assignment_id in number
448: ,p_corps_id in number
484: --
485: -- Convert constant values to their corresponding boolean value
486: --
487: l_validate :=
488: hr_api.constant_to_boolean
489: (p_constant_value => p_validate);
490: --
491: -- Register Surrogate ID or user key values
492: --
568: hr_utility.set_location(' Leaving:' || l_proc,50);
569: end update_administrative_career;
570:
571: PROCEDURE terminate_affectation
572: (p_validate in number default hr_api.g_false_num
573: ,p_assignment_id in number
574: ,p_effective_date in date
575: ,p_assignment_status_type_id in number
576: ,p_primary_affectation in varchar2 default null
604: --
605: -- Convert constant values to their corresponding boolean value
606: --
607: l_validate :=
608: hr_api.constant_to_boolean
609: (p_constant_value => p_validate);
610: --
611: -- Register Surrogate ID or user key values
612: --
682:
683: end terminate_affectation;
684:
685: PROCEDURE suspend_affectation
686: (p_validate in number default hr_api.g_false_num
687: ,p_assignment_id in number
688: ,p_effective_date in date
689: ,p_assignment_status_type_id in number
690: ,p_object_version_number in out nocopy number
716: --
717: -- Convert constant values to their corresponding boolean value
718: --
719: l_validate :=
720: hr_api.constant_to_boolean
721: (p_constant_value => p_validate);
722: --
723: -- Register Surrogate ID or user key values
724: --
791:
792: end suspend_affectation;
793:
794: PROCEDURE activate_affectation
795: (p_validate in number default hr_api.g_false_num
796: ,p_assignment_id in number
797: ,p_effective_date in date
798: ,p_assignment_status_type_id in number
799: ,p_object_version_number in out nocopy number
825: --
826: -- Convert constant values to their corresponding boolean value
827: --
828: l_validate :=
829: hr_api.constant_to_boolean
830: (p_constant_value => p_validate);
831: --
832: -- Register Surrogate ID or user key values
833: --