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

Line 1457: ,fnd_date.canonical_to_date(svc.pds_information10) LWD

1453: select svc.actual_termination_date ATD
1454: ,nvl(svc.adjusted_svc_date, svc.date_start)
1455: ,hr_general.decode_lookup('LEAV_REAS', svc.leaving_reason)
1456: ,svc.pds_information11 final_pay_schedule
1457: ,fnd_date.canonical_to_date(svc.pds_information10) LWD
1458: from per_periods_of_service svc
1459: ,per_all_assignments_f asg
1460: where asg.period_of_service_id = svc.period_of_service_id
1461: and p_effective_date between asg.effective_start_date and asg.effective_end_date

Line 1546: , p_action_information4 => fnd_date.date_to_canonical(l_ee_est_start_date)

1542: , p_action_context_type => l_archive_type
1543: , p_object_version_number => l_ovn
1544: , p_tax_unit_id => p_establishment_id
1545: , p_action_information_category => 'FR_SOE_EE_DATES'
1546: , p_action_information4 => fnd_date.date_to_canonical(l_ee_est_start_date)
1547: , p_action_information5 => fnd_date.date_to_canonical(l_ee_est_end_date)
1548: , p_action_information6 => fnd_date.date_to_canonical(l_ee_pay_date)
1549: , p_action_information7 => fnd_date.date_to_canonical(l_ee_pay_period_start_date)
1550: , p_action_information8 => fnd_date.date_to_canonical(l_ee_pay_period_end_date)

Line 1547: , p_action_information5 => fnd_date.date_to_canonical(l_ee_est_end_date)

1543: , p_object_version_number => l_ovn
1544: , p_tax_unit_id => p_establishment_id
1545: , p_action_information_category => 'FR_SOE_EE_DATES'
1546: , p_action_information4 => fnd_date.date_to_canonical(l_ee_est_start_date)
1547: , p_action_information5 => fnd_date.date_to_canonical(l_ee_est_end_date)
1548: , p_action_information6 => fnd_date.date_to_canonical(l_ee_pay_date)
1549: , p_action_information7 => fnd_date.date_to_canonical(l_ee_pay_period_start_date)
1550: , p_action_information8 => fnd_date.date_to_canonical(l_ee_pay_period_end_date)
1551: , p_action_information9 => fnd_date.date_to_canonical(l_ee_deposit_date)

Line 1548: , p_action_information6 => fnd_date.date_to_canonical(l_ee_pay_date)

1544: , p_tax_unit_id => p_establishment_id
1545: , p_action_information_category => 'FR_SOE_EE_DATES'
1546: , p_action_information4 => fnd_date.date_to_canonical(l_ee_est_start_date)
1547: , p_action_information5 => fnd_date.date_to_canonical(l_ee_est_end_date)
1548: , p_action_information6 => fnd_date.date_to_canonical(l_ee_pay_date)
1549: , p_action_information7 => fnd_date.date_to_canonical(l_ee_pay_period_start_date)
1550: , p_action_information8 => fnd_date.date_to_canonical(l_ee_pay_period_end_date)
1551: , p_action_information9 => fnd_date.date_to_canonical(l_ee_deposit_date)
1552: , p_action_information10 => fnd_date.date_to_canonical(l_ee_seniority_date));

Line 1549: , p_action_information7 => fnd_date.date_to_canonical(l_ee_pay_period_start_date)

1545: , p_action_information_category => 'FR_SOE_EE_DATES'
1546: , p_action_information4 => fnd_date.date_to_canonical(l_ee_est_start_date)
1547: , p_action_information5 => fnd_date.date_to_canonical(l_ee_est_end_date)
1548: , p_action_information6 => fnd_date.date_to_canonical(l_ee_pay_date)
1549: , p_action_information7 => fnd_date.date_to_canonical(l_ee_pay_period_start_date)
1550: , p_action_information8 => fnd_date.date_to_canonical(l_ee_pay_period_end_date)
1551: , p_action_information9 => fnd_date.date_to_canonical(l_ee_deposit_date)
1552: , p_action_information10 => fnd_date.date_to_canonical(l_ee_seniority_date));
1553: --

Line 1550: , p_action_information8 => fnd_date.date_to_canonical(l_ee_pay_period_end_date)

1546: , p_action_information4 => fnd_date.date_to_canonical(l_ee_est_start_date)
1547: , p_action_information5 => fnd_date.date_to_canonical(l_ee_est_end_date)
1548: , p_action_information6 => fnd_date.date_to_canonical(l_ee_pay_date)
1549: , p_action_information7 => fnd_date.date_to_canonical(l_ee_pay_period_start_date)
1550: , p_action_information8 => fnd_date.date_to_canonical(l_ee_pay_period_end_date)
1551: , p_action_information9 => fnd_date.date_to_canonical(l_ee_deposit_date)
1552: , p_action_information10 => fnd_date.date_to_canonical(l_ee_seniority_date));
1553: --
1554: -- Termination date is not archived

Line 1551: , p_action_information9 => fnd_date.date_to_canonical(l_ee_deposit_date)

1547: , p_action_information5 => fnd_date.date_to_canonical(l_ee_est_end_date)
1548: , p_action_information6 => fnd_date.date_to_canonical(l_ee_pay_date)
1549: , p_action_information7 => fnd_date.date_to_canonical(l_ee_pay_period_start_date)
1550: , p_action_information8 => fnd_date.date_to_canonical(l_ee_pay_period_end_date)
1551: , p_action_information9 => fnd_date.date_to_canonical(l_ee_deposit_date)
1552: , p_action_information10 => fnd_date.date_to_canonical(l_ee_seniority_date));
1553: --
1554: -- Termination date is not archived
1555: --

Line 1552: , p_action_information10 => fnd_date.date_to_canonical(l_ee_seniority_date));

1548: , p_action_information6 => fnd_date.date_to_canonical(l_ee_pay_date)
1549: , p_action_information7 => fnd_date.date_to_canonical(l_ee_pay_period_start_date)
1550: , p_action_information8 => fnd_date.date_to_canonical(l_ee_pay_period_end_date)
1551: , p_action_information9 => fnd_date.date_to_canonical(l_ee_deposit_date)
1552: , p_action_information10 => fnd_date.date_to_canonical(l_ee_seniority_date));
1553: --
1554: -- Termination date is not archived
1555: --
1556: -- pass back the date as at to fetch the employee data

Line 2280: fnd_message.set_token('TERM_DATE', fnd_date.date_to_displaydate(p_term_atd));

2276: --
2277: hr_utility.set_location('Step ' || l_proc, 50);
2278: if p_term_atd is not null then
2279: fnd_message.set_name('PAY', 'PAY_75057_SOE_TERM_DATA');
2280: fnd_message.set_token('TERM_DATE', fnd_date.date_to_displaydate(p_term_atd));
2281: fnd_message.set_token('TERM_REASON',p_term_reason);
2282: l_message := hr_utility.get_message;
2283: l_message := substrb(l_message, 1, 240);
2284: --

Line 2357: ,nvl(result_rollup.start_date, fnd_date.date_to_canonical(result_rollup.prorate_start_date)) std_start_date

2353: ,absattid absence_attendance_id
2354: ,decode(classification_name, 'Benefits', run_result_id, 0) distinct_ben
2355: ,decode(classification_name, 'Earnings Adjustment', -1, 1) adjust_sign
2356: /* get the correct dates for non-retro - input value names or proration dates if they exist */
2357: ,nvl(result_rollup.start_date, fnd_date.date_to_canonical(result_rollup.prorate_start_date)) std_start_date
2358: ,nvl(result_rollup.end_date, fnd_date.date_to_canonical(result_rollup.prorate_end_date)) std_end_Date
2359: /* get the correct dates for retro - retro proration dates or original period */
2360: ,decode(creator_type,'EE', nvl(result_rollup.retro_pro_start, ptp.start_date), 'RR', nvl(result_rollup.retro_pro_start, ptp.start_date)) retro_pro_start
2361: ,decode(creator_type,'EE', nvl(result_rollup.retro_pro_end, ptp.end_date) , 'RR', nvl(result_rollup.retro_pro_end, ptp.end_date)) retro_pro_end

Line 2358: ,nvl(result_rollup.end_date, fnd_date.date_to_canonical(result_rollup.prorate_end_date)) std_end_Date

2354: ,decode(classification_name, 'Benefits', run_result_id, 0) distinct_ben
2355: ,decode(classification_name, 'Earnings Adjustment', -1, 1) adjust_sign
2356: /* get the correct dates for non-retro - input value names or proration dates if they exist */
2357: ,nvl(result_rollup.start_date, fnd_date.date_to_canonical(result_rollup.prorate_start_date)) std_start_date
2358: ,nvl(result_rollup.end_date, fnd_date.date_to_canonical(result_rollup.prorate_end_date)) std_end_Date
2359: /* get the correct dates for retro - retro proration dates or original period */
2360: ,decode(creator_type,'EE', nvl(result_rollup.retro_pro_start, ptp.start_date), 'RR', nvl(result_rollup.retro_pro_start, ptp.start_date)) retro_pro_start
2361: ,decode(creator_type,'EE', nvl(result_rollup.retro_pro_end, ptp.end_date) , 'RR', nvl(result_rollup.retro_pro_end, ptp.end_date)) retro_pro_end
2362: ,creator_type

Line 2509: ,nvl(result_rollup.start_date, fnd_date.date_to_canonical(result_rollup.prorate_start_date))

2505: ,result_rollup.prorate_end_date
2506: ,result_rollup.creator_type
2507: ,decode(creator_type,'EE', nvl(result_rollup.retro_pro_start, ptp.start_date), 'RR', nvl(result_rollup.retro_pro_start, ptp.start_date))
2508: ,decode(creator_type,'EE', nvl(result_rollup.retro_pro_end, ptp.end_date) , 'RR', nvl(result_rollup.retro_pro_end, ptp.end_date))
2509: ,nvl(result_rollup.start_date, fnd_date.date_to_canonical(result_rollup.prorate_start_date))
2510: ,nvl(result_rollup.end_date, fnd_date.date_to_canonical(result_rollup.prorate_end_date))
2511: order by decode(absattid,null,null,result_rollup.start_date)
2512: ,rubric_code
2513: ,result_rollup.description desc

Line 2510: ,nvl(result_rollup.end_date, fnd_date.date_to_canonical(result_rollup.prorate_end_date))

2506: ,result_rollup.creator_type
2507: ,decode(creator_type,'EE', nvl(result_rollup.retro_pro_start, ptp.start_date), 'RR', nvl(result_rollup.retro_pro_start, ptp.start_date))
2508: ,decode(creator_type,'EE', nvl(result_rollup.retro_pro_end, ptp.end_date) , 'RR', nvl(result_rollup.retro_pro_end, ptp.end_date))
2509: ,nvl(result_rollup.start_date, fnd_date.date_to_canonical(result_rollup.prorate_start_date))
2510: ,nvl(result_rollup.end_date, fnd_date.date_to_canonical(result_rollup.prorate_end_date))
2511: order by decode(absattid,null,null,result_rollup.start_date)
2512: ,rubric_code
2513: ,result_rollup.description desc
2514: ,week_end_date

Line 2656: l_printed_start_date := fnd_date.date_to_canonical(rec_results.retro_pro_start);

2652: -- Adjust the start and end dates to be 'dd-mm - dd-mm'
2653: --
2654: begin
2655: if rec_results.creator_type = 'EE' or rec_results.creator_type = 'RR' THEN
2656: l_printed_start_date := fnd_date.date_to_canonical(rec_results.retro_pro_start);
2657: l_printed_end_date := fnd_date.date_to_canonical(rec_results.retro_pro_end);
2658: else
2659: l_printed_start_date := rec_results.std_start_date;
2660: l_printed_end_date := rec_results.std_end_date;

Line 2657: l_printed_end_date := fnd_date.date_to_canonical(rec_results.retro_pro_end);

2653: --
2654: begin
2655: if rec_results.creator_type = 'EE' or rec_results.creator_type = 'RR' THEN
2656: l_printed_start_date := fnd_date.date_to_canonical(rec_results.retro_pro_start);
2657: l_printed_end_date := fnd_date.date_to_canonical(rec_results.retro_pro_end);
2658: else
2659: l_printed_start_date := rec_results.std_start_date;
2660: l_printed_end_date := rec_results.std_end_date;
2661: end if;

Line 2664: l_append_dates := to_char(fnd_date.canonical_to_date(l_printed_start_date), ' dd-mm');

2660: l_printed_end_date := rec_results.std_end_date;
2661: end if;
2662:
2663: if l_printed_start_date is not null and l_loop <> 4 and rec_results.class <> 'Overtime' THEN
2664: l_append_dates := to_char(fnd_date.canonical_to_date(l_printed_start_date), ' dd-mm');
2665: end if;
2666: if l_printed_end_date is not null and l_loop <> 4 and rec_results.class <> 'Overtime' THEN
2667: l_append_dates := l_append_dates || to_char(fnd_date.canonical_to_date(l_printed_end_date), ' - dd-mm');
2668: end if;

Line 2667: l_append_dates := l_append_dates || to_char(fnd_date.canonical_to_date(l_printed_end_date), ' - dd-mm');

2663: if l_printed_start_date is not null and l_loop <> 4 and rec_results.class <> 'Overtime' THEN
2664: l_append_dates := to_char(fnd_date.canonical_to_date(l_printed_start_date), ' dd-mm');
2665: end if;
2666: if l_printed_end_date is not null and l_loop <> 4 and rec_results.class <> 'Overtime' THEN
2667: l_append_dates := l_append_dates || to_char(fnd_date.canonical_to_date(l_printed_end_date), ' - dd-mm');
2668: end if;
2669: exception
2670: when others then null; /* fnd date may raise error */
2671: end;

Line 2670: when others then null; /* fnd date may raise error */

2666: if l_printed_end_date is not null and l_loop <> 4 and rec_results.class <> 'Overtime' THEN
2667: l_append_dates := l_append_dates || to_char(fnd_date.canonical_to_date(l_printed_end_date), ' - dd-mm');
2668: end if;
2669: exception
2670: when others then null; /* fnd date may raise error */
2671: end;
2672: --
2673: -- Special procesing for overtime.
2674: --

Line 2685: l_append_dates := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(rec_results.week_end_date));

2681: end if;
2682: --
2683: -- Adjust the overtime date to be displayable
2684: if rec_results.week_end_date is not null THEN
2685: l_append_dates := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(rec_results.week_end_date));
2686: end if;
2687: exception
2688: when others then null; /* fnd date may raise error */
2689: end;

Line 2688: when others then null; /* fnd date may raise error */

2684: if rec_results.week_end_date is not null THEN
2685: l_append_dates := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(rec_results.week_end_date));
2686: end if;
2687: exception
2688: when others then null; /* fnd date may raise error */
2689: end;
2690: end if;
2691: --
2692: -- Special processing for termination