DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_BEO dependencies on IRC_UTILITIES_PKG

Line 93: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);

89: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
90: l_text:=l_text||'';
91: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
92: l_text:='';
93: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
94: l_text:=l_text||'
';
95: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
96: l_text:='';
97: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);

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

125: l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);
126: l_text:=l_text||'';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='';
129: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment1);
130: l_text:=l_text||'
';
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: l_text:='';
133: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment2);

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

129: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment1);
130: l_text:=l_text||'';
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: l_text:='';
133: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment2);
134: l_text:=l_text||'
';
135: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
136: l_text:='';
137: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment3);

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

133: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment2);
134: l_text:=l_text||'';
135: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
136: l_text:='';
137: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment3);
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||irc_utilities_pkg.removeTags(p_segment4);

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

137: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment3);
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||irc_utilities_pkg.removeTags(p_segment4);
142: l_text:=l_text||'
';
143: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
144: l_text:='';
145: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment5);

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

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

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

145: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment5);
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||irc_utilities_pkg.removeTags(p_segment6);
150: l_text:=l_text||'
';
151: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
152: l_text:='';
153: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment7);

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

149: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment6);
150: l_text:=l_text||'';
151: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
152: l_text:='';
153: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment7);
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||irc_utilities_pkg.removeTags(p_segment8);

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

153: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment7);
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||irc_utilities_pkg.removeTags(p_segment8);
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_segment9);

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

157: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment8);
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_segment9);
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_segment10);

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

161: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment9);
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_segment10);
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_segment11);

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

165: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment10);
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_segment11);
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_segment12);

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

169: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment11);
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_segment12);
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_segment13);

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

173: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment12);
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_segment13);
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_segment14);

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

177: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment13);
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_segment14);
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_segment15);

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

181: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment14);
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_segment15);
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_segment16);

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

185: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment15);
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_segment16);
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_segment17);

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

189: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment16);
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_segment17);
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_segment18);

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

193: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment17);
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_segment18);
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_segment19);

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

197: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment18);
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_segment19);
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_segment20);

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

201: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment19);
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_segment20);
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_segment21);

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

205: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment20);
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_segment21);
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_segment22);

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

209: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment21);
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_segment22);
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_segment23);

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

213: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment22);
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_segment23);
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_segment24);

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

217: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment23);
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_segment24);
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_segment25);

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

221: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment24);
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_segment25);
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_segment26);

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

225: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment25);
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_segment26);
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_segment27);

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

229: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment26);
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_segment27);
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_segment28);

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

233: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment27);
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_segment28);
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_segment29);

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

237: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment28);
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_segment29);
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_segment30);

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

241: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment29);
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_segment30);
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_people_group_name);

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

245: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment30);
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_people_group_name);
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||fnd_date.date_to_canonical(p_effective_start_date);

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

285: end if;
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_entries_changed_warning);
290: l_text:=l_text||'
';
291: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
292: l_text:='';
293: if(P_TAX_DISTRICT_CHANGED_WARNING) then

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

297: end if;
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_concat_segments);
302: l_text:=l_text||'
';
303: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
304: l_text:='';
305: --