APPS.HR_ASSIGNMENT_BEM dependencies on FND_DATE

Line 140: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);

136: l_text:='';
137: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
138: --
139: l_text:='';
140: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
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_datetrack_update_mode);

Line 252: l_text:=l_text||fnd_date.date_to_canonical(p_projected_assignment_end);

248: l_text:=l_text||fnd_number.number_to_canonical(p_po_line_id);
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||fnd_date.date_to_canonical(p_projected_assignment_end);
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||fnd_number.number_to_canonical(p_assignment_status_type_id);

Line 512: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);

508: end if;
509: l_text:=l_text||'';
510: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
511: l_text:='';
512: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
513: l_text:=l_text||'';
514: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
515: l_text:='';
516: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);

Line 516: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);

512: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
513: l_text:=l_text||'';
514: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
515: l_text:='';
516: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
517: l_text:=l_text||'';
518: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
519: l_text:='';
520: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);