APPS.OTA_CERT_ENROLLMENT_BE1 dependencies on FND_DATE

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

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

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

94: l_text:=l_text||irc_utilities_pkg.removeTags(p_certification_status_code);
95: l_text:=l_text||'';
96: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
97: l_text:='';
98: l_text:=l_text||fnd_date.date_to_canonical(p_completion_date);
99: l_text:=l_text||'';
100: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
101: l_text:='';
102: l_text:=l_text||fnd_date.date_to_canonical(p_unenrollment_date);

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

98: l_text:=l_text||fnd_date.date_to_canonical(p_completion_date);
99: l_text:=l_text||'';
100: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
101: l_text:='';
102: l_text:=l_text||fnd_date.date_to_canonical(p_unenrollment_date);
103: l_text:=l_text||'';
104: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
105: l_text:='';
106: l_text:=l_text||fnd_date.date_to_canonical(p_expiration_date);

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

102: l_text:=l_text||fnd_date.date_to_canonical(p_unenrollment_date);
103: l_text:=l_text||'';
104: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
105: l_text:='';
106: l_text:=l_text||fnd_date.date_to_canonical(p_expiration_date);
107: l_text:=l_text||'';
108: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
109: l_text:='';
110: l_text:=l_text||fnd_date.date_to_canonical(p_earliest_enroll_date);

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

106: l_text:=l_text||fnd_date.date_to_canonical(p_expiration_date);
107: l_text:=l_text||'';
108: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
109: l_text:='';
110: l_text:=l_text||fnd_date.date_to_canonical(p_earliest_enroll_date);
111: l_text:=l_text||'';
112: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
113: l_text:='';
114: l_text:=l_text||irc_utilities_pkg.removeTags(p_is_history_flag);

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

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