81: l_text:='
82: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
83: --
84: l_text:='
85: l_text:=l_text||fnd_number.number_to_canonical(p_default_posting_id);
86: l_text:=l_text||'
87: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
88: l_text:='
89: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
85: l_text:=l_text||fnd_number.number_to_canonical(p_default_posting_id);
86: l_text:=l_text||'';
87: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
88: l_text:='
89: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
90: l_text:=l_text||'
91: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
92: l_text:='
93: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
89: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
90: l_text:=l_text||'';
91: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
92: l_text:='
93: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
94: l_text:=l_text||'
95: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
96: l_text:='
97: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
93: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
94: l_text:=l_text||'';
95: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
96: l_text:='
97: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
98: l_text:=l_text||'
99: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
100: l_text:='
101: l_text:=l_text||irc_utilities_pkg.removeTags(p_language_code);