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

Line 1845: l_per_end_date := fnd_date.canonical_to_date(l_get_rsltid.Extract_eff_date); -- For Nuvos change

1841: LOOP
1842: FETCH csr_get_rsltid INTO l_get_rsltid;
1843: EXIT WHEN csr_get_rsltid%NOTFOUND;
1844: l_ext_date := l_get_rsltid.req_date;
1845: l_per_end_date := fnd_date.canonical_to_date(l_get_rsltid.Extract_eff_date); -- For Nuvos change
1846: hr_utility.set_location('l_per_end_date: ' || l_per_end_date, 10);
1847: IF l_get_rsltid.Interface_File = g_periodic_ext_names(1).extract_code THEN
1848: l_ext_bdi_rslt_id := l_get_rsltid.rslt_id; -- dbms_output.put_line(l_ext_bdi_rslt_id);
1849: debug('l_get_rsltid.rslt_id '|| l_get_rsltid.rslt_id, 20);

Line 1909: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);

1905: IF csr_get_eff_date%NOTFOUND
1906: THEN
1907: l_per_end_date := sysdate;
1908: ELSE
1909: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
1910: END IF;
1911: CLOSE csr_get_eff_date;
1912: ELSE
1913: l_Basic_Data_Cnt := RPAD(' ',10,' ');

Line 1936: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);

1932: IF csr_get_eff_date%NOTFOUND
1933: THEN
1934: l_per_end_date := sysdate;
1935: ELSE
1936: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
1937: END IF;
1938: CLOSE csr_get_eff_date;
1939: ELSE
1940: l_Address_Data_Cnt := RPAD(' ',10,' ');

Line 1982: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);

1978: IF csr_get_eff_date%NOTFOUND
1979: THEN
1980: l_per_end_date := sysdate;
1981: ELSE
1982: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
1983: END IF;
1984: CLOSE csr_get_eff_date;
1985:
1986: ELSE

Line 2014: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);

2010: IF csr_get_eff_date%NOTFOUND
2011: THEN
2012: l_per_end_date := sysdate;
2013: ELSE
2014: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2015: END IF;
2016: CLOSE csr_get_eff_date;
2017: ELSE
2018: l_Service_Hist_Cnt := RPAD(' ',10,' ');

Line 2063: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);

2059: IF csr_get_eff_date%NOTFOUND
2060: THEN
2061: l_per_end_date := sysdate;
2062: ELSE
2063: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2064: END IF;
2065: CLOSE csr_get_eff_date;
2066: hr_utility.set_location('l_per_end_date: '||l_per_end_date,64);
2067: ELSE

Line 2130: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);

2126: THEN
2127: l_per_end_date := sysdate;
2128: ELSE
2129: hr_utility.set_location('l_eff_date_arg8'|| l_eff_date_arg8,31);
2130: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2131: END IF;
2132: CLOSE csr_get_eff_date;
2133: hr_utility.set_location('l_per_end_date: '||l_per_end_date,64);
2134: ELSE

Line 2185: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);

2181: IF csr_get_eff_date%NOTFOUND
2182: THEN
2183: l_per_end_date := sysdate;
2184: ELSE
2185: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2186: END IF;
2187: CLOSE csr_get_eff_date;
2188:
2189: ELSE

Line 2237: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);

2233: IF csr_get_eff_date%NOTFOUND
2234: THEN
2235: l_per_end_date := sysdate;
2236: ELSE
2237: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2238: END IF;
2239: CLOSE csr_get_eff_date;
2240:
2241: ELSE

Line 2281: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);

2277: IF csr_get_eff_date%NOTFOUND
2278: THEN
2279: l_per_end_date := sysdate;
2280: ELSE
2281: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2282: END IF;
2283: CLOSE csr_get_eff_date;
2284:
2285: ELSE

Line 2325: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);

2321: IF csr_get_eff_date%NOTFOUND
2322: THEN
2323: l_per_end_date := sysdate;
2324: ELSE
2325: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2326: END IF;
2327: CLOSE csr_get_eff_date;
2328:
2329: ELSE

Line 2377: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);

2373: IF csr_get_eff_date%NOTFOUND
2374: THEN
2375: l_per_end_date := sysdate;
2376: ELSE
2377: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2378: END IF;
2379: CLOSE csr_get_eff_date;
2380:
2381: ELSE

Line 2422: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);

2418: IF csr_get_eff_date%NOTFOUND
2419: THEN
2420: l_per_end_date := sysdate;
2421: ELSE
2422: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2423: END IF;
2424: CLOSE csr_get_eff_date;
2425:
2426: ELSE

Line 5035: fnd_date.canonical_to_date(TO_CHAR(g_effective_start_date,'YYYY/MM/DD'));

5031:
5032: -- set the start date of the range to '00:00:00'
5033: -- and set the end date of the range to '23:59:59'
5034: g_effective_start_date :=
5035: fnd_date.canonical_to_date(TO_CHAR(g_effective_start_date,'YYYY/MM/DD'));
5036: g_effective_end_date :=
5037: fnd_date.canonical_to_date((TO_CHAR(g_effective_end_date,'YYYY/MM/DD')||'23:59:59'));
5038:
5039: IF g_debug

Line 5037: fnd_date.canonical_to_date((TO_CHAR(g_effective_end_date,'YYYY/MM/DD')||'23:59:59'));

5033: -- and set the end date of the range to '23:59:59'
5034: g_effective_start_date :=
5035: fnd_date.canonical_to_date(TO_CHAR(g_effective_start_date,'YYYY/MM/DD'));
5036: g_effective_end_date :=
5037: fnd_date.canonical_to_date((TO_CHAR(g_effective_end_date,'YYYY/MM/DD')||'23:59:59'));
5038:
5039: IF g_debug
5040: THEN
5041: debug('g_effective_start_date: '||g_effective_start_date,25);

Line 5194: ,p_token1 => fnd_date.date_to_displaydt(g_min_effective_date(g_assignment_id))

5190: l_value :=
5191: raise_extract_warning(
5192: p_error_text => 'BEN_94482_EXT_PSI_OVR_EVNT_WRN'
5193: ,p_error_number => 94482
5194: ,p_token1 => fnd_date.date_to_displaydt(g_min_effective_date(g_assignment_id))
5195: );
5196:
5197:
5198: IF NOT g_retro_event_date_reported THEN

Line 5211: ,p_token1 => fnd_date.date_to_displaydt(g_min_effective_date(g_assignment_id))

5207: l_value :=
5208: raise_extract_error(
5209: p_error_text => 'BEN_94540_FIRST_RETRO_DATE'
5210: ,p_error_number => 94540
5211: ,p_token1 => fnd_date.date_to_displaydt(g_min_effective_date(g_assignment_id))
5212: );
5213: g_retro_event_date_reported := TRUE;
5214: END IF;
5215: ELSE

Line 6716: (p_claim_date => fnd_date.canonical_to_date(l_claim_date)

6712:
6713: p_output := 'N';
6714: ELSE
6715: IF is_proper_claim_date -- function to check valid claim date
6716: (p_claim_date => fnd_date.canonical_to_date(l_claim_date)
6717: ,p_element_name => g_elements_of_info_type(p_ext_pay_element_type).element_name
6718: ,p_element_entry_id => p_ext_pay_element_entry
6719: ,p_assg_start_date => PQP_GB_PSI_ALLOWANCE_HISTORY.g_assg_start_date
6720: )