APPS.IRC_OFFERS_BE2 dependencies on FND_NUMBER

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

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);
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_number.number_to_canonical(p_offer_version);

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

94: l_text:=l_text||fnd_number.number_to_canonical(p_offer_id);
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_number.number_to_canonical(p_offer_version);
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||irc_utilities_pkg.removeTags(p_latest_offer);

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

114: l_text:=l_text||irc_utilities_pkg.removeTags(p_offer_extended_method);
115: l_text:=l_text||'';
116: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
117: l_text:='';
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);

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

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);
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_offer_assignment_id);

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

142: l_text:=l_text||fnd_number.number_to_canonical(p_applicant_assignment_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_offer_assignment_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||fnd_number.number_to_canonical(p_address_id);

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

146: l_text:=l_text||fnd_number.number_to_canonical(p_offer_assignment_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||fnd_number.number_to_canonical(p_address_id);
151: l_text:=l_text||'';
152: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
153: l_text:='';
154: l_text:=l_text||fnd_number.number_to_canonical(p_template_id);

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

150: l_text:=l_text||fnd_number.number_to_canonical(p_address_id);
151: l_text:=l_text||'';
152: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
153: l_text:='';
154: l_text:=l_text||fnd_number.number_to_canonical(p_template_id);
155: l_text:=l_text||'';
156: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
157: l_text:='';
158: l_text:=l_text||irc_utilities_pkg.removeTags(p_offer_letter_file_type);

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

286: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute30);
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: --