eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_JOB_BE1 dependencies on IRC_UTILITIES_PKG

Line 133: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);

129: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);
130: l_text:=l_text||'';
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: l_text:='';
133: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
134: l_text:=l_text||'';
135: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
136: l_text:='';
137: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);

Line 145: l_text:=l_text||irc_utilities_pkg.removeTags(p_benchmark_job_flag);

141: l_text:=l_text||fnd_number.number_to_canonical(p_approval_authority);
142: l_text:=l_text||'';
143: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
144: l_text:='';
145: l_text:=l_text||irc_utilities_pkg.removeTags(p_benchmark_job_flag);
146: l_text:=l_text||'';
147: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
148: l_text:='';
149: l_text:=l_text||fnd_number.number_to_canonical(p_benchmark_job_id);

Line 153: l_text:=l_text||irc_utilities_pkg.removeTags(p_emp_rights_flag);

149: l_text:=l_text||fnd_number.number_to_canonical(p_benchmark_job_id);
150: l_text:=l_text||'';
151: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
152: l_text:='';
153: l_text:=l_text||irc_utilities_pkg.removeTags(p_emp_rights_flag);
154: l_text:=l_text||'';
155: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
156: l_text:='';
157: l_text:=l_text||fnd_number.number_to_canonical(p_job_group_id);

Line 161: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);

157: l_text:=l_text||fnd_number.number_to_canonical(p_job_group_id);
158: l_text:=l_text||'';
159: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
160: l_text:='';
161: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);
162: l_text:=l_text||'';
163: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
164: l_text:='';
165: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute1);

Line 165: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute1);

161: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);
162: l_text:=l_text||'';
163: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
164: l_text:='';
165: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute1);
166: l_text:=l_text||'';
167: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
168: l_text:='';
169: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute2);

Line 169: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute2);

165: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute1);
166: l_text:=l_text||'';
167: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
168: l_text:='';
169: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute2);
170: l_text:=l_text||'';
171: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
172: l_text:='';
173: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute3);

Line 173: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute3);

169: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute2);
170: l_text:=l_text||'';
171: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
172: l_text:='';
173: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute3);
174: l_text:=l_text||'';
175: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
176: l_text:='';
177: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute4);

Line 177: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute4);

173: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute3);
174: l_text:=l_text||'';
175: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
176: l_text:='';
177: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute4);
178: l_text:=l_text||'';
179: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
180: l_text:='';
181: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute5);

Line 181: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute5);

177: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute4);
178: l_text:=l_text||'';
179: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
180: l_text:='';
181: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute5);
182: l_text:=l_text||'';
183: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
184: l_text:='';
185: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute6);

Line 185: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute6);

181: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute5);
182: l_text:=l_text||'';
183: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
184: l_text:='';
185: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute6);
186: l_text:=l_text||'';
187: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
188: l_text:='';
189: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute7);

Line 189: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute7);

185: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute6);
186: l_text:=l_text||'';
187: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
188: l_text:='';
189: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute7);
190: l_text:=l_text||'';
191: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
192: l_text:='';
193: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute8);

Line 193: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute8);

189: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute7);
190: l_text:=l_text||'';
191: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
192: l_text:='';
193: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute8);
194: l_text:=l_text||'';
195: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
196: l_text:='';
197: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute9);

Line 197: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute9);

193: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute8);
194: l_text:=l_text||'';
195: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
196: l_text:='';
197: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute9);
198: l_text:=l_text||'';
199: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
200: l_text:='';
201: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute10);

Line 201: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute10);

197: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute9);
198: l_text:=l_text||'';
199: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
200: l_text:='';
201: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute10);
202: l_text:=l_text||'';
203: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
204: l_text:='';
205: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute11);

Line 205: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute11);

201: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute10);
202: l_text:=l_text||'';
203: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
204: l_text:='';
205: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute11);
206: l_text:=l_text||'';
207: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
208: l_text:='';
209: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute12);

Line 209: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute12);

205: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute11);
206: l_text:=l_text||'';
207: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
208: l_text:='';
209: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute12);
210: l_text:=l_text||'';
211: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
212: l_text:='';
213: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute13);

Line 213: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute13);

209: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute12);
210: l_text:=l_text||'';
211: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
212: l_text:='';
213: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute13);
214: l_text:=l_text||'';
215: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
216: l_text:='';
217: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute14);

Line 217: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute14);

213: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute13);
214: l_text:=l_text||'';
215: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
216: l_text:='';
217: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute14);
218: l_text:=l_text||'';
219: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
220: l_text:='';
221: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute15);

Line 221: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute15);

217: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute14);
218: l_text:=l_text||'';
219: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
220: l_text:='';
221: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute15);
222: l_text:=l_text||'';
223: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
224: l_text:='';
225: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute16);

Line 225: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute16);

221: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute15);
222: l_text:=l_text||'';
223: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
224: l_text:='';
225: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute16);
226: l_text:=l_text||'';
227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
228: l_text:='';
229: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute17);

Line 229: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute17);

225: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute16);
226: l_text:=l_text||'';
227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
228: l_text:='';
229: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute17);
230: l_text:=l_text||'';
231: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
232: l_text:='';
233: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute18);

Line 233: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute18);

229: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute17);
230: l_text:=l_text||'';
231: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
232: l_text:='';
233: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute18);
234: l_text:=l_text||'';
235: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
236: l_text:='';
237: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute19);

Line 237: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute19);

233: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute18);
234: l_text:=l_text||'';
235: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
236: l_text:='';
237: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute19);
238: l_text:=l_text||'';
239: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
240: l_text:='';
241: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute20);

Line 241: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute20);

237: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute19);
238: l_text:=l_text||'';
239: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
240: l_text:='';
241: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute20);
242: l_text:=l_text||'';
243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
244: l_text:='';
245: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information_category);

Line 245: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information_category);

241: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute20);
242: l_text:=l_text||'';
243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
244: l_text:='';
245: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information_category);
246: l_text:=l_text||'';
247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
248: l_text:='';
249: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information1);

Line 249: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information1);

245: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information_category);
246: l_text:=l_text||'';
247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
248: l_text:='';
249: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information1);
250: l_text:=l_text||'';
251: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
252: l_text:='';
253: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information2);

Line 253: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information2);

249: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information1);
250: l_text:=l_text||'';
251: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
252: l_text:='';
253: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information2);
254: l_text:=l_text||'';
255: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
256: l_text:='';
257: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information3);

Line 257: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information3);

253: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information2);
254: l_text:=l_text||'';
255: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
256: l_text:='';
257: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information3);
258: l_text:=l_text||'';
259: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
260: l_text:='';
261: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information4);

Line 261: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information4);

257: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information3);
258: l_text:=l_text||'';
259: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
260: l_text:='';
261: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information4);
262: l_text:=l_text||'';
263: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
264: l_text:='';
265: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information5);

Line 265: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information5);

261: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information4);
262: l_text:=l_text||'';
263: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
264: l_text:='';
265: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information5);
266: l_text:=l_text||'';
267: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
268: l_text:='';
269: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information6);

Line 269: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information6);

265: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information5);
266: l_text:=l_text||'';
267: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
268: l_text:='';
269: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information6);
270: l_text:=l_text||'';
271: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
272: l_text:='';
273: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information7);

Line 273: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information7);

269: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information6);
270: l_text:=l_text||'';
271: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
272: l_text:='';
273: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information7);
274: l_text:=l_text||'';
275: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
276: l_text:='';
277: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information8);

Line 277: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information8);

273: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information7);
274: l_text:=l_text||'';
275: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
276: l_text:='';
277: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information8);
278: l_text:=l_text||'';
279: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
280: l_text:='';
281: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information9);

Line 281: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information9);

277: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information8);
278: l_text:=l_text||'';
279: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
280: l_text:='';
281: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information9);
282: l_text:=l_text||'';
283: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
284: l_text:='';
285: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information10);

Line 285: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information10);

281: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information9);
282: l_text:=l_text||'';
283: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
284: l_text:='';
285: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information10);
286: l_text:=l_text||'';
287: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
288: l_text:='';
289: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information11);

Line 289: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information11);

285: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information10);
286: l_text:=l_text||'';
287: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
288: l_text:='';
289: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information11);
290: l_text:=l_text||'';
291: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
292: l_text:='';
293: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information12);

Line 293: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information12);

289: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information11);
290: l_text:=l_text||'';
291: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
292: l_text:='';
293: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information12);
294: l_text:=l_text||'';
295: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
296: l_text:='';
297: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information13);

Line 297: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information13);

293: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information12);
294: l_text:=l_text||'';
295: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
296: l_text:='';
297: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information13);
298: l_text:=l_text||'';
299: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
300: l_text:='';
301: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information14);

Line 301: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information14);

297: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information13);
298: l_text:=l_text||'';
299: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
300: l_text:='';
301: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information14);
302: l_text:=l_text||'';
303: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
304: l_text:='';
305: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information15);

Line 305: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information15);

301: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information14);
302: l_text:=l_text||'';
303: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
304: l_text:='';
305: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information15);
306: l_text:=l_text||'';
307: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
308: l_text:='';
309: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information16);

Line 309: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information16);

305: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information15);
306: l_text:=l_text||'';
307: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
308: l_text:='';
309: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information16);
310: l_text:=l_text||'';
311: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
312: l_text:='';
313: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information17);

Line 313: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information17);

309: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information16);
310: l_text:=l_text||'';
311: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
312: l_text:='';
313: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information17);
314: l_text:=l_text||'';
315: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
316: l_text:='';
317: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information18);

Line 317: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information18);

313: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information17);
314: l_text:=l_text||'';
315: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
316: l_text:='';
317: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information18);
318: l_text:=l_text||'';
319: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
320: l_text:='';
321: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information19);

Line 321: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information19);

317: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information18);
318: l_text:=l_text||'';
319: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
320: l_text:='';
321: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information19);
322: l_text:=l_text||'';
323: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
324: l_text:='';
325: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information20);

Line 325: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information20);

321: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information19);
322: l_text:=l_text||'';
323: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
324: l_text:='';
325: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information20);
326: l_text:=l_text||'';
327: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
328: l_text:='';
329: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment1);

Line 329: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment1);

325: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_information20);
326: l_text:=l_text||'';
327: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
328: l_text:='';
329: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment1);
330: l_text:=l_text||'';
331: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
332: l_text:='';
333: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment2);

Line 333: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment2);

329: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment1);
330: l_text:=l_text||'';
331: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
332: l_text:='';
333: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment2);
334: l_text:=l_text||'';
335: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
336: l_text:='';
337: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment3);

Line 337: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment3);

333: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment2);
334: l_text:=l_text||'';
335: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
336: l_text:='';
337: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment3);
338: l_text:=l_text||'';
339: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
340: l_text:='';
341: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment4);

Line 341: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment4);

337: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment3);
338: l_text:=l_text||'';
339: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
340: l_text:='';
341: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment4);
342: l_text:=l_text||'';
343: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
344: l_text:='';
345: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment5);

Line 345: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment5);

341: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment4);
342: l_text:=l_text||'';
343: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
344: l_text:='';
345: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment5);
346: l_text:=l_text||'';
347: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
348: l_text:='';
349: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment6);

Line 349: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment6);

345: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment5);
346: l_text:=l_text||'';
347: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
348: l_text:='';
349: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment6);
350: l_text:=l_text||'';
351: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
352: l_text:='';
353: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment7);

Line 353: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment7);

349: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment6);
350: l_text:=l_text||'';
351: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
352: l_text:='';
353: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment7);
354: l_text:=l_text||'';
355: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
356: l_text:='';
357: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment8);

Line 357: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment8);

353: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment7);
354: l_text:=l_text||'';
355: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
356: l_text:='';
357: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment8);
358: l_text:=l_text||'';
359: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
360: l_text:='';
361: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment9);

Line 361: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment9);

357: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment8);
358: l_text:=l_text||'';
359: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
360: l_text:='';
361: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment9);
362: l_text:=l_text||'';
363: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
364: l_text:='';
365: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment10);

Line 365: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment10);

361: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment9);
362: l_text:=l_text||'';
363: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
364: l_text:='';
365: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment10);
366: l_text:=l_text||'';
367: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
368: l_text:='';
369: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment11);

Line 369: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment11);

365: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment10);
366: l_text:=l_text||'';
367: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
368: l_text:='';
369: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment11);
370: l_text:=l_text||'';
371: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
372: l_text:='';
373: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment12);

Line 373: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment12);

369: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment11);
370: l_text:=l_text||'';
371: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
372: l_text:='';
373: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment12);
374: l_text:=l_text||'';
375: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
376: l_text:='';
377: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment13);

Line 377: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment13);

373: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment12);
374: l_text:=l_text||'';
375: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
376: l_text:='';
377: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment13);
378: l_text:=l_text||'';
379: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
380: l_text:='';
381: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment14);

Line 381: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment14);

377: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment13);
378: l_text:=l_text||'';
379: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
380: l_text:='';
381: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment14);
382: l_text:=l_text||'';
383: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
384: l_text:='';
385: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment15);

Line 385: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment15);

381: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment14);
382: l_text:=l_text||'';
383: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
384: l_text:='';
385: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment15);
386: l_text:=l_text||'';
387: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
388: l_text:='';
389: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment16);

Line 389: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment16);

385: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment15);
386: l_text:=l_text||'';
387: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
388: l_text:='';
389: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment16);
390: l_text:=l_text||'';
391: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
392: l_text:='';
393: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment17);

Line 393: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment17);

389: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment16);
390: l_text:=l_text||'';
391: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
392: l_text:='';
393: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment17);
394: l_text:=l_text||'';
395: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
396: l_text:='';
397: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment18);

Line 397: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment18);

393: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment17);
394: l_text:=l_text||'';
395: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
396: l_text:='';
397: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment18);
398: l_text:=l_text||'';
399: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
400: l_text:='';
401: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment19);

Line 401: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment19);

397: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment18);
398: l_text:=l_text||'';
399: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
400: l_text:='';
401: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment19);
402: l_text:=l_text||'';
403: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
404: l_text:='';
405: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment20);

Line 405: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment20);

401: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment19);
402: l_text:=l_text||'';
403: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
404: l_text:='';
405: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment20);
406: l_text:=l_text||'';
407: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
408: l_text:='';
409: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment21);

Line 409: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment21);

405: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment20);
406: l_text:=l_text||'';
407: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
408: l_text:='';
409: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment21);
410: l_text:=l_text||'';
411: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
412: l_text:='';
413: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment22);

Line 413: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment22);

409: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment21);
410: l_text:=l_text||'';
411: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
412: l_text:='';
413: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment22);
414: l_text:=l_text||'';
415: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
416: l_text:='';
417: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment23);

Line 417: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment23);

413: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment22);
414: l_text:=l_text||'';
415: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
416: l_text:='';
417: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment23);
418: l_text:=l_text||'';
419: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
420: l_text:='';
421: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment24);

Line 421: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment24);

417: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment23);
418: l_text:=l_text||'';
419: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
420: l_text:='';
421: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment24);
422: l_text:=l_text||'';
423: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
424: l_text:='';
425: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment25);

Line 425: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment25);

421: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment24);
422: l_text:=l_text||'';
423: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
424: l_text:='';
425: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment25);
426: l_text:=l_text||'';
427: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
428: l_text:='';
429: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment26);

Line 429: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment26);

425: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment25);
426: l_text:=l_text||'';
427: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
428: l_text:='';
429: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment26);
430: l_text:=l_text||'';
431: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
432: l_text:='';
433: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment27);

Line 433: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment27);

429: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment26);
430: l_text:=l_text||'';
431: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
432: l_text:='';
433: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment27);
434: l_text:=l_text||'';
435: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
436: l_text:='';
437: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment28);

Line 437: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment28);

433: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment27);
434: l_text:=l_text||'';
435: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
436: l_text:='';
437: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment28);
438: l_text:=l_text||'';
439: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
440: l_text:='';
441: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment29);

Line 441: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment29);

437: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment28);
438: l_text:=l_text||'';
439: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
440: l_text:='';
441: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment29);
442: l_text:=l_text||'';
443: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
444: l_text:='';
445: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment30);

Line 445: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment30);

441: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment29);
442: l_text:=l_text||'';
443: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
444: l_text:='';
445: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment30);
446: l_text:=l_text||'';
447: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
448: l_text:='';
449: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);

Line 449: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);

445: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment30);
446: l_text:=l_text||'';
447: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
448: l_text:='';
449: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);
450: l_text:=l_text||'';
451: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
452: l_text:='';
453: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);

Line 465: l_text:=l_text||irc_utilities_pkg.removeTags(p_name);

461: l_text:=l_text||fnd_number.number_to_canonical(p_job_definition_id);
462: l_text:=l_text||'';
463: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
464: l_text:='';
465: l_text:=l_text||irc_utilities_pkg.removeTags(p_name);
466: l_text:=l_text||'';
467: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
468: l_text:='';
469: --