APPS.IRC_SEARCH_CRITERIA_BE4 dependencies on FND_NUMBER

Line 120: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);

116: l_text:='';
117: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
118: --
119: l_text:='';
120: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
121: l_text:=l_text||'';
122: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
123: l_text:='';
124: l_text:=l_text||fnd_number.number_to_canonical(p_search_criteria_id);

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

120: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
121: l_text:=l_text||'';
122: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
123: l_text:='';
124: l_text:=l_text||fnd_number.number_to_canonical(p_search_criteria_id);
125: l_text:=l_text||'';
126: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
127: l_text:='';
128: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);

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

148: l_text:=l_text||irc_utilities_pkg.removeTags(p_keywords);
149: l_text:=l_text||'';
150: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
151: l_text:='';
152: l_text:=l_text||fnd_number.number_to_canonical(p_travel_percentage);
153: l_text:=l_text||'';
154: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
155: l_text:='';
156: l_text:=l_text||fnd_number.number_to_canonical(p_min_salary);

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

152: l_text:=l_text||fnd_number.number_to_canonical(p_travel_percentage);
153: l_text:=l_text||'';
154: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
155: l_text:='';
156: l_text:=l_text||fnd_number.number_to_canonical(p_min_salary);
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_max_salary);

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

156: l_text:=l_text||fnd_number.number_to_canonical(p_min_salary);
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_max_salary);
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||irc_utilities_pkg.removeTags(p_salary_currency);

Line 180: l_text:=l_text||fnd_number.number_to_canonical(p_min_qual_level);

176: l_text:=l_text||irc_utilities_pkg.removeTags(p_work_at_home);
177: l_text:=l_text||'';
178: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
179: l_text:='';
180: l_text:=l_text||fnd_number.number_to_canonical(p_min_qual_level);
181: l_text:=l_text||'';
182: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
183: l_text:='';
184: l_text:=l_text||fnd_number.number_to_canonical(p_max_qual_level);

Line 184: l_text:=l_text||fnd_number.number_to_canonical(p_max_qual_level);

180: l_text:=l_text||fnd_number.number_to_canonical(p_min_qual_level);
181: l_text:=l_text||'';
182: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
183: l_text:='';
184: l_text:=l_text||fnd_number.number_to_canonical(p_max_qual_level);
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||irc_utilities_pkg.removeTags(p_description);

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

436: l_text:=l_text||irc_utilities_pkg.removeTags(p_isc_information30);
437: l_text:=l_text||'';
438: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
439: l_text:='';
440: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
441: l_text:=l_text||'';
442: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
443: l_text:='';
444: --