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

Line 778: --g_start_date := fnd_date.canonical_to_date(l_start_date);

774: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,505);
775: hr_utility.set_location(' g_business_group_id = '||g_business_group_id,505);
776: hr_utility.set_location(' g_employer_id = '||g_employer_id,505);
777:
778: --g_start_date := fnd_date.canonical_to_date(l_start_date);
779: --g_end_date := fnd_date.canonical_to_date(l_end_date);
780:
781: -- g_pact_id := pactid;
782:

Line 779: --g_end_date := fnd_date.canonical_to_date(l_end_date);

775: hr_utility.set_location(' g_business_group_id = '||g_business_group_id,505);
776: hr_utility.set_location(' g_employer_id = '||g_employer_id,505);
777:
778: --g_start_date := fnd_date.canonical_to_date(l_start_date);
779: --g_end_date := fnd_date.canonical_to_date(l_end_date);
780:
781: -- g_pact_id := pactid;
782:
783: --hr_utility.set_location('after get_all_parameter called',225);

Line 1885: l_string := l_string || ' '|| to_char(fnd_date.canonical_to_date(l_header.declare_date),'DD/MM/YYYY') ||'';

1881: l_string := l_string || ' '|| substr(l_header.declarant_name,1,40) ||'';
1882: l_string := l_string || ' '|| substr(l_header.declarant_phone,1,14) ||'' ;
1883: l_string := l_string || ' '|| substr(l_header.declarant_email,1,80) ||'';
1884: --l_string := l_string || ' '|| l_header.declare_date ||'';
1885: l_string := l_string || ' '|| to_char(fnd_date.canonical_to_date(l_header.declare_date),'DD/MM/YYYY') ||'';
1886: l_string := l_string || ' '||l_header.declarant_position||'';
1887:
1888: l_string := l_string ||''||EOL ;
1889: l_clob := l_clob||l_string;

Line 2121: and fnd_date.canonical_to_date(hoi.org_information13) between g_qtr_start_date and g_qtr_end_date

2117: and hoi.org_information1 IS NOT NULL
2118: and hoi.org_information2 IS NOT NULL
2119: --and decode(hoi.org_information1,'MPAP','M','CSSW','C','PTCO','P') = NVL(g_occupational_category_M_C_P,decode(hoi.org_information1,'MPAP','M','CSSW','C','PTCO','P'))
2120: and decode(hoi.org_information1,'Managers','M','Clerical Workers','C','Production Workers','P') = NVL(g_occupational_category_M_C_P,decode(hoi.org_information1,'Managers','M','Clerical Workers','C','Production Workers','P'))
2121: and fnd_date.canonical_to_date(hoi.org_information13) between g_qtr_start_date and g_qtr_end_date
2122: --group by decode(hoi.org_information1,'MPAP','M','CSSW','C','PTCO','P'),
2123: group by decode(hoi.org_information1,'Managers','M','Clerical Workers','C','Production Workers','P'),
2124: decode(hoi.org_information2,'FR','F','PR','P',hoi.org_information2)
2125: )