eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERSON_BE1 dependencies on FND_DATE

Line 179: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);

175: l_text:='';
176: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
177: --
178: l_text:='';
179: l_text:=l_text||fnd_date.date_to_canonical(p_effective_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||irc_utilities_pkg.removeTags(p_datetrack_update_mode);

Line 211: l_text:=l_text||fnd_date.date_to_canonical(p_date_employee_data_verified);

207: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
208: l_text:=l_text||'';
209: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
210: l_text:='';
211: l_text:=l_text||fnd_date.date_to_canonical(p_date_employee_data_verified);
212: l_text:=l_text||'';
213: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
214: l_text:='';
215: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_birth);

Line 215: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_birth);

211: l_text:=l_text||fnd_date.date_to_canonical(p_date_employee_data_verified);
212: l_text:=l_text||'';
213: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
214: l_text:='';
215: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_birth);
216: l_text:=l_text||'';
217: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
218: l_text:='';
219: l_text:=l_text||irc_utilities_pkg.removeTags(p_email_address);

Line 523: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_death);

519: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information30);
520: l_text:=l_text||'';
521: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
522: l_text:='';
523: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_death);
524: l_text:=l_text||'';
525: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
526: l_text:='';
527: l_text:=l_text||irc_utilities_pkg.removeTags(p_background_check_status);

Line 531: l_text:=l_text||fnd_date.date_to_canonical(p_background_date_check);

527: l_text:=l_text||irc_utilities_pkg.removeTags(p_background_check_status);
528: l_text:=l_text||'';
529: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
530: l_text:='';
531: l_text:=l_text||fnd_date.date_to_canonical(p_background_date_check);
532: l_text:=l_text||'';
533: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
534: l_text:='';
535: l_text:=l_text||irc_utilities_pkg.removeTags(p_blood_type);

Line 551: l_text:=l_text||fnd_date.date_to_canonical(p_hold_applicant_date_until);

547: l_text:=l_text||fnd_number.number_to_canonical(p_fte_capacity);
548: l_text:=l_text||'';
549: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
550: l_text:='';
551: l_text:=l_text||fnd_date.date_to_canonical(p_hold_applicant_date_until);
552: l_text:=l_text||'';
553: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
554: l_text:='';
555: l_text:=l_text||irc_utilities_pkg.removeTags(p_honors);

Line 567: l_text:=l_text||fnd_date.date_to_canonical(p_last_medical_test_date);

563: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_medical_test_by);
564: l_text:=l_text||'';
565: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
566: l_text:='';
567: l_text:=l_text||fnd_date.date_to_canonical(p_last_medical_test_date);
568: l_text:=l_text||'';
569: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
570: l_text:='';
571: l_text:=l_text||irc_utilities_pkg.removeTags(p_mailstop);

Line 587: l_text:=l_text||fnd_date.date_to_canonical(p_projected_start_date);

583: l_text:=l_text||irc_utilities_pkg.removeTags(p_pre_name_adjunct);
584: l_text:=l_text||'';
585: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
586: l_text:='';
587: l_text:=l_text||fnd_date.date_to_canonical(p_projected_start_date);
588: l_text:=l_text||'';
589: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
590: l_text:='';
591: l_text:=l_text||irc_utilities_pkg.removeTags(p_rehire_authorizor);

Line 603: l_text:=l_text||fnd_date.date_to_canonical(p_resume_last_updated);

599: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_exists);
600: l_text:=l_text||'';
601: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
602: l_text:='';
603: l_text:=l_text||fnd_date.date_to_canonical(p_resume_last_updated);
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||irc_utilities_pkg.removeTags(p_second_passport_exists);

Line 631: l_text:=l_text||fnd_date.date_to_canonical(p_receipt_of_death_cert_date);

627: l_text:=l_text||fnd_number.number_to_canonical(p_benefit_group_id);
628: l_text:=l_text||'';
629: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
630: l_text:='';
631: l_text:=l_text||fnd_date.date_to_canonical(p_receipt_of_death_cert_date);
632: l_text:=l_text||'';
633: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
634: l_text:='';
635: l_text:=l_text||irc_utilities_pkg.removeTags(p_coord_ben_med_pln_no);

Line 659: l_text:=l_text||fnd_date.date_to_canonical(p_coord_ben_med_cvg_strt_dt);

655: l_text:=l_text||irc_utilities_pkg.removeTags(p_coord_ben_med_insr_crr_ident);
656: l_text:=l_text||'';
657: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
658: l_text:='';
659: l_text:=l_text||fnd_date.date_to_canonical(p_coord_ben_med_cvg_strt_dt);
660: l_text:=l_text||'';
661: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
662: l_text:='';
663: l_text:=l_text||fnd_date.date_to_canonical(p_coord_ben_med_cvg_end_dt);

Line 663: l_text:=l_text||fnd_date.date_to_canonical(p_coord_ben_med_cvg_end_dt);

659: l_text:=l_text||fnd_date.date_to_canonical(p_coord_ben_med_cvg_strt_dt);
660: l_text:=l_text||'';
661: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
662: l_text:='';
663: l_text:=l_text||fnd_date.date_to_canonical(p_coord_ben_med_cvg_end_dt);
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||irc_utilities_pkg.removeTags(p_uses_tobacco_flag);

Line 671: l_text:=l_text||fnd_date.date_to_canonical(p_dpdnt_adoption_date);

667: l_text:=l_text||irc_utilities_pkg.removeTags(p_uses_tobacco_flag);
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_date.date_to_canonical(p_dpdnt_adoption_date);
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||irc_utilities_pkg.removeTags(p_dpdnt_vlntry_svce_flag);

Line 679: l_text:=l_text||fnd_date.date_to_canonical(p_original_date_of_hire);

675: l_text:=l_text||irc_utilities_pkg.removeTags(p_dpdnt_vlntry_svce_flag);
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_date.date_to_canonical(p_original_date_of_hire);
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_adjusted_svc_date);

Line 683: l_text:=l_text||fnd_date.date_to_canonical(p_adjusted_svc_date);

679: l_text:=l_text||fnd_date.date_to_canonical(p_original_date_of_hire);
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_adjusted_svc_date);
684: l_text:=l_text||'';
685: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
686: l_text:='';
687: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);

Line 687: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);

683: l_text:=l_text||fnd_date.date_to_canonical(p_adjusted_svc_date);
684: l_text:=l_text||'';
685: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
686: l_text:='';
687: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
688: l_text:=l_text||'';
689: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
690: l_text:='';
691: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);

Line 691: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);

687: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
688: l_text:=l_text||'';
689: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
690: l_text:='';
691: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
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||irc_utilities_pkg.removeTags(p_full_name);