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