APPS.HR_COMPETENCE_ELEMENT_BE3 dependencies on FND_DATE

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

81: l_text:=l_text||fnd_number.number_to_canonical(p_proficiency_level_id);
82: l_text:=l_text||'';
83: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
84: l_text:='';
85: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_from);
86: l_text:=l_text||'';
87: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
88: l_text:='';
89: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_to);

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

85: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_from);
86: l_text:=l_text||'';
87: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
88: l_text:='';
89: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_to);
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_source_of_proficiency_level);

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

93: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_of_proficiency_level);
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_date.date_to_canonical(p_certification_date);
98: l_text:=l_text||'';
99: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
100: l_text:='';
101: l_text:=l_text||irc_utilities_pkg.removeTags(p_certification_method);

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

101: l_text:=l_text||irc_utilities_pkg.removeTags(p_certification_method);
102: l_text:=l_text||'';
103: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
104: l_text:='';
105: l_text:=l_text||fnd_date.date_to_canonical(p_next_certification_date);
106: l_text:=l_text||'';
107: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
108: l_text:='';
109: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);

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

193: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute20);
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||fnd_date.date_to_canonical(p_effective_date);
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||fnd_number.number_to_canonical(p_ins_ovn);