DBA Data[Home] [Help]

APPS.HR_PERSON_ABSENCE_BE2 dependencies on FND_NUMBER

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

128: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
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_absence_attendance_id);
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_object_version_number);

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

132: l_text:=l_text||fnd_number.number_to_canonical(p_absence_attendance_id);
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_object_version_number);
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_abs_attendance_reason_id);

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

136: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
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_abs_attendance_reason_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||irc_utilities_pkg.removeTags(p_comments);

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

180: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_end);
181: l_text:=l_text||'';
182: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
183: l_text:='';
184: l_text:=l_text||fnd_number.number_to_canonical(p_absence_days);
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||fnd_number.number_to_canonical(p_absence_hours);

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

184: l_text:=l_text||fnd_number.number_to_canonical(p_absence_days);
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||fnd_number.number_to_canonical(p_absence_hours);
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_authorising_person_id);

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

188: l_text:=l_text||fnd_number.number_to_canonical(p_absence_hours);
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_authorising_person_id);
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_replacement_person_id);

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

192: l_text:=l_text||fnd_number.number_to_canonical(p_authorising_person_id);
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_replacement_person_id);
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_attribute_category);

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

280: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute20);
281: l_text:=l_text||'';
282: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
283: l_text:='';
284: l_text:=l_text||fnd_number.number_to_canonical(p_period_of_incapacity_id);
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_ssp1_issued);

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

288: l_text:=l_text||irc_utilities_pkg.removeTags(p_ssp1_issued);
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_maternity_id);
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_date.date_to_canonical(p_sickness_start_date);

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

312: l_text:=l_text||irc_utilities_pkg.removeTags(p_accept_late_notification_fla);
313: l_text:=l_text||'';
314: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
315: l_text:='';
316: l_text:=l_text||fnd_number.number_to_canonical(p_linked_absence_id);
317: l_text:=l_text||'
';
318: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
319: l_text:='';
320: l_text:=l_text||fnd_number.number_to_canonical(p_batch_id);

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

316: l_text:=l_text||fnd_number.number_to_canonical(p_linked_absence_id);
317: l_text:=l_text||'';
318: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
319: l_text:='';
320: l_text:=l_text||fnd_number.number_to_canonical(p_batch_id);
321: l_text:=l_text||'
';
322: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
323: l_text:='';
324: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information_category);

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

444: l_text:=l_text||irc_utilities_pkg.removeTags(p_abs_information30);
445: l_text:=l_text||'';
446: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
447: l_text:='';
448: l_text:=l_text||fnd_number.number_to_canonical(p_absence_case_id);
449: l_text:=l_text||'
';
450: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
451: l_text:='';
452: if(P_DUR_DYS_LESS_WARNING) then