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.IRC_PENDING_DATA_BE2 dependencies on IRC_UTILITIES_PKG

Line 92: l_text:=l_text||irc_utilities_pkg.removeTags(p_email_address);

88: l_text:='';
89: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
90: --
91: l_text:='';
92: l_text:=l_text||irc_utilities_pkg.removeTags(p_email_address);
93: l_text:=l_text||'';
94: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
95: l_text:='';
96: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);

Line 96: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);

92: l_text:=l_text||irc_utilities_pkg.removeTags(p_email_address);
93: l_text:=l_text||'';
94: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
95: l_text:='';
96: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);
97: l_text:=l_text||'';
98: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
99: l_text:='';
100: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);

Line 104: l_text:=l_text||irc_utilities_pkg.removeTags(p_first_name);

100: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
101: l_text:=l_text||'';
102: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
103: l_text:='';
104: l_text:=l_text||irc_utilities_pkg.removeTags(p_first_name);
105: l_text:=l_text||'';
106: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
107: l_text:='';
108: l_text:=l_text||irc_utilities_pkg.removeTags(p_user_password);

Line 108: l_text:=l_text||irc_utilities_pkg.removeTags(p_user_password);

104: l_text:=l_text||irc_utilities_pkg.removeTags(p_first_name);
105: l_text:=l_text||'';
106: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
107: l_text:='';
108: l_text:=l_text||irc_utilities_pkg.removeTags(p_user_password);
109: l_text:=l_text||'';
110: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
111: l_text:='';
112: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_file_name);

Line 112: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_file_name);

108: l_text:=l_text||irc_utilities_pkg.removeTags(p_user_password);
109: l_text:=l_text||'';
110: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
111: l_text:='';
112: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_file_name);
113: l_text:=l_text||'';
114: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
115: l_text:='';
116: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_description);

Line 116: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_description);

112: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_file_name);
113: l_text:=l_text||'';
114: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
115: l_text:='';
116: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_description);
117: l_text:=l_text||'';
118: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
119: l_text:='';
120: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_mime_type);

Line 120: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_mime_type);

116: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_description);
117: l_text:=l_text||'';
118: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
119: l_text:='';
120: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_mime_type);
121: l_text:=l_text||'';
122: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
123: l_text:='';
124: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);

Line 124: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);

120: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_mime_type);
121: l_text:=l_text||'';
122: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
123: l_text:='';
124: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);
125: l_text:=l_text||'';
126: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
127: l_text:='';
128: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);

Line 128: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);

124: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);
125: l_text:=l_text||'';
126: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
127: l_text:='';
128: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);
129: l_text:=l_text||'';
130: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
131: l_text:='';
132: l_text:=l_text||fnd_number.number_to_canonical(p_posting_content_id);

Line 140: l_text:=l_text||irc_utilities_pkg.removeTags(p_processed);

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||irc_utilities_pkg.removeTags(p_processed);
141: l_text:=l_text||'';
142: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
143: l_text:='';
144: l_text:=l_text||irc_utilities_pkg.removeTags(p_sex);

Line 144: l_text:=l_text||irc_utilities_pkg.removeTags(p_sex);

140: l_text:=l_text||irc_utilities_pkg.removeTags(p_processed);
141: l_text:=l_text||'';
142: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
143: l_text:='';
144: l_text:=l_text||irc_utilities_pkg.removeTags(p_sex);
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_date.date_to_canonical(p_date_of_birth);

Line 152: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information_category);

148: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_birth);
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_per_information_category);
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||irc_utilities_pkg.removeTags(p_per_information1);

Line 156: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information1);

152: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information_category);
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||irc_utilities_pkg.removeTags(p_per_information1);
157: l_text:=l_text||'';
158: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
159: l_text:='';
160: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information2);

Line 160: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information2);

156: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information1);
157: l_text:=l_text||'';
158: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
159: l_text:='';
160: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information2);
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_per_information3);

Line 164: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information3);

160: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information2);
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_per_information3);
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||irc_utilities_pkg.removeTags(p_per_information4);

Line 168: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information4);

164: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information3);
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||irc_utilities_pkg.removeTags(p_per_information4);
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_per_information5);

Line 172: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information5);

168: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information4);
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_per_information5);
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||irc_utilities_pkg.removeTags(p_per_information6);

Line 176: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information6);

172: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information5);
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||irc_utilities_pkg.removeTags(p_per_information6);
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_per_information7);

Line 180: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information7);

176: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information6);
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_per_information7);
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||irc_utilities_pkg.removeTags(p_per_information8);

Line 184: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information8);

180: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information7);
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||irc_utilities_pkg.removeTags(p_per_information8);
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_per_information9);

Line 188: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information9);

184: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information8);
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_per_information9);
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||irc_utilities_pkg.removeTags(p_per_information10);

Line 192: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information10);

188: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information9);
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||irc_utilities_pkg.removeTags(p_per_information10);
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||irc_utilities_pkg.removeTags(p_per_information11);

Line 196: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information11);

192: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information10);
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||irc_utilities_pkg.removeTags(p_per_information11);
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||irc_utilities_pkg.removeTags(p_per_information12);

Line 200: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information12);

196: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information11);
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||irc_utilities_pkg.removeTags(p_per_information12);
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||irc_utilities_pkg.removeTags(p_per_information13);

Line 204: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information13);

200: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information12);
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||irc_utilities_pkg.removeTags(p_per_information13);
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_per_information14);

Line 208: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information14);

204: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information13);
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_per_information14);
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_per_information15);

Line 212: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information15);

208: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information14);
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_per_information15);
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_per_information16);

Line 216: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information16);

212: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information15);
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_per_information16);
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_per_information17);

Line 220: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information17);

216: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information16);
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_per_information17);
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_per_information18);

Line 224: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information18);

220: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information17);
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_per_information18);
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_per_information19);

Line 228: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information19);

224: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information18);
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_per_information19);
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_per_information20);

Line 232: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information20);

228: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information19);
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_per_information20);
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_per_information21);

Line 236: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information21);

232: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information20);
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_per_information21);
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_per_information22);

Line 240: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information22);

236: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information21);
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_per_information22);
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_per_information23);

Line 244: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information23);

240: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information22);
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_per_information23);
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_per_information24);

Line 248: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information24);

244: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information23);
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_per_information24);
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_per_information25);

Line 252: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information25);

248: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information24);
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_per_information25);
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_per_information26);

Line 256: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information26);

252: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information25);
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_per_information26);
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_per_information27);

Line 260: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information27);

256: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information26);
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_per_information27);
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_per_information28);

Line 264: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information28);

260: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information27);
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_per_information28);
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_per_information29);

Line 268: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information29);

264: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information28);
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_per_information29);
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_per_information30);

Line 272: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information30);

268: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information29);
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_per_information30);
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_error_message);

Line 276: l_text:=l_text||irc_utilities_pkg.removeTags(p_error_message);

272: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information30);
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_error_message);
277: l_text:=l_text||'';
278: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
279: l_text:='';
280: l_text:=l_text||fnd_date.date_to_canonical(p_creation_date);

Line 288: l_text:=l_text||irc_utilities_pkg.removeTags(p_allow_access);

284: l_text:=l_text||fnd_date.date_to_canonical(p_last_update_date);
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_allow_access);
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||irc_utilities_pkg.removeTags(p_visitor_resp_key);

Line 292: l_text:=l_text||irc_utilities_pkg.removeTags(p_visitor_resp_key);

288: l_text:=l_text||irc_utilities_pkg.removeTags(p_allow_access);
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||irc_utilities_pkg.removeTags(p_visitor_resp_key);
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_visitor_resp_appl_id);

Line 300: l_text:=l_text||irc_utilities_pkg.removeTags(p_security_group_key);

296: l_text:=l_text||fnd_number.number_to_canonical(p_visitor_resp_appl_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_security_group_key);
301: l_text:=l_text||'';
302: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
303: l_text:='';
304: --