APPS.HR_SIT_BE1 dependencies on FND_DATE

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

113: l_text:=l_text||fnd_number.number_to_canonical(p_id_flex_num);
114: l_text:=l_text||'';
115: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
116: l_text:='';
117: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
118: l_text:=l_text||'';
119: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
120: l_text:='';
121: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);

Line 125: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);

121: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
122: l_text:=l_text||'';
123: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
124: l_text:='';
125: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);
126: l_text:=l_text||'';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='';
129: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);

Line 129: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);

125: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);
126: l_text:=l_text||'';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='';
129: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);
130: l_text:=l_text||'';
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: l_text:='';
133: l_text:=l_text||fnd_number.number_to_canonical(p_request_id);

Line 145: l_text:=l_text||fnd_date.date_to_canonical(p_program_update_date);

141: l_text:=l_text||fnd_number.number_to_canonical(p_program_id);
142: l_text:=l_text||'';
143: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
144: l_text:='';
145: l_text:=l_text||fnd_date.date_to_canonical(p_program_update_date);
146: l_text:=l_text||'';
147: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
148: l_text:='';
149: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);