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

Line 166: l_text:=l_text||fnd_date.date_to_canonical(p_date_received);

162: l_text:='';
163: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
164: --
165: l_text:='';
166: l_text:=l_text||fnd_date.date_to_canonical(p_date_received);
167: l_text:=l_text||'';
168: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
169: l_text:='';
170: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);

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

186: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_comments);
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_date.date_to_canonical(p_date_employee_data_verified);
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||fnd_date.date_to_canonical(p_date_of_birth);

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

190: l_text:=l_text||fnd_date.date_to_canonical(p_date_employee_data_verified);
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||fnd_date.date_to_canonical(p_date_of_birth);
195: l_text:=l_text||'';
196: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
197: l_text:='';
198: l_text:=l_text||irc_utilities_pkg.removeTags(p_email_address);

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

498: l_text:=l_text||irc_utilities_pkg.removeTags(p_background_check_status);
499: l_text:=l_text||'';
500: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
501: l_text:='';
502: l_text:=l_text||fnd_date.date_to_canonical(p_background_date_check);
503: l_text:=l_text||'';
504: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
505: l_text:='';
506: l_text:=l_text||irc_utilities_pkg.removeTags(p_correspondence_language);

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

510: l_text:=l_text||fnd_number.number_to_canonical(p_fte_capacity);
511: l_text:=l_text||'';
512: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
513: l_text:='';
514: l_text:=l_text||fnd_date.date_to_canonical(p_hold_applicant_date_until);
515: l_text:=l_text||'';
516: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
517: l_text:='';
518: l_text:=l_text||irc_utilities_pkg.removeTags(p_honors);

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

534: l_text:=l_text||irc_utilities_pkg.removeTags(p_pre_name_adjunct);
535: l_text:=l_text||'';
536: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
537: l_text:='';
538: l_text:=l_text||fnd_date.date_to_canonical(p_projected_start_date);
539: l_text:=l_text||'';
540: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
541: l_text:='';
542: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_exists);

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

542: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_exists);
543: l_text:=l_text||'';
544: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
545: l_text:='';
546: l_text:=l_text||fnd_date.date_to_canonical(p_resume_last_updated);
547: l_text:=l_text||'';
548: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
549: l_text:='';
550: l_text:=l_text||irc_utilities_pkg.removeTags(p_student_status);

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

558: l_text:=l_text||irc_utilities_pkg.removeTags(p_suffix);
559: l_text:=l_text||'';
560: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
561: l_text:='';
562: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_death);
563: l_text:=l_text||'';
564: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
565: l_text:='';
566: l_text:=l_text||fnd_number.number_to_canonical(p_benefit_group_id);

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

566: l_text:=l_text||fnd_number.number_to_canonical(p_benefit_group_id);
567: l_text:=l_text||'';
568: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
569: l_text:='';
570: l_text:=l_text||fnd_date.date_to_canonical(p_receipt_of_death_cert_date);
571: l_text:=l_text||'';
572: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
573: l_text:='';
574: l_text:=l_text||irc_utilities_pkg.removeTags(p_coord_ben_med_pln_no);

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

582: l_text:=l_text||irc_utilities_pkg.removeTags(p_uses_tobacco_flag);
583: l_text:=l_text||'';
584: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
585: l_text:='';
586: l_text:=l_text||fnd_date.date_to_canonical(p_dpdnt_adoption_date);
587: l_text:=l_text||'';
588: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
589: l_text:='';
590: l_text:=l_text||irc_utilities_pkg.removeTags(p_dpdnt_vlntry_svce_flag);

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

590: l_text:=l_text||irc_utilities_pkg.removeTags(p_dpdnt_vlntry_svce_flag);
591: l_text:=l_text||'';
592: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
593: l_text:='';
594: l_text:=l_text||fnd_date.date_to_canonical(p_original_date_of_hire);
595: l_text:=l_text||'';
596: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
597: l_text:='';
598: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);

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

618: l_text:=l_text||fnd_number.number_to_canonical(p_apl_object_version_number);
619: l_text:=l_text||'';
620: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
621: l_text:='';
622: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_date);
623: l_text:=l_text||'';
624: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
625: l_text:='';
626: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_end_date);

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

622: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_date);
623: l_text:=l_text||'';
624: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
625: l_text:='';
626: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_end_date);
627: l_text:=l_text||'';
628: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
629: l_text:='';
630: l_text:=l_text||irc_utilities_pkg.removeTags(p_full_name);