APPS.IRC_NOTIFICATION_PREFS_BE1 dependencies on FND_NUMBER

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

77: l_text:='';
78: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
79: --
80: l_text:='';
81: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
82: l_text:=l_text||'';
83: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
84: l_text:='';
85: l_text:=l_text||fnd_number.number_to_canonical(p_notification_preference_id);

Line 85: l_text:=l_text||fnd_number.number_to_canonical(p_notification_preference_id);

81: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
82: l_text:=l_text||'';
83: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
84: l_text:='';
85: l_text:=l_text||fnd_number.number_to_canonical(p_notification_preference_id);
86: l_text:=l_text||'';
87: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
88: l_text:='';
89: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);

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

89: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
90: l_text:=l_text||'';
91: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
92: l_text:='';
93: l_text:=l_text||fnd_number.number_to_canonical(p_address_id);
94: l_text:=l_text||'';
95: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
96: l_text:='';
97: l_text:=l_text||irc_utilities_pkg.removeTags(p_matching_jobs);

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

109: l_text:=l_text||irc_utilities_pkg.removeTags(p_receive_info_mail);
110: l_text:=l_text||'';
111: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
112: l_text:='';
113: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
114: l_text:=l_text||'';
115: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
116: l_text:='';
117: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);

Line 241: l_text:=l_text||fnd_number.number_to_canonical(p_agency_id);

237: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute30);
238: l_text:=l_text||'';
239: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
240: l_text:='';
241: l_text:=l_text||fnd_number.number_to_canonical(p_agency_id);
242: l_text:=l_text||'';
243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
244: l_text:='';
245: l_text:=l_text||fnd_number.number_to_canonical(p_attempt_id);

Line 245: l_text:=l_text||fnd_number.number_to_canonical(p_attempt_id);

241: l_text:=l_text||fnd_number.number_to_canonical(p_agency_id);
242: l_text:=l_text||'';
243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
244: l_text:='';
245: l_text:=l_text||fnd_number.number_to_canonical(p_attempt_id);
246: l_text:=l_text||'';
247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
248: l_text:='';
249: --