APPS.IRC_OFFERS_BE1 dependencies on FND_NUMBER

Line 110: l_text:=l_text||fnd_number.number_to_canonical(p_respondent_id);

106: l_text:=l_text||irc_utilities_pkg.removeTags(p_offer_extended_method);
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_number.number_to_canonical(p_respondent_id);
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||fnd_date.date_to_canonical(p_expiry_date);

Line 134: l_text:=l_text||fnd_number.number_to_canonical(p_applicant_assignment_id);

130: l_text:=l_text||fnd_date.date_to_canonical(p_offer_shipping_date);
131: l_text:=l_text||'';
132: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
133: l_text:='';
134: l_text:=l_text||fnd_number.number_to_canonical(p_applicant_assignment_id);
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_number.number_to_canonical(p_offer_assignment_id);

Line 138: l_text:=l_text||fnd_number.number_to_canonical(p_offer_assignment_id);

134: l_text:=l_text||fnd_number.number_to_canonical(p_applicant_assignment_id);
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_number.number_to_canonical(p_offer_assignment_id);
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_address_id);

Line 142: l_text:=l_text||fnd_number.number_to_canonical(p_address_id);

138: l_text:=l_text||fnd_number.number_to_canonical(p_offer_assignment_id);
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_address_id);
143: l_text:=l_text||'';
144: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
145: l_text:='';
146: l_text:=l_text||fnd_number.number_to_canonical(p_template_id);

Line 146: l_text:=l_text||fnd_number.number_to_canonical(p_template_id);

142: l_text:=l_text||fnd_number.number_to_canonical(p_address_id);
143: l_text:=l_text||'';
144: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
145: l_text:='';
146: l_text:=l_text||fnd_number.number_to_canonical(p_template_id);
147: l_text:=l_text||'';
148: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
149: l_text:='';
150: l_text:=l_text||irc_utilities_pkg.removeTags(p_offer_letter_file_type);

Line 282: l_text:=l_text||fnd_number.number_to_canonical(p_offer_id);

278: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute30);
279: l_text:=l_text||'';
280: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
281: l_text:='';
282: l_text:=l_text||fnd_number.number_to_canonical(p_offer_id);
283: l_text:=l_text||'';
284: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
285: l_text:='';
286: l_text:=l_text||fnd_number.number_to_canonical(p_offer_version);

Line 286: l_text:=l_text||fnd_number.number_to_canonical(p_offer_version);

282: l_text:=l_text||fnd_number.number_to_canonical(p_offer_id);
283: l_text:=l_text||'';
284: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
285: l_text:='';
286: l_text:=l_text||fnd_number.number_to_canonical(p_offer_version);
287: l_text:=l_text||'';
288: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
289: l_text:='';
290: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

Line 290: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

286: l_text:=l_text||fnd_number.number_to_canonical(p_offer_version);
287: l_text:=l_text||'';
288: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
289: l_text:='';
290: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
291: l_text:=l_text||'';
292: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
293: l_text:='';
294: --