[Home] [Help]
PACKAGE BODY: APPS.HR_ASSIGNMENT_BE2
Source
1 package body hr_assignment_be2 as
2 --Code generated on 30/03/2009 04:46:46
3 /* $Header: hrapiwfe.pkb 120.4.12010000.2 2008/09/29 12:54:07 srgnanas ship $*/
4 procedure update_emp_asg_a (
5 p_effective_date date,
6 p_datetrack_update_mode varchar2,
7 p_assignment_id number,
8 p_object_version_number number,
9 p_supervisor_id number,
10 p_assignment_number varchar2,
11 p_change_reason varchar2,
12 p_assignment_status_type_id number,
13 p_comments varchar2,
14 p_date_probation_end date,
15 p_default_code_comb_id number,
16 p_frequency varchar2,
17 p_internal_address_line varchar2,
18 p_manager_flag varchar2,
19 p_normal_hours number,
20 p_perf_review_period number,
21 p_perf_review_period_frequency varchar2,
22 p_probation_period number,
23 p_probation_unit varchar2,
24 p_projected_assignment_end varchar2,
25 p_sal_review_period number,
26 p_sal_review_period_frequency varchar2,
27 p_set_of_books_id number,
28 p_source_type varchar2,
29 p_time_normal_finish varchar2,
30 p_time_normal_start varchar2,
31 p_bargaining_unit_code varchar2,
32 p_labour_union_member_flag varchar2,
33 p_hourly_salaried_code varchar2,
34 p_ass_attribute_category varchar2,
35 p_ass_attribute1 varchar2,
36 p_ass_attribute2 varchar2,
37 p_ass_attribute3 varchar2,
38 p_ass_attribute4 varchar2,
39 p_ass_attribute5 varchar2,
40 p_ass_attribute6 varchar2,
41 p_ass_attribute7 varchar2,
42 p_ass_attribute8 varchar2,
43 p_ass_attribute9 varchar2,
44 p_ass_attribute10 varchar2,
45 p_ass_attribute11 varchar2,
46 p_ass_attribute12 varchar2,
47 p_ass_attribute13 varchar2,
48 p_ass_attribute14 varchar2,
49 p_ass_attribute15 varchar2,
50 p_ass_attribute16 varchar2,
51 p_ass_attribute17 varchar2,
52 p_ass_attribute18 varchar2,
53 p_ass_attribute19 varchar2,
54 p_ass_attribute20 varchar2,
55 p_ass_attribute21 varchar2,
56 p_ass_attribute22 varchar2,
57 p_ass_attribute23 varchar2,
58 p_ass_attribute24 varchar2,
59 p_ass_attribute25 varchar2,
60 p_ass_attribute26 varchar2,
61 p_ass_attribute27 varchar2,
62 p_ass_attribute28 varchar2,
63 p_ass_attribute29 varchar2,
64 p_ass_attribute30 varchar2,
65 p_title varchar2,
66 p_segment1 varchar2,
67 p_segment2 varchar2,
68 p_segment3 varchar2,
69 p_segment4 varchar2,
70 p_segment5 varchar2,
71 p_segment6 varchar2,
72 p_segment7 varchar2,
73 p_segment8 varchar2,
74 p_segment9 varchar2,
75 p_segment10 varchar2,
76 p_segment11 varchar2,
77 p_segment12 varchar2,
78 p_segment13 varchar2,
79 p_segment14 varchar2,
80 p_segment15 varchar2,
81 p_segment16 varchar2,
82 p_segment17 varchar2,
83 p_segment18 varchar2,
84 p_segment19 varchar2,
85 p_segment20 varchar2,
86 p_segment21 varchar2,
87 p_segment22 varchar2,
88 p_segment23 varchar2,
89 p_segment24 varchar2,
90 p_segment25 varchar2,
91 p_segment26 varchar2,
92 p_segment27 varchar2,
93 p_segment28 varchar2,
94 p_segment29 varchar2,
95 p_segment30 varchar2,
96 p_concatenated_segments varchar2,
97 p_soft_coding_keyflex_id number,
98 p_comment_id number,
99 p_effective_start_date date,
100 p_effective_end_date date,
101 p_no_managers_warning boolean,
102 p_other_manager_warning boolean,
103 p_hourly_salaried_warning boolean,
104 p_concat_segments varchar2,
105 p_contract_id number,
106 p_establishment_id number,
107 p_collective_agreement_id number,
108 p_cagr_id_flex_num number,
109 p_cag_segment1 varchar2,
110 p_cag_segment2 varchar2,
111 p_cag_segment3 varchar2,
112 p_cag_segment4 varchar2,
113 p_cag_segment5 varchar2,
114 p_cag_segment6 varchar2,
115 p_cag_segment7 varchar2,
116 p_cag_segment8 varchar2,
117 p_cag_segment9 varchar2,
118 p_cag_segment10 varchar2,
119 p_cag_segment11 varchar2,
120 p_cag_segment12 varchar2,
121 p_cag_segment13 varchar2,
122 p_cag_segment14 varchar2,
123 p_cag_segment15 varchar2,
124 p_cag_segment16 varchar2,
125 p_cag_segment17 varchar2,
126 p_cag_segment18 varchar2,
127 p_cag_segment19 varchar2,
128 p_cag_segment20 varchar2,
129 p_notice_period number,
130 p_notice_period_uom varchar2,
131 p_employee_category varchar2,
132 p_work_at_home varchar2,
133 p_job_post_source_name varchar2,
134 p_cagr_grade_def_id number,
135 p_cagr_concatenated_segments varchar2,
136 p_supervisor_assignment_id number) is
137 l_event_key number;
138 l_event_data clob;
139 l_event_name varchar2(250);
140 l_text varchar2(2000);
141 l_message varchar2(10);
142 --
143 cursor get_seq is
144 select per_wf_events_s.nextval from dual;
145 --
146 l_proc varchar2(72):=' hr_assignment_be2.update_emp_asg_a';
147 begin
148 hr_utility.set_location('Entering: '||l_proc,10);
149 -- check the status of the business event
150 l_event_name:='oracle.apps.per.api.assignment.update_emp_asg';
151 l_message:=wf_event.test(l_event_name);
152 --
153 if (l_message='MESSAGE') then
154 hr_utility.set_location(l_proc,20);
155 --
156 -- get a key for the event
157 --
158 open get_seq;
159 fetch get_seq into l_event_key;
160 close get_seq;
161 --
162 -- build the xml data for the event
163 --
164 dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
165 l_text:='<?xml version =''1.0'' encoding =''ASCII''?>';
166 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
167 l_text:='<assignment>';
168 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
169 --
170 l_text:='<effective_date>';
171 l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
172 l_text:=l_text||'</effective_date>';
173 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
174 l_text:='<datetrack_update_mode>';
175 l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
176 l_text:=l_text||'</datetrack_update_mode>';
177 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
178 l_text:='<assignment_id>';
179 l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
180 l_text:=l_text||'</assignment_id>';
181 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
182 l_text:='<object_version_number>';
183 l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
184 l_text:=l_text||'</object_version_number>';
185 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
186 l_text:='<supervisor_id>';
187 l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
188 l_text:=l_text||'</supervisor_id>';
189 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
190 l_text:='<assignment_number>';
191 l_text:=l_text||irc_utilities_pkg.removeTags(p_assignment_number);
192 l_text:=l_text||'</assignment_number>';
193 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
194 l_text:='<change_reason>';
195 l_text:=l_text||irc_utilities_pkg.removeTags(p_change_reason);
196 l_text:=l_text||'</change_reason>';
197 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
198 l_text:='<assignment_status_type_id>';
199 l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
200 l_text:=l_text||'</assignment_status_type_id>';
201 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
202 l_text:='<comments>';
203 l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
204 l_text:=l_text||'</comments>';
205 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
206 l_text:='<date_probation_end>';
207 l_text:=l_text||fnd_date.date_to_canonical(p_date_probation_end);
208 l_text:=l_text||'</date_probation_end>';
209 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
210 l_text:='<default_code_comb_id>';
211 l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
212 l_text:=l_text||'</default_code_comb_id>';
213 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
214 l_text:='<frequency>';
215 l_text:=l_text||irc_utilities_pkg.removeTags(p_frequency);
216 l_text:=l_text||'</frequency>';
217 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
218 l_text:='<internal_address_line>';
219 l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_address_line);
220 l_text:=l_text||'</internal_address_line>';
221 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
222 l_text:='<manager_flag>';
223 l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);
224 l_text:=l_text||'</manager_flag>';
225 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
226 l_text:='<normal_hours>';
227 l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
228 l_text:=l_text||'</normal_hours>';
229 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
230 l_text:='<perf_review_period>';
231 l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);
232 l_text:=l_text||'</perf_review_period>';
233 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
234 l_text:='<perf_review_period_frequency>';
235 l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);
236 l_text:=l_text||'</perf_review_period_frequency>';
237 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
238 l_text:='<probation_period>';
239 l_text:=l_text||fnd_number.number_to_canonical(p_probation_period);
240 l_text:=l_text||'</probation_period>';
241 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
242 l_text:='<probation_unit>';
243 l_text:=l_text||irc_utilities_pkg.removeTags(p_probation_unit);
244 l_text:=l_text||'</probation_unit>';
245 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
246 l_text:='<projected_assignment_end>';
247 l_text:=l_text||irc_utilities_pkg.removeTags(p_projected_assignment_end);
248 l_text:=l_text||'</projected_assignment_end>';
249 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
250 l_text:='<sal_review_period>';
251 l_text:=l_text||fnd_number.number_to_canonical(p_sal_review_period);
252 l_text:=l_text||'</sal_review_period>';
253 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
254 l_text:='<sal_review_period_frequency>';
255 l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);
256 l_text:=l_text||'</sal_review_period_frequency>';
257 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
258 l_text:='<set_of_books_id>';
259 l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);
260 l_text:=l_text||'</set_of_books_id>';
261 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
262 l_text:='<source_type>';
263 l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);
264 l_text:=l_text||'</source_type>';
265 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
266 l_text:='<time_normal_finish>';
267 l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_finish);
268 l_text:=l_text||'</time_normal_finish>';
269 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
270 l_text:='<time_normal_start>';
271 l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_start);
272 l_text:=l_text||'</time_normal_start>';
273 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
274 l_text:='<bargaining_unit_code>';
275 l_text:=l_text||irc_utilities_pkg.removeTags(p_bargaining_unit_code);
276 l_text:=l_text||'</bargaining_unit_code>';
277 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
278 l_text:='<labour_union_member_flag>';
279 l_text:=l_text||irc_utilities_pkg.removeTags(p_labour_union_member_flag);
280 l_text:=l_text||'</labour_union_member_flag>';
281 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
282 l_text:='<hourly_salaried_code>';
283 l_text:=l_text||irc_utilities_pkg.removeTags(p_hourly_salaried_code);
284 l_text:=l_text||'</hourly_salaried_code>';
285 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
286 l_text:='<ass_attribute_category>';
290 l_text:='<ass_attribute1>';
287 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute_category);
288 l_text:=l_text||'</ass_attribute_category>';
289 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
291 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute1);
292 l_text:=l_text||'</ass_attribute1>';
293 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
294 l_text:='<ass_attribute2>';
295 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute2);
296 l_text:=l_text||'</ass_attribute2>';
297 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
298 l_text:='<ass_attribute3>';
299 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute3);
300 l_text:=l_text||'</ass_attribute3>';
301 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
302 l_text:='<ass_attribute4>';
303 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute4);
304 l_text:=l_text||'</ass_attribute4>';
305 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
306 l_text:='<ass_attribute5>';
307 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute5);
308 l_text:=l_text||'</ass_attribute5>';
309 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
310 l_text:='<ass_attribute6>';
311 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute6);
312 l_text:=l_text||'</ass_attribute6>';
313 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
314 l_text:='<ass_attribute7>';
315 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute7);
316 l_text:=l_text||'</ass_attribute7>';
317 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
318 l_text:='<ass_attribute8>';
319 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute8);
320 l_text:=l_text||'</ass_attribute8>';
321 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
322 l_text:='<ass_attribute9>';
323 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute9);
324 l_text:=l_text||'</ass_attribute9>';
325 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
326 l_text:='<ass_attribute10>';
327 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute10);
328 l_text:=l_text||'</ass_attribute10>';
329 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
330 l_text:='<ass_attribute11>';
331 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute11);
332 l_text:=l_text||'</ass_attribute11>';
333 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
334 l_text:='<ass_attribute12>';
335 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute12);
336 l_text:=l_text||'</ass_attribute12>';
337 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
338 l_text:='<ass_attribute13>';
339 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute13);
340 l_text:=l_text||'</ass_attribute13>';
341 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
342 l_text:='<ass_attribute14>';
343 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute14);
344 l_text:=l_text||'</ass_attribute14>';
345 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
346 l_text:='<ass_attribute15>';
347 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute15);
348 l_text:=l_text||'</ass_attribute15>';
349 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
350 l_text:='<ass_attribute16>';
351 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute16);
352 l_text:=l_text||'</ass_attribute16>';
353 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
354 l_text:='<ass_attribute17>';
355 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute17);
356 l_text:=l_text||'</ass_attribute17>';
357 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
358 l_text:='<ass_attribute18>';
359 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute18);
360 l_text:=l_text||'</ass_attribute18>';
361 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
362 l_text:='<ass_attribute19>';
363 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute19);
364 l_text:=l_text||'</ass_attribute19>';
365 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
366 l_text:='<ass_attribute20>';
367 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute20);
368 l_text:=l_text||'</ass_attribute20>';
369 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
370 l_text:='<ass_attribute21>';
371 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute21);
372 l_text:=l_text||'</ass_attribute21>';
373 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
374 l_text:='<ass_attribute22>';
375 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute22);
376 l_text:=l_text||'</ass_attribute22>';
377 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
378 l_text:='<ass_attribute23>';
379 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute23);
380 l_text:=l_text||'</ass_attribute23>';
381 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
382 l_text:='<ass_attribute24>';
383 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute24);
384 l_text:=l_text||'</ass_attribute24>';
385 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
386 l_text:='<ass_attribute25>';
387 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute25);
388 l_text:=l_text||'</ass_attribute25>';
392 l_text:=l_text||'</ass_attribute26>';
389 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
390 l_text:='<ass_attribute26>';
391 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute26);
393 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
394 l_text:='<ass_attribute27>';
395 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute27);
396 l_text:=l_text||'</ass_attribute27>';
397 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
398 l_text:='<ass_attribute28>';
399 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute28);
400 l_text:=l_text||'</ass_attribute28>';
401 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
402 l_text:='<ass_attribute29>';
403 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute29);
404 l_text:=l_text||'</ass_attribute29>';
405 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
406 l_text:='<ass_attribute30>';
407 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute30);
408 l_text:=l_text||'</ass_attribute30>';
409 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
410 l_text:='<title>';
411 l_text:=l_text||irc_utilities_pkg.removeTags(p_title);
412 l_text:=l_text||'</title>';
413 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
414 l_text:='<segment1>';
415 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment1);
416 l_text:=l_text||'</segment1>';
417 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
418 l_text:='<segment2>';
419 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment2);
420 l_text:=l_text||'</segment2>';
421 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
422 l_text:='<segment3>';
423 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment3);
424 l_text:=l_text||'</segment3>';
425 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
426 l_text:='<segment4>';
427 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment4);
428 l_text:=l_text||'</segment4>';
429 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
430 l_text:='<segment5>';
431 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment5);
432 l_text:=l_text||'</segment5>';
433 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
434 l_text:='<segment6>';
435 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment6);
436 l_text:=l_text||'</segment6>';
437 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
438 l_text:='<segment7>';
439 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment7);
440 l_text:=l_text||'</segment7>';
441 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
442 l_text:='<segment8>';
443 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment8);
444 l_text:=l_text||'</segment8>';
445 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
446 l_text:='<segment9>';
447 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment9);
448 l_text:=l_text||'</segment9>';
449 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
450 l_text:='<segment10>';
451 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment10);
452 l_text:=l_text||'</segment10>';
453 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
454 l_text:='<segment11>';
455 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment11);
456 l_text:=l_text||'</segment11>';
457 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
458 l_text:='<segment12>';
459 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment12);
460 l_text:=l_text||'</segment12>';
461 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
462 l_text:='<segment13>';
463 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment13);
464 l_text:=l_text||'</segment13>';
465 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
466 l_text:='<segment14>';
467 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment14);
468 l_text:=l_text||'</segment14>';
469 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
470 l_text:='<segment15>';
471 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment15);
472 l_text:=l_text||'</segment15>';
473 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
474 l_text:='<segment16>';
475 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment16);
476 l_text:=l_text||'</segment16>';
477 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
478 l_text:='<segment17>';
479 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment17);
480 l_text:=l_text||'</segment17>';
481 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
482 l_text:='<segment18>';
483 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment18);
484 l_text:=l_text||'</segment18>';
485 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
486 l_text:='<segment19>';
487 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment19);
488 l_text:=l_text||'</segment19>';
489 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
490 l_text:='<segment20>';
491 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment20);
492 l_text:=l_text||'</segment20>';
493 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
494 l_text:='<segment21>';
495 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment21);
496 l_text:=l_text||'</segment21>';
497 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
501 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
498 l_text:='<segment22>';
499 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment22);
500 l_text:=l_text||'</segment22>';
502 l_text:='<segment23>';
503 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment23);
504 l_text:=l_text||'</segment23>';
505 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
506 l_text:='<segment24>';
507 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment24);
508 l_text:=l_text||'</segment24>';
509 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
510 l_text:='<segment25>';
511 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment25);
512 l_text:=l_text||'</segment25>';
513 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
514 l_text:='<segment26>';
515 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment26);
516 l_text:=l_text||'</segment26>';
517 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
518 l_text:='<segment27>';
519 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment27);
520 l_text:=l_text||'</segment27>';
521 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
522 l_text:='<segment28>';
523 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment28);
524 l_text:=l_text||'</segment28>';
525 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
526 l_text:='<segment29>';
527 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment29);
528 l_text:=l_text||'</segment29>';
529 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
530 l_text:='<segment30>';
531 l_text:=l_text||irc_utilities_pkg.removeTags(p_segment30);
532 l_text:=l_text||'</segment30>';
533 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
534 l_text:='<concatenated_segments>';
535 l_text:=l_text||irc_utilities_pkg.removeTags(p_concatenated_segments);
536 l_text:=l_text||'</concatenated_segments>';
537 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
538 l_text:='<soft_coding_keyflex_id>';
539 l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
540 l_text:=l_text||'</soft_coding_keyflex_id>';
541 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
542 l_text:='<comment_id>';
543 l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
544 l_text:=l_text||'</comment_id>';
545 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
546 l_text:='<effective_start_date>';
547 l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
548 l_text:=l_text||'</effective_start_date>';
549 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
550 l_text:='<effective_end_date>';
551 l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
552 l_text:=l_text||'</effective_end_date>';
553 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
554 l_text:='<no_managers_warning>';
555 if(P_NO_MANAGERS_WARNING) then
556 l_text:=l_text||'TRUE';
557 else
558 l_text:=l_text||'FALSE';
559 end if;
560 l_text:=l_text||'</no_managers_warning>';
561 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
562 l_text:='<other_manager_warning>';
563 if(P_OTHER_MANAGER_WARNING) then
564 l_text:=l_text||'TRUE';
565 else
566 l_text:=l_text||'FALSE';
567 end if;
568 l_text:=l_text||'</other_manager_warning>';
569 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
570 l_text:='<hourly_salaried_warning>';
571 if(P_HOURLY_SALARIED_WARNING) then
572 l_text:=l_text||'TRUE';
573 else
574 l_text:=l_text||'FALSE';
575 end if;
576 l_text:=l_text||'</hourly_salaried_warning>';
577 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
578 l_text:='<concat_segments>';
579 l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);
580 l_text:=l_text||'</concat_segments>';
581 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
582 l_text:='<contract_id>';
583 l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);
584 l_text:=l_text||'</contract_id>';
585 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
586 l_text:='<establishment_id>';
587 l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
588 l_text:=l_text||'</establishment_id>';
589 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
590 l_text:='<collective_agreement_id>';
591 l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
592 l_text:=l_text||'</collective_agreement_id>';
593 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
594 l_text:='<cagr_id_flex_num>';
595 l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);
596 l_text:=l_text||'</cagr_id_flex_num>';
597 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
598 l_text:='<cag_segment1>';
599 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment1);
600 l_text:=l_text||'</cag_segment1>';
601 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
602 l_text:='<cag_segment2>';
603 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment2);
604 l_text:=l_text||'</cag_segment2>';
605 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
606 l_text:='<cag_segment3>';
607 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment3);
608 l_text:=l_text||'</cag_segment3>';
609 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
610 l_text:='<cag_segment4>';
614 l_text:='<cag_segment5>';
611 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment4);
612 l_text:=l_text||'</cag_segment4>';
613 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
615 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment5);
616 l_text:=l_text||'</cag_segment5>';
617 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
618 l_text:='<cag_segment6>';
619 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment6);
620 l_text:=l_text||'</cag_segment6>';
621 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
622 l_text:='<cag_segment7>';
623 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment7);
624 l_text:=l_text||'</cag_segment7>';
625 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
626 l_text:='<cag_segment8>';
627 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment8);
628 l_text:=l_text||'</cag_segment8>';
629 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
630 l_text:='<cag_segment9>';
631 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment9);
632 l_text:=l_text||'</cag_segment9>';
633 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
634 l_text:='<cag_segment10>';
635 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment10);
636 l_text:=l_text||'</cag_segment10>';
637 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
638 l_text:='<cag_segment11>';
639 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment11);
640 l_text:=l_text||'</cag_segment11>';
641 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
642 l_text:='<cag_segment12>';
643 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment12);
644 l_text:=l_text||'</cag_segment12>';
645 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
646 l_text:='<cag_segment13>';
647 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment13);
648 l_text:=l_text||'</cag_segment13>';
649 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
650 l_text:='<cag_segment14>';
651 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment14);
652 l_text:=l_text||'</cag_segment14>';
653 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
654 l_text:='<cag_segment15>';
655 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment15);
656 l_text:=l_text||'</cag_segment15>';
657 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
658 l_text:='<cag_segment16>';
659 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment16);
660 l_text:=l_text||'</cag_segment16>';
661 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
662 l_text:='<cag_segment17>';
663 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment17);
664 l_text:=l_text||'</cag_segment17>';
665 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
666 l_text:='<cag_segment18>';
667 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment18);
668 l_text:=l_text||'</cag_segment18>';
669 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
670 l_text:='<cag_segment19>';
671 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment19);
672 l_text:=l_text||'</cag_segment19>';
673 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
674 l_text:='<cag_segment20>';
675 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment20);
676 l_text:=l_text||'</cag_segment20>';
677 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
678 l_text:='<notice_period>';
679 l_text:=l_text||fnd_number.number_to_canonical(p_notice_period);
680 l_text:=l_text||'</notice_period>';
681 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
682 l_text:='<notice_period_uom>';
683 l_text:=l_text||irc_utilities_pkg.removeTags(p_notice_period_uom);
684 l_text:=l_text||'</notice_period_uom>';
685 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
686 l_text:='<employee_category>';
687 l_text:=l_text||irc_utilities_pkg.removeTags(p_employee_category);
688 l_text:=l_text||'</employee_category>';
689 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
690 l_text:='<work_at_home>';
691 l_text:=l_text||irc_utilities_pkg.removeTags(p_work_at_home);
692 l_text:=l_text||'</work_at_home>';
693 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
694 l_text:='<job_post_source_name>';
695 l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);
696 l_text:=l_text||'</job_post_source_name>';
697 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
698 l_text:='<cagr_grade_def_id>';
699 l_text:=l_text||fnd_number.number_to_canonical(p_cagr_grade_def_id);
700 l_text:=l_text||'</cagr_grade_def_id>';
701 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
702 l_text:='<cagr_concatenated_segments>';
703 l_text:=l_text||irc_utilities_pkg.removeTags(p_cagr_concatenated_segments);
704 l_text:=l_text||'</cagr_concatenated_segments>';
705 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
706 l_text:='<supervisor_assignment_id>';
707 l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);
708 l_text:=l_text||'</supervisor_assignment_id>';
709 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
710 l_text:='</assignment>';
711 --
712 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
713 --
714 if p_effective_start_date is not NULL and
715 p_effective_start_date > trunc(SYSDATE) and
716 fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
717 -- raise the event with the event data, with send date set to effective date
718 wf_event.raise(p_event_name=>l_event_name
719 ,p_event_key=>l_event_key
720 ,p_event_data=>l_event_data
721 ,p_send_date => p_effective_start_date);
722 --
723 else
724 -- raise the event with the event data
725 wf_event.raise(p_event_name=>l_event_name
726 ,p_event_key=>l_event_key
727 ,p_event_data=>l_event_data);
728 end if;
729 elsif (l_message='KEY') then
730 hr_utility.set_location(l_proc,30);
731 -- get a key for the event
732 open get_seq;
733 fetch get_seq into l_event_key;
734 close get_seq;
735 if p_effective_start_date is not NULL and
736 p_effective_start_date > trunc(SYSDATE) and
737 fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
738 -- this is a key event, so just raise the event
739 -- without the event data, with send date set to effective date
740 wf_event.raise(p_event_name=>l_event_name
741 ,p_event_key=>l_event_key
742 ,p_send_date => p_effective_start_date);
743 --
744 else
745 -- this is a key event, so just raise the event
746 -- without the event data
747 wf_event.raise(p_event_name=>l_event_name
748 ,p_event_key=>l_event_key);
749 end if;
750 elsif (l_message='NONE') then
751 hr_utility.set_location(l_proc,40);
752 -- no event is required, so do nothing
753 null;
754 end if;
755 hr_utility.set_location('Leaving: '||l_proc,50);
756 end update_emp_asg_a;
757 end hr_assignment_be2;