APPS.PER_QUALIFICATIONS_BE2 dependencies on FND_DATE

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

107: l_text:='';
108: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
109: --
110: l_text:='';
111: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
112: l_text:=l_text||'';
113: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
114: l_text:='';
115: l_text:=l_text||fnd_number.number_to_canonical(p_qualification_id);

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

131: l_text:=l_text||irc_utilities_pkg.removeTags(p_status);
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_awarded_date);
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_number.number_to_canonical(p_fee);

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

159: l_text:=l_text||fnd_number.number_to_canonical(p_total_training_amount);
160: l_text:=l_text||'';
161: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
162: l_text:='';
163: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);
164: l_text:=l_text||'';
165: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
166: l_text:='';
167: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);

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

163: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);
164: l_text:=l_text||'';
165: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
166: l_text:='';
167: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);
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||irc_utilities_pkg.removeTags(p_license_number);

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

171: l_text:=l_text||irc_utilities_pkg.removeTags(p_license_number);
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||fnd_date.date_to_canonical(p_expiry_date);
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||irc_utilities_pkg.removeTags(p_license_restrictions);

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

179: l_text:=l_text||irc_utilities_pkg.removeTags(p_license_restrictions);
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||fnd_date.date_to_canonical(p_projected_completion_date);
184: l_text:=l_text||'';
185: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
186: l_text:='';
187: l_text:=l_text||irc_utilities_pkg.removeTags(p_awarding_body);