1 package pqh_asg_wrapper as
2 /* $Header: peasgmup.pkh 120.1 2005/11/21 02:46:38 ayegappa noship $ */
3 -- PL/SQL table declaration
4 TYPE p_asgt_id is table of number index by binary_integer;
5 p_asg_id p_asgt_id;
6 --
7 FUNCTION show_worker_number
8 (p_employee_number IN VARCHAR2
9 ,p_npw_number IN VARCHAR2
10 ) RETURN VARCHAR2;
11 --
12 FUNCTION Is_Person_Correct_Type
13 (p_person_type_id IN per_person_types.person_type_id%TYPE)
14 RETURN CHAR ;
15 --
16 FUNCTION Is_Type_An_Applicant_Type
17 (p_person_type_id IN per_person_types.person_type_id%TYPE)
18 RETURN CHAR;
19 --
20 FUNCTION Is_Type_A_System_Type
21 (p_person_type_id IN per_person_types.person_type_id%TYPE)
22 RETURN CHAR;
23 --
24 FUNCTION Is_Org_In_Hierarchy
25 (p_search_org_id IN hr_organization_units.organization_id%TYPE)
26 RETURN CHAR;
27 --
28 FUNCTION Is_Org_A_Node
29 (p_search_org_id IN hr_organization_units.organization_id%TYPE
30 ,p_organization_structure_id IN per_org_structure_versions_v.organization_structure_id%TYPE)
31 RETURN CHAR;
32 --
33 FUNCTION Is_Position_In_Hierarchy
34 (p_search_pos_id IN hr_all_positions_f.position_id%TYPE)
35 RETURN CHAR;
36 --
37 FUNCTION Is_Pos_A_Node
38 (p_search_pos_id IN per_positions.position_id%TYPE
39 ,p_position_structure_id IN per_pos_structure_versions_v.position_structure_id%TYPE
40 ,p_effective_date IN DATE)
41 RETURN CHAR;
42 --
43 PROCEDURE update_assignment
44 (p_validate IN BOOLEAN DEFAULT FALSE
45 ,p_datetrack_update_mode IN VARCHAR2 DEFAULT hr_api.g_varchar2
46 ,p_object_version_number IN OUT NOCOPY NUMBER
47 ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
48 ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
49 ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
50 ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
51 ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
52 ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53 ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54 ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55 ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56 ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57 ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58 ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59 ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60 ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61 ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62 ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63 ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64 ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65 ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66 ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67 ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68 ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69 ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70 ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71 ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72 ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73 ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74 ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75 ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76 ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77 ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78 ,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
79 ,p_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
80 ,p_assignment_status_type_id IN NUMBER DEFAULT hr_api.g_number
81 ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
82 ,p_cagr_id_flex_num IN NUMBER DEFAULT hr_api.g_number
83 ,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
84 ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
85 ,p_contract_id IN NUMBER DEFAULT hr_api.g_number
86 ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
87 ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
88 ,p_establishment_id IN NUMBER DEFAULT hr_api.g_number
89 ,p_employment_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
90 ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
91 ,p_grade_id IN NUMBER DEFAULT hr_api.g_number
92 ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
93 ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
94 ,p_job_id IN NUMBER DEFAULT hr_api.g_number
95 ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
96 ,p_location_id IN NUMBER DEFAULT hr_api.g_number
97 ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
98 ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
99 ,p_pay_basis_id IN NUMBER DEFAULT hr_api.g_number
100 ,p_payroll_id IN NUMBER DEFAULT hr_api.g_number
101 ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
102 ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
103 ,p_position_id IN NUMBER DEFAULT hr_api.g_number
104 ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
105 ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
106 ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
107 ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
108 ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
109 ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
110 ,p_supervisor_id IN NUMBER DEFAULT hr_api.g_number
111 ,p_supervisor_assignment_id IN NUMBER DEFAULT hr_api.g_number
112 ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
113 ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
114 ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
115 ,p_cag_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
116 ,p_cag_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
117 ,p_cag_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
118 ,p_cag_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
119 ,p_cag_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
120 ,p_cag_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
121 ,p_cag_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
122 ,p_cag_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
123 ,p_cag_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
124 ,p_cag_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
125 ,p_cag_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
126 ,p_cag_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
127 ,p_cag_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
128 ,p_cag_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
129 ,p_cag_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
130 ,p_cag_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
131 ,p_cag_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
132 ,p_cag_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
133 ,p_cag_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
134 ,p_cag_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
135 ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
136 ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
137 ,p_effective_date IN DATE DEFAULT hr_api.g_date
138 ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
139 ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
140 ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
141 ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
142 ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
143 ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
144 ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
145 ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
146 ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
147 ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
148 ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
149 ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
150 ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
151 ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
152 ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
153 ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
154 ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
155 ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
156 ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
157 ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
158 ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
159 ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
160 ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
161 ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
162 ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
163 ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
164 ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
165 ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
166 ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
167 ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
168 ,p_scl_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
169 ,p_scl_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
170 ,p_scl_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
171 ,p_scl_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
172 ,p_scl_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
173 ,p_scl_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
174 ,p_scl_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
175 ,p_scl_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
176 ,p_scl_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
177 ,p_scl_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
178 ,p_scl_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
179 ,p_scl_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
180 ,p_scl_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
181 ,p_scl_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
182 ,p_scl_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
183 ,p_scl_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
184 ,p_scl_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
185 ,p_scl_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
186 ,p_scl_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
187 ,p_scl_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
188 ,p_scl_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
189 ,p_scl_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
190 ,p_scl_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
191 ,p_scl_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
192 ,p_scl_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
193 ,p_scl_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
194 ,p_scl_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
195 ,p_scl_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
196 ,p_scl_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
197 ,p_scl_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
198 ,p_grade_ladder_pgm_id IN NUMBER DEFAULT hr_api.g_number
199 ,p_recruiter_id IN NUMBER DEFAULT hr_api.g_number
200 ,p_person_referred_by_id IN NUMBER DEFAULT hr_api.g_number
201 ,p_recruitment_activity_id IN NUMBER DEFAULT hr_api.g_number
202 ,p_source_organization_id IN NUMBER DEFAULT hr_api.g_number
203 ,p_vacancy_id IN NUMBER DEFAULT hr_api.g_number
204 ,p_application_id IN NUMBER DEFAULT hr_api.g_number
205 ,p_vendor_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
206 ,p_vendor_employee_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
207 ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
208 ,p_vendor_site_id IN NUMBER DEFAULT hr_api.g_number
209 ,p_project_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
210 ,p_projected_assignment_end IN DATE DEFAULT hr_api.g_date
211 ,p_organization_id IN OUT NOCOPY NUMBER
212 ,p_concatenated_segments IN OUT NOCOPY VARCHAR2
213 ,p_special_ceiling_step_id IN OUT NOCOPY NUMBER
214 ,p_cagr_grade_def_id IN OUT NOCOPY NUMBER
215 ,p_comment_id OUT NOCOPY NUMBER
216 ,p_cagr_concatenated_segments OUT NOCOPY VARCHAR2
217 ,p_effective_end_date OUT NOCOPY DATE
218 ,p_effective_start_date OUT NOCOPY DATE
219 ,p_no_managers_warning OUT NOCOPY BOOLEAN
220 ,p_other_manager_warning OUT NOCOPY BOOLEAN
221 ,p_gsp_post_process_warning OUT NOCOPY VARCHAR2
222 ,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
223 ,p_entries_changed_warning OUT NOCOPY VARCHAR2
224 ,p_group_name OUT NOCOPY VARCHAR2
225 ,p_org_now_no_manager_warning OUT NOCOPY BOOLEAN
226 ,p_people_group_id OUT NOCOPY NUMBER
227 ,p_spp_delete_warning OUT NOCOPY BOOLEAN
228 ,p_tax_district_changed_warning OUT NOCOPY BOOLEAN );
229 --
230 procedure upd_asg (
231 p_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 ,
232 p_ASS_ATTRIBUTE1 IN VARCHAR2 ,
233 p_ASS_ATTRIBUTE10 IN VARCHAR2 ,
234 p_ASS_ATTRIBUTE11 IN VARCHAR2 ,
235 p_ASS_ATTRIBUTE12 IN VARCHAR2 ,
236 p_ASS_ATTRIBUTE13 IN VARCHAR2 ,
237 p_ASS_ATTRIBUTE14 IN VARCHAR2 ,
238 p_ASS_ATTRIBUTE15 IN VARCHAR2 ,
239 p_ASS_ATTRIBUTE16 IN VARCHAR2 ,
240 p_ASS_ATTRIBUTE17 IN VARCHAR2 ,
241 p_ASS_ATTRIBUTE18 IN VARCHAR2 ,
242 p_ASS_ATTRIBUTE19 IN VARCHAR2 ,
243 p_ASS_ATTRIBUTE2 IN VARCHAR2 ,
244 p_ASS_ATTRIBUTE20 IN VARCHAR2 ,
245 p_ASS_ATTRIBUTE21 IN VARCHAR2 ,
246 p_ASS_ATTRIBUTE22 IN VARCHAR2 ,
247 p_ASS_ATTRIBUTE23 IN VARCHAR2 ,
248 p_ASS_ATTRIBUTE24 IN VARCHAR2 ,
249 p_ASS_ATTRIBUTE25 IN VARCHAR2 ,
250 p_ASS_ATTRIBUTE26 IN VARCHAR2 ,
251 p_ASS_ATTRIBUTE27 IN VARCHAR2 ,
252 p_ASS_ATTRIBUTE28 IN VARCHAR2 ,
253 p_ASS_ATTRIBUTE29 IN VARCHAR2 ,
254 p_ASS_ATTRIBUTE3 IN VARCHAR2 ,
255 p_ASS_ATTRIBUTE30 IN VARCHAR2 ,
256 p_ASS_ATTRIBUTE4 IN VARCHAR2 ,
257 p_ASS_ATTRIBUTE5 IN VARCHAR2 ,
258 p_ASS_ATTRIBUTE6 IN VARCHAR2 ,
259 p_ASS_ATTRIBUTE7 IN VARCHAR2 ,
260 p_ASS_ATTRIBUTE8 IN VARCHAR2 ,
261 p_ASS_ATTRIBUTE9 IN VARCHAR2 ,
262 p_ASSIGNMENT_ID IN NUMBER ,
263 p_ASSIGNMENT_NUMBER IN VARCHAR2 ,
264 p_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER ,
265 p_BARGAINING_UNIT_CODE IN VARCHAR2 ,
266 p_CAGR_GRADE_DEF_ID IN OUT NOCOPY NUMBER ,
267 p_CAGR_ID_FLEX_NUM IN NUMBER ,
268 p_CHANGE_REASON IN VARCHAR2 ,
269 p_COLLECTIVE_AGREEMENT_ID IN NUMBER ,
270 p_COMMENT_ID OUT NOCOPY NUMBER ,
271 p_CONTRACT_ID IN NUMBER ,
272 p_DATE_PROBATION_END IN DATE ,
273 p_DEFAULT_CODE_COMB_ID IN NUMBER ,
274 p_ESTABLISHMENT_ID IN NUMBER ,
275 p_EMPLOYMENT_CATEGORY IN VARCHAR2 ,
276 p_FREQUENCY IN VARCHAR2 ,
277 p_GRADE_ID IN NUMBER ,
278 p_HOURLY_SALARIED_CODE IN VARCHAR2 ,
279 p_INTERNAL_ADDRESS_LINE IN VARCHAR2 ,
280 p_JOB_ID IN NUMBER ,
281 p_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 ,
282 p_LOCATION_ID IN NUMBER ,
283 p_MANAGER_FLAG IN VARCHAR2 ,
284 p_NORMAL_HOURS IN NUMBER ,
285 p_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER ,
286 p_ORGANIZATION_ID IN OUT NOCOPY NUMBER ,
287 p_PAY_BASIS_ID IN NUMBER ,
288 p_PAYROLL_ID IN NUMBER ,
289 p_PERF_REVIEW_PERIOD IN NUMBER ,
290 p_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 ,
291 p_POSITION_ID IN NUMBER ,
292 p_PROBATION_PERIOD IN NUMBER ,
293 p_PROBATION_UNIT IN VARCHAR2 ,
294 p_SAL_REVIEW_PERIOD IN NUMBER ,
295 p_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 ,
296 p_SET_OF_BOOKS_ID IN NUMBER ,
297 p_SOFT_CODING_KEYFLEX_ID OUT NOCOPY NUMBER ,
298 p_SOURCE_TYPE IN VARCHAR2 ,
299 p_SPECIAL_CEILING_STEP_ID IN OUT NOCOPY NUMBER ,
300 p_SUPERVISOR_ID IN NUMBER ,
301 P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER ,
302 p_TIME_NORMAL_FINISH IN VARCHAR2 ,
303 p_TIME_NORMAL_START IN VARCHAR2 ,
304 p_TITLE IN VARCHAR2 ,
305 p_ENTRIES_CHANGED_WARNING OUT NOCOPY VARCHAR2,
306 p_GROUP_NAME OUT NOCOPY VARCHAR2,
307 p_ORG_NOW_NO_MANAGER_WARNING OUT NOCOPY BOOLEAN ,
308 p_PEOPLE_GROUP_ID OUT NOCOPY NUMBER ,
309 p_SPP_DELETE_WARNING OUT NOCOPY BOOLEAN ,
310 p_TAX_DISTRICT_CHANGED_WARNING OUT NOCOPY BOOLEAN ,
311 p_CAG_SEGMENT1 IN VARCHAR2 ,
312 p_CAG_SEGMENT10 IN VARCHAR2 ,
313 p_CAG_SEGMENT11 IN VARCHAR2 ,
314 p_CAG_SEGMENT12 IN VARCHAR2 ,
315 p_CAG_SEGMENT13 IN VARCHAR2 ,
316 p_CAG_SEGMENT14 IN VARCHAR2 ,
317 p_CAG_SEGMENT15 IN VARCHAR2 ,
318 p_CAG_SEGMENT16 IN VARCHAR2 ,
319 p_CAG_SEGMENT17 IN VARCHAR2 ,
320 p_CAG_SEGMENT18 IN VARCHAR2 ,
321 p_CAG_SEGMENT19 IN VARCHAR2 ,
322 p_CAG_SEGMENT2 IN VARCHAR2 ,
323 p_CAG_SEGMENT20 IN VARCHAR2 ,
324 p_CAG_SEGMENT3 IN VARCHAR2 ,
325 p_CAG_SEGMENT4 IN VARCHAR2 ,
326 p_CAG_SEGMENT5 IN VARCHAR2 ,
327 p_CAG_SEGMENT6 IN VARCHAR2 ,
328 p_CAG_SEGMENT7 IN VARCHAR2 ,
329 p_CAG_SEGMENT8 IN VARCHAR2 ,
330 p_CAG_SEGMENT9 IN VARCHAR2 ,
331 p_CAGR_CONCATENATED_SEGMENTS OUT NOCOPY VARCHAR2 ,
332 p_COMMENTS IN VARCHAR2 ,
333 p_CONCAT_SEGMENTS IN VARCHAR2 ,
334 p_CONCATENATED_SEGMENTS IN OUT NOCOPY VARCHAR2 ,
335 p_DATETRACK_UPDATE_MODE IN VARCHAR2 ,
336 p_EFFECTIVE_DATE IN DATE ,
337 p_EFFECTIVE_END_DATE OUT NOCOPY DATE ,
338 p_EFFECTIVE_START_DATE OUT NOCOPY DATE ,
339 p_NO_MANAGERS_WARNING OUT NOCOPY BOOLEAN ,
340 p_OTHER_MANAGER_WARNING OUT NOCOPY BOOLEAN ,
341 p_GSP_POST_PROCESS_WARNING OUT NOCOPY VARCHAR2 ,
342 p_SEGMENT1 IN VARCHAR2 ,
343 p_SEGMENT10 IN VARCHAR2 ,
344 p_SEGMENT11 IN VARCHAR2 ,
345 p_SEGMENT12 IN VARCHAR2 ,
346 p_SEGMENT13 IN VARCHAR2 ,
347 p_SEGMENT14 IN VARCHAR2 ,
348 p_SEGMENT15 IN VARCHAR2 ,
349 p_SEGMENT16 IN VARCHAR2 ,
350 p_SEGMENT17 IN VARCHAR2 ,
351 p_SEGMENT18 IN VARCHAR2 ,
352 p_SEGMENT19 IN VARCHAR2 ,
353 p_SEGMENT2 IN VARCHAR2 ,
354 p_SEGMENT20 IN VARCHAR2 ,
355 p_SEGMENT21 IN VARCHAR2 ,
356 p_SEGMENT22 IN VARCHAR2 ,
357 p_SEGMENT23 IN VARCHAR2 ,
358 p_SEGMENT24 IN VARCHAR2 ,
359 p_SEGMENT25 IN VARCHAR2 ,
360 p_SEGMENT26 IN VARCHAR2 ,
361 p_SEGMENT27 IN VARCHAR2 ,
362 p_SEGMENT28 IN VARCHAR2 ,
363 p_SEGMENT29 IN VARCHAR2 ,
364 p_SEGMENT3 IN VARCHAR2 ,
365 p_SEGMENT30 IN VARCHAR2 ,
366 p_SEGMENT4 IN VARCHAR2 ,
367 p_SEGMENT5 IN VARCHAR2 ,
368 p_SEGMENT6 IN VARCHAR2 ,
369 p_SEGMENT7 IN VARCHAR2 ,
370 p_SEGMENT8 IN VARCHAR2 ,
371 p_SEGMENT9 IN VARCHAR2 ,
372 p_SCL_SEGMENT1 IN VARCHAR2 ,
373 p_SCL_SEGMENT10 IN VARCHAR2 ,
374 p_SCL_SEGMENT11 IN VARCHAR2 ,
375 p_SCL_SEGMENT12 IN VARCHAR2 ,
376 p_SCL_SEGMENT13 IN VARCHAR2 ,
377 p_SCL_SEGMENT14 IN VARCHAR2 ,
378 p_SCL_SEGMENT15 IN VARCHAR2 ,
379 p_SCL_SEGMENT16 IN VARCHAR2 ,
380 p_SCL_SEGMENT17 IN VARCHAR2 ,
381 p_SCL_SEGMENT18 IN VARCHAR2 ,
382 p_SCL_SEGMENT19 IN VARCHAR2 ,
383 p_SCL_SEGMENT2 IN VARCHAR2 ,
384 p_SCL_SEGMENT20 IN VARCHAR2 ,
385 p_SCL_SEGMENT21 IN VARCHAR2 ,
386 p_SCL_SEGMENT22 IN VARCHAR2 ,
387 p_SCL_SEGMENT23 IN VARCHAR2 ,
388 p_SCL_SEGMENT24 IN VARCHAR2 ,
389 p_SCL_SEGMENT25 IN VARCHAR2 ,
390 p_SCL_SEGMENT26 IN VARCHAR2 ,
391 p_SCL_SEGMENT27 IN VARCHAR2 ,
392 p_SCL_SEGMENT28 IN VARCHAR2 ,
393 p_SCL_SEGMENT29 IN VARCHAR2 ,
394 p_SCL_SEGMENT3 IN VARCHAR2 ,
395 p_SCL_SEGMENT30 IN VARCHAR2 ,
396 p_SCL_SEGMENT4 IN VARCHAR2 ,
397 p_SCL_SEGMENT5 IN VARCHAR2 ,
398 p_SCL_SEGMENT6 IN VARCHAR2 ,
399 p_SCL_SEGMENT7 IN VARCHAR2 ,
400 p_SCL_SEGMENT8 IN VARCHAR2 ,
401 p_SCL_SEGMENT9 IN VARCHAR2 ,
402 p_GRADE_LADDER_PGM_ID IN NUMBER ,
403 p_VALIDATE IN BOOLEAN) ;
404 --
405 PROCEDURE update_applicant_asg
406 (p_validate in boolean default false
407 ,p_effective_date in date
408 ,p_datetrack_update_mode in varchar2
409 ,p_assignment_id in number
410 ,p_object_version_number in out nocopy number
411 ,p_recruiter_id in number default hr_api.g_number
412 ,p_grade_id in number default hr_api.g_number
413 ,p_position_id in number default hr_api.g_number
414 ,p_job_id in number default hr_api.g_number
415 ,p_payroll_id in number default hr_api.g_number
416 ,p_location_id in number default hr_api.g_number
417 ,p_person_referred_by_id in number default hr_api.g_number
418 ,p_assignment_status_type_id in number default hr_api.g_number
419 ,p_supervisor_id in number default hr_api.g_number
420 ,p_supervisor_assignment_id IN NUMBER DEFAULT hr_api.g_number
421 ,p_special_ceiling_step_id in number default hr_api.g_number
422 ,p_recruitment_activity_id in number default hr_api.g_number
423 ,p_source_organization_id in number default hr_api.g_number
424 ,p_organization_id in number default hr_api.g_number
425 ,p_vacancy_id in number default hr_api.g_number
426 ,p_pay_basis_id in number default hr_api.g_number
427 ,p_application_id in number default hr_api.g_number
428 ,p_change_reason in varchar2 default hr_api.g_varchar2
429 ,p_comments in varchar2 default hr_api.g_varchar2
430 ,p_date_probation_end in date default hr_api.g_date
431 ,p_default_code_comb_id in number default hr_api.g_number
432 ,p_employment_category in varchar2 default hr_api.g_varchar2
433 ,p_frequency in varchar2 default hr_api.g_varchar2
434 ,p_internal_address_line in varchar2 default hr_api.g_varchar2
435 ,p_manager_flag in varchar2 default hr_api.g_varchar2
436 ,p_normal_hours in number default hr_api.g_number
437 ,p_perf_review_period in number default hr_api.g_number
438 ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
439 ,p_probation_period in number default hr_api.g_number
440 ,p_probation_unit in varchar2 default hr_api.g_varchar2
441 ,p_sal_review_period in number default hr_api.g_number
442 ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
443 ,p_set_of_books_id in number default hr_api.g_number
444 ,p_source_type in varchar2 default hr_api.g_varchar2
445 ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
446 ,p_time_normal_start in varchar2 default hr_api.g_varchar2
447 ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
448 ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
449 ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
450 ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
451 ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
452 ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
453 ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
454 ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
455 ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
456 ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
457 ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
458 ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
459 ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
460 ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
461 ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
462 ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
463 ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
464 ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
465 ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
466 ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
467 ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
468 ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
469 ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
470 ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
471 ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
472 ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
473 ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
474 ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
475 ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
476 ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
477 ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
478 ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
479 ,p_title in varchar2 default hr_api.g_varchar2
480 ,p_scl_segment1 in varchar2 default hr_api.g_varchar2
481 ,p_scl_segment2 in varchar2 default hr_api.g_varchar2
482 ,p_scl_segment3 in varchar2 default hr_api.g_varchar2
483 ,p_scl_segment4 in varchar2 default hr_api.g_varchar2
484 ,p_scl_segment5 in varchar2 default hr_api.g_varchar2
485 ,p_scl_segment6 in varchar2 default hr_api.g_varchar2
486 ,p_scl_segment7 in varchar2 default hr_api.g_varchar2
487 ,p_scl_segment8 in varchar2 default hr_api.g_varchar2
488 ,p_scl_segment9 in varchar2 default hr_api.g_varchar2
489 ,p_scl_segment10 in varchar2 default hr_api.g_varchar2
490 ,p_scl_segment11 in varchar2 default hr_api.g_varchar2
491 ,p_scl_segment12 in varchar2 default hr_api.g_varchar2
492 ,p_scl_segment13 in varchar2 default hr_api.g_varchar2
493 ,p_scl_segment14 in varchar2 default hr_api.g_varchar2
494 ,p_scl_segment15 in varchar2 default hr_api.g_varchar2
495 ,p_scl_segment16 in varchar2 default hr_api.g_varchar2
496 ,p_scl_segment17 in varchar2 default hr_api.g_varchar2
497 ,p_scl_segment18 in varchar2 default hr_api.g_varchar2
498 ,p_scl_segment19 in varchar2 default hr_api.g_varchar2
499 ,p_scl_segment20 in varchar2 default hr_api.g_varchar2
500 ,p_scl_segment21 in varchar2 default hr_api.g_varchar2
501 ,p_scl_segment22 in varchar2 default hr_api.g_varchar2
502 ,p_scl_segment23 in varchar2 default hr_api.g_varchar2
503 ,p_scl_segment24 in varchar2 default hr_api.g_varchar2
504 ,p_scl_segment25 in varchar2 default hr_api.g_varchar2
505 ,p_scl_segment26 in varchar2 default hr_api.g_varchar2
506 ,p_scl_segment27 in varchar2 default hr_api.g_varchar2
507 ,p_scl_segment28 in varchar2 default hr_api.g_varchar2
508 ,p_scl_segment29 in varchar2 default hr_api.g_varchar2
509 ,p_scl_segment30 in varchar2 default hr_api.g_varchar2
510 ,p_concatenated_segments in out nocopy varchar2
511 ,p_pgp_segment1 in varchar2 default hr_api.g_varchar2
512 ,p_pgp_segment2 in varchar2 default hr_api.g_varchar2
513 ,p_pgp_segment3 in varchar2 default hr_api.g_varchar2
514 ,p_pgp_segment4 in varchar2 default hr_api.g_varchar2
515 ,p_pgp_segment5 in varchar2 default hr_api.g_varchar2
516 ,p_pgp_segment6 in varchar2 default hr_api.g_varchar2
517 ,p_pgp_segment7 in varchar2 default hr_api.g_varchar2
518 ,p_pgp_segment8 in varchar2 default hr_api.g_varchar2
519 ,p_pgp_segment9 in varchar2 default hr_api.g_varchar2
520 ,p_pgp_segment10 in varchar2 default hr_api.g_varchar2
521 ,p_pgp_segment11 in varchar2 default hr_api.g_varchar2
522 ,p_pgp_segment12 in varchar2 default hr_api.g_varchar2
523 ,p_pgp_segment13 in varchar2 default hr_api.g_varchar2
524 ,p_pgp_segment14 in varchar2 default hr_api.g_varchar2
525 ,p_pgp_segment15 in varchar2 default hr_api.g_varchar2
526 ,p_pgp_segment16 in varchar2 default hr_api.g_varchar2
527 ,p_pgp_segment17 in varchar2 default hr_api.g_varchar2
528 ,p_pgp_segment18 in varchar2 default hr_api.g_varchar2
529 ,p_pgp_segment19 in varchar2 default hr_api.g_varchar2
530 ,p_pgp_segment20 in varchar2 default hr_api.g_varchar2
531 ,p_pgp_segment21 in varchar2 default hr_api.g_varchar2
532 ,p_pgp_segment22 in varchar2 default hr_api.g_varchar2
533 ,p_pgp_segment23 in varchar2 default hr_api.g_varchar2
534 ,p_pgp_segment24 in varchar2 default hr_api.g_varchar2
535 ,p_pgp_segment25 in varchar2 default hr_api.g_varchar2
536 ,p_pgp_segment26 in varchar2 default hr_api.g_varchar2
537 ,p_pgp_segment27 in varchar2 default hr_api.g_varchar2
538 ,p_pgp_segment28 in varchar2 default hr_api.g_varchar2
539 ,p_pgp_segment29 in varchar2 default hr_api.g_varchar2
540 ,p_pgp_segment30 in varchar2 default hr_api.g_varchar2
541 ,p_concat_segments in varchar2 default hr_api.g_varchar2
542 ,p_contract_id in number default hr_api.g_number
543 ,p_establishment_id in number default hr_api.g_number
544 ,p_collective_agreement_id in number default hr_api.g_number
545 ,p_cagr_id_flex_num in number default hr_api.g_number
546 ,p_cag_segment1 in varchar2 default hr_api.g_varchar2
547 ,p_cag_segment2 in varchar2 default hr_api.g_varchar2
548 ,p_cag_segment3 in varchar2 default hr_api.g_varchar2
549 ,p_cag_segment4 in varchar2 default hr_api.g_varchar2
550 ,p_cag_segment5 in varchar2 default hr_api.g_varchar2
551 ,p_cag_segment6 in varchar2 default hr_api.g_varchar2
552 ,p_cag_segment7 in varchar2 default hr_api.g_varchar2
553 ,p_cag_segment8 in varchar2 default hr_api.g_varchar2
554 ,p_cag_segment9 in varchar2 default hr_api.g_varchar2
555 ,p_cag_segment10 in varchar2 default hr_api.g_varchar2
556 ,p_cag_segment11 in varchar2 default hr_api.g_varchar2
557 ,p_cag_segment12 in varchar2 default hr_api.g_varchar2
558 ,p_cag_segment13 in varchar2 default hr_api.g_varchar2
559 ,p_cag_segment14 in varchar2 default hr_api.g_varchar2
560 ,p_cag_segment15 in varchar2 default hr_api.g_varchar2
561 ,p_cag_segment16 in varchar2 default hr_api.g_varchar2
562 ,p_cag_segment17 in varchar2 default hr_api.g_varchar2
563 ,p_cag_segment18 in varchar2 default hr_api.g_varchar2
564 ,p_cag_segment19 in varchar2 default hr_api.g_varchar2
565 ,p_cag_segment20 in varchar2 default hr_api.g_varchar2
566 ,p_grade_ladder_pgm_id in number default hr_api.g_number
567 ,p_cagr_grade_def_id in out nocopy number
568 ,p_cagr_concatenated_segments out nocopy varchar2
569 ,p_group_name out nocopy varchar2
570 ,p_comment_id out nocopy number
571 ,p_people_group_id out nocopy number
572 ,p_soft_coding_keyflex_id out nocopy number
573 ,p_effective_start_date out nocopy date
574 ,p_effective_end_date out nocopy date);
575 --
576 end;
[Home] [Help]