APPS.OTA_CERT_ENROLLMENT_BE1 dependencies on FND_DATE

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

69: l_text:='';
70: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
71: --
72: l_text:='';
73: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
74: l_text:=l_text||'';
75: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
76: l_text:='';
77: l_text:=l_text||fnd_number.number_to_canonical(p_cert_enrollment_id);

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

93: l_text:=l_text||irc_utilities_pkg.removeTags(p_certification_status_code);
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_completion_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||fnd_date.date_to_canonical(p_unenrollment_date);

Line 101: l_text:=l_text||fnd_date.date_to_canonical(p_unenrollment_date);

97: l_text:=l_text||fnd_date.date_to_canonical(p_completion_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||fnd_date.date_to_canonical(p_unenrollment_date);
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_expiration_date);

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

101: l_text:=l_text||fnd_date.date_to_canonical(p_unenrollment_date);
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_expiration_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||fnd_date.date_to_canonical(p_earliest_enroll_date);

Line 109: l_text:=l_text||fnd_date.date_to_canonical(p_earliest_enroll_date);

105: l_text:=l_text||fnd_date.date_to_canonical(p_expiration_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||fnd_date.date_to_canonical(p_earliest_enroll_date);
110: l_text:=l_text||'';
111: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
112: l_text:='';
113: l_text:=l_text||irc_utilities_pkg.removeTags(p_is_history_flag);

Line 205: l_text:=l_text||fnd_date.date_to_canonical(p_enrollment_date);

201: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute20);
202: l_text:=l_text||'';
203: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
204: l_text:='';
205: l_text:=l_text||fnd_date.date_to_canonical(p_enrollment_date);
206: l_text:=l_text||'';
207: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
208: l_text:='';
209: --