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_PERSON_ABSENCE_BE1 dependencies on DBMS_LOB

Line 125: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);

121: close get_seq;
122: --
123: -- build the xml data for the event
124: --
125: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
126: l_text:='';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='';
129: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

123: -- build the xml data for the event
124: --
125: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
126: l_text:='';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='';
129: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
130: --
131: l_text:='';

Line 129: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

125: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
126: l_text:='';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='';
129: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
130: --
131: l_text:='';
132: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
133: l_text:=l_text||'';

Line 134: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

130: --
131: l_text:='';
132: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
133: l_text:=l_text||'';
134: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
135: l_text:='';
136: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
137: l_text:=l_text||'';
138: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 138: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

134: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
135: l_text:='';
136: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
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_business_group_id);
141: l_text:=l_text||'';
142: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 142: dbms_lob.writeAppend(l_event_data,length(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_business_group_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||fnd_number.number_to_canonical(p_absence_attendance_type_id);
145: l_text:=l_text||'';
146: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 146: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

142: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
143: l_text:='';
144: l_text:=l_text||fnd_number.number_to_canonical(p_absence_attendance_type_id);
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_abs_attendance_reason_id);
149: l_text:=l_text||'';
150: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 150: dbms_lob.writeAppend(l_event_data,length(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_abs_attendance_reason_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_comments);
153: l_text:=l_text||'';
154: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 154: dbms_lob.writeAppend(l_event_data,length(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_comments);
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_date.date_to_canonical(p_date_notification);
157: l_text:=l_text||'';
158: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 158: dbms_lob.writeAppend(l_event_data,length(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_date.date_to_canonical(p_date_notification);
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||fnd_date.date_to_canonical(p_date_projected_start);
161: l_text:=l_text||'';
162: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 162: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

158: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
159: l_text:='';
160: l_text:=l_text||fnd_date.date_to_canonical(p_date_projected_start);
161: l_text:=l_text||'';
162: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
163: l_text:='';
164: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_projected_start);
165: l_text:=l_text||'';
166: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 166: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

162: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
163: l_text:='';
164: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_projected_start);
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_date.date_to_canonical(p_date_projected_end);
169: l_text:=l_text||'';
170: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 170: dbms_lob.writeAppend(l_event_data,length(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_date.date_to_canonical(p_date_projected_end);
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_time_projected_end);
173: l_text:=l_text||'';
174: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 174: dbms_lob.writeAppend(l_event_data,length(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_time_projected_end);
173: l_text:=l_text||'';
174: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
175: l_text:='';
176: l_text:=l_text||fnd_date.date_to_canonical(p_date_start);
177: l_text:=l_text||'';
178: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 178: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

174: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
175: l_text:='';
176: l_text:=l_text||fnd_date.date_to_canonical(p_date_start);
177: l_text:=l_text||'';
178: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
179: l_text:='';
180: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_start);
181: l_text:=l_text||'';
182: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 182: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

178: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
179: l_text:='';
180: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_start);
181: l_text:=l_text||'';
182: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
183: l_text:='';
184: l_text:=l_text||fnd_date.date_to_canonical(p_date_end);
185: l_text:=l_text||'';
186: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 186: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

182: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
183: l_text:='';
184: l_text:=l_text||fnd_date.date_to_canonical(p_date_end);
185: l_text:=l_text||'';
186: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
187: l_text:='';
188: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_end);
189: l_text:=l_text||'';
190: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 190: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

186: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
187: l_text:='';
188: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_end);
189: l_text:=l_text||'';
190: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
191: l_text:='';
192: l_text:=l_text||fnd_number.number_to_canonical(p_absence_days);
193: l_text:=l_text||'';
194: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 194: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

190: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
191: l_text:='';
192: l_text:=l_text||fnd_number.number_to_canonical(p_absence_days);
193: l_text:=l_text||'';
194: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
195: l_text:='';
196: l_text:=l_text||fnd_number.number_to_canonical(p_absence_hours);
197: l_text:=l_text||'';
198: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 198: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

194: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
195: l_text:='';
196: l_text:=l_text||fnd_number.number_to_canonical(p_absence_hours);
197: l_text:=l_text||'';
198: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
199: l_text:='';
200: l_text:=l_text||fnd_number.number_to_canonical(p_authorising_person_id);
201: l_text:=l_text||'';
202: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 202: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

198: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
199: l_text:='';
200: l_text:=l_text||fnd_number.number_to_canonical(p_authorising_person_id);
201: l_text:=l_text||'';
202: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
203: l_text:='';
204: l_text:=l_text||fnd_number.number_to_canonical(p_replacement_person_id);
205: l_text:=l_text||'';
206: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 206: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

202: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
203: l_text:='';
204: l_text:=l_text||fnd_number.number_to_canonical(p_replacement_person_id);
205: l_text:=l_text||'';
206: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
207: l_text:='';
208: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);
209: l_text:=l_text||'';
210: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 210: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

206: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
207: l_text:='';
208: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);
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||irc_utilities_pkg.removeTags(p_attribute1);
213: l_text:=l_text||'';
214: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 214: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

210: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
211: l_text:='';
212: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute1);
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_attribute2);
217: l_text:=l_text||'';
218: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 218: dbms_lob.writeAppend(l_event_data,length(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_attribute2);
217: l_text:=l_text||'';
218: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
219: l_text:='';
220: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute3);
221: l_text:=l_text||'';
222: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 222: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

218: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
219: l_text:='';
220: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute3);
221: l_text:=l_text||'';
222: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
223: l_text:='';
224: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute4);
225: l_text:=l_text||'';
226: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 226: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

222: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
223: l_text:='';
224: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute4);
225: l_text:=l_text||'';
226: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
227: l_text:='';
228: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute5);
229: l_text:=l_text||'';
230: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 230: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

226: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
227: l_text:='';
228: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute5);
229: l_text:=l_text||'';
230: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
231: l_text:='';
232: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute6);
233: l_text:=l_text||'';
234: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 234: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

230: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
231: l_text:='';
232: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute6);
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||irc_utilities_pkg.removeTags(p_attribute7);
237: l_text:=l_text||'';
238: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 238: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

234: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
235: l_text:='';
236: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute7);
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||irc_utilities_pkg.removeTags(p_attribute8);
241: l_text:=l_text||'';
242: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 242: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

238: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
239: l_text:='';
240: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute8);
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_attribute9);
245: l_text:=l_text||'';
246: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 246: dbms_lob.writeAppend(l_event_data,length(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_attribute9);
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||irc_utilities_pkg.removeTags(p_attribute10);
249: l_text:=l_text||'';
250: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 250: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

246: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
247: l_text:='';
248: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute10);
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_attribute11);
253: l_text:=l_text||'';
254: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 254: dbms_lob.writeAppend(l_event_data,length(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_attribute11);
253: l_text:=l_text||'';
254: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
255: l_text:='';
256: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute12);
257: l_text:=l_text||'';
258: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 258: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

254: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
255: l_text:='';
256: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute12);
257: l_text:=l_text||'';
258: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
259: l_text:='';
260: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute13);
261: l_text:=l_text||'';
262: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 262: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

258: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
259: l_text:='';
260: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute13);
261: l_text:=l_text||'';
262: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
263: l_text:='';
264: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute14);
265: l_text:=l_text||'';
266: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 266: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

262: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
263: l_text:='';
264: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute14);
265: l_text:=l_text||'';
266: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
267: l_text:='';
268: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute15);
269: l_text:=l_text||'';
270: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 270: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

266: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
267: l_text:='';
268: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute15);
269: l_text:=l_text||'';
270: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
271: l_text:='';
272: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute16);
273: l_text:=l_text||'';
274: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 274: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

270: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
271: l_text:='';
272: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute16);
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||irc_utilities_pkg.removeTags(p_attribute17);
277: l_text:=l_text||'';
278: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 278: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

274: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
275: l_text:='';
276: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute17);
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||irc_utilities_pkg.removeTags(p_attribute18);
281: l_text:=l_text||'';
282: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 282: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

278: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
279: l_text:='';
280: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute18);
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||irc_utilities_pkg.removeTags(p_attribute19);
285: l_text:=l_text||'';
286: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 286: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

282: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
283: l_text:='';
284: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute19);
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_attribute20);
289: l_text:=l_text||'';
290: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 290: dbms_lob.writeAppend(l_event_data,length(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_attribute20);
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_occurrence);
293: l_text:=l_text||'';
294: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 294: dbms_lob.writeAppend(l_event_data,length(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_occurrence);
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_period_of_incapacity_id);
297: l_text:=l_text||'';
298: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 298: dbms_lob.writeAppend(l_event_data,length(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_period_of_incapacity_id);
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_ssp1_issued);
301: l_text:=l_text||'';
302: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 302: dbms_lob.writeAppend(l_event_data,length(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_ssp1_issued);
301: l_text:=l_text||'';
302: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
303: l_text:='';
304: l_text:=l_text||fnd_number.number_to_canonical(p_maternity_id);
305: l_text:=l_text||'';
306: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 306: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

302: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
303: l_text:='';
304: l_text:=l_text||fnd_number.number_to_canonical(p_maternity_id);
305: l_text:=l_text||'';
306: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
307: l_text:='';
308: l_text:=l_text||fnd_date.date_to_canonical(p_sickness_start_date);
309: l_text:=l_text||'';
310: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 310: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

306: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
307: l_text:='';
308: l_text:=l_text||fnd_date.date_to_canonical(p_sickness_start_date);
309: l_text:=l_text||'';
310: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
311: l_text:='';
312: l_text:=l_text||fnd_date.date_to_canonical(p_sickness_end_date);
313: l_text:=l_text||'';
314: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 314: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

310: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
311: l_text:='';
312: l_text:=l_text||fnd_date.date_to_canonical(p_sickness_end_date);
313: l_text:=l_text||'';
314: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
315: l_text:='';
316: l_text:=l_text||irc_utilities_pkg.removeTags(p_pregnancy_related_illness);
317: l_text:=l_text||'';
318: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 318: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

314: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
315: l_text:='';
316: l_text:=l_text||irc_utilities_pkg.removeTags(p_pregnancy_related_illness);
317: l_text:=l_text||'';
318: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
319: l_text:='';
320: l_text:=l_text||irc_utilities_pkg.removeTags(p_reason_for_notification_dela);
321: l_text:=l_text||'';
322: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 322: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

318: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
319: l_text:='';
320: l_text:=l_text||irc_utilities_pkg.removeTags(p_reason_for_notification_dela);
321: l_text:=l_text||'';
322: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
323: l_text:='';
324: l_text:=l_text||irc_utilities_pkg.removeTags(p_accept_late_notification_fla);
325: l_text:=l_text||'';
326: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 326: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

322: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
323: l_text:='';
324: l_text:=l_text||irc_utilities_pkg.removeTags(p_accept_late_notification_fla);
325: l_text:=l_text||'';
326: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
327: l_text:='';
328: l_text:=l_text||fnd_number.number_to_canonical(p_linked_absence_id);
329: l_text:=l_text||'';
330: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 330: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

326: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
327: l_text:='';
328: l_text:=l_text||fnd_number.number_to_canonical(p_linked_absence_id);
329: l_text:=l_text||'';
330: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
331: l_text:='';
332: l_text:=l_text||fnd_number.number_to_canonical(p_batch_id);
333: l_text:=l_text||'';
334: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 334: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

330: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
331: l_text:='';
332: l_text:=l_text||fnd_number.number_to_canonical(p_batch_id);
333: l_text:=l_text||'';
334: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
335: l_text:='';
336: if(P_CREATE_ELEMENT_ENTRY) then
337: l_text:=l_text||'TRUE';
338: else

Line 342: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

338: else
339: l_text:=l_text||'FALSE';
340: end if;
341: l_text:=l_text||'';
342: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
343: l_text:='';
344: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information_category);
345: l_text:=l_text||'';
346: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 346: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

342: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
343: l_text:='';
344: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information_category);
345: l_text:=l_text||'';
346: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
347: l_text:='';
348: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information1);
349: l_text:=l_text||'';
350: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 350: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

346: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
347: l_text:='';
348: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information1);
349: l_text:=l_text||'';
350: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
351: l_text:='';
352: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information2);
353: l_text:=l_text||'';
354: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 354: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

350: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
351: l_text:='';
352: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information2);
353: l_text:=l_text||'';
354: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
355: l_text:='';
356: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information3);
357: l_text:=l_text||'';
358: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 358: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

354: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
355: l_text:='';
356: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information3);
357: l_text:=l_text||'';
358: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
359: l_text:='';
360: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information4);
361: l_text:=l_text||'';
362: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 362: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

358: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
359: l_text:='';
360: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information4);
361: l_text:=l_text||'';
362: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
363: l_text:='';
364: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information5);
365: l_text:=l_text||'';
366: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 366: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

362: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
363: l_text:='';
364: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information5);
365: l_text:=l_text||'';
366: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
367: l_text:='';
368: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information6);
369: l_text:=l_text||'';
370: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 370: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

366: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
367: l_text:='';
368: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information6);
369: l_text:=l_text||'';
370: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
371: l_text:='';
372: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information7);
373: l_text:=l_text||'';
374: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 374: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

370: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
371: l_text:='';
372: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information7);
373: l_text:=l_text||'';
374: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
375: l_text:='';
376: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information8);
377: l_text:=l_text||'';
378: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 378: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

374: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
375: l_text:='';
376: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information8);
377: l_text:=l_text||'';
378: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
379: l_text:='';
380: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information9);
381: l_text:=l_text||'';
382: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 382: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

378: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
379: l_text:='';
380: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information9);
381: l_text:=l_text||'';
382: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
383: l_text:='';
384: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information10);
385: l_text:=l_text||'';
386: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 386: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

382: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
383: l_text:='';
384: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information10);
385: l_text:=l_text||'';
386: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
387: l_text:='';
388: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information11);
389: l_text:=l_text||'';
390: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 390: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

386: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
387: l_text:='';
388: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information11);
389: l_text:=l_text||'';
390: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
391: l_text:='';
392: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information12);
393: l_text:=l_text||'';
394: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 394: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

390: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
391: l_text:='';
392: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information12);
393: l_text:=l_text||'';
394: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
395: l_text:='';
396: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information13);
397: l_text:=l_text||'';
398: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 398: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

394: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
395: l_text:='';
396: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information13);
397: l_text:=l_text||'';
398: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
399: l_text:='';
400: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information14);
401: l_text:=l_text||'';
402: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 402: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

398: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
399: l_text:='';
400: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information14);
401: l_text:=l_text||'';
402: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
403: l_text:='';
404: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information15);
405: l_text:=l_text||'';
406: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 406: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

402: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
403: l_text:='';
404: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information15);
405: l_text:=l_text||'';
406: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
407: l_text:='';
408: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information16);
409: l_text:=l_text||'';
410: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 410: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

406: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
407: l_text:='';
408: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information16);
409: l_text:=l_text||'';
410: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
411: l_text:='';
412: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information17);
413: l_text:=l_text||'';
414: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 414: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

410: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
411: l_text:='';
412: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information17);
413: l_text:=l_text||'';
414: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
415: l_text:='';
416: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information18);
417: l_text:=l_text||'';
418: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 418: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

414: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
415: l_text:='';
416: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information18);
417: l_text:=l_text||'';
418: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
419: l_text:='';
420: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information19);
421: l_text:=l_text||'';
422: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 422: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

418: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
419: l_text:='';
420: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information19);
421: l_text:=l_text||'';
422: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
423: l_text:='';
424: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information20);
425: l_text:=l_text||'';
426: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 426: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

422: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
423: l_text:='';
424: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information20);
425: l_text:=l_text||'';
426: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
427: l_text:='';
428: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information21);
429: l_text:=l_text||'';
430: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 430: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

426: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
427: l_text:='';
428: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information21);
429: l_text:=l_text||'';
430: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
431: l_text:='';
432: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information22);
433: l_text:=l_text||'';
434: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 434: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

430: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
431: l_text:='';
432: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information22);
433: l_text:=l_text||'';
434: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
435: l_text:='';
436: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information23);
437: l_text:=l_text||'';
438: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 438: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

434: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
435: l_text:='';
436: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information23);
437: l_text:=l_text||'';
438: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
439: l_text:='';
440: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information24);
441: l_text:=l_text||'';
442: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 442: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

438: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
439: l_text:='';
440: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information24);
441: l_text:=l_text||'';
442: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
443: l_text:='';
444: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information25);
445: l_text:=l_text||'';
446: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 446: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

442: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
443: l_text:='';
444: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information25);
445: l_text:=l_text||'';
446: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
447: l_text:='';
448: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information26);
449: l_text:=l_text||'';
450: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 450: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

446: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
447: l_text:='';
448: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information26);
449: l_text:=l_text||'';
450: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
451: l_text:='';
452: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information27);
453: l_text:=l_text||'';
454: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 454: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

450: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
451: l_text:='';
452: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information27);
453: l_text:=l_text||'';
454: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
455: l_text:='';
456: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information28);
457: l_text:=l_text||'';
458: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 458: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

454: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
455: l_text:='';
456: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information28);
457: l_text:=l_text||'';
458: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
459: l_text:='';
460: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information29);
461: l_text:=l_text||'';
462: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 462: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

458: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
459: l_text:='';
460: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information29);
461: l_text:=l_text||'';
462: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
463: l_text:='';
464: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information30);
465: l_text:=l_text||'';
466: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 466: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

462: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
463: l_text:='';
464: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information30);
465: l_text:=l_text||'';
466: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
467: l_text:='';
468: l_text:=l_text||fnd_number.number_to_canonical(p_absence_case_id);
469: l_text:=l_text||'';
470: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 470: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

466: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
467: l_text:='';
468: l_text:=l_text||fnd_number.number_to_canonical(p_absence_case_id);
469: l_text:=l_text||'';
470: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
471: l_text:='';
472: l_text:=l_text||fnd_number.number_to_canonical(p_absence_attendance_id);
473: l_text:=l_text||'';
474: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 474: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

470: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
471: l_text:='';
472: l_text:=l_text||fnd_number.number_to_canonical(p_absence_attendance_id);
473: l_text:=l_text||'';
474: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
475: l_text:='';
476: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
477: l_text:=l_text||'';
478: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 478: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

474: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
475: l_text:='';
476: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
477: l_text:=l_text||'';
478: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
479: l_text:='';
480: if(P_DUR_DYS_LESS_WARNING) then
481: l_text:=l_text||'TRUE';
482: else

Line 486: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

482: else
483: l_text:=l_text||'FALSE';
484: end if;
485: l_text:=l_text||'';
486: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
487: l_text:='';
488: if(P_DUR_HRS_LESS_WARNING) then
489: l_text:=l_text||'TRUE';
490: else

Line 494: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

490: else
491: l_text:=l_text||'FALSE';
492: end if;
493: l_text:=l_text||'';
494: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
495: l_text:='';
496: if(P_EXCEEDS_PTO_ENTIT_WARNING) then
497: l_text:=l_text||'TRUE';
498: else

Line 502: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

498: else
499: l_text:=l_text||'FALSE';
500: end if;
501: l_text:=l_text||'';
502: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
503: l_text:='';
504: if(P_EXCEEDS_RUN_TOTAL_WARNING) then
505: l_text:=l_text||'TRUE';
506: else

Line 510: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

506: else
507: l_text:=l_text||'FALSE';
508: end if;
509: l_text:=l_text||'';
510: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
511: l_text:='';
512: if(P_ABS_OVERLAP_WARNING) then
513: l_text:=l_text||'TRUE';
514: else

Line 518: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

514: else
515: l_text:=l_text||'FALSE';
516: end if;
517: l_text:=l_text||'';
518: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
519: l_text:='';
520: if(P_ABS_DAY_AFTER_WARNING) then
521: l_text:=l_text||'TRUE';
522: else

Line 526: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

522: else
523: l_text:=l_text||'FALSE';
524: end if;
525: l_text:=l_text||'';
526: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
527: l_text:='';
528: if(P_DUR_OVERWRITTEN_WARNING) then
529: l_text:=l_text||'TRUE';
530: else

Line 534: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

530: else
531: l_text:=l_text||'FALSE';
532: end if;
533: l_text:=l_text||'';
534: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
535: l_text:='';
536: --
537: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
538: --

Line 537: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

533: l_text:=l_text||'';
534: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
535: l_text:='';
536: --
537: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
538: --
539: -- raise the event with the event data
540: wf_event.raise(p_event_name=>l_event_name
541: ,p_event_key=>l_event_key