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

Line 99: SELECT fnd_date.canonical_to_date(p_date)

95: BEGIN
96: l_pg_count := 1;
97: IF p_date IS NOT NULL THEN
98: BEGIN
99: SELECT fnd_date.canonical_to_date(p_date)
100: INTO l_date
101: FROM DUAL;
102: EXCEPTION
103: WHEN OTHERS THEN

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

185: gxmltable(gCtr).tagName := 'page_number_label';
186: gxmltable(gCtr).tagValue := get_lookup_meaning('AE_FORM_LABELS','PAGE_NO_LABEL');
187: gctr := gctr + 1;
188: gxmltable(gCtr).tagName := 'report_date_value';
189: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(sysdate);
190: gctr := gctr + 1;
191: gxmltable(gCtr).tagName := 'of_label';
192: gxmltable(gCtr).tagValue := get_lookup_meaning('AE_FORM_LABELS','OF_LABEL');
193: gctr := gctr + 1;

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

233: gxmltable(gCtr).tagName := 'effective_date_label';
234: gxmltable(gCtr).tagValue := get_lookup_meaning('AE_FORM_LABELS','EFFECTIVE_DATE_LABEL');
235: gctr := gctr + 1;
236: gxmltable(gCtr).tagName := 'effective_date_value';
237: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(l_date);
238: gctr := gctr + 1;
239: gxmltable(gCtr).tagName := '0';
240: gxmltable(gCtr).tagValue := ('-----------------------------------------------------');
241: gctr := gctr + 1;

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

266: gxmltable(gCtr).tagName := 'report_date_body_label';
267: gxmltable(gCtr).tagValue := get_lookup_meaning('AE_FORM_LABELS','REPORT_DATE_LABEL');
268: gctr := gctr + 1;
269: gxmltable(gCtr).tagName := 'report_date_body_value';
270: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(sysdate);
271: gctr := gctr + 1;
272: gxmltable(gCtr).tagName := 'page_number_body_label';
273: gxmltable(gCtr).tagValue := get_lookup_meaning('AE_FORM_LABELS','PAGE_NO_LABEL');
274: gctr := gctr + 1;

Line 477: SELECT fnd_date.canonical_to_date(p_date)

473: BEGIN
474: l_pg_count := 1;
475: IF p_date IS NOT NULL THEN
476: BEGIN
477: SELECT fnd_date.canonical_to_date(p_date)
478: INTO l_date
479: FROM DUAL;
480: EXCEPTION
481: WHEN OTHERS THEN

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

563: gxmltable(gCtr).tagName := 'page_number_label';
564: gxmltable(gCtr).tagValue := get_lookup_meaning('AE_FORM_LABELS','PAGE_NO_LABEL');
565: gctr := gctr + 1;
566: gxmltable(gCtr).tagName := 'report_date_value';
567: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(sysdate);
568: gctr := gctr + 1;
569: gxmltable(gCtr).tagName := 'of_label';
570: gxmltable(gCtr).tagValue := get_lookup_meaning('AE_FORM_LABELS','OF_LABEL');
571: gctr := gctr + 1;

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

611: gxmltable(gCtr).tagName := 'effective_date_label';
612: gxmltable(gCtr).tagValue := get_lookup_meaning('AE_FORM_LABELS','EFFECTIVE_DATE_LABEL');
613: gctr := gctr + 1;
614: gxmltable(gCtr).tagName := 'effective_date_value';
615: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(l_date);
616: gctr := gctr + 1;
617: gxmltable(gCtr).tagName := '0';
618: gxmltable(gCtr).tagValue := ('-----------------------------------------------------');
619: gctr := gctr + 1;

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

644: gxmltable(gCtr).tagName := 'report_date_body_label';
645: gxmltable(gCtr).tagValue := get_lookup_meaning('AE_FORM_LABELS','REPORT_DATE_LABEL');
646: gctr := gctr + 1;
647: gxmltable(gCtr).tagName := 'report_date_body_value';
648: gxmltable(gCtr).tagValue := fnd_date.date_to_displaydate(sysdate);
649: gctr := gctr + 1;
650: gxmltable(gCtr).tagName := 'page_number_body_label';
651: gxmltable(gCtr).tagValue := get_lookup_meaning('AE_FORM_LABELS','PAGE_NO_LABEL');
652: gctr := gctr + 1;

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

852: ,job.name job_name
853: ,cont.reference cont_reference
854: ,get_lookup_meaning('CONTRACT_TYPE',cont.type) cont_type
855: ,cont.ctr_information1 employment_status
856: ,fnd_date.canonical_to_date(cont.ctr_information2) expiry_date
857: FROM per_all_assignments_f assg
858: ,per_all_people_f people
859: ,per_contracts cont
860: ,per_jobs job

Line 900: SELECT fnd_date.canonical_to_date(p_date)

896: BEGIN
897: l_pg_count := 1;
898: IF p_date IS NOT NULL THEN
899: BEGIN
900: SELECT fnd_date.canonical_to_date(p_date)
901: INTO l_date
902: FROM DUAL;
903: EXCEPTION
904: WHEN OTHERS THEN

Line 995: l_rep_date := '' ||fnd_date.date_to_displaydate(sysdate)||'';

991: etc. etc.
992: END OF COMMENTED ON 3-NOV-05 FOR RTF FORMAT******************************/
993: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
994: l_rep_date_label := '' ||get_lookup_meaning('AE_FORM_LABELS','REPORT_DATE_LABEL')||'';
995: l_rep_date := '' ||fnd_date.date_to_displaydate(sysdate)||'';
996: l_rep_page := ''||get_lookup_meaning('AE_FORM_LABELS','PAGE_NO_LABEL')||'';
997: l_one_value := '' || '1' || '';
998: l_rep_param_name := ''||get_lookup_meaning('AE_FORM_LABELS','REPORT_PARAMETERS_LABEL_CTR')||'';
999: l_str_9 := ''||get_lookup_meaning('AE_FORM_LABELS','ORGANIZATION_NAME_LABEL')||'';

Line 1012: l_str_0bb := ''||fnd_date.date_to_displaydate(l_date)||'';

1008: l_str_2 := ''||p_expires_in||'';
1009: l_str_1 := ''||get_lookup_meaning('AE_FORM_LABELS','DURATION_UNITS_LABEL')||'';
1010: l_str_0 := ''||l_units||'';
1011: l_str_0a := ''||get_lookup_meaning('AE_FORM_LABELS','EFFECTIVE_DATE_LABEL')||'';
1012: l_str_0bb := ''||fnd_date.date_to_displaydate(l_date)||'';
1013: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date_label), l_rep_date_label);
1014: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date), l_rep_date);
1015: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);
1016: dbms_lob.writeAppend( l_xfdf_string, length(l_one_value), l_one_value);

Line 1052: l_rep_date := '' ||fnd_date.date_to_displaydate(sysdate)||'';

1048: IF l_emp_found = 0 OR i = 1 THEN
1049: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1050: l_pg_count := l_pg_count + 1;
1051: l_rep_date_label := '' ||get_lookup_meaning('AE_FORM_LABELS','REPORT_DATE_LABEL')||'';
1052: l_rep_date := '' ||fnd_date.date_to_displaydate(sysdate)||'';
1053: l_rep_page := ''||get_lookup_meaning('AE_FORM_LABELS','PAGE_NO_LABEL')||'';
1054: l_page_num := ''||l_pg_count||'';
1055: l_rep_label := ''||get_lookup_meaning('AE_FORM_LABELS','REPORT_LABEL_CTR')||'';
1056: l_str_9b := ''||get_lookup_meaning('AE_FORM_LABELS','ORGANIZATION_LABEL')||'';

Line 1109: l_appdate := ''||fnd_date.date_to_displaydate(rec_get_contract_det.date_start)||'';

1105: l_ref := ''||'' ||'';
1106: --l_type := ''|| (rec_get_contract_det.cont_type) ||'';
1107: l_type := ''||'' ||'';
1108: l_status := ''|| (rec_get_contract_det.employment_status) ||'';
1109: l_appdate := ''||fnd_date.date_to_displaydate(rec_get_contract_det.date_start)||'';
1110: l_edate := ''|| fnd_date.date_to_displaydate(rec_get_contract_det.expiry_date) ||'';
1111: dbms_lob.writeAppend( l_xfdf_string, length(l_eno), l_eno);
1112: dbms_lob.writeAppend( l_xfdf_string, length(l_fname), l_fname);
1113: dbms_lob.writeAppend( l_xfdf_string, length(l_job), l_job);

Line 1110: l_edate := ''|| fnd_date.date_to_displaydate(rec_get_contract_det.expiry_date) ||'';

1106: --l_type := ''|| (rec_get_contract_det.cont_type) ||'';
1107: l_type := ''||'' ||'';
1108: l_status := ''|| (rec_get_contract_det.employment_status) ||'';
1109: l_appdate := ''||fnd_date.date_to_displaydate(rec_get_contract_det.date_start)||'';
1110: l_edate := ''|| fnd_date.date_to_displaydate(rec_get_contract_det.expiry_date) ||'';
1111: dbms_lob.writeAppend( l_xfdf_string, length(l_eno), l_eno);
1112: dbms_lob.writeAppend( l_xfdf_string, length(l_fname), l_fname);
1113: dbms_lob.writeAppend( l_xfdf_string, length(l_job), l_job);
1114: dbms_lob.writeAppend( l_xfdf_string, length(l_ref), l_ref);