APPS.HR_COMPETENCE_ELEMENT_BE5 dependencies on FND_DATE

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

64: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
65: l_text:=l_text||'';
66: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
67: l_text:='';
68: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_from);
69: l_text:=l_text||'';
70: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
71: l_text:='';
72: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_to);

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

68: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_from);
69: l_text:=l_text||'';
70: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
71: l_text:='';
72: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_to);
73: l_text:=l_text||'';
74: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
75: l_text:='';
76: l_text:=l_text||fnd_date.date_to_canonical(p_certification_date);

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

72: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_to);
73: l_text:=l_text||'';
74: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
75: l_text:='';
76: l_text:=l_text||fnd_date.date_to_canonical(p_certification_date);
77: l_text:=l_text||'';
78: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
79: l_text:='';
80: l_text:=l_text||irc_utilities_pkg.removeTags(p_certification_method);

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

80: l_text:=l_text||irc_utilities_pkg.removeTags(p_certification_method);
81: l_text:=l_text||'';
82: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
83: l_text:='';
84: l_text:=l_text||fnd_date.date_to_canonical(p_next_certification_date);
85: l_text:=l_text||'';
86: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
87: l_text:='';
88: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_of_proficiency_level);

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

92: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
93: l_text:=l_text||'';
94: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
95: l_text:='';
96: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
97: l_text:=l_text||'';
98: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
99: l_text:='';
100: l_text:=l_text||fnd_number.number_to_canonical(p_competence_created);