[Home] [Help]
PACKAGE BODY: APPS.HR_ASSIGNMENT_BE5
Source
1 package body hr_assignment_be5 as
2 --Code generated on 30/03/2009 04:46:19
3 /* $Header: hrapiwfe.pkb 120.4.12010000.2 2008/09/29 12:54:07 srgnanas ship $*/
4 procedure update_apl_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_grade_id number,
10 p_job_id number,
11 p_payroll_id number,
12 p_location_id number,
13 p_organization_id number,
14 p_position_id number,
15 p_application_id number,
16 p_special_ceiling_step_id number,
17 p_recruiter_id number,
18 p_recruitment_activity_id number,
19 p_soft_coding_keyflex_id number,
20 p_vacancy_id number,
21 p_pay_basis_id number,
22 p_person_referred_by_id number,
23 p_supervisor_id number,
24 p_source_organization_id number,
25 p_change_reason varchar2,
26 p_assignment_status_type_id number,
27 p_internal_address_line varchar2,
28 p_default_code_comb_id number,
29 p_employment_category varchar2,
30 p_frequency varchar2,
31 p_manager_flag varchar2,
32 p_normal_hours number,
33 p_perf_review_period number,
34 p_perf_review_period_frequency varchar2,
35 p_probation_period number,
36 p_probation_unit varchar2,
37 p_sal_review_period number,
38 p_sal_review_period_frequency varchar2,
39 p_set_of_books_id number,
40 p_source_type varchar2,
41 p_time_normal_finish varchar2,
42 p_time_normal_start varchar2,
43 p_bargaining_unit_code varchar2,
44 p_comments varchar2,
45 p_date_probation_end date,
46 p_title varchar2,
47 p_ass_attribute_category varchar2,
48 p_ass_attribute1 varchar2,
49 p_ass_attribute2 varchar2,
50 p_ass_attribute3 varchar2,
51 p_ass_attribute4 varchar2,
52 p_ass_attribute5 varchar2,
53 p_ass_attribute6 varchar2,
54 p_ass_attribute7 varchar2,
55 p_ass_attribute8 varchar2,
56 p_ass_attribute9 varchar2,
57 p_ass_attribute10 varchar2,
58 p_ass_attribute11 varchar2,
59 p_ass_attribute12 varchar2,
60 p_ass_attribute13 varchar2,
61 p_ass_attribute14 varchar2,
62 p_ass_attribute15 varchar2,
63 p_ass_attribute16 varchar2,
64 p_ass_attribute17 varchar2,
65 p_ass_attribute18 varchar2,
66 p_ass_attribute19 varchar2,
67 p_ass_attribute20 varchar2,
68 p_ass_attribute21 varchar2,
69 p_ass_attribute22 varchar2,
70 p_ass_attribute23 varchar2,
71 p_ass_attribute24 varchar2,
72 p_ass_attribute25 varchar2,
73 p_ass_attribute26 varchar2,
74 p_ass_attribute27 varchar2,
75 p_ass_attribute28 varchar2,
76 p_ass_attribute29 varchar2,
77 p_ass_attribute30 varchar2,
78 p_scl_segment1 varchar2,
79 p_scl_segment2 varchar2,
80 p_scl_segment3 varchar2,
81 p_scl_segment4 varchar2,
82 p_scl_segment5 varchar2,
83 p_scl_segment6 varchar2,
84 p_scl_segment7 varchar2,
85 p_scl_segment8 varchar2,
86 p_scl_segment9 varchar2,
87 p_scl_segment10 varchar2,
88 p_scl_segment11 varchar2,
89 p_scl_segment12 varchar2,
90 p_scl_segment13 varchar2,
91 p_scl_segment14 varchar2,
92 p_scl_segment15 varchar2,
93 p_scl_segment16 varchar2,
94 p_scl_segment17 varchar2,
95 p_scl_segment18 varchar2,
96 p_scl_segment19 varchar2,
97 p_scl_segment20 varchar2,
98 p_scl_segment21 varchar2,
99 p_scl_segment22 varchar2,
100 p_scl_segment23 varchar2,
101 p_scl_segment24 varchar2,
102 p_scl_segment25 varchar2,
103 p_scl_segment26 varchar2,
104 p_scl_segment27 varchar2,
105 p_scl_segment28 varchar2,
106 p_scl_segment29 varchar2,
107 p_scl_segment30 varchar2,
108 p_concatenated_segments varchar2,
109 p_pgp_segment1 varchar2,
110 p_pgp_segment2 varchar2,
111 p_pgp_segment3 varchar2,
112 p_pgp_segment4 varchar2,
113 p_pgp_segment5 varchar2,
114 p_pgp_segment6 varchar2,
115 p_pgp_segment7 varchar2,
116 p_pgp_segment8 varchar2,
117 p_pgp_segment9 varchar2,
118 p_pgp_segment10 varchar2,
119 p_pgp_segment11 varchar2,
120 p_pgp_segment12 varchar2,
121 p_pgp_segment13 varchar2,
122 p_pgp_segment14 varchar2,
123 p_pgp_segment15 varchar2,
124 p_pgp_segment16 varchar2,
125 p_pgp_segment17 varchar2,
126 p_pgp_segment18 varchar2,
127 p_pgp_segment19 varchar2,
128 p_pgp_segment20 varchar2,
129 p_pgp_segment21 varchar2,
130 p_pgp_segment22 varchar2,
131 p_pgp_segment23 varchar2,
132 p_pgp_segment24 varchar2,
133 p_pgp_segment25 varchar2,
134 p_pgp_segment26 varchar2,
135 p_pgp_segment27 varchar2,
136 p_pgp_segment28 varchar2,
137 p_pgp_segment29 varchar2,
138 p_pgp_segment30 varchar2,
139 p_group_name varchar2,
140 p_comment_id number,
141 p_people_group_id number,
142 p_effective_start_date date,
143 p_effective_end_date date,
144 p_scl_concat_segments varchar2,
145 p_concat_segments varchar2,
146 p_contract_id number,
147 p_establishment_id number,
148 p_collective_agreement_id number,
149 p_cagr_id_flex_num number,
150 p_cag_segment1 varchar2,
151 p_cag_segment2 varchar2,
152 p_cag_segment3 varchar2,
153 p_cag_segment4 varchar2,
154 p_cag_segment5 varchar2,
155 p_cag_segment6 varchar2,
156 p_cag_segment7 varchar2,
157 p_cag_segment8 varchar2,
158 p_cag_segment9 varchar2,
159 p_cag_segment10 varchar2,
160 p_cag_segment11 varchar2,
161 p_cag_segment12 varchar2,
162 p_cag_segment13 varchar2,
163 p_cag_segment14 varchar2,
164 p_cag_segment15 varchar2,
165 p_cag_segment16 varchar2,
166 p_cag_segment17 varchar2,
167 p_cag_segment18 varchar2,
168 p_cag_segment19 varchar2,
169 p_cag_segment20 varchar2,
170 p_notice_period number,
171 p_notice_period_uom varchar2,
172 p_employee_category varchar2,
173 p_work_at_home varchar2,
174 p_job_post_source_name varchar2,
175 p_cagr_grade_def_id number,
176 p_cagr_concatenated_segments varchar2,
177 p_applicant_rank number,
178 p_posting_content_id number,
179 p_grade_ladder_pgm_id number,
180 p_supervisor_assignment_id number) is
181 l_event_key number;
182 l_event_data clob;
183 l_event_name varchar2(250);
184 l_text varchar2(2000);
185 l_message varchar2(10);
186 --
187 cursor get_seq is
188 select per_wf_events_s.nextval from dual;
189 --
190 l_proc varchar2(72):=' hr_assignment_be5.update_apl_asg_a';
191 begin
192 hr_utility.set_location('Entering: '||l_proc,10);
193 -- check the status of the business event
194 l_event_name:='oracle.apps.per.api.assignment.update_apl_asg';
195 l_message:=wf_event.test(l_event_name);
196 --
197 if (l_message='MESSAGE') then
198 hr_utility.set_location(l_proc,20);
199 --
200 -- get a key for the event
201 --
202 open get_seq;
203 fetch get_seq into l_event_key;
204 close get_seq;
205 --
206 -- build the xml data for the event
207 --
208 dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
209 l_text:='<?xml version =''1.0'' encoding =''ASCII''?>';
210 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
211 l_text:='<assignment>';
212 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
213 --
214 l_text:='<effective_date>';
215 l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
216 l_text:=l_text||'</effective_date>';
217 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
218 l_text:='<datetrack_update_mode>';
219 l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
220 l_text:=l_text||'</datetrack_update_mode>';
221 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
222 l_text:='<assignment_id>';
223 l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
224 l_text:=l_text||'</assignment_id>';
225 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
226 l_text:='<object_version_number>';
227 l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
228 l_text:=l_text||'</object_version_number>';
229 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
230 l_text:='<grade_id>';
231 l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
232 l_text:=l_text||'</grade_id>';
233 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
234 l_text:='<job_id>';
235 l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
236 l_text:=l_text||'</job_id>';
237 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
238 l_text:='<payroll_id>';
239 l_text:=l_text||fnd_number.number_to_canonical(p_payroll_id);
240 l_text:=l_text||'</payroll_id>';
241 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
242 l_text:='<location_id>';
243 l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
244 l_text:=l_text||'</location_id>';
245 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
246 l_text:='<organization_id>';
247 l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
248 l_text:=l_text||'</organization_id>';
249 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
250 l_text:='<position_id>';
251 l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
252 l_text:=l_text||'</position_id>';
253 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
254 l_text:='<application_id>';
255 l_text:=l_text||fnd_number.number_to_canonical(p_application_id);
256 l_text:=l_text||'</application_id>';
257 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
258 l_text:='<special_ceiling_step_id>';
259 l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);
260 l_text:=l_text||'</special_ceiling_step_id>';
261 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
262 l_text:='<recruiter_id>';
263 l_text:=l_text||fnd_number.number_to_canonical(p_recruiter_id);
264 l_text:=l_text||'</recruiter_id>';
265 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
266 l_text:='<recruitment_activity_id>';
267 l_text:=l_text||fnd_number.number_to_canonical(p_recruitment_activity_id);
268 l_text:=l_text||'</recruitment_activity_id>';
269 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
270 l_text:='<soft_coding_keyflex_id>';
271 l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
272 l_text:=l_text||'</soft_coding_keyflex_id>';
273 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
274 l_text:='<vacancy_id>';
275 l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
276 l_text:=l_text||'</vacancy_id>';
277 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
278 l_text:='<pay_basis_id>';
279 l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);
280 l_text:=l_text||'</pay_basis_id>';
281 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
282 l_text:='<person_referred_by_id>';
283 l_text:=l_text||fnd_number.number_to_canonical(p_person_referred_by_id);
284 l_text:=l_text||'</person_referred_by_id>';
285 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
286 l_text:='<supervisor_id>';
287 l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
288 l_text:=l_text||'</supervisor_id>';
289 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
290 l_text:='<source_organization_id>';
291 l_text:=l_text||fnd_number.number_to_canonical(p_source_organization_id);
292 l_text:=l_text||'</source_organization_id>';
293 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
294 l_text:='<change_reason>';
295 l_text:=l_text||irc_utilities_pkg.removeTags(p_change_reason);
296 l_text:=l_text||'</change_reason>';
297 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
298 l_text:='<assignment_status_type_id>';
299 l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
300 l_text:=l_text||'</assignment_status_type_id>';
301 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
302 l_text:='<internal_address_line>';
303 l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_address_line);
304 l_text:=l_text||'</internal_address_line>';
305 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
306 l_text:='<default_code_comb_id>';
307 l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
308 l_text:=l_text||'</default_code_comb_id>';
312 l_text:=l_text||'</employment_category>';
309 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
310 l_text:='<employment_category>';
311 l_text:=l_text||irc_utilities_pkg.removeTags(p_employment_category);
313 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
314 l_text:='<frequency>';
315 l_text:=l_text||irc_utilities_pkg.removeTags(p_frequency);
316 l_text:=l_text||'</frequency>';
317 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
318 l_text:='<manager_flag>';
319 l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);
320 l_text:=l_text||'</manager_flag>';
321 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
322 l_text:='<normal_hours>';
323 l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
324 l_text:=l_text||'</normal_hours>';
325 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
326 l_text:='<perf_review_period>';
327 l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);
328 l_text:=l_text||'</perf_review_period>';
329 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
330 l_text:='<perf_review_period_frequency>';
331 l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);
332 l_text:=l_text||'</perf_review_period_frequency>';
333 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
334 l_text:='<probation_period>';
335 l_text:=l_text||fnd_number.number_to_canonical(p_probation_period);
336 l_text:=l_text||'</probation_period>';
337 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
338 l_text:='<probation_unit>';
339 l_text:=l_text||irc_utilities_pkg.removeTags(p_probation_unit);
340 l_text:=l_text||'</probation_unit>';
341 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
342 l_text:='<sal_review_period>';
343 l_text:=l_text||fnd_number.number_to_canonical(p_sal_review_period);
344 l_text:=l_text||'</sal_review_period>';
345 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
346 l_text:='<sal_review_period_frequency>';
347 l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);
348 l_text:=l_text||'</sal_review_period_frequency>';
349 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
350 l_text:='<set_of_books_id>';
351 l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);
352 l_text:=l_text||'</set_of_books_id>';
353 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
354 l_text:='<source_type>';
355 l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);
356 l_text:=l_text||'</source_type>';
357 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
358 l_text:='<time_normal_finish>';
359 l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_finish);
360 l_text:=l_text||'</time_normal_finish>';
361 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
362 l_text:='<time_normal_start>';
363 l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_start);
364 l_text:=l_text||'</time_normal_start>';
365 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
366 l_text:='<bargaining_unit_code>';
367 l_text:=l_text||irc_utilities_pkg.removeTags(p_bargaining_unit_code);
368 l_text:=l_text||'</bargaining_unit_code>';
369 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
370 l_text:='<comments>';
371 l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
372 l_text:=l_text||'</comments>';
373 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
374 l_text:='<date_probation_end>';
375 l_text:=l_text||fnd_date.date_to_canonical(p_date_probation_end);
376 l_text:=l_text||'</date_probation_end>';
377 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
378 l_text:='<title>';
379 l_text:=l_text||irc_utilities_pkg.removeTags(p_title);
380 l_text:=l_text||'</title>';
381 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
382 l_text:='<ass_attribute_category>';
383 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute_category);
384 l_text:=l_text||'</ass_attribute_category>';
385 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
386 l_text:='<ass_attribute1>';
387 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute1);
388 l_text:=l_text||'</ass_attribute1>';
389 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
390 l_text:='<ass_attribute2>';
391 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute2);
392 l_text:=l_text||'</ass_attribute2>';
393 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
394 l_text:='<ass_attribute3>';
395 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute3);
396 l_text:=l_text||'</ass_attribute3>';
397 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
398 l_text:='<ass_attribute4>';
399 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute4);
400 l_text:=l_text||'</ass_attribute4>';
401 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
402 l_text:='<ass_attribute5>';
403 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute5);
404 l_text:=l_text||'</ass_attribute5>';
405 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
406 l_text:='<ass_attribute6>';
407 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute6);
408 l_text:=l_text||'</ass_attribute6>';
409 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
410 l_text:='<ass_attribute7>';
414 l_text:='<ass_attribute8>';
411 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute7);
412 l_text:=l_text||'</ass_attribute7>';
413 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
415 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute8);
416 l_text:=l_text||'</ass_attribute8>';
417 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
418 l_text:='<ass_attribute9>';
419 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute9);
420 l_text:=l_text||'</ass_attribute9>';
421 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
422 l_text:='<ass_attribute10>';
423 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute10);
424 l_text:=l_text||'</ass_attribute10>';
425 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
426 l_text:='<ass_attribute11>';
427 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute11);
428 l_text:=l_text||'</ass_attribute11>';
429 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
430 l_text:='<ass_attribute12>';
431 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute12);
432 l_text:=l_text||'</ass_attribute12>';
433 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
434 l_text:='<ass_attribute13>';
435 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute13);
436 l_text:=l_text||'</ass_attribute13>';
437 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
438 l_text:='<ass_attribute14>';
439 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute14);
440 l_text:=l_text||'</ass_attribute14>';
441 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
442 l_text:='<ass_attribute15>';
443 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute15);
444 l_text:=l_text||'</ass_attribute15>';
445 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
446 l_text:='<ass_attribute16>';
447 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute16);
448 l_text:=l_text||'</ass_attribute16>';
449 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
450 l_text:='<ass_attribute17>';
451 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute17);
452 l_text:=l_text||'</ass_attribute17>';
453 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
454 l_text:='<ass_attribute18>';
455 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute18);
456 l_text:=l_text||'</ass_attribute18>';
457 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
458 l_text:='<ass_attribute19>';
459 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute19);
460 l_text:=l_text||'</ass_attribute19>';
461 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
462 l_text:='<ass_attribute20>';
463 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute20);
464 l_text:=l_text||'</ass_attribute20>';
465 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
466 l_text:='<ass_attribute21>';
467 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute21);
468 l_text:=l_text||'</ass_attribute21>';
469 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
470 l_text:='<ass_attribute22>';
471 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute22);
472 l_text:=l_text||'</ass_attribute22>';
473 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
474 l_text:='<ass_attribute23>';
475 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute23);
476 l_text:=l_text||'</ass_attribute23>';
477 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
478 l_text:='<ass_attribute24>';
479 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute24);
480 l_text:=l_text||'</ass_attribute24>';
481 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
482 l_text:='<ass_attribute25>';
483 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute25);
484 l_text:=l_text||'</ass_attribute25>';
485 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
486 l_text:='<ass_attribute26>';
487 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute26);
488 l_text:=l_text||'</ass_attribute26>';
489 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
490 l_text:='<ass_attribute27>';
491 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute27);
492 l_text:=l_text||'</ass_attribute27>';
493 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
494 l_text:='<ass_attribute28>';
495 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute28);
496 l_text:=l_text||'</ass_attribute28>';
497 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
498 l_text:='<ass_attribute29>';
499 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute29);
500 l_text:=l_text||'</ass_attribute29>';
501 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
502 l_text:='<ass_attribute30>';
503 l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute30);
504 l_text:=l_text||'</ass_attribute30>';
505 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
506 l_text:='<scl_segment1>';
507 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment1);
508 l_text:=l_text||'</scl_segment1>';
509 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
510 l_text:='<scl_segment2>';
511 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment2);
512 l_text:=l_text||'</scl_segment2>';
516 l_text:=l_text||'</scl_segment3>';
513 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
514 l_text:='<scl_segment3>';
515 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment3);
517 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
518 l_text:='<scl_segment4>';
519 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment4);
520 l_text:=l_text||'</scl_segment4>';
521 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
522 l_text:='<scl_segment5>';
523 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment5);
524 l_text:=l_text||'</scl_segment5>';
525 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
526 l_text:='<scl_segment6>';
527 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment6);
528 l_text:=l_text||'</scl_segment6>';
529 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
530 l_text:='<scl_segment7>';
531 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment7);
532 l_text:=l_text||'</scl_segment7>';
533 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
534 l_text:='<scl_segment8>';
535 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment8);
536 l_text:=l_text||'</scl_segment8>';
537 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
538 l_text:='<scl_segment9>';
539 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment9);
540 l_text:=l_text||'</scl_segment9>';
541 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
542 l_text:='<scl_segment10>';
543 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment10);
544 l_text:=l_text||'</scl_segment10>';
545 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
546 l_text:='<scl_segment11>';
547 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment11);
548 l_text:=l_text||'</scl_segment11>';
549 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
550 l_text:='<scl_segment12>';
551 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment12);
552 l_text:=l_text||'</scl_segment12>';
553 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
554 l_text:='<scl_segment13>';
555 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment13);
556 l_text:=l_text||'</scl_segment13>';
557 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
558 l_text:='<scl_segment14>';
559 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment14);
560 l_text:=l_text||'</scl_segment14>';
561 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
562 l_text:='<scl_segment15>';
563 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment15);
564 l_text:=l_text||'</scl_segment15>';
565 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
566 l_text:='<scl_segment16>';
567 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment16);
568 l_text:=l_text||'</scl_segment16>';
569 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
570 l_text:='<scl_segment17>';
571 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment17);
572 l_text:=l_text||'</scl_segment17>';
573 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
574 l_text:='<scl_segment18>';
575 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment18);
576 l_text:=l_text||'</scl_segment18>';
577 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
578 l_text:='<scl_segment19>';
579 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment19);
580 l_text:=l_text||'</scl_segment19>';
581 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
582 l_text:='<scl_segment20>';
583 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment20);
584 l_text:=l_text||'</scl_segment20>';
585 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
586 l_text:='<scl_segment21>';
587 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment21);
588 l_text:=l_text||'</scl_segment21>';
589 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
590 l_text:='<scl_segment22>';
591 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment22);
592 l_text:=l_text||'</scl_segment22>';
593 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
594 l_text:='<scl_segment23>';
595 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment23);
596 l_text:=l_text||'</scl_segment23>';
597 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
598 l_text:='<scl_segment24>';
599 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment24);
600 l_text:=l_text||'</scl_segment24>';
601 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
602 l_text:='<scl_segment25>';
603 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment25);
604 l_text:=l_text||'</scl_segment25>';
605 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
606 l_text:='<scl_segment26>';
607 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment26);
608 l_text:=l_text||'</scl_segment26>';
609 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
610 l_text:='<scl_segment27>';
611 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment27);
612 l_text:=l_text||'</scl_segment27>';
613 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
614 l_text:='<scl_segment28>';
615 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment28);
616 l_text:=l_text||'</scl_segment28>';
617 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
621 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
618 l_text:='<scl_segment29>';
619 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment29);
620 l_text:=l_text||'</scl_segment29>';
622 l_text:='<scl_segment30>';
623 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment30);
624 l_text:=l_text||'</scl_segment30>';
625 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
626 l_text:='<concatenated_segments>';
627 l_text:=l_text||irc_utilities_pkg.removeTags(p_concatenated_segments);
628 l_text:=l_text||'</concatenated_segments>';
629 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
630 l_text:='<pgp_segment1>';
631 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment1);
632 l_text:=l_text||'</pgp_segment1>';
633 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
634 l_text:='<pgp_segment2>';
635 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment2);
636 l_text:=l_text||'</pgp_segment2>';
637 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
638 l_text:='<pgp_segment3>';
639 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment3);
640 l_text:=l_text||'</pgp_segment3>';
641 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
642 l_text:='<pgp_segment4>';
643 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment4);
644 l_text:=l_text||'</pgp_segment4>';
645 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
646 l_text:='<pgp_segment5>';
647 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment5);
648 l_text:=l_text||'</pgp_segment5>';
649 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
650 l_text:='<pgp_segment6>';
651 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment6);
652 l_text:=l_text||'</pgp_segment6>';
653 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
654 l_text:='<pgp_segment7>';
655 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment7);
656 l_text:=l_text||'</pgp_segment7>';
657 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
658 l_text:='<pgp_segment8>';
659 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment8);
660 l_text:=l_text||'</pgp_segment8>';
661 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
662 l_text:='<pgp_segment9>';
663 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment9);
664 l_text:=l_text||'</pgp_segment9>';
665 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
666 l_text:='<pgp_segment10>';
667 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment10);
668 l_text:=l_text||'</pgp_segment10>';
669 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
670 l_text:='<pgp_segment11>';
671 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment11);
672 l_text:=l_text||'</pgp_segment11>';
673 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
674 l_text:='<pgp_segment12>';
675 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment12);
676 l_text:=l_text||'</pgp_segment12>';
677 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
678 l_text:='<pgp_segment13>';
679 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment13);
680 l_text:=l_text||'</pgp_segment13>';
681 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
682 l_text:='<pgp_segment14>';
683 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment14);
684 l_text:=l_text||'</pgp_segment14>';
685 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
686 l_text:='<pgp_segment15>';
687 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment15);
688 l_text:=l_text||'</pgp_segment15>';
689 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
690 l_text:='<pgp_segment16>';
691 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment16);
692 l_text:=l_text||'</pgp_segment16>';
693 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
694 l_text:='<pgp_segment17>';
695 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment17);
696 l_text:=l_text||'</pgp_segment17>';
697 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
698 l_text:='<pgp_segment18>';
699 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment18);
700 l_text:=l_text||'</pgp_segment18>';
701 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
702 l_text:='<pgp_segment19>';
703 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment19);
704 l_text:=l_text||'</pgp_segment19>';
705 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
706 l_text:='<pgp_segment20>';
707 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment20);
708 l_text:=l_text||'</pgp_segment20>';
709 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
710 l_text:='<pgp_segment21>';
711 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment21);
712 l_text:=l_text||'</pgp_segment21>';
713 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
714 l_text:='<pgp_segment22>';
715 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment22);
716 l_text:=l_text||'</pgp_segment22>';
717 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
718 l_text:='<pgp_segment23>';
719 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment23);
720 l_text:=l_text||'</pgp_segment23>';
721 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
722 l_text:='<pgp_segment24>';
726 l_text:='<pgp_segment25>';
723 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment24);
724 l_text:=l_text||'</pgp_segment24>';
725 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
727 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment25);
728 l_text:=l_text||'</pgp_segment25>';
729 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
730 l_text:='<pgp_segment26>';
731 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment26);
732 l_text:=l_text||'</pgp_segment26>';
733 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
734 l_text:='<pgp_segment27>';
735 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment27);
736 l_text:=l_text||'</pgp_segment27>';
737 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
738 l_text:='<pgp_segment28>';
739 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment28);
740 l_text:=l_text||'</pgp_segment28>';
741 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
742 l_text:='<pgp_segment29>';
743 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment29);
744 l_text:=l_text||'</pgp_segment29>';
745 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
746 l_text:='<pgp_segment30>';
747 l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment30);
748 l_text:=l_text||'</pgp_segment30>';
749 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
750 l_text:='<group_name>';
751 l_text:=l_text||irc_utilities_pkg.removeTags(p_group_name);
752 l_text:=l_text||'</group_name>';
753 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
754 l_text:='<comment_id>';
755 l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
756 l_text:=l_text||'</comment_id>';
757 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
758 l_text:='<people_group_id>';
759 l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
760 l_text:=l_text||'</people_group_id>';
761 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
762 l_text:='<effective_start_date>';
763 l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
764 l_text:=l_text||'</effective_start_date>';
765 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
766 l_text:='<effective_end_date>';
767 l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
768 l_text:=l_text||'</effective_end_date>';
769 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
770 l_text:='<scl_concat_segments>';
771 l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_concat_segments);
772 l_text:=l_text||'</scl_concat_segments>';
773 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
774 l_text:='<concat_segments>';
775 l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);
776 l_text:=l_text||'</concat_segments>';
777 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
778 l_text:='<contract_id>';
779 l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);
780 l_text:=l_text||'</contract_id>';
781 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
782 l_text:='<establishment_id>';
783 l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
784 l_text:=l_text||'</establishment_id>';
785 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
786 l_text:='<collective_agreement_id>';
787 l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
788 l_text:=l_text||'</collective_agreement_id>';
789 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
790 l_text:='<cagr_id_flex_num>';
791 l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);
792 l_text:=l_text||'</cagr_id_flex_num>';
793 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
794 l_text:='<cag_segment1>';
795 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment1);
796 l_text:=l_text||'</cag_segment1>';
797 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
798 l_text:='<cag_segment2>';
799 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment2);
800 l_text:=l_text||'</cag_segment2>';
801 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
802 l_text:='<cag_segment3>';
803 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment3);
804 l_text:=l_text||'</cag_segment3>';
805 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
806 l_text:='<cag_segment4>';
807 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment4);
808 l_text:=l_text||'</cag_segment4>';
809 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
810 l_text:='<cag_segment5>';
811 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment5);
812 l_text:=l_text||'</cag_segment5>';
813 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
814 l_text:='<cag_segment6>';
815 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment6);
816 l_text:=l_text||'</cag_segment6>';
817 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
818 l_text:='<cag_segment7>';
819 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment7);
820 l_text:=l_text||'</cag_segment7>';
821 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
822 l_text:='<cag_segment8>';
823 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment8);
824 l_text:=l_text||'</cag_segment8>';
828 l_text:=l_text||'</cag_segment9>';
825 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
826 l_text:='<cag_segment9>';
827 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment9);
829 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
830 l_text:='<cag_segment10>';
831 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment10);
832 l_text:=l_text||'</cag_segment10>';
833 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
834 l_text:='<cag_segment11>';
835 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment11);
836 l_text:=l_text||'</cag_segment11>';
837 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
838 l_text:='<cag_segment12>';
839 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment12);
840 l_text:=l_text||'</cag_segment12>';
841 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
842 l_text:='<cag_segment13>';
843 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment13);
844 l_text:=l_text||'</cag_segment13>';
845 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
846 l_text:='<cag_segment14>';
847 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment14);
848 l_text:=l_text||'</cag_segment14>';
849 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
850 l_text:='<cag_segment15>';
851 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment15);
852 l_text:=l_text||'</cag_segment15>';
853 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
854 l_text:='<cag_segment16>';
855 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment16);
856 l_text:=l_text||'</cag_segment16>';
857 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
858 l_text:='<cag_segment17>';
859 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment17);
860 l_text:=l_text||'</cag_segment17>';
861 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
862 l_text:='<cag_segment18>';
863 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment18);
864 l_text:=l_text||'</cag_segment18>';
865 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
866 l_text:='<cag_segment19>';
867 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment19);
868 l_text:=l_text||'</cag_segment19>';
869 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
870 l_text:='<cag_segment20>';
871 l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment20);
872 l_text:=l_text||'</cag_segment20>';
873 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
874 l_text:='<notice_period>';
875 l_text:=l_text||fnd_number.number_to_canonical(p_notice_period);
876 l_text:=l_text||'</notice_period>';
877 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
878 l_text:='<notice_period_uom>';
879 l_text:=l_text||irc_utilities_pkg.removeTags(p_notice_period_uom);
880 l_text:=l_text||'</notice_period_uom>';
881 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
882 l_text:='<employee_category>';
883 l_text:=l_text||irc_utilities_pkg.removeTags(p_employee_category);
884 l_text:=l_text||'</employee_category>';
885 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
886 l_text:='<work_at_home>';
887 l_text:=l_text||irc_utilities_pkg.removeTags(p_work_at_home);
888 l_text:=l_text||'</work_at_home>';
889 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
890 l_text:='<job_post_source_name>';
891 l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);
892 l_text:=l_text||'</job_post_source_name>';
893 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
894 l_text:='<cagr_grade_def_id>';
895 l_text:=l_text||fnd_number.number_to_canonical(p_cagr_grade_def_id);
896 l_text:=l_text||'</cagr_grade_def_id>';
897 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
898 l_text:='<cagr_concatenated_segments>';
899 l_text:=l_text||irc_utilities_pkg.removeTags(p_cagr_concatenated_segments);
900 l_text:=l_text||'</cagr_concatenated_segments>';
901 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
902 l_text:='<applicant_rank>';
903 l_text:=l_text||fnd_number.number_to_canonical(p_applicant_rank);
904 l_text:=l_text||'</applicant_rank>';
905 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
906 l_text:='<posting_content_id>';
907 l_text:=l_text||fnd_number.number_to_canonical(p_posting_content_id);
908 l_text:=l_text||'</posting_content_id>';
909 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
910 l_text:='<grade_ladder_pgm_id>';
911 l_text:=l_text||fnd_number.number_to_canonical(p_grade_ladder_pgm_id);
912 l_text:=l_text||'</grade_ladder_pgm_id>';
913 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
914 l_text:='<supervisor_assignment_id>';
915 l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);
916 l_text:=l_text||'</supervisor_assignment_id>';
917 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
918 l_text:='</assignment>';
919 --
920 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
921 --
922 if p_effective_start_date is not NULL and
923 p_effective_start_date > trunc(SYSDATE) and
924 fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
925 -- raise the event with the event data, with send date set to effective date
926 wf_event.raise(p_event_name=>l_event_name
927 ,p_event_key=>l_event_key
928 ,p_event_data=>l_event_data
929 ,p_send_date => p_effective_start_date);
930 --
931 else
932 -- raise the event with the event data
933 wf_event.raise(p_event_name=>l_event_name
934 ,p_event_key=>l_event_key
935 ,p_event_data=>l_event_data);
936 end if;
937 elsif (l_message='KEY') then
938 hr_utility.set_location(l_proc,30);
939 -- get a key for the event
940 open get_seq;
941 fetch get_seq into l_event_key;
942 close get_seq;
943 if p_effective_start_date is not NULL and
944 p_effective_start_date > trunc(SYSDATE) and
945 fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
946 -- this is a key event, so just raise the event
947 -- without the event data, with send date set to effective date
948 wf_event.raise(p_event_name=>l_event_name
949 ,p_event_key=>l_event_key
950 ,p_send_date => p_effective_start_date);
951 --
952 else
953 -- this is a key event, so just raise the event
954 -- without the event data
955 wf_event.raise(p_event_name=>l_event_name
956 ,p_event_key=>l_event_key);
957 end if;
958 elsif (l_message='NONE') then
959 hr_utility.set_location(l_proc,40);
960 -- no event is required, so do nothing
961 null;
962 end if;
963 hr_utility.set_location('Leaving: '||l_proc,50);
964 end update_apl_asg_a;
965 end hr_assignment_be5;