APPS.IRC_SEARCH_CRITERIA_BE2 dependencies on FND_NUMBER

Line 135: l_text:=l_text||fnd_number.number_to_canonical(p_search_criteria_id);

131: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
132: l_text:=l_text||'';
133: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
134: l_text:='';
135: l_text:=l_text||fnd_number.number_to_canonical(p_search_criteria_id);
136: l_text:=l_text||'';
137: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
138: l_text:='';
139: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);

Line 139: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);

135: l_text:=l_text||fnd_number.number_to_canonical(p_search_criteria_id);
136: l_text:=l_text||'';
137: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
138: l_text:='';
139: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
140: l_text:=l_text||'';
141: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
142: l_text:='';
143: l_text:=l_text||irc_utilities_pkg.removeTags(p_search_name);

Line 167: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);

163: l_text:=l_text||irc_utilities_pkg.removeTags(p_derived_location);
164: l_text:=l_text||'';
165: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
166: l_text:='';
167: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
168: l_text:=l_text||'';
169: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
170: l_text:='';
171: l_text:=l_text||fnd_number.number_to_canonical(p_longitude);

Line 171: l_text:=l_text||fnd_number.number_to_canonical(p_longitude);

167: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
168: l_text:=l_text||'';
169: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
170: l_text:='';
171: l_text:=l_text||fnd_number.number_to_canonical(p_longitude);
172: l_text:=l_text||'';
173: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
174: l_text:='';
175: l_text:=l_text||fnd_number.number_to_canonical(p_latitude);

Line 175: l_text:=l_text||fnd_number.number_to_canonical(p_latitude);

171: l_text:=l_text||fnd_number.number_to_canonical(p_longitude);
172: l_text:=l_text||'';
173: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
174: l_text:='';
175: l_text:=l_text||fnd_number.number_to_canonical(p_latitude);
176: l_text:=l_text||'';
177: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
178: l_text:='';
179: l_text:=l_text||irc_utilities_pkg.removeTags(p_employee);

Line 195: l_text:=l_text||fnd_number.number_to_canonical(p_travel_percentage);

191: l_text:=l_text||irc_utilities_pkg.removeTags(p_keywords);
192: l_text:=l_text||'';
193: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
194: l_text:='';
195: l_text:=l_text||fnd_number.number_to_canonical(p_travel_percentage);
196: l_text:=l_text||'';
197: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
198: l_text:='';
199: l_text:=l_text||fnd_number.number_to_canonical(p_min_salary);

Line 199: l_text:=l_text||fnd_number.number_to_canonical(p_min_salary);

195: l_text:=l_text||fnd_number.number_to_canonical(p_travel_percentage);
196: l_text:=l_text||'';
197: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
198: l_text:='';
199: l_text:=l_text||fnd_number.number_to_canonical(p_min_salary);
200: l_text:=l_text||'';
201: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
202: l_text:='';
203: l_text:=l_text||irc_utilities_pkg.removeTags(p_salary_currency);

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

491: l_text:=l_text||irc_utilities_pkg.removeTags(p_date_posted);
492: l_text:=l_text||'';
493: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
494: l_text:='';
495: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
496: l_text:=l_text||'';
497: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
498: l_text:='';
499: --