[Home] [Help]
PACKAGE: APPS.PER_ASSIGNMENTS_F_PKG
Source
1 PACKAGE PER_ASSIGNMENTS_F_PKG AUTHID CURRENT_USER AS
2 /* $Header: peasg01t.pkh 120.3.12020000.3 2012/07/05 01:02:38 amnaraya ship $ */
3 -----------------------------------------------------------------------------
4 -----------------------------------------------------------------------------
5 --
6 -- **** Standard ON-* procedures of base view. *****
7 --
8 -----------------------------------------------------------------------------
9 --
10 -- Standard Insert procedure
11 --
12 procedure insert_row(
13 p_row_id in out nocopy varchar2,
14 p_assignment_id in out nocopy number,
15 p_effective_start_date date,
16 p_effective_end_date date,
17 p_business_group_id number,
18 p_recruiter_id number,
19 p_grade_id number,
20 p_position_id number,
21 p_job_id number,
22 p_assignment_status_type_id number,
23 p_payroll_id number,
24 p_location_id number,
25 p_person_referred_by_id number,
26 p_supervisor_id number,
27 p_special_ceiling_step_id number,
28 p_person_id number,
29 p_recruitment_activity_id number,
30 p_source_organization_id number,
31 p_organization_id number,
32 p_people_group_id number,
33 p_soft_coding_keyflex_id number,
34 p_vacancy_id number,
35 p_assignment_sequence number,
36 p_assignment_type varchar2,
37 p_primary_flag varchar2,
38 p_application_id number,
39 p_assignment_number varchar2,
40 p_change_reason varchar2,
41 p_comment_id number,
42 p_date_probation_end date,
43 p_default_code_comb_id number,
44 p_frequency varchar2,
45 p_internal_address_line varchar2,
46 p_manager_flag varchar2,
47 p_normal_hours number,
48 p_period_of_service_id number,
49 p_probation_period number,
50 p_probation_unit varchar2,
51 p_set_of_books_id number,
52 p_source_type varchar2,
53 p_time_normal_finish varchar2,
54 p_time_normal_start varchar2,
55 p_request_id number,
56 p_program_application_id number,
57 p_program_id number,
58 p_program_update_date date,
59 p_ass_attribute_category varchar2,
60 p_ass_attribute1 varchar2,
61 p_ass_attribute2 varchar2,
62 p_ass_attribute3 varchar2,
63 p_ass_attribute4 varchar2,
64 p_ass_attribute5 varchar2,
65 p_ass_attribute6 varchar2,
66 p_ass_attribute7 varchar2,
67 p_ass_attribute8 varchar2,
68 p_ass_attribute9 varchar2,
69 p_ass_attribute10 varchar2,
70 p_ass_attribute11 varchar2,
71 p_ass_attribute12 varchar2,
72 p_ass_attribute13 varchar2,
73 p_ass_attribute14 varchar2,
74 p_ass_attribute15 varchar2,
75 p_ass_attribute16 varchar2,
76 p_ass_attribute17 varchar2,
77 p_ass_attribute18 varchar2,
78 p_ass_attribute19 varchar2,
79 p_ass_attribute20 varchar2,
80 p_ass_attribute21 varchar2,
81 p_ass_attribute22 varchar2,
82 p_ass_attribute23 varchar2,
83 p_ass_attribute24 varchar2,
84 p_ass_attribute25 varchar2,
85 p_ass_attribute26 varchar2,
86 p_ass_attribute27 varchar2,
87 p_ass_attribute28 varchar2,
88 p_ass_attribute29 varchar2,
89 p_ass_attribute30 varchar2,
90 p_sal_review_period number,
91 p_sal_review_period_frequency varchar2,
92 p_perf_review_period number,
93 p_perf_review_period_frequency varchar2,
94 p_pay_basis_id number,
95 p_employment_category varchar2,
96 p_bargaining_unit_code varchar2,
97 p_labour_union_member_flag varchar2,
98 p_hourly_salaried_code varchar2,
99 p_contract_id number default null,
100 p_cagr_id_flex_num number default null,
101 p_cagr_grade_def_id number default null,
102 p_establishment_id number default null,
103 p_collective_agreement_id number default null,
104 p_notice_period number default null,
105 p_notice_period_uom varchar2 default null,
106 p_employee_category varchar2 default null,
107 p_work_at_home varchar2 default null,
108 p_job_post_source_name varchar2 default null,
109 p_placement_date_start date default null,
110 p_vendor_id number default null,
111 p_vendor_employee_number varchar2 default null,
112 p_vendor_assignment_number varchar2 default null,
113 p_assignment_category varchar2 default null,
114 p_title varchar2 default null,
115 p_project_title varchar2 default null,
116 p_grade_ladder_pgm_id number default null,
117 p_supervisor_assignment_id number default null,
118 p_vendor_site_id number default null,
119 p_po_header_id number default null,
120 p_po_line_id number default null,
121 p_projected_assignment_end date default null
122 );
123 -----------------------------------------------------------------------------
124 --
125 -- Standard delete procedure
126 --
127 procedure delete_row(p_row_id varchar2);
128 -----------------------------------------------------------------------------
129 --
130 -- Standard lock procedure
131 --
132 procedure lock_row(
133 p_row_id varchar2,
134 p_assignment_id number,
135 p_effective_start_date date,
136 p_effective_end_date date,
137 p_business_group_id number,
138 p_recruiter_id number,
139 p_grade_id number,
140 p_position_id number,
141 p_job_id number,
142 p_assignment_status_type_id number,
143 p_payroll_id number,
144 p_location_id number,
145 p_person_referred_by_id number,
146 p_supervisor_id number,
147 p_special_ceiling_step_id number,
148 p_person_id number,
149 p_recruitment_activity_id number,
150 p_source_organization_id number,
151 p_organization_id number,
152 p_people_group_id number,
153 p_soft_coding_keyflex_id number,
154 p_vacancy_id number,
155 p_assignment_sequence number,
156 p_assignment_type varchar2,
157 p_primary_flag varchar2,
158 p_application_id number,
159 p_assignment_number varchar2,
160 p_change_reason varchar2,
161 p_comment_id number,
162 p_date_probation_end date,
163 p_default_code_comb_id number,
164 p_frequency varchar2,
165 p_internal_address_line varchar2,
166 p_manager_flag varchar2,
167 p_normal_hours number,
168 p_period_of_service_id number,
169 p_probation_period number,
170 p_probation_unit varchar2,
171 p_set_of_books_id number,
172 p_source_type varchar2,
173 p_time_normal_finish varchar2,
174 p_time_normal_start varchar2,
175 p_request_id number,
176 p_program_application_id number,
177 p_program_id number,
178 p_program_update_date date,
179 p_ass_attribute_category varchar2,
180 p_ass_attribute1 varchar2,
181 p_ass_attribute2 varchar2,
182 p_ass_attribute3 varchar2,
183 p_ass_attribute4 varchar2,
184 p_ass_attribute5 varchar2,
185 p_ass_attribute6 varchar2,
186 p_ass_attribute7 varchar2,
187 p_ass_attribute8 varchar2,
188 p_ass_attribute9 varchar2,
189 p_ass_attribute10 varchar2,
190 p_ass_attribute11 varchar2,
191 p_ass_attribute12 varchar2,
192 p_ass_attribute13 varchar2,
193 p_ass_attribute14 varchar2,
194 p_ass_attribute15 varchar2,
195 p_ass_attribute16 varchar2,
196 p_ass_attribute17 varchar2,
197 p_ass_attribute18 varchar2,
198 p_ass_attribute19 varchar2,
199 p_ass_attribute20 varchar2,
200 p_ass_attribute21 varchar2,
201 p_ass_attribute22 varchar2,
202 p_ass_attribute23 varchar2,
203 p_ass_attribute24 varchar2,
204 p_ass_attribute25 varchar2,
205 p_ass_attribute26 varchar2,
206 p_ass_attribute27 varchar2,
207 p_ass_attribute28 varchar2,
208 p_ass_attribute29 varchar2,
209 p_ass_attribute30 varchar2,
210 p_sal_review_period number,
211 p_sal_review_period_frequency varchar2,
212 p_perf_review_period number,
213 p_perf_review_period_frequency varchar2,
214 p_pay_basis_id number,
215 p_employment_category varchar2,
216 p_bargaining_unit_code varchar2,
217 p_labour_union_member_flag varchar2,
218 p_hourly_salaried_code varchar2,
219 p_contract_id number,
220 p_cagr_id_flex_num number,
221 p_cagr_grade_def_id number,
222 p_establishment_id number,
223 p_collective_agreement_id number,
224 p_notice_period number,
225 p_notice_period_uom varchar2,
226 p_employee_category varchar2,
227 p_work_at_home varchar2,
228 p_job_post_source_name varchar2,
229 p_placement_date_start date,
230 p_vendor_id number,
231 p_vendor_employee_number varchar2,
232 p_vendor_assignment_number varchar2,
233 p_assignment_category varchar2,
234 p_title varchar2,
235 p_project_title varchar2,
236 p_grade_ladder_pgm_id number,
237 p_supervisor_assignment_id number,
238 p_vendor_site_id number,
239 p_po_header_id number,
240 p_po_line_id number,
241 p_projected_assignment_end date
242 );
243 -----------------------------------------------------------------------------
244 --
245 -- Standard update procedure
246 --
247 procedure update_row(
248 p_row_id varchar2,
249 p_assignment_id number,
250 p_effective_start_date date,
251 p_effective_end_date date,
252 p_business_group_id number,
253 p_recruiter_id number,
254 p_grade_id number,
255 p_position_id number,
256 p_job_id number,
257 p_assignment_status_type_id number,
258 p_payroll_id number,
259 p_location_id number,
260 p_person_referred_by_id number,
261 p_supervisor_id number,
262 p_special_ceiling_step_id number,
263 p_person_id number,
264 p_recruitment_activity_id number,
265 p_source_organization_id number,
266 p_organization_id number,
267 p_people_group_id number,
268 p_soft_coding_keyflex_id number,
272 p_primary_flag varchar2,
269 p_vacancy_id number,
270 p_assignment_sequence number,
271 p_assignment_type varchar2,
273 p_application_id number,
274 p_assignment_number varchar2,
275 p_change_reason varchar2,
276 p_comment_id number,
277 p_date_probation_end date,
278 p_default_code_comb_id number,
279 p_frequency varchar2,
280 p_internal_address_line varchar2,
281 p_manager_flag varchar2,
282 p_normal_hours number,
283 p_period_of_service_id number,
284 p_probation_period number,
285 p_probation_unit varchar2,
286 p_set_of_books_id number,
287 p_source_type varchar2,
288 p_time_normal_finish varchar2,
289 p_time_normal_start varchar2,
290 p_request_id number,
291 p_program_application_id number,
292 p_program_id number,
293 p_program_update_date date,
294 p_ass_attribute_category varchar2,
295 p_ass_attribute1 varchar2,
296 p_ass_attribute2 varchar2,
297 p_ass_attribute3 varchar2,
298 p_ass_attribute4 varchar2,
299 p_ass_attribute5 varchar2,
300 p_ass_attribute6 varchar2,
301 p_ass_attribute7 varchar2,
302 p_ass_attribute8 varchar2,
303 p_ass_attribute9 varchar2,
304 p_ass_attribute10 varchar2,
305 p_ass_attribute11 varchar2,
306 p_ass_attribute12 varchar2,
307 p_ass_attribute13 varchar2,
308 p_ass_attribute14 varchar2,
309 p_ass_attribute15 varchar2,
310 p_ass_attribute16 varchar2,
311 p_ass_attribute17 varchar2,
312 p_ass_attribute18 varchar2,
313 p_ass_attribute19 varchar2,
314 p_ass_attribute20 varchar2,
315 p_ass_attribute21 varchar2,
316 p_ass_attribute22 varchar2,
317 p_ass_attribute23 varchar2,
318 p_ass_attribute24 varchar2,
319 p_ass_attribute25 varchar2,
320 p_ass_attribute26 varchar2,
321 p_ass_attribute27 varchar2,
322 p_ass_attribute28 varchar2,
323 p_ass_attribute29 varchar2,
324 p_ass_attribute30 varchar2,
325 p_sal_review_period number,
326 p_sal_review_period_frequency varchar2,
327 p_perf_review_period number,
328 p_perf_review_period_frequency varchar2,
329 p_pay_basis_id number,
330 p_employment_category varchar2,
331 p_dt_update_mode varchar2,
332 p_session_date date,
333 p_bargaining_unit_code varchar2,
334 p_labour_union_member_flag varchar2,
335 p_hourly_salaried_code varchar2,
336 p_contract_id number default null,
337 p_cagr_id_flex_num number default null,
338 p_cagr_grade_def_id number default null,
339 p_establishment_id number default null,
340 p_collective_agreement_id number default null,
341 p_notice_period number default null,
342 p_notice_period_uom varchar2 default null,
343 p_employee_category varchar2 default null,
344 p_work_at_home varchar2 default null,
345 p_job_post_source_name varchar2 default null,
346 p_placement_date_start date default null,
347 p_vendor_id number default null,
348 p_vendor_employee_number varchar2 default null,
349 p_vendor_assignment_number varchar2 default null,
350 p_assignment_category varchar2 default null,
351 p_title varchar2 default null,
352 p_project_title varchar2 default null,
353 p_grade_ladder_pgm_id number default null,
354 p_supervisor_assignment_id number default null,
355 p_vendor_site_id number default null,
356 p_po_header_id number default null,
357 p_po_line_id number default null,
358 p_projected_assignment_end date default null
359 ) ;
360 --
361 procedure dml_promotion(
362 p_assignment_id number,
363 p_promotion_date date,
364 p_prom_flag char);
365 --
366 -----------------------------------------------------------------------------
367 --
368 -- **** End of standard ON-* checks. ****
369 --
370 -----------------------------------------------------------------------------
371 END PER_ASSIGNMENTS_F_PKG;