1 PACKAGE hr_process_assignment_ss AUTHID CURRENT_USER AS
2 /* $Header: hrascwrs.pkh 120.4.12020000.1 2012/06/28 23:45:55 appldev ship $*/
3
4 g_data_error exception;
5 g_date_format constant varchar2(10):='RRRR-MM-DD';
6 g_new_hire_registration constant varchar2(30) := 'REGISTRATION'; --04/15/02
7 g_hire_an_applicant constant varchar2(30) := 'APPLICANT_HIRE'; -- 2355929
8 g_canonical_date constant date := to_date('4712-01-01', 'RRRR-MM-DD');
9
10 gv_ele_warning constant varchar2(200) := 'HR_ELEMENT_WARNING';
11 -- NTF changes
12 -- added by Vineeth
13 TYPE ref_cursor IS REF CURSOR;
14
15 -- End of NTF changes
16 --
17
18 --
19 procedure update_object_version
20 (p_transaction_step_id in number
21 ,p_login_person_id in number);
22
23 --
24 procedure get_asg_from_tt
25 (p_transaction_step_id in number
26 ,p_assignment_rec out nocopy per_all_assignments_f%rowtype);
27 --
28 procedure get_assignment_from_tt
29 (p_item_type in varchar2
30 ,p_item_key in varchar2
31 ,p_actid in varchar2
32 ,p_transaction_step_id in varchar2
33 ,p_assignment_id out nocopy varchar2
34 ,p_object_version_number out nocopy varchar2
35 ,p_effective_date out nocopy varchar2
36 ,p_grade_id out nocopy varchar2
37 ,p_position_id out nocopy varchar2
38 ,p_job_id out nocopy varchar2
39 ,p_location_id out nocopy varchar2
40 ,p_special_ceiling_step_id out nocopy varchar2
41 ,p_organization_id out nocopy varchar2
42 ,p_employment_category out nocopy varchar2
43 ,p_supervisor_id out nocopy varchar2
44 ,p_manager_flag out nocopy varchar2
45 ,p_normal_hours out nocopy varchar2
46 ,p_frequency out nocopy varchar2
47 ,p_time_normal_finish out nocopy varchar2
48 ,p_time_normal_start out nocopy varchar2
49 ,p_bargaining_unit_code out nocopy varchar2
50 ,p_labour_union_member_flag out nocopy varchar2
51 ,p_assignment_status_type_id out nocopy varchar2
52 ,p_change_reason out nocopy varchar2
53 ,p_ass_attribute_category out nocopy varchar2
54 ,p_ass_attribute1 out nocopy varchar2
55 ,p_ass_attribute2 out nocopy varchar2
56 ,p_ass_attribute3 out nocopy varchar2
57 ,p_ass_attribute4 out nocopy varchar2
58 ,p_ass_attribute5 out nocopy varchar2
59 ,p_ass_attribute6 out nocopy varchar2
60 ,p_ass_attribute7 out nocopy varchar2
61 ,p_ass_attribute8 out nocopy varchar2
62 ,p_ass_attribute9 out nocopy varchar2
63 ,p_ass_attribute10 out nocopy varchar2
64 ,p_ass_attribute11 out nocopy varchar2
65 ,p_ass_attribute12 out nocopy varchar2
66 ,p_ass_attribute13 out nocopy varchar2
67 ,p_ass_attribute14 out nocopy varchar2
68 ,p_ass_attribute15 out nocopy varchar2
69 ,p_ass_attribute16 out nocopy varchar2
70 ,p_ass_attribute17 out nocopy varchar2
71 ,p_ass_attribute18 out nocopy varchar2
72 ,p_ass_attribute19 out nocopy varchar2
73 ,p_ass_attribute20 out nocopy varchar2
74 ,p_ass_attribute21 out nocopy varchar2
75 ,p_ass_attribute22 out nocopy varchar2
76 ,p_ass_attribute23 out nocopy varchar2
77 ,p_ass_attribute24 out nocopy varchar2
78 ,p_ass_attribute25 out nocopy varchar2
79 ,p_ass_attribute26 out nocopy varchar2
80 ,p_ass_attribute27 out nocopy varchar2
81 ,p_ass_attribute28 out nocopy varchar2
82 ,p_ass_attribute29 out nocopy varchar2
83 ,p_ass_attribute30 out nocopy varchar2
84 ,p_soft_coding_keyflex_id out nocopy varchar2
85 ,p_people_group_id out nocopy varchar2
86 ,p_org_name out nocopy varchar2
87 ,p_job_name out nocopy varchar2
88 ,p_pos_name out nocopy varchar2
89 ,p_grade_name out nocopy varchar2
90 ,p_contract_id out nocopy varchar2
91 ,p_establishment_id out nocopy varchar2
92 ,p_cagr_grade_def_id out nocopy varchar2
93 ,p_collective_agreement_id out nocopy varchar2
94 ,p_cagr_id_flex_num out nocopy varchar2
95 ,p_payroll_id out nocopy varchar2
96 ,p_pay_basis_id out nocopy varchar2
97 ,p_sal_review_period out nocopy varchar2
98 ,p_sal_review_period_frequency out nocopy varchar2
99 ,p_date_probation_end out nocopy varchar2
100 ,p_probation_period out nocopy varchar2
101 ,p_probation_unit out nocopy varchar2
102 ,p_notice_period out nocopy varchar2
103 ,p_notice_period_uom out nocopy varchar2
104 ,p_employee_category out nocopy varchar2
105 ,p_work_at_home out nocopy varchar2
106 ,p_job_post_source_name out nocopy varchar2
107 ,p_perf_review_period out nocopy varchar2
108 ,p_perf_review_period_frequency out nocopy varchar2
109 ,p_internal_address_line out nocopy varchar2
110 ,p_display_org out nocopy varchar2
111 ,p_display_job out nocopy varchar2
112 ,p_display_pos out nocopy varchar2
113 ,p_display_grade out nocopy varchar2
114 ,p_display_ass_status out nocopy varchar2
115 ,p_business_group_id out nocopy varchar2
116 ,p_title out nocopy varchar2
117 ,p_default_code_comb_id out nocopy varchar2
118 ,p_set_of_books_id out nocopy varchar2
119 ,p_source_type out nocopy varchar2
120 ,p_project_title out nocopy varchar2
121 ,p_vendor_assignment_number out nocopy varchar2
122 ,p_vendor_employee_number out nocopy varchar2
123 ,p_vendor_id out nocopy varchar2
124 ,p_assignment_type out nocopy varchar2
125 ,p_grade_ladder_pgm_id out nocopy varchar2
126 ,p_supervisor_assignment_id out nocopy varchar2
127 ,p_vendor_name out nocopy varchar2
128 ,p_po_header_id out nocopy varchar2
129 ,p_po_line_id out nocopy varchar2
130 ,p_vendor_site_id out nocopy varchar2
131 ,p_po_number out nocopy varchar2
132 ,p_po_line_number out nocopy varchar2
133 ,p_vendor_site_name out nocopy varchar2
134 ,p_projected_asgn_end out nocopy date
135
136 );
137 --
138 procedure get_assignment_from_tt
139 (p_transaction_step_id in number
140 ,p_assignment_id out nocopy number
141 ,p_object_version_number out nocopy number
142 ,p_effective_date out nocopy varchar2
143 ,p_grade_id out nocopy number
144 ,p_position_id out nocopy number
145 ,p_job_id out nocopy number
146 ,p_location_id out nocopy number
147 ,p_special_ceiling_step_id out nocopy number
148 ,p_organization_id out nocopy number
149 ,p_employment_category out nocopy varchar2
150 ,p_supervisor_id out nocopy number
151 ,p_manager_flag out nocopy varchar2
152 ,p_normal_hours out nocopy number
153 ,p_frequency out nocopy varchar2
154 ,p_time_normal_finish out nocopy varchar2
155 ,p_time_normal_start out nocopy varchar2
156 ,p_bargaining_unit_code out nocopy varchar2
157 ,p_labour_union_member_flag out nocopy varchar2
158 ,p_assignment_status_type_id out nocopy number
159 ,p_change_reason out nocopy varchar2
160 ,p_ass_attribute_category out nocopy varchar2
161 ,p_ass_attribute1 out nocopy varchar2
162 ,p_ass_attribute2 out nocopy varchar2
163 ,p_ass_attribute3 out nocopy varchar2
164 ,p_ass_attribute4 out nocopy varchar2
165 ,p_ass_attribute5 out nocopy varchar2
166 ,p_ass_attribute6 out nocopy varchar2
167 ,p_ass_attribute7 out nocopy varchar2
168 ,p_ass_attribute8 out nocopy varchar2
169 ,p_ass_attribute9 out nocopy varchar2
170 ,p_ass_attribute10 out nocopy varchar2
171 ,p_ass_attribute11 out nocopy varchar2
172 ,p_ass_attribute12 out nocopy varchar2
173 ,p_ass_attribute13 out nocopy varchar2
174 ,p_ass_attribute14 out nocopy varchar2
175 ,p_ass_attribute15 out nocopy varchar2
176 ,p_ass_attribute16 out nocopy varchar2
177 ,p_ass_attribute17 out nocopy varchar2
178 ,p_ass_attribute18 out nocopy varchar2
179 ,p_ass_attribute19 out nocopy varchar2
180 ,p_ass_attribute20 out nocopy varchar2
181 ,p_ass_attribute21 out nocopy varchar2
182 ,p_ass_attribute22 out nocopy varchar2
183 ,p_ass_attribute23 out nocopy varchar2
184 ,p_ass_attribute24 out nocopy varchar2
185 ,p_ass_attribute25 out nocopy varchar2
186 ,p_ass_attribute26 out nocopy varchar2
187 ,p_ass_attribute27 out nocopy varchar2
188 ,p_ass_attribute28 out nocopy varchar2
189 ,p_ass_attribute29 out nocopy varchar2
190 ,p_ass_attribute30 out nocopy varchar2
191 ,p_soft_coding_keyflex_id out nocopy number
192 ,p_people_group_id out nocopy number
193 ,p_contract_id out nocopy number
194 ,p_establishment_id out nocopy number
195 ,p_cagr_grade_def_id out nocopy number
196 ,p_collective_agreement_id out nocopy number
197 ,p_cagr_id_flex_num out nocopy number
198 ,p_payroll_id out nocopy number
199 ,p_pay_basis_id out nocopy number
200 ,p_sal_review_period out nocopy number
201 ,p_sal_review_period_frequency out nocopy varchar2
202 ,p_date_probation_end out nocopy date
203 ,p_probation_period out nocopy number
204 ,p_probation_unit out nocopy varchar2
205 ,p_notice_period out nocopy number
206 ,p_notice_period_uom out nocopy varchar2
207 ,p_employee_category out nocopy varchar2
208 ,p_work_at_home out nocopy varchar2
209 ,p_job_post_source_name out nocopy varchar2
210 ,p_perf_review_period out nocopy number
211 ,p_perf_review_period_frequency out nocopy varchar2
212 ,p_internal_address_line out nocopy varchar2
213 ,p_display_org out nocopy varchar2
214 ,p_display_job out nocopy varchar2
215 ,p_display_pos out nocopy varchar2
216 ,p_display_grade out nocopy varchar2
217 ,p_display_ass_status out nocopy varchar2
218 ,p_business_group_id out nocopy number
219 ,p_title out nocopy varchar2
220 ,p_default_code_comb_id out nocopy number
221 ,p_set_of_books_id out nocopy number
222 ,p_source_type out nocopy varchar2
223 ,p_project_title out nocopy varchar2
224 ,p_vendor_assignment_number out nocopy varchar2
225 ,p_vendor_employee_number out nocopy varchar2
226 ,p_vendor_id out nocopy number
227 ,p_assignment_type out nocopy varchar2
228 ,p_grade_ladder_pgm_id out nocopy number
229 ,p_supervisor_assignment_id out nocopy number
230 ,p_po_header_id out nocopy number
231 ,p_po_line_id out nocopy number
232 ,p_vendor_site_id out nocopy number
233 ,p_projected_asgn_end out nocopy date
234 );
235
236
237 procedure process_save
238 (p_save_mode in varchar2 default null
239 ,p_item_type in varchar2
240 ,p_item_key in varchar2
241 ,p_actid in varchar2
242 ,p_login_person_id in varchar2 default null
243 ,p_assignment_id in varchar2
244 ,p_object_version_number in varchar2
245 ,p_effective_date in varchar2
246 ,p_grade_id in varchar2 default to_char(hr_api.g_number)
247 ,p_position_id in varchar2 default to_char(hr_api.g_number)
248 ,p_job_id in varchar2 default to_char(hr_api.g_number)
249 ,p_location_id in varchar2 default to_char(hr_api.g_number)
250 ,p_special_ceiling_step_id in varchar2 default to_char(hr_api.g_number)
251 ,p_organization_id in varchar2 default to_char(hr_api.g_number)
252 ,p_employment_category in varchar2 default hr_api.g_varchar2
253 ,p_supervisor_id in varchar2 default to_char(hr_api.g_number)
254 ,p_manager_flag in varchar2 default hr_api.g_varchar2
255 ,p_normal_hours in varchar2 default to_char(hr_api.g_number)
256 ,p_frequency in varchar2 default hr_api.g_varchar2
257 ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
258 ,p_time_normal_start in varchar2 default hr_api.g_varchar2
259 ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
260 ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
261 ,p_assignment_status_type_id in varchar2 default to_char(hr_api.g_number)
262 ,p_change_reason in varchar2 default hr_api.g_varchar2
263 ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
264 ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
265 ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
266 ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
267 ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
268 ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
269 ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
270 ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
271 ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
272 ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
273 ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
274 ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
275 ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
276 ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
277 ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
278 ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
279 ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
280 ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
281 ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
282 ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
283 ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
284 ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
285 ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
286 ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
287 ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
288 ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
289 ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
290 ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
291 ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
292 ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
293 ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
294 ,p_soft_coding_keyflex_id in varchar2 default to_char(hr_api.g_number)
295 ,p_people_group_id in varchar2 default to_char(hr_api.g_number)
296 ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
297 ,p_display_pos in varchar2 default hr_api.g_varchar2
298 ,p_display_org in varchar2 default hr_api.g_varchar2
299 ,p_display_job in varchar2 default hr_api.g_varchar2
300 ,p_display_ass_status in varchar2 default hr_api.g_varchar2
301 ,p_grade_lov in varchar2 default hr_api.g_varchar2
302 ,p_approver_id in varchar2 default to_char(hr_api.g_number)
303 ,p_review_proc_call in varchar2
304 ,p_display_grade in varchar2 default hr_api.g_varchar2
305 ,p_contract_id in varchar2 default to_char(hr_api.g_number)
306 ,p_establishment_id in varchar2 default to_char(hr_api.g_number)
307 ,p_cagr_grade_def_id in varchar2 default to_char(hr_api.g_number)
308 ,p_collective_agreement_id in varchar2 default to_char(hr_api.g_number)
309 ,p_cagr_id_flex_num in varchar2 default to_char(hr_api.g_number)
310 ,p_payroll_id in varchar2 default to_char(hr_api.g_number)
311 ,p_pay_basis_id in varchar2 default to_char(hr_api.g_number)
312 ,p_sal_review_period in varchar2 default to_char(hr_api.g_number)
313 ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
314 ,p_date_probation_end in varchar2 default to_char(hr_api.g_date,g_date_format)
315 ,p_probation_period in varchar2 default to_char(hr_api.g_number)
316 ,p_probation_unit in varchar2 default hr_api.g_varchar2
317 ,p_notice_period in varchar2 default to_char(hr_api.g_number)
318 ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
319 ,p_employee_category in varchar2 default hr_api.g_varchar2
320 ,p_work_at_home in varchar2 default hr_api.g_varchar2
321 ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
322 ,p_perf_review_period in varchar2 default to_char(hr_api.g_number)
323 ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
324 ,p_internal_address_line in varchar2 default hr_api.g_varchar2
325 ,p_element_changed in out nocopy varchar2
326 ,p_page_error in out nocopy varchar2
327 ,p_page_error_msg in out nocopy varchar2
328 ,p_page_warning in out nocopy varchar2
329 ,p_page_warning_msg in out nocopy varchar2
330 ,p_organization_error in out nocopy varchar2
331 ,p_organization_error_msg in out nocopy varchar2
332 ,p_job_error in out nocopy varchar2
333 ,p_job_error_msg in out nocopy varchar2
334 ,p_position_error in out nocopy varchar2
335 ,p_position_error_msg in out nocopy varchar2
336 ,p_grade_error in out nocopy varchar2
337 ,p_grade_error_msg in out nocopy varchar2
338 ,p_supervisor_error in out nocopy varchar2
339 ,p_supervisor_error_msg in out nocopy varchar2
340 ,p_location_error in out nocopy varchar2
341 ,p_location_error_msg in out nocopy varchar2
342 ,p_transaction_step_id in out nocopy varchar2
343 ,p_flow_mode in varchar2 default null
344 ,p_rptg_grp_id in varchar2 default null
345 ,p_plan_id in varchar2 default null
346 ,p_effective_date_option in varchar2 default null
347 ,p_title in varchar2 default hr_api.g_varchar2
348 ,p_default_code_comb_id in varchar2 default to_char(hr_api.g_number)
349 ,p_set_of_books_id in varchar2 default to_char(hr_api.g_number)
350 ,p_source_type in varchar2 default hr_api.g_varchar2
351 ,p_project_title in varchar2 default hr_api.g_varchar2
352 ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
353 ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
354 ,p_vendor_id in varchar2 default to_char(hr_api.g_number)
355 ,p_assignment_type in varchar2 default hr_api.g_varchar2
356 ,p_grade_ladder_pgm_id in varchar2 default to_char(hr_api.g_number)
357 ,p_supervisor_assignment_id in varchar2 default to_char(hr_api.g_number)
358 -- GSP changes
359 ,p_salary_change_warning in out nocopy varchar2
360 ,p_gsp_post_process_warning out nocopy varchar2
361 ,p_gsp_salary_effective_date out nocopy date
362 -- End of GSP changes
363 ,p_po_header_id in varchar2 default to_char(hr_api.g_number)
364 ,p_po_line_id in varchar2 default to_char(hr_api.g_number)
365 ,p_vendor_site_id in varchar2 default to_char(hr_api.g_number)
366 ,p_projected_asgn_end in date default g_canonical_date
367 );
368
369 procedure process_save
370 (p_save_mode in varchar2 default null
371 ,p_item_type in wf_items.item_type%TYPE
372 ,p_item_key in wf_items.item_key%TYPE
373 ,p_actid in wf_activity_attr_values.process_activity_id%type
374 ,p_login_person_id in number
375 ,p_assignment_id in number
376 ,p_object_version_number in number
377 ,p_effective_date in varchar2
378 ,p_grade_id in number default hr_api.g_number
379 ,p_position_id in number default hr_api.g_number
380 ,p_job_id in number default hr_api.g_number
381 ,p_location_id in number default hr_api.g_number
382 ,p_special_ceiling_step_id in number default hr_api.g_number
383 ,p_organization_id in number default hr_api.g_number
384 ,p_employment_category in varchar2 default hr_api.g_varchar2
385 ,p_supervisor_id in number default hr_api.g_number
386 ,p_manager_flag in varchar2 default hr_api.g_varchar2
387 ,p_normal_hours in number default hr_api.g_number
388 ,p_frequency in varchar2 default hr_api.g_varchar2
389 ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
390 ,p_time_normal_start in varchar2 default hr_api.g_varchar2
391 ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
392 ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
393 ,p_assignment_status_type_id in number default hr_api.g_number
394 ,p_change_reason in varchar2 default hr_api.g_varchar2
395 ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
396 ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
397 ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
398 ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
399 ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
400 ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
401 ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
402 ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
403 ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
404 ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
405 ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
406 ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
407 ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
408 ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
409 ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
410 ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
411 ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
412 ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
413 ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
414 ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
415 ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
416 ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
417 ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
418 ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
419 ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
420 ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
421 ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
422 ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
423 ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
424 ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
425 ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
426 ,p_soft_coding_keyflex_id in number default hr_api.g_number
427 ,p_people_group_id in number default hr_api.g_number
428 ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
429 ,p_display_pos in varchar2 default hr_api.g_varchar2
430 ,p_display_org in varchar2 default hr_api.g_varchar2
431 ,p_display_job in varchar2 default hr_api.g_varchar2
432 ,p_display_ass_status in varchar2 default hr_api.g_varchar2
433 ,p_grade_lov in varchar2 default hr_api.g_varchar2
434 ,p_approver_id in number default hr_api.g_number
435 ,p_review_proc_call in varchar2
436 ,p_display_grade in varchar2 default hr_api.g_varchar2
437 ,p_contract_id in number default hr_api.g_number
438 ,p_establishment_id in number default hr_api.g_number
439 ,p_cagr_grade_def_id in number default hr_api.g_number
440 ,p_collective_agreement_id in number default hr_api.g_number
441 ,p_cagr_id_flex_num in number default hr_api.g_number
442 ,p_payroll_id in number default hr_api.g_number
443 ,p_pay_basis_id in number default hr_api.g_number
444 ,p_sal_review_period in number default hr_api.g_number
445 ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
446 ,p_date_probation_end in date default hr_api.g_date
447 ,p_probation_period in number default hr_api.g_number
448 ,p_probation_unit in varchar2 default hr_api.g_varchar2
449 ,p_notice_period in number default hr_api.g_number
450 ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
451 ,p_employee_category in varchar2 default hr_api.g_varchar2
452 ,p_work_at_home in varchar2 default hr_api.g_varchar2
453 ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
454 ,p_perf_review_period in number default hr_api.g_number
455 ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
456 ,p_internal_address_line in varchar2 default hr_api.g_varchar2
457 ,p_element_changed in out nocopy varchar2
458 ,p_page_error in out nocopy varchar2
459 ,p_page_error_msg in out nocopy varchar2
460 ,p_page_warning in out nocopy varchar2
461 ,p_page_warning_msg in out nocopy varchar2
462 ,p_organization_error in out nocopy varchar2
463 ,p_organization_error_msg in out nocopy varchar2
464 ,p_job_error in out nocopy varchar2
465 ,p_job_error_msg in out nocopy varchar2
466 ,p_position_error in out nocopy varchar2
467 ,p_position_error_msg in out nocopy varchar2
468 ,p_grade_error in out nocopy varchar2
469 ,p_grade_error_msg in out nocopy varchar2
470 ,p_supervisor_error in out nocopy varchar2
471 ,p_supervisor_error_msg in out nocopy varchar2
472 ,p_location_error in out nocopy varchar2
473 ,p_location_error_msg in out nocopy varchar2
474 ,p_transaction_step_id in out nocopy varchar2
475 ,p_flow_mode in varchar2 default null
476 ,p_rptg_grp_id in varchar2 default null
477 ,p_plan_id in varchar2 default null
478 ,p_effective_date_option in varchar2 default null
479 ,p_title in varchar2 default hr_api.g_varchar2
480 ,p_default_code_comb_id in number default hr_api.g_number
481 ,p_set_of_books_id in number default hr_api.g_number
482 ,p_source_type in varchar2 default hr_api.g_varchar2
483 ,p_project_title in varchar2 default hr_api.g_varchar2
484 ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
485 ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
486 ,p_vendor_id in number default hr_api.g_number
487 ,p_assignment_type in varchar2 default hr_api.g_varchar2
488 ,p_grade_ladder_pgm_id in number default hr_api.g_number
489 ,p_supervisor_assignment_id in number default hr_api.g_number
490 -- GSP changes
491 ,p_salary_change_warning in out nocopy varchar2
492 ,p_gsp_post_process_warning out nocopy varchar2
493 ,p_gsp_salary_effective_date out nocopy date
494 -- End of GSP changes
495 ,p_po_header_id in number default hr_api.g_number
496 ,p_po_line_id in number default hr_api.g_number
497 ,p_vendor_site_id in number default hr_api.g_number
498 ,p_proj_asgn_end in date default g_canonical_date
499
500 );
501
502
503 -- This procedure is to recover all of the assignment data from the transaction
504 -- tables and save the data into database.
505 procedure process_api
506 (p_validate in boolean default false
507 ,p_transaction_step_id in number
508 ,p_effective_date in varchar2 default null
509 );
510
511 -- This is the procedure to update the assignment data, including
512 -- the People Group and Soft Coded Key Flexfields
513 procedure update_assignment
514 (p_validate in boolean default false
515 ,p_login_person_id in number default null
516 ,p_new_hire_appl_hire in varchar2 default 'N'
517 ,p_assignment_id in number
518 ,p_object_version_number in number
519 ,p_effective_date in date
520 ,p_datetrack_update_mode in varchar2
521 ,p_organization_id in number
522 ,p_position_id in number default null
523 ,p_job_id in number default null
524 ,p_grade_id in number default null
525 ,p_location_id in number default null
526 ,p_employment_category in varchar2 default null
527 ,p_supervisor_id in number default null
528 ,p_manager_flag in varchar2 default null
529 ,p_normal_hours in number default null
530 ,p_frequency in varchar2 default null
531 ,p_time_normal_finish in varchar2 default null
532 ,p_time_normal_start in varchar2 default null
533 ,p_bargaining_unit_code in varchar2 default null
534 ,p_labour_union_member_flag in varchar2 default null
535 ,p_assignment_status_type_id in number default null
536 ,p_change_reason in varchar2 default null
537 ,p_ass_attribute_category in varchar2 default null
538 ,p_ass_attribute1 in varchar2 default null
539 ,p_ass_attribute2 in varchar2 default null
540 ,p_ass_attribute3 in varchar2 default null
541 ,p_ass_attribute4 in varchar2 default null
542 ,p_ass_attribute5 in varchar2 default null
543 ,p_ass_attribute6 in varchar2 default null
544 ,p_ass_attribute7 in varchar2 default null
545 ,p_ass_attribute8 in varchar2 default null
546 ,p_ass_attribute9 in varchar2 default null
547 ,p_ass_attribute10 in varchar2 default null
548 ,p_ass_attribute11 in varchar2 default null
549 ,p_ass_attribute12 in varchar2 default null
550 ,p_ass_attribute13 in varchar2 default null
551 ,p_ass_attribute14 in varchar2 default null
552 ,p_ass_attribute15 in varchar2 default null
553 ,p_ass_attribute16 in varchar2 default null
554 ,p_ass_attribute17 in varchar2 default null
555 ,p_ass_attribute18 in varchar2 default null
556 ,p_ass_attribute19 in varchar2 default null
557 ,p_ass_attribute20 in varchar2 default null
558 ,p_ass_attribute21 in varchar2 default null
559 ,p_ass_attribute22 in varchar2 default null
560 ,p_ass_attribute23 in varchar2 default null
561 ,p_ass_attribute24 in varchar2 default null
562 ,p_ass_attribute25 in varchar2 default null
563 ,p_ass_attribute26 in varchar2 default null
564 ,p_ass_attribute27 in varchar2 default null
565 ,p_ass_attribute28 in varchar2 default null
566 ,p_ass_attribute29 in varchar2 default null
567 ,p_ass_attribute30 in varchar2 default null
568 ,p_soft_coding_keyflex_id in out nocopy number
569 ,p_people_group_id in number default null
570 ,p_contract_id in number default null
571 ,p_establishment_id in number default null
572 ,p_cagr_grade_def_id in number default null
573 ,p_collective_agreement_id in number default null
574 ,p_cagr_id_flex_num in number default null
575 ,p_payroll_id in number default null
576 ,p_pay_basis_id in number default null
577 ,p_sal_review_period in number default null
578 ,p_sal_review_period_frequency in varchar2 default null
579 ,p_date_probation_end in date default null
580 ,p_probation_period in number default null
581 ,p_probation_unit in varchar2 default null
582 ,p_notice_period in number default null
583 ,p_notice_period_uom in varchar2 default null
584 ,p_employee_category in varchar2 default null
585 ,p_work_at_home in varchar2 default null
586 ,p_job_post_source_name in varchar2 default null
587 ,p_perf_review_period in number default null
588 ,p_perf_review_period_frequency in varchar2 default null
589 ,p_internal_address_line in varchar2 default null
590 ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
591 --GSP change
592 ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
593 -- End of GSP change
594 ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
595 ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
596 ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
597 ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
598 ,p_person_id in per_all_assignments_f.person_id%TYPE
599 ,p_effective_start_date out nocopy date
600 ,p_effective_end_date out nocopy date
601 ,p_element_warning in boolean
602 ,p_element_changed in out nocopy varchar2
603 ,p_email_id in varchar2 default null
604 ,p_page_error in out nocopy varchar2
605 ,p_page_error_msg in out nocopy varchar2
606 ,p_page_warning in out nocopy varchar2
607 ,p_page_warning_msg in out nocopy varchar2
608 ,p_organization_error in out nocopy varchar2
609 ,p_organization_error_msg in out nocopy varchar2
610 ,p_job_error in out nocopy varchar2
611 ,p_job_error_msg in out nocopy varchar2
612 ,p_position_error in out nocopy varchar2
613 ,p_position_error_msg in out nocopy varchar2
614 ,p_grade_error in out nocopy varchar2
615 ,p_grade_error_msg in out nocopy varchar2
616 ,p_supervisor_error in out nocopy varchar2
617 ,p_supervisor_error_msg in out nocopy varchar2
618 ,p_location_error in out nocopy varchar2
619 ,p_location_error_msg in out nocopy varchar2
620 ,p_title in varchar2 default null
621 ,p_default_code_comb_id in number default null
622 ,p_set_of_books_id in number default null
623 ,p_source_type in varchar2 default null
624 ,p_project_title in varchar2 default null
625 ,p_vendor_assignment_number in varchar2 default null
626 ,p_vendor_employee_number in varchar2 default null
627 ,p_vendor_id in number default null
628 --GSP populates salary information GL assignment
629 ,p_ltt_salary_data IN OUT NOCOPY sshr_sal_prop_tab_typ
630 ,p_gsp_post_process_warning out nocopy varchar2
631 -- End of GSP
632 ,p_po_header_id in number default null
633 ,p_po_line_id in number default null
634 ,p_vendor_site_id in number default null
635 ,p_projected_asgn_end in date default null
636 ,p_j_changed in varchar2 default 'Y'
637 );
638
639 procedure update_apl_assignment
640 (p_validate in boolean default false,
641 p_assignment_rec in out nocopy per_all_assignments_f%rowtype,
642 p_effective_date in date,
643 p_person_id in number,
644 p_appl_assignment_id in number,
645 p_person_type_id in number,
646 p_overwrite_primary in varchar2,
647 p_ovn in number
648 );
649 --
650 -- NTF changes
651 function get_assignment
652 (p_transaction_step_id in number) return ref_cursor;
653
654 function get_rec_cnt return NUMBER;
655
656 --End of NTF changes
657 --
658
659 FUNCTION get_po_number(p_po_header_id in number)
660 RETURN VARCHAR2;
661
662 FUNCTION get_po_line_nuber(p_po_line_id in number)
663 RETURN number;
664
665 FUNCTION get_vend_site_name(p_vendor_site_id in number)
666 RETURN VARCHAR2;
667
668 FUNCTION get_probation_end_date(p_probation_end_date in varchar2)
669 RETURN varchar2;
670
671 end hr_process_assignment_ss;