APPS.IRC_SEARCH_CRITERIA_BE7 dependencies on FND_NUMBER

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

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

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

132: l_text:=l_text||fnd_number.number_to_canonical(p_search_criteria_id);
133: l_text:=l_text||'';
134: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
135: l_text:='';
136: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
137: l_text:=l_text||'';
138: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
139: l_text:='';
140: l_text:=l_text||irc_utilities_pkg.removeTags(p_location);

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

156: l_text:=l_text||irc_utilities_pkg.removeTags(p_derived_location);
157: l_text:=l_text||'';
158: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
159: l_text:='';
160: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
161: l_text:=l_text||'';
162: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
163: l_text:='';
164: l_text:=l_text||fnd_number.number_to_canonical(p_longitude);

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

160: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
161: l_text:=l_text||'';
162: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
163: l_text:='';
164: l_text:=l_text||fnd_number.number_to_canonical(p_longitude);
165: l_text:=l_text||'';
166: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
167: l_text:='';
168: l_text:=l_text||fnd_number.number_to_canonical(p_latitude);

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

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

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

184: l_text:=l_text||irc_utilities_pkg.removeTags(p_keywords);
185: l_text:=l_text||'';
186: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
187: l_text:='';
188: l_text:=l_text||fnd_number.number_to_canonical(p_travel_percentage);
189: l_text:=l_text||'';
190: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
191: l_text:='';
192: l_text:=l_text||fnd_number.number_to_canonical(p_min_salary);

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

188: l_text:=l_text||fnd_number.number_to_canonical(p_travel_percentage);
189: l_text:=l_text||'';
190: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
191: l_text:='';
192: l_text:=l_text||fnd_number.number_to_canonical(p_min_salary);
193: l_text:=l_text||'';
194: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
195: l_text:='';
196: l_text:=l_text||irc_utilities_pkg.removeTags(p_salary_currency);

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

476: l_text:=l_text||irc_utilities_pkg.removeTags(p_isc_information30);
477: l_text:=l_text||'';
478: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
479: l_text:='';
480: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
481: l_text:=l_text||'';
482: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
483: l_text:='';
484: --