APPS.HR_COMPETENCE_ELEMENT_BE2 dependencies on FND_DATE

Line 135: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_from);

131: l_text:=l_text||irc_utilities_pkg.removeTags(p_mandatory);
132: l_text:=l_text||'';
133: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
134: l_text:='';
135: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_from);
136: l_text:=l_text||'';
137: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
138: l_text:='';
139: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_to);

Line 139: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_to);

135: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_from);
136: l_text:=l_text||'';
137: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
138: l_text:='';
139: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_to);
140: l_text:=l_text||'';
141: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
142: l_text:='';
143: l_text:=l_text||irc_utilities_pkg.removeTags(p_group_competence_type);

Line 171: l_text:=l_text||fnd_date.date_to_canonical(p_certification_date);

167: l_text:=l_text||fnd_number.number_to_canonical(p_line_score);
168: l_text:=l_text||'';
169: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
170: l_text:='';
171: l_text:=l_text||fnd_date.date_to_canonical(p_certification_date);
172: l_text:=l_text||'';
173: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
174: l_text:='';
175: l_text:=l_text||irc_utilities_pkg.removeTags(p_certification_method);

Line 179: l_text:=l_text||fnd_date.date_to_canonical(p_next_certification_date);

175: l_text:=l_text||irc_utilities_pkg.removeTags(p_certification_method);
176: l_text:=l_text||'';
177: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
178: l_text:='';
179: l_text:=l_text||fnd_date.date_to_canonical(p_next_certification_date);
180: l_text:=l_text||'';
181: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
182: l_text:='';
183: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);

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

267: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute20);
268: l_text:=l_text||'';
269: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
270: l_text:='';
271: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
272: l_text:=l_text||'';
273: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
274: l_text:='';
275: l_text:=l_text||fnd_number.number_to_canonical(p_qualification_type_id);

Line 371: l_text:=l_text||fnd_date.date_to_canonical(p_achieved_date);

367: l_text:=l_text||irc_utilities_pkg.removeTags(p_information20);
368: l_text:=l_text||'';
369: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
370: l_text:='';
371: l_text:=l_text||fnd_date.date_to_canonical(p_achieved_date);
372: l_text:=l_text||'';
373: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
374: l_text:='';
375: l_text:=l_text||fnd_number.number_to_canonical(p_appr_line_score);