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

Line 252: RETURN fnd_date.canonical_to_date(

248: -- fiscal year date, just concatenated the current year
249: -- with the fiscal start month and date. Adding offset gives
250: -- one day less in case of leap year.
251:
252: RETURN fnd_date.canonical_to_date(
253: to_char(next_year(p_date - l_fiscal_year_offset),'RRRR')||
254: substr(fnd_date.date_to_canonical(p_beg_of_fiscal_year),5,6));
255: -- RETURN (next_year(p_date - l_fiscal_year_offset) + l_fiscal_year_offset);
256:

Line 254: substr(fnd_date.date_to_canonical(p_beg_of_fiscal_year),5,6));

250: -- one day less in case of leap year.
251:
252: RETURN fnd_date.canonical_to_date(
253: to_char(next_year(p_date - l_fiscal_year_offset),'RRRR')||
254: substr(fnd_date.date_to_canonical(p_beg_of_fiscal_year),5,6));
255: -- RETURN (next_year(p_date - l_fiscal_year_offset) + l_fiscal_year_offset);
256:
257: END next_fiscal_year;
258:

Line 322: SELECT fnd_date.canonical_to_date(org_information11)

318: ELSIF p_dimension_name like '%Month' THEN
319: l_expiry_date := next_month(p_owner_effective_date);
320:
321: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
322: SELECT fnd_date.canonical_to_date(org_information11)
323: INTO l_beg_of_fiscal_year
324: FROM pay_payroll_actions PACT,
325: hr_organization_information HOI
326: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 334: SELECT fnd_date.canonical_to_date(org_information11)

330: l_expiry_date := next_fiscal_quarter(l_beg_of_fiscal_year,
331: p_owner_effective_date);
332:
333: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
334: SELECT fnd_date.canonical_to_date(org_information11)
335: INTO l_beg_of_fiscal_year
336: FROM pay_payroll_actions PACT,
337: hr_organization_information HOI
338: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 415: SELECT fnd_date.canonical_to_date(org_information11)

411:
412: p_expiry_information := next_month(p_owner_effective_date) - 1;
413:
414: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
415: SELECT fnd_date.canonical_to_date(org_information11)
416: INTO l_beg_of_fiscal_year
417: FROM pay_payroll_actions PACT,
418: hr_organization_information HOI
419: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 427: SELECT fnd_date.canonical_to_date(org_information11)

423: p_expiry_information := next_fiscal_quarter(l_beg_of_fiscal_year,
424: p_owner_effective_date) - 1;
425:
426: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
427: SELECT fnd_date.canonical_to_date(org_information11)
428: INTO l_beg_of_fiscal_year
429: FROM pay_payroll_actions PACT,
430: hr_organization_information HOI
431: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 449: p_expiry_information := fnd_date.canonical_to_date('4712/12/31');

445: p_expiry_information := next_year(p_owner_effective_date) -1;
446:
447: ELSIF p_dimension_name like '%Lifetime to Date' THEN
448:
449: p_expiry_information := fnd_date.canonical_to_date('4712/12/31');
450:
451: ELSE
452:
453: hr_utility.set_message(801, 'NO_EXP_CHECK_FOR_THIS_DIMENSION');