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 1909: l_per_end_date := fnd_date.canonical_to_date(l_get_rsltid.Extract_eff_date); -- For Nuvos change

1905: LOOP
1906: FETCH csr_get_rsltid INTO l_get_rsltid;
1907: EXIT WHEN csr_get_rsltid%NOTFOUND;
1908: l_ext_date := l_get_rsltid.req_date;
1909: l_per_end_date := fnd_date.canonical_to_date(l_get_rsltid.Extract_eff_date); -- For Nuvos change
1910: hr_utility.set_location('l_per_end_date: ' || l_per_end_date, 10);
1911: IF l_get_rsltid.Interface_File = g_periodic_ext_names(1).extract_code THEN
1912: l_ext_bdi_rslt_id := l_get_rsltid.rslt_id; -- dbms_output.put_line(l_ext_bdi_rslt_id);
1913: debug('l_get_rsltid.rslt_id '|| l_get_rsltid.rslt_id, 20);

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

1969: IF csr_get_eff_date%NOTFOUND
1970: THEN
1971: l_per_end_date := sysdate;
1972: ELSE
1973: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
1974: END IF;
1975: CLOSE csr_get_eff_date;
1976: ELSE
1977: l_Basic_Data_Cnt := RPAD(' ',10,' ');

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

1996: IF csr_get_eff_date%NOTFOUND
1997: THEN
1998: l_per_end_date := sysdate;
1999: ELSE
2000: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2001: END IF;
2002: CLOSE csr_get_eff_date;
2003: ELSE
2004: l_Address_Data_Cnt := RPAD(' ',10,' ');

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

2042: IF csr_get_eff_date%NOTFOUND
2043: THEN
2044: l_per_end_date := sysdate;
2045: ELSE
2046: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2047: END IF;
2048: CLOSE csr_get_eff_date;
2049:
2050: ELSE

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

2074: IF csr_get_eff_date%NOTFOUND
2075: THEN
2076: l_per_end_date := sysdate;
2077: ELSE
2078: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2079: END IF;
2080: CLOSE csr_get_eff_date;
2081: ELSE
2082: l_Service_Hist_Cnt := RPAD(' ',10,' ');

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

2123: IF csr_get_eff_date%NOTFOUND
2124: THEN
2125: l_per_end_date := sysdate;
2126: ELSE
2127: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2128: END IF;
2129: CLOSE csr_get_eff_date;
2130: hr_utility.set_location('l_per_end_date: '||l_per_end_date,64);
2131: ELSE

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

2190: THEN
2191: l_per_end_date := sysdate;
2192: ELSE
2193: hr_utility.set_location('l_eff_date_arg8'|| l_eff_date_arg8,31);
2194: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2195: END IF;
2196: CLOSE csr_get_eff_date;
2197: hr_utility.set_location('l_per_end_date: '||l_per_end_date,64);
2198: ELSE

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

2245: IF csr_get_eff_date%NOTFOUND
2246: THEN
2247: l_per_end_date := sysdate;
2248: ELSE
2249: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2250: END IF;
2251: CLOSE csr_get_eff_date;
2252:
2253: ELSE

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

2297: IF csr_get_eff_date%NOTFOUND
2298: THEN
2299: l_per_end_date := sysdate;
2300: ELSE
2301: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2302: END IF;
2303: CLOSE csr_get_eff_date;
2304:
2305: ELSE

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

2341: IF csr_get_eff_date%NOTFOUND
2342: THEN
2343: l_per_end_date := sysdate;
2344: ELSE
2345: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2346: END IF;
2347: CLOSE csr_get_eff_date;
2348:
2349: ELSE

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

2385: IF csr_get_eff_date%NOTFOUND
2386: THEN
2387: l_per_end_date := sysdate;
2388: ELSE
2389: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2390: END IF;
2391: CLOSE csr_get_eff_date;
2392:
2393: ELSE

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

2437: IF csr_get_eff_date%NOTFOUND
2438: THEN
2439: l_per_end_date := sysdate;
2440: ELSE
2441: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2442: END IF;
2443: CLOSE csr_get_eff_date;
2444:
2445: ELSE

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

2482: IF csr_get_eff_date%NOTFOUND
2483: THEN
2484: l_per_end_date := sysdate;
2485: ELSE
2486: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2487: END IF;
2488: CLOSE csr_get_eff_date;
2489:
2490: ELSE

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

5112:
5113: -- set the start date of the range to '00:00:00'
5114: -- and set the end date of the range to '23:59:59'
5115: g_effective_start_date :=
5116: fnd_date.canonical_to_date(TO_CHAR(g_effective_start_date,'YYYY/MM/DD'));
5117: g_effective_end_date :=
5118: fnd_date.canonical_to_date((TO_CHAR(g_effective_end_date,'YYYY/MM/DD')||'23:59:59'));
5119:
5120: IF g_debug

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

5114: -- and set the end date of the range to '23:59:59'
5115: g_effective_start_date :=
5116: fnd_date.canonical_to_date(TO_CHAR(g_effective_start_date,'YYYY/MM/DD'));
5117: g_effective_end_date :=
5118: fnd_date.canonical_to_date((TO_CHAR(g_effective_end_date,'YYYY/MM/DD')||'23:59:59'));
5119:
5120: IF g_debug
5121: THEN
5122: debug('g_effective_start_date: '||g_effective_start_date,25);

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

5300: l_value :=
5301: raise_extract_warning(
5302: p_error_text => 'BEN_94482_EXT_PSI_OVR_EVNT_WRN'
5303: ,p_error_number => 94482
5304: ,p_token1 => fnd_date.date_to_displaydt(g_min_effective_date(g_assignment_id))
5305: );
5306:
5307:
5308: IF NOT g_retro_event_date_reported THEN

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

5317: l_value :=
5318: raise_extract_error(
5319: p_error_text => 'BEN_94540_FIRST_RETRO_DATE'
5320: ,p_error_number => 94540
5321: ,p_token1 => fnd_date.date_to_displaydt(g_min_effective_date(g_assignment_id))
5322: );
5323: g_retro_event_date_reported := TRUE;
5324: END IF;
5325: ELSE

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

6872:
6873: p_output := 'N';
6874: ELSE
6875: IF is_proper_claim_date -- function to check valid claim date
6876: (p_claim_date => fnd_date.canonical_to_date(l_claim_date)
6877: ,p_element_name => g_elements_of_info_type(p_ext_pay_element_type).element_name
6878: ,p_element_entry_id => p_ext_pay_element_entry
6879: ,p_assg_start_date => PQP_GB_PSI_ALLOWANCE_HISTORY.g_assg_start_date
6880: )