DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_BEM dependencies on FND_NUMBER

Line 148: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);

144: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
145: l_text:=l_text||'';
146: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
147: l_text:='';
148: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
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_object_version_number);

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

148: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
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_object_version_number);
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||irc_utilities_pkg.removeTags(p_assignment_category);

Line 172: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);

168: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
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||fnd_number.number_to_canonical(p_default_code_comb_id);
173: l_text:=l_text||'
';
174: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
175: l_text:='';
176: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);

Line 176: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);

172: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
173: l_text:=l_text||'';
174: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
175: l_text:='';
176: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
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||irc_utilities_pkg.removeTags(p_frequency);

Line 196: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);

192: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);
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||fnd_number.number_to_canonical(p_normal_hours);
197: l_text:=l_text||'
';
198: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
199: l_text:='';
200: l_text:=l_text||irc_utilities_pkg.removeTags(p_project_title);

Line 204: l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);

200: l_text:=l_text||irc_utilities_pkg.removeTags(p_project_title);
201: l_text:=l_text||'';
202: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
203: l_text:='';
204: l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);
205: l_text:=l_text||'
';
206: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
207: l_text:='';
208: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);

Line 212: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);

208: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);
209: l_text:=l_text||'';
210: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
211: l_text:='';
212: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
213: l_text:=l_text||'
';
214: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
215: l_text:='';
216: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_finish);

Line 236: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_id);

232: l_text:=l_text||irc_utilities_pkg.removeTags(p_vendor_employee_number);
233: l_text:=l_text||'';
234: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
235: l_text:='';
236: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_id);
237: l_text:=l_text||'
';
238: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
239: l_text:='';
240: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_site_id);

Line 240: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_site_id);

236: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_id);
237: l_text:=l_text||'';
238: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
239: l_text:='';
240: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_site_id);
241: l_text:=l_text||'
';
242: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
243: l_text:='';
244: l_text:=l_text||fnd_number.number_to_canonical(p_po_header_id);

Line 244: l_text:=l_text||fnd_number.number_to_canonical(p_po_header_id);

240: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_site_id);
241: l_text:=l_text||'';
242: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
243: l_text:='';
244: l_text:=l_text||fnd_number.number_to_canonical(p_po_header_id);
245: l_text:=l_text||'
';
246: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
247: l_text:='';
248: l_text:=l_text||fnd_number.number_to_canonical(p_po_line_id);

Line 248: l_text:=l_text||fnd_number.number_to_canonical(p_po_line_id);

244: l_text:=l_text||fnd_number.number_to_canonical(p_po_header_id);
245: l_text:=l_text||'';
246: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
247: l_text:='';
248: l_text:=l_text||fnd_number.number_to_canonical(p_po_line_id);
249: l_text:=l_text||'
';
250: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
251: l_text:='';
252: l_text:=l_text||fnd_date.date_to_canonical(p_projected_assignment_end);

Line 256: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);

252: l_text:=l_text||fnd_date.date_to_canonical(p_projected_assignment_end);
253: l_text:=l_text||'';
254: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
255: l_text:='';
256: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
257: l_text:=l_text||'
';
258: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
259: l_text:='';
260: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);

Line 520: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);

516: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
517: l_text:=l_text||'';
518: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
519: l_text:='';
520: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
521: l_text:=l_text||'
';
522: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
523: l_text:='';
524: if(P_NO_MANAGERS_WARNING) then

Line 540: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);

536: end if;
537: l_text:=l_text||'';
538: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
539: l_text:='';
540: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
541: l_text:=l_text||'
';
542: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
543: l_text:='';
544: l_text:=l_text||irc_utilities_pkg.removeTags(p_concatenated_segments);

Line 556: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);

552: end if;
553: l_text:=l_text||'';
554: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
555: l_text:='';
556: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);
557: l_text:=l_text||'
';
558: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
559: l_text:='';
560: --