136: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
137: l_text:=l_text||'';
138: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
139: l_text:='
140: l_text:=l_text||fnd_number.number_to_canonical(p_classification_id);
141: l_text:=l_text||'
142: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
143: l_text:='
144: l_text:=l_text||irc_utilities_pkg.removeTags(p_element_name);
144: l_text:=l_text||irc_utilities_pkg.removeTags(p_element_name);
145: l_text:=l_text||'';
146: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
147: l_text:='
148: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
149: l_text:=l_text||'
150: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
151: l_text:='
152: l_text:=l_text||irc_utilities_pkg.removeTags(p_legislation_code);
152: l_text:=l_text||irc_utilities_pkg.removeTags(p_legislation_code);
153: l_text:=l_text||'';
154: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
155: l_text:='
156: l_text:=l_text||fnd_number.number_to_canonical(p_formula_id);
157: l_text:=l_text||'
158: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
159: l_text:='
160: l_text:=l_text||irc_utilities_pkg.removeTags(p_input_currency_code);
164: l_text:=l_text||irc_utilities_pkg.removeTags(p_output_currency_code);
165: l_text:=l_text||'';
166: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
167: l_text:='
168: l_text:=l_text||fnd_number.number_to_canonical(p_benefit_classification_id);
169: l_text:=l_text||'
170: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
171: l_text:='
172: l_text:=l_text||irc_utilities_pkg.removeTags(p_additional_entry_allowed_fla);
208: l_text:=l_text||irc_utilities_pkg.removeTags(p_process_in_run_flag);
209: l_text:=l_text||'';
210: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
211: l_text:='
212: l_text:=l_text||fnd_number.number_to_canonical(p_processing_priority);
213: l_text:=l_text||'
214: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
215: l_text:='
216: l_text:=l_text||irc_utilities_pkg.removeTags(p_processing_type);
232: l_text:=l_text||irc_utilities_pkg.removeTags(p_iterative_flag);
233: l_text:=l_text||'';
234: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
235: l_text:='
236: l_text:=l_text||fnd_number.number_to_canonical(p_iterative_formula_id);
237: l_text:=l_text||'
238: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
239: l_text:='
240: l_text:=l_text||fnd_number.number_to_canonical(p_iterative_priority);
236: l_text:=l_text||fnd_number.number_to_canonical(p_iterative_formula_id);
237: l_text:=l_text||'';
238: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
239: l_text:='
240: l_text:=l_text||fnd_number.number_to_canonical(p_iterative_priority);
241: l_text:=l_text||'
242: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
243: l_text:='
244: l_text:=l_text||irc_utilities_pkg.removeTags(p_creator_type);
244: l_text:=l_text||irc_utilities_pkg.removeTags(p_creator_type);
245: l_text:=l_text||'';
246: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
247: l_text:='
248: l_text:=l_text||fnd_number.number_to_canonical(p_retro_summ_ele_id);
249: l_text:=l_text||'
250: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
251: l_text:='
252: l_text:=l_text||irc_utilities_pkg.removeTags(p_grossup_flag);
272: l_text:=l_text||irc_utilities_pkg.removeTags(p_process_advance_entry);
273: l_text:=l_text||'';
274: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
275: l_text:='
276: l_text:=l_text||fnd_number.number_to_canonical(p_proration_group_id);
277: l_text:=l_text||'
278: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
279: l_text:='
280: l_text:=l_text||fnd_number.number_to_canonical(p_proration_formula_id);
276: l_text:=l_text||fnd_number.number_to_canonical(p_proration_group_id);
277: l_text:=l_text||'';
278: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
279: l_text:='
280: l_text:=l_text||fnd_number.number_to_canonical(p_proration_formula_id);
281: l_text:=l_text||'
282: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
283: l_text:='
284: l_text:=l_text||fnd_number.number_to_canonical(p_recalc_event_group_id);
280: l_text:=l_text||fnd_number.number_to_canonical(p_proration_formula_id);
281: l_text:=l_text||'';
282: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
283: l_text:='
284: l_text:=l_text||fnd_number.number_to_canonical(p_recalc_event_group_id);
285: l_text:=l_text||'
286: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
287: l_text:='
288: l_text:=l_text||irc_utilities_pkg.removeTags(p_legislation_subgroup);
288: l_text:=l_text||irc_utilities_pkg.removeTags(p_legislation_subgroup);
289: l_text:=l_text||'';
290: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
291: l_text:='
292: l_text:=l_text||fnd_number.number_to_canonical(p_qualifying_age);
293: l_text:=l_text||'
294: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
295: l_text:='
296: l_text:=l_text||fnd_number.number_to_canonical(p_qualifying_length_of_service);
292: l_text:=l_text||fnd_number.number_to_canonical(p_qualifying_age);
293: l_text:=l_text||'';
294: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
295: l_text:='
296: l_text:=l_text||fnd_number.number_to_canonical(p_qualifying_length_of_service);
297: l_text:=l_text||'
298: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
299: l_text:='
300: l_text:=l_text||irc_utilities_pkg.removeTags(p_qualifying_units);
484: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_definition_type);
485: l_text:=l_text||'';
486: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
487: l_text:='
488: l_text:=l_text||fnd_number.number_to_canonical(p_time_definition_id);
489: l_text:=l_text||'
490: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
491: l_text:='
492: l_text:=l_text||fnd_number.number_to_canonical(p_advance_element_type_id);
488: l_text:=l_text||fnd_number.number_to_canonical(p_time_definition_id);
489: l_text:=l_text||'';
490: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
491: l_text:='
492: l_text:=l_text||fnd_number.number_to_canonical(p_advance_element_type_id);
493: l_text:=l_text||'
494: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
495: l_text:='
496: l_text:=l_text||fnd_number.number_to_canonical(p_deduction_element_type_id);
492: l_text:=l_text||fnd_number.number_to_canonical(p_advance_element_type_id);
493: l_text:=l_text||'';
494: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
495: l_text:='
496: l_text:=l_text||fnd_number.number_to_canonical(p_deduction_element_type_id);
497: l_text:=l_text||'
498: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
499: l_text:='
500: l_text:=l_text||fnd_number.number_to_canonical(p_element_type_id);
496: l_text:=l_text||fnd_number.number_to_canonical(p_deduction_element_type_id);
497: l_text:=l_text||'';
498: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
499: l_text:='
500: l_text:=l_text||fnd_number.number_to_canonical(p_element_type_id);
501: l_text:=l_text||'
502: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
503: l_text:='
504: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
508: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
509: l_text:=l_text||'';
510: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
511: l_text:='
512: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
513: l_text:=l_text||'
514: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
515: l_text:='
516: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
512: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
513: l_text:=l_text||'';
514: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
515: l_text:='
516: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
517: l_text:=l_text||'
518: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
519: l_text:='
520: if(P_PROCESSING_PRIORITY_WARNING) then