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 192: RETURN fnd_date.canonical_to_date(

188: -- Bug 4100637: Instead of adding the offset to get the next
189: -- fiscal year date, just concatenated the current year
190: -- with the fiscal start month and date. Adding offset gives
191: -- one day less in case of leap year.
192: RETURN fnd_date.canonical_to_date(
193: to_char(next_year(p_date - l_fiscal_year_offset),'RRRR')||
194: substr(fnd_date.date_to_canonical(p_beg_of_fiscal_year),5,6));
195: -- RETURN (next_year(p_date - l_fiscal_year_offset) + l_fiscal_year_offset);
196:

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

190: -- with the fiscal start month and date. Adding offset gives
191: -- one day less in case of leap year.
192: RETURN fnd_date.canonical_to_date(
193: to_char(next_year(p_date - l_fiscal_year_offset),'RRRR')||
194: substr(fnd_date.date_to_canonical(p_beg_of_fiscal_year),5,6));
195: -- RETURN (next_year(p_date - l_fiscal_year_offset) + l_fiscal_year_offset);
196:
197: END next_fiscal_year;
198:

Line 262: SELECT fnd_date.canonical_to_date(org_information11)

258: ELSIF p_dimension_name like '%Month' THEN
259: l_expiry_date := next_month(p_owner_effective_date);
260:
261: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
262: SELECT fnd_date.canonical_to_date(org_information11)
263: INTO l_beg_of_fiscal_year
264: FROM pay_payroll_actions PACT,
265: hr_organization_information HOI
266: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 274: SELECT fnd_date.canonical_to_date(org_information11)

270: l_expiry_date := next_fiscal_quarter(l_beg_of_fiscal_year,
271: p_owner_effective_date);
272:
273: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
274: SELECT fnd_date.canonical_to_date(org_information11)
275: INTO l_beg_of_fiscal_year
276: FROM pay_payroll_actions PACT,
277: hr_organization_information HOI
278: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 355: SELECT fnd_date.canonical_to_date(org_information11)

351:
352: p_expiry_information := next_month(p_owner_effective_date) - 1;
353:
354: ELSIF p_dimension_name like '%Fiscal Quarter to Date' THEN
355: SELECT fnd_date.canonical_to_date(org_information11)
356: INTO l_beg_of_fiscal_year
357: FROM pay_payroll_actions PACT,
358: hr_organization_information HOI
359: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 367: SELECT fnd_date.canonical_to_date(org_information11)

363: p_expiry_information := next_fiscal_quarter(l_beg_of_fiscal_year,
364: p_owner_effective_date) - 1;
365:
366: ELSIF p_dimension_name like '%Fiscal Year to Date' THEN
367: SELECT fnd_date.canonical_to_date(org_information11)
368: INTO l_beg_of_fiscal_year
369: FROM pay_payroll_actions PACT,
370: hr_organization_information HOI
371: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

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

385: p_expiry_information := next_year(p_owner_effective_date) -1;
386:
387: ELSIF p_dimension_name like '%Lifetime to Date' THEN
388:
389: p_expiry_information := fnd_date.canonical_to_date('4712/12/31');
390:
391: ELSE
392:
393: hr_utility.set_message(801, 'NO_EXP_CHECK_FOR_THIS_DIMENSION');