APPS.IRC_PENDING_DATA_BE1 dependencies on FND_NUMBER

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

96: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);
97: l_text:=l_text||'';
98: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
99: l_text:='';
100: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
101: l_text:=l_text||'';
102: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
103: l_text:='';
104: l_text:=l_text||irc_utilities_pkg.removeTags(p_first_name);

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

128: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);
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_posting_content_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_posting_content_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_processed);

Line 296: l_text:=l_text||fnd_number.number_to_canonical(p_visitor_resp_appl_id);

292: l_text:=l_text||irc_utilities_pkg.removeTags(p_visitor_resp_key);
293: l_text:=l_text||'';
294: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
295: l_text:='';
296: l_text:=l_text||fnd_number.number_to_canonical(p_visitor_resp_appl_id);
297: l_text:=l_text||'';
298: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
299: l_text:='';
300: l_text:=l_text||irc_utilities_pkg.removeTags(p_security_group_key);