APPS.IRC_OFFERS_BE2 dependencies on FND_DATE

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

86: l_text:='';
87: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
88: --
89: l_text:='';
90: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
91: l_text:=l_text||'';
92: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
93: l_text:='';
94: l_text:=l_text||fnd_number.number_to_canonical(p_offer_id);

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

118: l_text:=l_text||fnd_number.number_to_canonical(p_respondent_id);
119: l_text:=l_text||'';
120: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
121: l_text:='';
122: l_text:=l_text||fnd_date.date_to_canonical(p_expiry_date);
123: l_text:=l_text||'';
124: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
125: l_text:='';
126: l_text:=l_text||fnd_date.date_to_canonical(p_proposed_start_date);

Line 126: l_text:=l_text||fnd_date.date_to_canonical(p_proposed_start_date);

122: l_text:=l_text||fnd_date.date_to_canonical(p_expiry_date);
123: l_text:=l_text||'';
124: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
125: l_text:='';
126: l_text:=l_text||fnd_date.date_to_canonical(p_proposed_start_date);
127: l_text:=l_text||'';
128: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
129: l_text:='';
130: l_text:=l_text||irc_utilities_pkg.removeTags(p_offer_letter_tracking_code);

Line 138: l_text:=l_text||fnd_date.date_to_canonical(p_offer_shipping_date);

134: l_text:=l_text||irc_utilities_pkg.removeTags(p_offer_postal_service);
135: l_text:=l_text||'';
136: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
137: l_text:='';
138: l_text:=l_text||fnd_date.date_to_canonical(p_offer_shipping_date);
139: l_text:=l_text||'';
140: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
141: l_text:='';
142: l_text:=l_text||fnd_number.number_to_canonical(p_applicant_assignment_id);