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_US_W2_INFO_PKG dependencies on FND_DATE

Line 536: l_corrected_date := fnd_date.canonical_to_date(

532: begin
533:
534: /* Code to print Amended/amended date on W-2 */
535:
536: l_corrected_date := fnd_date.canonical_to_date(
537: pay_us_archive_util.get_archive_value(p_asg_action_id,
538: 'A_ARCHIVE_DATE',
539: p_tax_unit_id));
540:

Line 544: l_profile_date := fnd_date.canonical_to_date('4712/12/31');

540:
541: hr_utility.trace('Archive Date : ' || l_corrected_date);
542: /* l_profile_option := fnd_profile.value('HR_VIEW_ONLINE_W2');
543: IF (l_profile_option is null) or (l_profile_option = '') THEN
544: l_profile_date := fnd_date.canonical_to_date('4712/12/31');
545: ELSE
546: */
547: OPEN c_get_payroll_action(p_asg_action_id);
548: FETCH c_get_payroll_action INTO l_payroll_action_id;

Line 552: --l_profile_date := fnd_date.canonical_to_date(p_year+1||'/'||l_profile_option);

548: FETCH c_get_payroll_action INTO l_payroll_action_id;
549: CLOSE c_get_payroll_action;
550:
551:
552: --l_profile_date := fnd_date.canonical_to_date(p_year+1||'/'||l_profile_option);
553: -- END IF;
554: /* If live profile option is null then allow the view W-2 till end of time
555: otherwise check if the archive profile option exist then use the archive
556: profile option date else continue using the old logic of appending year,

Line 563: l_profile_date := fnd_date.canonical_to_date('4712/12/31');

559: l_live_profile_option := fnd_profile.value('HR_VIEW_ONLINE_W2');
560: hr_utility.trace('View Online W2 Profile date'||l_live_profile_option);
561:
562: IF (l_live_profile_option is null) or (l_live_profile_option = '') THEN
563: l_profile_date := fnd_date.canonical_to_date('4712/12/31');
564: ELSE
565: --- changed th date format for bug 5656018
566: l_profile_date_string :=-- fnd_date.canonical_to_date(
567: -- fnd_date.chardate_to_date(

Line 566: l_profile_date_string :=-- fnd_date.canonical_to_date(

562: IF (l_live_profile_option is null) or (l_live_profile_option = '') THEN
563: l_profile_date := fnd_date.canonical_to_date('4712/12/31');
564: ELSE
565: --- changed th date format for bug 5656018
566: l_profile_date_string :=-- fnd_date.canonical_to_date(
567: -- fnd_date.chardate_to_date(
568: pay_us_archive_util.get_archive_value(l_payroll_action_id,
569: 'A_VIEW_ONLINE_W2',
570: p_tax_unit_id);

Line 567: -- fnd_date.chardate_to_date(

563: l_profile_date := fnd_date.canonical_to_date('4712/12/31');
564: ELSE
565: --- changed th date format for bug 5656018
566: l_profile_date_string :=-- fnd_date.canonical_to_date(
567: -- fnd_date.chardate_to_date(
568: pay_us_archive_util.get_archive_value(l_payroll_action_id,
569: 'A_VIEW_ONLINE_W2',
570: p_tax_unit_id);
571:

Line 575: l_profile_date := fnd_date.canonical_to_date(p_year+1||'/'||l_live_profile_option);

571:
572: hr_utility.trace('l_profile_date '||l_profile_date_string);
573:
574: IF (l_profile_date_string is null) or (l_profile_date_string = '') THEN
575: l_profile_date := fnd_date.canonical_to_date(p_year+1||'/'||l_live_profile_option);
576: hr_utility.trace('l_profile_date was null , setting to '||l_profile_date);
577: ELSE
578: l_profile_date := -- bug 5656018 fnd_date.chardate_to_date
579: fnd_date.canonical_to_date(l_profile_date_string);

Line 578: l_profile_date := -- bug 5656018 fnd_date.chardate_to_date

574: IF (l_profile_date_string is null) or (l_profile_date_string = '') THEN
575: l_profile_date := fnd_date.canonical_to_date(p_year+1||'/'||l_live_profile_option);
576: hr_utility.trace('l_profile_date was null , setting to '||l_profile_date);
577: ELSE
578: l_profile_date := -- bug 5656018 fnd_date.chardate_to_date
579: fnd_date.canonical_to_date(l_profile_date_string);
580:
581: hr_utility.trace('l_profile_date was not null , setting to '||l_profile_date);
582:

Line 579: fnd_date.canonical_to_date(l_profile_date_string);

575: l_profile_date := fnd_date.canonical_to_date(p_year+1||'/'||l_live_profile_option);
576: hr_utility.trace('l_profile_date was null , setting to '||l_profile_date);
577: ELSE
578: l_profile_date := -- bug 5656018 fnd_date.chardate_to_date
579: fnd_date.canonical_to_date(l_profile_date_string);
580:
581: hr_utility.trace('l_profile_date was not null , setting to '||l_profile_date);
582:
583: END IF;

Line 671: hr_utility.trace(' end of year ' || fnd_date.canonical_to_date(p_year||'/12/31'));

667: l_w2_fields.employer_address;
668: END IF;
669: /* Bug 5575567 */
670: hr_utility.trace(' sysdate ' || sysdate);
671: hr_utility.trace(' end of year ' || fnd_date.canonical_to_date(p_year||'/12/31'));
672:
673: IF (trunc(sysdate) <
674: fnd_date.canonical_to_date(p_year||'/12/31')) THEN
675: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');

Line 674: fnd_date.canonical_to_date(p_year||'/12/31')) THEN

670: hr_utility.trace(' sysdate ' || sysdate);
671: hr_utility.trace(' end of year ' || fnd_date.canonical_to_date(p_year||'/12/31'));
672:
673: IF (trunc(sysdate) <
674: fnd_date.canonical_to_date(p_year||'/12/31')) THEN
675: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');
676: ELSE
677: p_effective_date := sysdate;
678: END IF;

Line 675: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');

671: hr_utility.trace(' end of year ' || fnd_date.canonical_to_date(p_year||'/12/31'));
672:
673: IF (trunc(sysdate) <
674: fnd_date.canonical_to_date(p_year||'/12/31')) THEN
675: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');
676: ELSE
677: p_effective_date := sysdate;
678: END IF;
679: