DBA Data[Home] [Help]

APPS.PQH_FR_ASSIGNMENT_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

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

Line 64: hr_api.constant_to_boolean

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: --

Line 162: (p_validate in number default hr_api.g_false_num

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

Line 165: ,p_organization_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

Line 166: ,p_position_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

Line 168: ,p_job_id in number default hr_api.g_number

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

Line 169: ,p_supervisor_id in number default hr_api.g_number

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

Line 170: ,p_assignment_number 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

Line 171: ,p_assignment_status_type_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
175: ,p_primary_affectation in varchar2 default hr_api.g_varchar2

Line 172: ,p_identifier 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

Line 173: ,p_affectation_type in varchar2 default hr_api.g_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

Line 174: ,p_percent_effected 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

Line 175: ,p_primary_affectation 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
179: ,p_soft_coding_keyflex_id out nocopy number

Line 177: ,p_scl_concat_segments 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
180: ,p_object_version_number in out nocopy number
181: ,p_effective_start_date out nocopy date

Line 213: hr_api.constant_to_boolean

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: --

Line 308: (p_validate in number default hr_api.g_false_num

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

Line 313: ,p_comments in varchar2 default hr_api.g_varchar2

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

Line 315: ,p_reason_for_parttime in varchar2 default hr_api.g_varchar2

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

Line 316: ,p_working_hours_share in varchar2 default hr_api.g_varchar2

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

Line 317: ,p_contract_id in number default hr_api.g_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
321: ,p_soft_coding_keyflex_id out nocopy number

Line 318: ,p_change_reason 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
322: ,p_object_version_number in out nocopy number

Line 319: ,p_normal_hours in number default hr_api.g_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

Line 320: ,p_frequency 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
324: ,p_effective_end_date out nocopy date

Line 355: hr_api.constant_to_boolean

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: --

Line 444: (p_validate in number default hr_api.g_false_num

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

Line 488: hr_api.constant_to_boolean

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: --

Line 572: (p_validate in number default hr_api.g_false_num

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

Line 608: hr_api.constant_to_boolean

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: --

Line 686: (p_validate in number default hr_api.g_false_num

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

Line 720: hr_api.constant_to_boolean

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: --

Line 795: (p_validate in number default hr_api.g_false_num

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

Line 829: hr_api.constant_to_boolean

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: --