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.PER_KW_XDO_REPORT dependencies on FND_DATE

Line 130: SELECT fnd_date.canonical_to_date(p_date)

126: BEGIN
127: l_pg_count := 1;
128: IF p_date IS NOT NULL THEN
129: BEGIN
130: SELECT fnd_date.canonical_to_date(p_date)
131: INTO l_date
132: FROM DUAL;
133: EXCEPTION
134: WHEN OTHERS THEN

Line 246: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(sysdate);

242: gxmltable(gCtr).tagName := 'page_number_label';
243: gxmltable(gCtr).tagValue := get_lookup_meaning('KW_FORM_LABELS','PAGE_NO_LABEL');
244: gctr := gctr + 1;
245: gxmltable(gCtr).tagName := 'report_date_value';
246: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(sysdate);
247: gctr := gctr + 1;
248: gxmltable(gCtr).tagName := 'of_label';
249: gxmltable(gCtr).tagValue := get_lookup_meaning('KW_FORM_LABELS','OF_LABEL');
250: gctr := gctr + 1;

Line 300: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(l_date);

296: gxmltable(gCtr).tagName := 'effective_date_label';
297: gxmltable(gCtr).tagValue := get_lookup_meaning('KW_FORM_LABELS','EFFECTIVE_DATE_LABEL');
298: gctr := gctr + 1;
299: gxmltable(gCtr).tagName := 'effective_date_value';
300: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(l_date);
301: gctr := gctr + 1;
302: gxmltable(gCtr).tagName := '0';
303: gxmltable(gCtr).tagValue := ('-----------------------------------------------------');
304: gctr := gctr + 1;

Line 333: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(sysdate);

329: gxmltable(gCtr).tagName := 'report_date_body_label';
330: gxmltable(gCtr).tagValue := get_lookup_meaning('KW_FORM_LABELS','REPORT_DATE_LABEL');
331: gctr := gctr + 1;
332: gxmltable(gCtr).tagName := 'report_date_body_value';
333: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(sysdate);
334: gctr := gctr + 1;
335: gxmltable(gCtr).tagName := 'page_number_body_label';
336: gxmltable(gCtr).tagValue := get_lookup_meaning('KW_FORM_LABELS','PAGE_NO_LABEL');
337: gctr := gctr + 1;

Line 446: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(rec_get_dis_emp.date_start);

442: gxmltable(gCtr).tagName := 'full_name_value'||' '||i;
443: gxmltable(gCtr).tagValue := (rec_get_dis_emp.full_name);
444: gctr := gctr + 1;
445: gxmltable(gCtr).tagName := 'start_date_value'||' '||i;
446: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(rec_get_dis_emp.date_start);
447: gctr := gctr + 1;
448: gxmltable(gCtr).tagName := 'job_value'||' '||i;
449: gxmltable(gCtr).tagValue := (rec_get_dis_emp.job_name);
450: gctr := gctr + 1;

Line 464: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(l_incident_date);

460: gxmltable(gCtr).tagName := 'disability_value'||' '||i;
461: gxmltable(gCtr).tagValue := (rec_get_dis_emp.rep_description);
462: gctr := gctr + 1;
463: gxmltable(gCtr).tagName := 'incident_date_value'||' '||i;
464: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(l_incident_date);
465: gctr := gctr + 1;
466: gxmltable(gCtr).tagName := 'assessment_date_value'||' '||i;
467: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(l_consultation_date);
468: gctr := gctr + 1;

Line 467: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(l_consultation_date);

463: gxmltable(gCtr).tagName := 'incident_date_value'||' '||i;
464: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(l_incident_date);
465: gctr := gctr + 1;
466: gxmltable(gCtr).tagName := 'assessment_date_value'||' '||i;
467: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(l_consultation_date);
468: gctr := gctr + 1;
469: i := i + 1;
470: END LOOP;
471: CLOSE csr_get_dis_emp;

Line 572: ,fnd_date.canonical_to_date(cont.ctr_information2) expiry_date

568: ,job.name job_name
569: ,cont.reference cont_reference
570: ,get_lookup_meaning('CONTRACT_TYPE',cont.type) cont_type
571: ,cont.ctr_information1 employment_status
572: ,fnd_date.canonical_to_date(cont.ctr_information2) expiry_date
573: FROM per_all_assignments_f assg
574: ,per_all_people_f people
575: ,per_contracts cont
576: ,per_jobs job

Line 627: SELECT fnd_date.canonical_to_date(p_date)

623: BEGIN
624: l_pg_count := 1;
625: IF p_date IS NOT NULL THEN
626: BEGIN
627: SELECT fnd_date.canonical_to_date(p_date)
628: INTO l_date
629: FROM DUAL;
630: EXCEPTION
631: WHEN OTHERS THEN

Line 730: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(sysdate);

726: gxmltable(gCtr).tagName := 'page_number_label';
727: gxmltable(gCtr).tagValue := get_lookup_meaning('KW_FORM_LABELS','PAGE_NO_LABEL');
728: gctr := gctr + 1;
729: gxmltable(gCtr).tagName := 'report_date_value';
730: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(sysdate);
731: gctr := gctr + 1;
732: gxmltable(gCtr).tagName := 'of_label';
733: gxmltable(gCtr).tagValue := get_lookup_meaning('KW_FORM_LABELS','OF_LABEL');
734: gctr := gctr + 1;

Line 784: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(l_date);

780: gxmltable(gCtr).tagName := 'effective_date_label';
781: gxmltable(gCtr).tagValue := get_lookup_meaning('KW_FORM_LABELS','EFFECTIVE_DATE_LABEL');
782: gctr := gctr + 1;
783: gxmltable(gCtr).tagName := 'effective_date_value';
784: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(l_date);
785: gctr := gctr + 1;
786: gxmltable(gCtr).tagName := '0';
787: gxmltable(gCtr).tagValue := ('-----------------------------------------------------');
788: gctr := gctr + 1;

Line 820: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(sysdate);

816: gxmltable(gCtr).tagName := 'report_date_body_label';
817: gxmltable(gCtr).tagValue := get_lookup_meaning('KW_FORM_LABELS','REPORT_DATE_LABEL');
818: gctr := gctr + 1;
819: gxmltable(gCtr).tagName := 'report_date_body_value';
820: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(sysdate);
821: gctr := gctr + 1;
822: gxmltable(gCtr).tagName := 'page_number_body_label';
823: gxmltable(gCtr).tagValue := get_lookup_meaning('KW_FORM_LABELS','PAGE_NO_LABEL');
824: gctr := gctr + 1;

Line 897: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(rec_get_cont_emp.date_start);

893: gxmltable(gCtr).tagName := 'full_name_value'||' '||i;
894: gxmltable(gCtr).tagValue := (rec_get_cont_emp.full_name);
895: gctr := gctr + 1;
896: gxmltable(gCtr).tagName := 'appointment_date_value'||' '||i;
897: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(rec_get_cont_emp.date_start);
898: gctr := gctr + 1;
899: gxmltable(gCtr).tagName := 'job_value'||' '||i;
900: gxmltable(gCtr).tagValue := (rec_get_cont_emp.job_name);
901: gctr := gctr + 1;

Line 912: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(rec_get_cont_emp.expiry_date);

908: gxmltable(gCtr).tagName := 'employment_status_value'||' '||i;
909: gxmltable(gCtr).tagValue := (rec_get_cont_emp.employment_status);
910: gctr := gctr + 1;
911: gxmltable(gCtr).tagName := 'expiry_date_value'||' '||i;
912: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(rec_get_cont_emp.expiry_date);
913: gctr := gctr + 1;
914: i := i + 1;
915: END LOOP;
916: CLOSE csr_get_cont_emp;