APPS.HR_PERSON_ABSENCE_BE1 dependencies on FND_NUMBER

Line 136: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);

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);
139: l_text:='';
140: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);

Line 140: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);

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);
143: l_text:='';
144: l_text:=l_text||fnd_number.number_to_canonical(p_absence_attendance_type_id);

Line 144: l_text:=l_text||fnd_number.number_to_canonical(p_absence_attendance_type_id);

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);
147: l_text:='';
148: l_text:=l_text||fnd_number.number_to_canonical(p_abs_attendance_reason_id);

Line 148: l_text:=l_text||fnd_number.number_to_canonical(p_abs_attendance_reason_id);

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);
151: l_text:='';
152: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);

Line 192: l_text:=l_text||fnd_number.number_to_canonical(p_absence_days);

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);
195: l_text:='';
196: l_text:=l_text||fnd_number.number_to_canonical(p_absence_hours);

Line 196: l_text:=l_text||fnd_number.number_to_canonical(p_absence_hours);

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);
199: l_text:='';
200: l_text:=l_text||fnd_number.number_to_canonical(p_authorising_person_id);

Line 200: l_text:=l_text||fnd_number.number_to_canonical(p_authorising_person_id);

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);
203: l_text:='';
204: l_text:=l_text||fnd_number.number_to_canonical(p_replacement_person_id);

Line 204: l_text:=l_text||fnd_number.number_to_canonical(p_replacement_person_id);

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);
207: l_text:='';
208: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);

Line 292: l_text:=l_text||fnd_number.number_to_canonical(p_occurrence);

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);
295: l_text:='';
296: l_text:=l_text||fnd_number.number_to_canonical(p_period_of_incapacity_id);

Line 296: l_text:=l_text||fnd_number.number_to_canonical(p_period_of_incapacity_id);

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);
299: l_text:='';
300: l_text:=l_text||irc_utilities_pkg.removeTags(p_ssp1_issued);

Line 304: l_text:=l_text||fnd_number.number_to_canonical(p_maternity_id);

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);
307: l_text:='';
308: l_text:=l_text||fnd_date.date_to_canonical(p_sickness_start_date);

Line 328: l_text:=l_text||fnd_number.number_to_canonical(p_linked_absence_id);

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);
331: l_text:='';
332: l_text:=l_text||fnd_number.number_to_canonical(p_batch_id);

Line 332: l_text:=l_text||fnd_number.number_to_canonical(p_batch_id);

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);
335: l_text:='';
336: if(P_CREATE_ELEMENT_ENTRY) then

Line 468: l_text:=l_text||fnd_number.number_to_canonical(p_absence_case_id);

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);
471: l_text:='';
472: l_text:=l_text||fnd_number.number_to_canonical(p_absence_attendance_id);

Line 472: l_text:=l_text||fnd_number.number_to_canonical(p_absence_attendance_id);

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);
475: l_text:='';
476: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

Line 476: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

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);
479: l_text:='';
480: if(P_DUR_DYS_LESS_WARNING) then