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_EMPLOYEE_BE1 dependencies on FND_DATE

Line 179: l_text:=l_text||fnd_date.date_to_canonical(p_hire_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_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);

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

199: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_comments);
200: l_text:=l_text||'';
201: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
202: l_text:='';
203: l_text:=l_text||fnd_date.date_to_canonical(p_date_employee_data_verified);
204: l_text:=l_text||'';
205: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
206: l_text:='';
207: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_birth);

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

203: l_text:=l_text||fnd_date.date_to_canonical(p_date_employee_data_verified);
204: l_text:=l_text||'';
205: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
206: l_text:='';
207: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_birth);
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||irc_utilities_pkg.removeTags(p_email_address);

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

511: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information30);
512: l_text:=l_text||'';
513: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
514: l_text:='';
515: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_death);
516: l_text:=l_text||'';
517: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
518: l_text:='';
519: l_text:=l_text||irc_utilities_pkg.removeTags(p_background_check_status);

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

519: l_text:=l_text||irc_utilities_pkg.removeTags(p_background_check_status);
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_background_date_check);
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_blood_type);

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

551: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_medical_test_by);
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||fnd_date.date_to_canonical(p_last_medical_test_date);
556: l_text:=l_text||'';
557: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
558: l_text:='';
559: l_text:=l_text||irc_utilities_pkg.removeTags(p_mailstop);

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

575: l_text:=l_text||irc_utilities_pkg.removeTags(p_rehire_recommendation);
576: l_text:=l_text||'';
577: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
578: l_text:='';
579: l_text:=l_text||fnd_date.date_to_canonical(p_projected_start_date);
580: l_text:=l_text||'';
581: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
582: l_text:='';
583: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_exists);

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

583: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_exists);
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_resume_last_updated);
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_second_passport_exists);

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

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);
612: l_text:=l_text||'';
613: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
614: l_text:='';
615: l_text:=l_text||irc_utilities_pkg.removeTags(p_coord_ben_med_pln_no);

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

635: l_text:=l_text||irc_utilities_pkg.removeTags(p_coord_ben_med_insr_crr_ident);
636: l_text:=l_text||'';
637: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
638: l_text:='';
639: l_text:=l_text||fnd_date.date_to_canonical(p_coord_ben_med_cvg_strt_dt);
640: l_text:=l_text||'';
641: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
642: l_text:='';
643: l_text:=l_text||fnd_date.date_to_canonical(p_coord_ben_med_cvg_end_dt);

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

639: l_text:=l_text||fnd_date.date_to_canonical(p_coord_ben_med_cvg_strt_dt);
640: l_text:=l_text||'';
641: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
642: l_text:='';
643: l_text:=l_text||fnd_date.date_to_canonical(p_coord_ben_med_cvg_end_dt);
644: l_text:=l_text||'';
645: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
646: l_text:='';
647: l_text:=l_text||irc_utilities_pkg.removeTags(p_uses_tobacco_flag);

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

647: l_text:=l_text||irc_utilities_pkg.removeTags(p_uses_tobacco_flag);
648: l_text:=l_text||'';
649: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
650: l_text:='';
651: l_text:=l_text||fnd_date.date_to_canonical(p_dpdnt_adoption_date);
652: l_text:=l_text||'';
653: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
654: l_text:='';
655: l_text:=l_text||irc_utilities_pkg.removeTags(p_dpdnt_vlntry_svce_flag);

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

655: l_text:=l_text||irc_utilities_pkg.removeTags(p_dpdnt_vlntry_svce_flag);
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_original_date_of_hire);
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_adjusted_svc_date);

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

659: l_text:=l_text||fnd_date.date_to_canonical(p_original_date_of_hire);
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_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);

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

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);
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_per_effective_end_date);

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

683: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_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_per_effective_end_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||irc_utilities_pkg.removeTags(p_full_name);