DBA Data[Home] [Help]

APPS.PQH_FR_ASSIGNMENT_SWI dependencies on HR_API

Line 27: (p_validate in number default hr_api.g_false_num

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

Line 55: (p_validate in number default hr_api.g_false_num

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

Line 91: (p_validate in number default hr_api.g_false_num

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

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

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

Line 97: ,p_job_id in number default hr_api.g_number

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

Line 98: ,p_supervisor_id in number default hr_api.g_number

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

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

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

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

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

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

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

Line 106: ,p_scl_concat_segments 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
109: ,p_object_version_number in out nocopy number
110: ,p_effective_start_date out nocopy date

Line 139: (p_validate in number default hr_api.g_false_num

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

Line 144: ,p_comments in varchar2 default hr_api.g_varchar2

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

Line 146: ,p_reason_for_parttime in varchar2 default hr_api.g_varchar2

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

Line 147: ,p_working_hours_share in varchar2 default hr_api.g_varchar2

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

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

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

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

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

Line 183: (p_validate in number default hr_api.g_false_num

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

Line 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

Line 188: ,p_grade_id in number default hr_api.g_number

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

Line 189: ,p_step_id in number default hr_api.g_number

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

Line 202: (p_validate in number default hr_api.g_false_num

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

Line 213: (p_validate in number default hr_api.g_false_num

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