DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_BEN dependencies on FND_NUMBER

Line 182: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);

178: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
179: l_text:=l_text||'';
180: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
181: l_text:='';
182: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
183: l_text:=l_text||'
';
184: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
185: l_text:='';
186: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);

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

182: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
183: l_text:=l_text||'';
184: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
185: l_text:='';
186: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
187: l_text:=l_text||'
';
188: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
189: l_text:='';
190: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);

Line 190: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);

186: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
187: l_text:=l_text||'';
188: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
189: l_text:='';
190: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
191: l_text:=l_text||'
';
192: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
193: l_text:='';
194: l_text:=l_text||irc_utilities_pkg.removeTags(p_assignment_number);

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

198: l_text:=l_text||irc_utilities_pkg.removeTags(p_assignment_category);
199: l_text:=l_text||'';
200: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
201: l_text:='';
202: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
203: l_text:=l_text||'
';
204: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
205: l_text:='';
206: l_text:=l_text||irc_utilities_pkg.removeTags(p_change_reason);

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

210: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
211: l_text:=l_text||'';
212: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
213: l_text:='';
214: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
215: l_text:=l_text||'
';
216: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
217: l_text:='';
218: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);

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

214: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
215: l_text:=l_text||'';
216: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
217: l_text:='';
218: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
219: l_text:=l_text||'
';
220: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
221: l_text:='';
222: l_text:=l_text||irc_utilities_pkg.removeTags(p_frequency);

Line 230: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);

226: l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_address_line);
227: l_text:=l_text||'';
228: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
229: l_text:='';
230: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
231: l_text:=l_text||'
';
232: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
233: l_text:='';
234: l_text:=l_text||irc_utilities_pkg.removeTags(p_labour_union_member_flag);

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

234: l_text:=l_text||irc_utilities_pkg.removeTags(p_labour_union_member_flag);
235: l_text:=l_text||'';
236: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
237: l_text:='';
238: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
239: l_text:=l_text||'
';
240: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
241: l_text:='';
242: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);

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

242: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);
243: l_text:=l_text||'';
244: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
245: l_text:='';
246: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
247: l_text:=l_text||'
';
248: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
249: l_text:='';
250: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);

Line 250: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);

246: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
247: l_text:=l_text||'';
248: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
249: l_text:='';
250: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
251: l_text:=l_text||'
';
252: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
253: l_text:='';
254: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);

Line 254: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);

250: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
251: l_text:=l_text||'';
252: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
253: l_text:='';
254: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
255: l_text:=l_text||'
';
256: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
257: l_text:='';
258: l_text:=l_text||irc_utilities_pkg.removeTags(p_project_title);

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

258: l_text:=l_text||irc_utilities_pkg.removeTags(p_project_title);
259: l_text:=l_text||'';
260: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
261: l_text:='';
262: l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);
263: l_text:=l_text||'
';
264: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
265: l_text:='';
266: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);

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

266: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);
267: l_text:=l_text||'';
268: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
269: l_text:='';
270: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
271: l_text:=l_text||'
';
272: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
273: l_text:='';
274: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_finish);

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

290: l_text:=l_text||irc_utilities_pkg.removeTags(p_vendor_employee_number);
291: l_text:=l_text||'';
292: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
293: l_text:='';
294: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_id);
295: l_text:=l_text||'
';
296: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
297: l_text:='';
298: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_site_id);

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

294: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_id);
295: l_text:=l_text||'';
296: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
297: l_text:='';
298: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_site_id);
299: l_text:=l_text||'
';
300: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
301: l_text:='';
302: l_text:=l_text||fnd_number.number_to_canonical(p_po_header_id);

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

298: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_site_id);
299: l_text:=l_text||'';
300: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
301: l_text:='';
302: l_text:=l_text||fnd_number.number_to_canonical(p_po_header_id);
303: l_text:=l_text||'
';
304: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
305: l_text:='';
306: l_text:=l_text||fnd_number.number_to_canonical(p_po_line_id);

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

302: l_text:=l_text||fnd_number.number_to_canonical(p_po_header_id);
303: l_text:=l_text||'';
304: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
305: l_text:='';
306: l_text:=l_text||fnd_number.number_to_canonical(p_po_line_id);
307: l_text:=l_text||'
';
308: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
309: l_text:='';
310: l_text:=l_text||fnd_date.date_to_canonical(p_projected_assignment_end);

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

682: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_concat_segments);
683: l_text:=l_text||'';
684: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
685: l_text:='';
686: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
687: l_text:=l_text||'
';
688: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
689: l_text:='';
690: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

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

686: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
687: l_text:=l_text||'';
688: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
689: l_text:='';
690: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
691: l_text:=l_text||'
';
692: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
693: l_text:='';
694: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);

Line 702: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);

698: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
699: l_text:=l_text||'';
700: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
701: l_text:='';
702: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
703: l_text:=l_text||'
';
704: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
705: l_text:='';
706: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);

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

702: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
703: l_text:=l_text||'';
704: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
705: l_text:='';
706: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
707: l_text:=l_text||'
';
708: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
709: l_text:='';
710: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);

Line 710: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);

706: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
707: l_text:=l_text||'';
708: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
709: l_text:='';
710: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
711: l_text:=l_text||'
';
712: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
713: l_text:='';
714: l_text:=l_text||irc_utilities_pkg.removeTags(p_people_group_name);

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

730: end if;
731: l_text:=l_text||'';
732: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
733: l_text:='';
734: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
735: l_text:=l_text||'
';
736: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
737: l_text:='';
738: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);

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

734: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
735: l_text:=l_text||'';
736: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
737: l_text:='';
738: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);
739: l_text:=l_text||'
';
740: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
741: l_text:='';
742: --