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

Line 252: hr_utility.trace('session_date'|| fnd_date.date_to_canonical(p_session_date));

248: open period_end_date;
249: fetch period_end_date into l_period_end_date;
250:
251: if period_end_date%notfound then
252: hr_utility.trace('session_date'|| fnd_date.date_to_canonical(p_session_date));
253: hr_utility.set_message (801,'PAY_52103_PERIOD_NOT_EXIST');
254: hr_utility.raise_error;
255: end if;
256: --

Line 569: p_entry_value1 => fnd_date.date_to_displaydate(p_pai_start_date,calendar_aware=>fnd_date.calendar_aware_alt), --modified as per bug 11830805

565: p_creator_type => 'DF',
566: p_entry_type => 'E',
567: p_input_value_id1 => p_pai_sd_input_value_id,
568: p_input_value_id2 => p_pai_ed_input_value_id,
569: p_entry_value1 => fnd_date.date_to_displaydate(p_pai_start_date,calendar_aware=>fnd_date.calendar_aware_alt), --modified as per bug 11830805
570: p_entry_value2 => fnd_date.date_to_displaydate(p_pai_end_date,calendar_aware=>fnd_date.calendar_aware_alt) --modified as per bug 11830805
571: );
572:
573: -- set out value

Line 570: p_entry_value2 => fnd_date.date_to_displaydate(p_pai_end_date,calendar_aware=>fnd_date.calendar_aware_alt) --modified as per bug 11830805

566: p_entry_type => 'E',
567: p_input_value_id1 => p_pai_sd_input_value_id,
568: p_input_value_id2 => p_pai_ed_input_value_id,
569: p_entry_value1 => fnd_date.date_to_displaydate(p_pai_start_date,calendar_aware=>fnd_date.calendar_aware_alt), --modified as per bug 11830805
570: p_entry_value2 => fnd_date.date_to_displaydate(p_pai_end_date,calendar_aware=>fnd_date.calendar_aware_alt) --modified as per bug 11830805
571: );
572:
573: -- set out value
574: l_session_date := l_element_entry_start_date;

Line 591: fnd_date.date_to_canonical(l_element_entry_start_date));

587:
588: l_element_entry_start_date := p_advance_pay_start_date;
589:
590: hr_utility.trace('l_element_entry_start_date (1): ' ||
591: fnd_date.date_to_canonical(l_element_entry_start_date));
592:
593: l_element_entry_end_date := pay_advance_pay_pkg.get_period_end_date
594: (
595: p_assignment_id,

Line 642: fnd_date.date_to_canonical(l_element_entry_start_date));

638: --
639: -- move to the next pay period
640: --
641: hr_utility.trace('l_element_entry_start_date (2): ' ||
642: fnd_date.date_to_canonical(l_element_entry_start_date));
643: l_element_entry_start_date := pay_advance_pay_pkg.get_period_end_date
644: (
645: p_assignment_id,
646: l_element_entry_start_date

Line 650: fnd_date.date_to_canonical(l_element_entry_start_date));

646: l_element_entry_start_date
647: ) + 1;
648: --
649: hr_utility.trace('l_element_entry_start_date (3): ' ||
650: fnd_date.date_to_canonical(l_element_entry_start_date));
651: --
652: l_element_entry_end_date := pay_advance_pay_pkg.get_period_end_date
653: (
654: p_assignment_id,

Line 688: min(fnd_date.canonical_to_date(peevf.screen_entry_value)),

684: --
685: cursor advance_dates is
686: select
687: -- min of two input values - advance pay period start date
688: min(fnd_date.canonical_to_date(peevf.screen_entry_value)),
689: -- max of two input values - advance pay period end date
690: max(fnd_date.canonical_to_date(peevf.screen_entry_value))
691: from pay_element_entry_values_f peevf
692: where peevf.element_entry_id = p_pai_element_entry_id;

Line 690: max(fnd_date.canonical_to_date(peevf.screen_entry_value))

686: select
687: -- min of two input values - advance pay period start date
688: min(fnd_date.canonical_to_date(peevf.screen_entry_value)),
689: -- max of two input values - advance pay period end date
690: max(fnd_date.canonical_to_date(peevf.screen_entry_value))
691: from pay_element_entry_values_f peevf
692: where peevf.element_entry_id = p_pai_element_entry_id;
693: --
694: cursor corresponding_ai_entries is

Line 747: hr_utility.trace('l_indicators_start_date: ' || fnd_date.date_to_canonical(l_indicators_start_date));

743: end if;
744:
745: -- trace dates used to remove Advance Indicators
746: hr_utility.trace('p_pai_element_entry_id: ' || to_char(p_pai_element_entry_id));
747: hr_utility.trace('l_indicators_start_date: ' || fnd_date.date_to_canonical(l_indicators_start_date));
748: hr_utility.trace('l_indicators_end_date: ' || fnd_date.date_to_canonical(l_indicators_end_date));
749:
750: -- Advance Indicator(s)
751:

Line 748: hr_utility.trace('l_indicators_end_date: ' || fnd_date.date_to_canonical(l_indicators_end_date));

744:
745: -- trace dates used to remove Advance Indicators
746: hr_utility.trace('p_pai_element_entry_id: ' || to_char(p_pai_element_entry_id));
747: hr_utility.trace('l_indicators_start_date: ' || fnd_date.date_to_canonical(l_indicators_start_date));
748: hr_utility.trace('l_indicators_end_date: ' || fnd_date.date_to_canonical(l_indicators_end_date));
749:
750: -- Advance Indicator(s)
751:
752: -- first Advance Indicator element_entry_id