DBA Data[Home] [Help]

APPS.HR_EMPLOYEE_BE1 dependencies on FND_NUMBER

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

179: l_text:=l_text||fnd_date.date_to_canonical(p_hire_date);
180: l_text:=l_text||'';
181: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
182: l_text:='';
183: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
184: l_text:=l_text||'
';
185: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
186: l_text:='';
187: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);

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

191: l_text:=l_text||irc_utilities_pkg.removeTags(p_sex);
192: l_text:=l_text||'';
193: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
194: l_text:='';
195: l_text:=l_text||fnd_number.number_to_canonical(p_person_type_id);
196: l_text:=l_text||'
';
197: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
198: l_text:='';
199: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_comments);

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

255: l_text:=l_text||irc_utilities_pkg.removeTags(p_title);
256: l_text:=l_text||'';
257: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
258: l_text:='';
259: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_id);
260: l_text:=l_text||'
';
261: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
262: l_text:='';
263: l_text:=l_text||irc_utilities_pkg.removeTags(p_work_telephone);

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

535: l_text:=l_text||irc_utilities_pkg.removeTags(p_fast_path_employee);
536: l_text:=l_text||'';
537: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
538: l_text:='';
539: l_text:=l_text||fnd_number.number_to_canonical(p_fte_capacity);
540: l_text:=l_text||'
';
541: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
542: l_text:='';
543: l_text:=l_text||irc_utilities_pkg.removeTags(p_honors);

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

603: l_text:=l_text||irc_utilities_pkg.removeTags(p_suffix);
604: l_text:=l_text||'';
605: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
606: l_text:='';
607: l_text:=l_text||fnd_number.number_to_canonical(p_benefit_group_id);
608: l_text:=l_text||'
';
609: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
610: l_text:='';
611: l_text:=l_text||fnd_date.date_to_canonical(p_receipt_of_death_cert_date);

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

663: l_text:=l_text||fnd_date.date_to_canonical(p_adjusted_svc_date);
664: l_text:=l_text||'';
665: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
666: l_text:='';
667: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
668: l_text:=l_text||'
';
669: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
670: l_text:='';
671: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);

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

667: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
668: l_text:=l_text||'';
669: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
670: l_text:='';
671: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
672: l_text:=l_text||'
';
673: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
674: l_text:='';
675: l_text:=l_text||fnd_number.number_to_canonical(p_per_object_version_number);

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

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

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

675: l_text:=l_text||fnd_number.number_to_canonical(p_per_object_version_number);
676: l_text:=l_text||'';
677: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
678: l_text:='';
679: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);
680: l_text:=l_text||'
';
681: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
682: l_text:='';
683: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_date);

Line 695: l_text:=l_text||fnd_number.number_to_canonical(p_per_comment_id);

691: l_text:=l_text||irc_utilities_pkg.removeTags(p_full_name);
692: l_text:=l_text||'';
693: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
694: l_text:='';
695: l_text:=l_text||fnd_number.number_to_canonical(p_per_comment_id);
696: l_text:=l_text||'
';
697: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
698: l_text:='';
699: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);

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

695: l_text:=l_text||fnd_number.number_to_canonical(p_per_comment_id);
696: l_text:=l_text||'';
697: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
698: l_text:='';
699: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
700: l_text:=l_text||'
';
701: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
702: l_text:='';
703: l_text:=l_text||irc_utilities_pkg.removeTags(p_assignment_number);

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

719: l_text:=l_text||irc_utilities_pkg.removeTags(p_global_person_id);
720: l_text:=l_text||'';
721: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
722: l_text:='';
723: l_text:=l_text||fnd_number.number_to_canonical(p_party_id);
724: l_text:=l_text||'
';
725: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
726: l_text:='';
727: if(P_NAME_COMBINATION_WARNING) then