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