APPS.PER_QUALIFICATIONS_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_qualification_id);
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||fnd_number.number_to_canonical(p_business_group_id);

Line 149: l_text:=l_text||fnd_date.date_to_canonical(p_awarded_date);

145: l_text:=l_text||irc_utilities_pkg.removeTags(p_status);
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||fnd_date.date_to_canonical(p_awarded_date);
150: l_text:=l_text||'';
151: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
152: l_text:='';
153: l_text:=l_text||fnd_number.number_to_canonical(p_fee);

Line 177: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);

173: l_text:=l_text||fnd_number.number_to_canonical(p_total_training_amount);
174: l_text:=l_text||'';
175: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
176: l_text:='';
177: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);
178: l_text:=l_text||'';
179: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
180: l_text:='';
181: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);

Line 181: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);

177: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);
178: l_text:=l_text||'';
179: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
180: l_text:='';
181: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);
182: l_text:=l_text||'';
183: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
184: l_text:='';
185: l_text:=l_text||irc_utilities_pkg.removeTags(p_license_number);

Line 189: l_text:=l_text||fnd_date.date_to_canonical(p_expiry_date);

185: l_text:=l_text||irc_utilities_pkg.removeTags(p_license_number);
186: l_text:=l_text||'';
187: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
188: l_text:='';
189: l_text:=l_text||fnd_date.date_to_canonical(p_expiry_date);
190: l_text:=l_text||'';
191: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
192: l_text:='';
193: l_text:=l_text||irc_utilities_pkg.removeTags(p_license_restrictions);

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

193: l_text:=l_text||irc_utilities_pkg.removeTags(p_license_restrictions);
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_projected_completion_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||irc_utilities_pkg.removeTags(p_awarding_body);