APPS.HR_PERSONAL_PAY_METHOD_BE1 dependencies on DBMS_LOB

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

126: close get_seq;
127: --
128: -- build the xml data for the event
129: --
130: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
131: l_text:='';
132: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
133: l_text:='';
134: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

128: -- build the xml data for the event
129: --
130: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
131: l_text:='';
132: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
133: l_text:='';
134: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
135: --
136: l_text:='';

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

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

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

135: --
136: l_text:='';
137: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
138: l_text:=l_text||'';
139: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
140: l_text:='';
141: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
142: l_text:=l_text||'';
143: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

139: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
140: l_text:='';
141: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
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||fnd_number.number_to_canonical(p_org_payment_method_id);
146: l_text:=l_text||'';
147: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

143: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
144: l_text:='';
145: l_text:=l_text||fnd_number.number_to_canonical(p_org_payment_method_id);
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_amount);
150: l_text:=l_text||'';
151: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 151: dbms_lob.writeAppend(l_event_data,length(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_amount);
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||fnd_number.number_to_canonical(p_percentage);
154: l_text:=l_text||'';
155: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

151: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
152: l_text:='';
153: l_text:=l_text||fnd_number.number_to_canonical(p_percentage);
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_priority);
158: l_text:=l_text||'';
159: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 159: dbms_lob.writeAppend(l_event_data,length(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_priority);
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_comments);
162: l_text:=l_text||'';
163: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 163: dbms_lob.writeAppend(l_event_data,length(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_comments);
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_attribute_category);
166: l_text:=l_text||'';
167: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 167: dbms_lob.writeAppend(l_event_data,length(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_attribute_category);
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_attribute1);
170: l_text:=l_text||'';
171: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 171: dbms_lob.writeAppend(l_event_data,length(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_attribute1);
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_attribute2);
174: l_text:=l_text||'';
175: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 175: dbms_lob.writeAppend(l_event_data,length(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_attribute2);
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_attribute3);
178: l_text:=l_text||'';
179: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 179: dbms_lob.writeAppend(l_event_data,length(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_attribute3);
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_attribute4);
182: l_text:=l_text||'';
183: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 183: dbms_lob.writeAppend(l_event_data,length(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_attribute4);
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_attribute5);
186: l_text:=l_text||'';
187: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 187: dbms_lob.writeAppend(l_event_data,length(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_attribute5);
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_attribute6);
190: l_text:=l_text||'';
191: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 191: dbms_lob.writeAppend(l_event_data,length(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_attribute6);
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_attribute7);
194: l_text:=l_text||'';
195: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 195: dbms_lob.writeAppend(l_event_data,length(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_attribute7);
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_attribute8);
198: l_text:=l_text||'';
199: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 199: dbms_lob.writeAppend(l_event_data,length(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_attribute8);
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_attribute9);
202: l_text:=l_text||'';
203: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 203: dbms_lob.writeAppend(l_event_data,length(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_attribute9);
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_attribute10);
206: l_text:=l_text||'';
207: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 207: dbms_lob.writeAppend(l_event_data,length(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_attribute10);
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_attribute11);
210: l_text:=l_text||'';
211: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 211: dbms_lob.writeAppend(l_event_data,length(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_attribute11);
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_attribute12);
214: l_text:=l_text||'';
215: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 215: dbms_lob.writeAppend(l_event_data,length(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_attribute12);
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_attribute13);
218: l_text:=l_text||'';
219: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 219: dbms_lob.writeAppend(l_event_data,length(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_attribute13);
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_attribute14);
222: l_text:=l_text||'';
223: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 223: dbms_lob.writeAppend(l_event_data,length(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_attribute14);
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_attribute15);
226: l_text:=l_text||'';
227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 227: dbms_lob.writeAppend(l_event_data,length(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_attribute15);
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_attribute16);
230: l_text:=l_text||'';
231: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 231: dbms_lob.writeAppend(l_event_data,length(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_attribute16);
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_attribute17);
234: l_text:=l_text||'';
235: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 235: dbms_lob.writeAppend(l_event_data,length(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_attribute17);
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_attribute18);
238: l_text:=l_text||'';
239: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 239: dbms_lob.writeAppend(l_event_data,length(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_attribute18);
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_attribute19);
242: l_text:=l_text||'';
243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 243: dbms_lob.writeAppend(l_event_data,length(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_attribute19);
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_attribute20);
246: l_text:=l_text||'';
247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 247: dbms_lob.writeAppend(l_event_data,length(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_attribute20);
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_territory_code);
250: l_text:=l_text||'';
251: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 251: dbms_lob.writeAppend(l_event_data,length(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_territory_code);
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_segment1);
254: l_text:=l_text||'';
255: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 255: dbms_lob.writeAppend(l_event_data,length(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_segment1);
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_segment2);
258: l_text:=l_text||'';
259: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 259: dbms_lob.writeAppend(l_event_data,length(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_segment2);
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_segment3);
262: l_text:=l_text||'';
263: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 263: dbms_lob.writeAppend(l_event_data,length(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_segment3);
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_segment4);
266: l_text:=l_text||'';
267: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 267: dbms_lob.writeAppend(l_event_data,length(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_segment4);
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_segment5);
270: l_text:=l_text||'';
271: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 271: dbms_lob.writeAppend(l_event_data,length(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_segment5);
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_segment6);
274: l_text:=l_text||'';
275: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 275: dbms_lob.writeAppend(l_event_data,length(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_segment6);
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_segment7);
278: l_text:=l_text||'';
279: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 279: dbms_lob.writeAppend(l_event_data,length(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_segment7);
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_segment8);
282: l_text:=l_text||'';
283: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 283: dbms_lob.writeAppend(l_event_data,length(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_segment8);
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_segment9);
286: l_text:=l_text||'';
287: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 287: dbms_lob.writeAppend(l_event_data,length(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_segment9);
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_segment10);
290: l_text:=l_text||'';
291: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 291: dbms_lob.writeAppend(l_event_data,length(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_segment10);
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_segment11);
294: l_text:=l_text||'';
295: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 295: dbms_lob.writeAppend(l_event_data,length(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_segment11);
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_segment12);
298: l_text:=l_text||'';
299: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 299: dbms_lob.writeAppend(l_event_data,length(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_segment12);
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_segment13);
302: l_text:=l_text||'';
303: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 303: dbms_lob.writeAppend(l_event_data,length(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_segment13);
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_segment14);
306: l_text:=l_text||'';
307: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 307: dbms_lob.writeAppend(l_event_data,length(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_segment14);
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_segment15);
310: l_text:=l_text||'';
311: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 311: dbms_lob.writeAppend(l_event_data,length(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_segment15);
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_segment16);
314: l_text:=l_text||'';
315: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 315: dbms_lob.writeAppend(l_event_data,length(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_segment16);
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_segment17);
318: l_text:=l_text||'';
319: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 319: dbms_lob.writeAppend(l_event_data,length(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_segment17);
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_segment18);
322: l_text:=l_text||'';
323: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 323: dbms_lob.writeAppend(l_event_data,length(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_segment18);
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_segment19);
326: l_text:=l_text||'';
327: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 327: dbms_lob.writeAppend(l_event_data,length(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_segment19);
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_segment20);
330: l_text:=l_text||'';
331: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 331: dbms_lob.writeAppend(l_event_data,length(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_segment20);
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_segment21);
334: l_text:=l_text||'';
335: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 335: dbms_lob.writeAppend(l_event_data,length(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_segment21);
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_segment22);
338: l_text:=l_text||'';
339: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 339: dbms_lob.writeAppend(l_event_data,length(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_segment22);
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_segment23);
342: l_text:=l_text||'';
343: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 343: dbms_lob.writeAppend(l_event_data,length(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_segment23);
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_segment24);
346: l_text:=l_text||'';
347: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 347: dbms_lob.writeAppend(l_event_data,length(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_segment24);
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_segment25);
350: l_text:=l_text||'';
351: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 351: dbms_lob.writeAppend(l_event_data,length(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_segment25);
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_segment26);
354: l_text:=l_text||'';
355: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 355: dbms_lob.writeAppend(l_event_data,length(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_segment26);
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_segment27);
358: l_text:=l_text||'';
359: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 359: dbms_lob.writeAppend(l_event_data,length(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_segment27);
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_segment28);
362: l_text:=l_text||'';
363: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 363: dbms_lob.writeAppend(l_event_data,length(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_segment28);
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_segment29);
366: l_text:=l_text||'';
367: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 367: dbms_lob.writeAppend(l_event_data,length(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_segment29);
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_segment30);
370: l_text:=l_text||'';
371: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 371: dbms_lob.writeAppend(l_event_data,length(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_segment30);
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_payee_type);
374: l_text:=l_text||'';
375: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 375: dbms_lob.writeAppend(l_event_data,length(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_payee_type);
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||fnd_number.number_to_canonical(p_payee_id);
378: l_text:=l_text||'';
379: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

375: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
376: l_text:='';
377: l_text:=l_text||fnd_number.number_to_canonical(p_payee_id);
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||fnd_number.number_to_canonical(p_personal_payment_method_id);
382: l_text:=l_text||'';
383: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

379: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
380: l_text:='';
381: l_text:=l_text||fnd_number.number_to_canonical(p_personal_payment_method_id);
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||fnd_number.number_to_canonical(p_external_account_id);
386: l_text:=l_text||'';
387: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

383: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
384: l_text:='';
385: l_text:=l_text||fnd_number.number_to_canonical(p_external_account_id);
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||fnd_number.number_to_canonical(p_object_version_number);
390: l_text:=l_text||'';
391: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

387: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
388: l_text:='';
389: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
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||fnd_date.date_to_canonical(p_effective_start_date);
394: l_text:=l_text||'';
395: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

391: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
392: l_text:='';
393: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
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||fnd_date.date_to_canonical(p_effective_end_date);
398: l_text:=l_text||'';
399: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

395: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
396: l_text:='';
397: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
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||fnd_number.number_to_canonical(p_comment_id);
402: l_text:=l_text||'';
403: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

399: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
400: l_text:='';
401: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
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_ppm_information1);
406: l_text:=l_text||'';
407: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 407: dbms_lob.writeAppend(l_event_data,length(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_ppm_information1);
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_ppm_information2);
410: l_text:=l_text||'';
411: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 411: dbms_lob.writeAppend(l_event_data,length(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_ppm_information2);
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_ppm_information3);
414: l_text:=l_text||'';
415: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 415: dbms_lob.writeAppend(l_event_data,length(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_ppm_information3);
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_ppm_information4);
418: l_text:=l_text||'';
419: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 419: dbms_lob.writeAppend(l_event_data,length(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_ppm_information4);
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_ppm_information5);
422: l_text:=l_text||'';
423: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 423: dbms_lob.writeAppend(l_event_data,length(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_ppm_information5);
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_ppm_information6);
426: l_text:=l_text||'';
427: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 427: dbms_lob.writeAppend(l_event_data,length(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_ppm_information6);
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_ppm_information7);
430: l_text:=l_text||'';
431: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 431: dbms_lob.writeAppend(l_event_data,length(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_ppm_information7);
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_ppm_information8);
434: l_text:=l_text||'';
435: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 435: dbms_lob.writeAppend(l_event_data,length(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_ppm_information8);
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_ppm_information9);
438: l_text:=l_text||'';
439: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 439: dbms_lob.writeAppend(l_event_data,length(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_ppm_information9);
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_ppm_information10);
442: l_text:=l_text||'';
443: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 443: dbms_lob.writeAppend(l_event_data,length(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_ppm_information10);
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_ppm_information11);
446: l_text:=l_text||'';
447: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 447: dbms_lob.writeAppend(l_event_data,length(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_ppm_information11);
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_ppm_information12);
450: l_text:=l_text||'';
451: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 451: dbms_lob.writeAppend(l_event_data,length(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_ppm_information12);
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||irc_utilities_pkg.removeTags(p_ppm_information13);
454: l_text:=l_text||'';
455: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

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

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

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

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

459: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
460: l_text:='';
461: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information15);
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_ppm_information16);
466: l_text:=l_text||'';
467: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 467: dbms_lob.writeAppend(l_event_data,length(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_ppm_information16);
466: l_text:=l_text||'';
467: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
468: l_text:='';
469: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information17);
470: l_text:=l_text||'';
471: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

467: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
468: l_text:='';
469: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information17);
470: l_text:=l_text||'';
471: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
472: l_text:='';
473: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information18);
474: l_text:=l_text||'';
475: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

471: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
472: l_text:='';
473: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information18);
474: l_text:=l_text||'';
475: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
476: l_text:='';
477: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information19);
478: l_text:=l_text||'';
479: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

475: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
476: l_text:='';
477: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information19);
478: l_text:=l_text||'';
479: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
480: l_text:='';
481: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information20);
482: l_text:=l_text||'';
483: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

479: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
480: l_text:='';
481: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information20);
482: l_text:=l_text||'';
483: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
484: l_text:='';
485: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information21);
486: l_text:=l_text||'';
487: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

483: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
484: l_text:='';
485: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information21);
486: l_text:=l_text||'';
487: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
488: l_text:='';
489: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information22);
490: l_text:=l_text||'';
491: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

487: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
488: l_text:='';
489: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information22);
490: l_text:=l_text||'';
491: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
492: l_text:='';
493: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information23);
494: l_text:=l_text||'';
495: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

491: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
492: l_text:='';
493: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information23);
494: l_text:=l_text||'';
495: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
496: l_text:='';
497: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information24);
498: l_text:=l_text||'';
499: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

495: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
496: l_text:='';
497: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information24);
498: l_text:=l_text||'';
499: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
500: l_text:='';
501: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information25);
502: l_text:=l_text||'';
503: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

499: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
500: l_text:='';
501: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information25);
502: l_text:=l_text||'';
503: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
504: l_text:='';
505: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information26);
506: l_text:=l_text||'';
507: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

503: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
504: l_text:='';
505: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information26);
506: l_text:=l_text||'';
507: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
508: l_text:='';
509: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information27);
510: l_text:=l_text||'';
511: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

507: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
508: l_text:='';
509: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information27);
510: l_text:=l_text||'';
511: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
512: l_text:='';
513: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information28);
514: l_text:=l_text||'';
515: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

511: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
512: l_text:='';
513: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information28);
514: l_text:=l_text||'';
515: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
516: l_text:='';
517: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information29);
518: l_text:=l_text||'';
519: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

515: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
516: l_text:='';
517: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information29);
518: l_text:=l_text||'';
519: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
520: l_text:='';
521: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information30);
522: l_text:=l_text||'';
523: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

519: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
520: l_text:='';
521: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information30);
522: l_text:=l_text||'';
523: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
524: l_text:='';
525: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information_category);
526: l_text:=l_text||'';
527: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

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

523: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
524: l_text:='';
525: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information_category);
526: l_text:=l_text||'';
527: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
528: l_text:='';
529: --
530: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
531: --

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

526: l_text:=l_text||'';
527: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
528: l_text:='';
529: --
530: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
531: --
532: if p_effective_start_date is not NULL and
533: p_effective_start_date > trunc(SYSDATE) and
534: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then