DBA Data[Home] [Help]

APPS.HR_CONTINGENT_WORKER_BE1 dependencies on FND_NUMBER

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

169: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);
170: l_text:=l_text||'';
171: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
172: l_text:='';
173: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
174: l_text:=l_text||'
';
175: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
176: l_text:='';
177: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);

Line 181: l_text:=l_text||fnd_number.number_to_canonical(p_person_type_id);

177: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);
178: l_text:=l_text||'';
179: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
180: l_text:='';
181: l_text:=l_text||fnd_number.number_to_canonical(p_person_type_id);
182: l_text:=l_text||'
';
183: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
184: l_text:='';
185: l_text:=l_text||irc_utilities_pkg.removeTags(p_npw_number);

Line 237: l_text:=l_text||fnd_number.number_to_canonical(p_fte_capacity);

233: l_text:=l_text||irc_utilities_pkg.removeTags(p_first_name);
234: l_text:=l_text||'';
235: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
236: l_text:='';
237: l_text:=l_text||fnd_number.number_to_canonical(p_fte_capacity);
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||irc_utilities_pkg.removeTags(p_honors);

Line 289: l_text:=l_text||fnd_number.number_to_canonical(p_party_id);

285: l_text:=l_text||irc_utilities_pkg.removeTags(p_on_military_service);
286: l_text:=l_text||'';
287: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
288: l_text:='';
289: l_text:=l_text||fnd_number.number_to_canonical(p_party_id);
290: l_text:=l_text||'
';
291: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
292: l_text:='';
293: l_text:=l_text||irc_utilities_pkg.removeTags(p_pre_name_adjunct);

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

349: l_text:=l_text||irc_utilities_pkg.removeTags(p_uses_tobacco_flag);
350: l_text:=l_text||'';
351: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
352: l_text:='';
353: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_id);
354: l_text:=l_text||'
';
355: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
356: l_text:='';
357: l_text:=l_text||irc_utilities_pkg.removeTags(p_work_schedule);

Line 377: l_text:=l_text||fnd_number.number_to_canonical(p_benefit_group_id);

373: l_text:=l_text||fnd_date.date_to_canonical(p_date_employee_data_verified);
374: l_text:=l_text||'';
375: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
376: l_text:='';
377: l_text:=l_text||fnd_number.number_to_canonical(p_benefit_group_id);
378: l_text:=l_text||'
';
379: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
380: l_text:='';
381: l_text:=l_text||irc_utilities_pkg.removeTags(p_coord_ben_med_pln_no);

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

637: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information30);
638: l_text:=l_text||'';
639: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
640: l_text:='';
641: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
642: l_text:=l_text||'
';
643: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
644: l_text:='';
645: l_text:=l_text||fnd_number.number_to_canonical(p_per_object_version_number);

Line 645: l_text:=l_text||fnd_number.number_to_canonical(p_per_object_version_number);

641: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
642: l_text:=l_text||'';
643: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
644: l_text:='';
645: l_text:=l_text||fnd_number.number_to_canonical(p_per_object_version_number);
646: l_text:=l_text||'
';
647: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
648: l_text:='';
649: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_date);

Line 657: l_text:=l_text||fnd_number.number_to_canonical(p_pdp_object_version_number);

653: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_end_date);
654: l_text:=l_text||'';
655: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
656: l_text:='';
657: l_text:=l_text||fnd_number.number_to_canonical(p_pdp_object_version_number);
658: l_text:=l_text||'
';
659: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
660: l_text:='';
661: l_text:=l_text||irc_utilities_pkg.removeTags(p_full_name);

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

661: l_text:=l_text||irc_utilities_pkg.removeTags(p_full_name);
662: l_text:=l_text||'';
663: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
664: l_text:='';
665: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
666: l_text:=l_text||'
';
667: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
668: l_text:='';
669: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);

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

665: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
666: l_text:=l_text||'';
667: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
668: l_text:='';
669: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
670: l_text:=l_text||'
';
671: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
672: l_text:='';
673: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);

Line 673: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);

669: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
670: l_text:=l_text||'';
671: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
672: l_text:='';
673: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);
674: l_text:=l_text||'
';
675: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
676: l_text:='';
677: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);

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

673: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);
674: l_text:=l_text||'';
675: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
676: l_text:='';
677: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
678: l_text:=l_text||'
';
679: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
680: l_text:='';
681: l_text:=l_text||irc_utilities_pkg.removeTags(p_assignment_number);