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 560: l_corrected_date := fnd_date.canonical_to_date(

556: begin
557:
558: /* Code to print Amended/amended date on W-2 */
559:
560: l_corrected_date := fnd_date.canonical_to_date(
561: pay_us_archive_util.get_archive_value(p_asg_action_id,
562: 'A_ARCHIVE_DATE',
563: p_tax_unit_id));
564:

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

564:
565: hr_utility.trace('Archive Date : ' || l_corrected_date);
566: /* l_profile_option := fnd_profile.value('HR_VIEW_ONLINE_W2');
567: IF (l_profile_option is null) or (l_profile_option = '') THEN
568: l_profile_date := fnd_date.canonical_to_date('4712/12/31');
569: ELSE
570: */
571: OPEN c_get_payroll_action(p_asg_action_id);
572: FETCH c_get_payroll_action INTO l_payroll_action_id;

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

572: FETCH c_get_payroll_action INTO l_payroll_action_id;
573: CLOSE c_get_payroll_action;
574:
575:
576: --l_profile_date := fnd_date.canonical_to_date(p_year+1||'/'||l_profile_option);
577: -- END IF;
578: /* If live profile option is null then allow the view W-2 till end of time
579: otherwise check if the archive profile option exist then use the archive
580: profile option date else continue using the old logic of appending year,

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

583: l_live_profile_option := fnd_profile.value('HR_VIEW_ONLINE_W2');
584: hr_utility.trace('View Online W2 Profile date'||l_live_profile_option);
585:
586: IF (l_live_profile_option is null) or (l_live_profile_option = '') THEN
587: l_profile_date := fnd_date.canonical_to_date('4712/12/31');
588: ELSE
589: --- changed th date format for bug 5656018
590: l_profile_date_string :=-- fnd_date.canonical_to_date(
591: -- fnd_date.chardate_to_date(

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

586: IF (l_live_profile_option is null) or (l_live_profile_option = '') THEN
587: l_profile_date := fnd_date.canonical_to_date('4712/12/31');
588: ELSE
589: --- changed th date format for bug 5656018
590: l_profile_date_string :=-- fnd_date.canonical_to_date(
591: -- fnd_date.chardate_to_date(
592: pay_us_archive_util.get_archive_value(l_payroll_action_id,
593: 'A_VIEW_ONLINE_W2',
594: p_tax_unit_id);

Line 591: -- fnd_date.chardate_to_date(

587: l_profile_date := fnd_date.canonical_to_date('4712/12/31');
588: ELSE
589: --- changed th date format for bug 5656018
590: l_profile_date_string :=-- fnd_date.canonical_to_date(
591: -- fnd_date.chardate_to_date(
592: pay_us_archive_util.get_archive_value(l_payroll_action_id,
593: 'A_VIEW_ONLINE_W2',
594: p_tax_unit_id);
595:

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

595:
596: hr_utility.trace('l_profile_date '||l_profile_date_string);
597:
598: IF (l_profile_date_string is null) or (l_profile_date_string = '') THEN
599: l_profile_date := fnd_date.canonical_to_date(p_year+1||'/'||l_live_profile_option);
600: hr_utility.trace('l_profile_date was null , setting to '||l_profile_date);
601: ELSE
602: l_profile_date := -- bug 5656018 fnd_date.chardate_to_date
603: fnd_date.canonical_to_date(l_profile_date_string);

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

598: IF (l_profile_date_string is null) or (l_profile_date_string = '') THEN
599: l_profile_date := fnd_date.canonical_to_date(p_year+1||'/'||l_live_profile_option);
600: hr_utility.trace('l_profile_date was null , setting to '||l_profile_date);
601: ELSE
602: l_profile_date := -- bug 5656018 fnd_date.chardate_to_date
603: fnd_date.canonical_to_date(l_profile_date_string);
604:
605: hr_utility.trace('l_profile_date was not null , setting to '||l_profile_date);
606:

Line 603: fnd_date.canonical_to_date(l_profile_date_string);

599: l_profile_date := fnd_date.canonical_to_date(p_year+1||'/'||l_live_profile_option);
600: hr_utility.trace('l_profile_date was null , setting to '||l_profile_date);
601: ELSE
602: l_profile_date := -- bug 5656018 fnd_date.chardate_to_date
603: fnd_date.canonical_to_date(l_profile_date_string);
604:
605: hr_utility.trace('l_profile_date was not null , setting to '||l_profile_date);
606:
607: END IF;

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

692: l_w2_fields.employer_address;
693: END IF;
694: /* Bug 5575567 */
695: hr_utility.trace(' sysdate ' || sysdate);
696: hr_utility.trace(' end of year ' || fnd_date.canonical_to_date(p_year||'/12/31'));
697:
698: /* Start : Bug # 8353425
699: Considering the Session Date instead of System Date while fetching employee's
700: name. The report will now take the employee's current name as of the application

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

703: name that was effective as of the last day of the year.
704: Commenting the following If-Else condition.
705:
706: IF (trunc(sysdate) <
707: fnd_date.canonical_to_date(p_year||'/12/31')) THEN
708: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');
709: ELSE
710: p_effective_date := trunc(sysdate); --Bug 8222402
711: END IF;

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

704: Commenting the following If-Else condition.
705:
706: IF (trunc(sysdate) <
707: fnd_date.canonical_to_date(p_year||'/12/31')) THEN
708: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');
709: ELSE
710: p_effective_date := trunc(sysdate); --Bug 8222402
711: END IF;
712:

Line 724: IF (trunc(nvl(c_get_session_date_rec.session_date,sysdate)) <= fnd_date.canonical_to_date(p_year||'/12/31')) THEN -- Bug 9073693

720:
721: /*Start Bug 9073693: Since Application session date is sysdate in case of selfservice,
722: Replacing c_get_session_date_rec.session_date with sysdate if it is null */
723:
724: IF (trunc(nvl(c_get_session_date_rec.session_date,sysdate)) <= fnd_date.canonical_to_date(p_year||'/12/31')) THEN -- Bug 9073693
725: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');
726: ELSE
727: p_effective_date := trunc(nvl(c_get_session_date_rec.session_date,sysdate)); -- Bug 9073693
728: END IF;

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

721: /*Start Bug 9073693: Since Application session date is sysdate in case of selfservice,
722: Replacing c_get_session_date_rec.session_date with sysdate if it is null */
723:
724: IF (trunc(nvl(c_get_session_date_rec.session_date,sysdate)) <= fnd_date.canonical_to_date(p_year||'/12/31')) THEN -- Bug 9073693
725: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');
726: ELSE
727: p_effective_date := trunc(nvl(c_get_session_date_rec.session_date,sysdate)); -- Bug 9073693
728: END IF;
729:

Line 806: IF (trunc(c_get_session_date_rec.session_date) < fnd_date.canonical_to_date(p_year||'/12/31')) THEN

802: CLOSE c_get_session_date;
803:
804: hr_utility.trace('Application Session Date ' || c_get_session_date_rec.session_date);
805:
806: IF (trunc(c_get_session_date_rec.session_date) < fnd_date.canonical_to_date(p_year||'/12/31')) THEN
807: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');
808: ELSE
809: p_effective_date := trunc(c_get_session_date_rec.session_date);
810: END IF;

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

803:
804: hr_utility.trace('Application Session Date ' || c_get_session_date_rec.session_date);
805:
806: IF (trunc(c_get_session_date_rec.session_date) < fnd_date.canonical_to_date(p_year||'/12/31')) THEN
807: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');
808: ELSE
809: p_effective_date := trunc(c_get_session_date_rec.session_date);
810: END IF;
811: hr_utility.trace('p_effective_date ' || p_effective_date);*/