APPS.PAY_ADVANCE_PAY_PKG dependencies on FND_DATE

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

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

Line 567: p_entry_value1 => fnd_date.date_to_displaydate(p_pai_start_date),

563: p_creator_type => 'DF',
564: p_entry_type => 'E',
565: p_input_value_id1 => p_pai_sd_input_value_id,
566: p_input_value_id2 => p_pai_ed_input_value_id,
567: p_entry_value1 => fnd_date.date_to_displaydate(p_pai_start_date),
568: p_entry_value2 => fnd_date.date_to_displaydate(p_pai_end_date)
569: );
570:
571: -- set out value

Line 568: p_entry_value2 => fnd_date.date_to_displaydate(p_pai_end_date)

564: p_entry_type => 'E',
565: p_input_value_id1 => p_pai_sd_input_value_id,
566: p_input_value_id2 => p_pai_ed_input_value_id,
567: p_entry_value1 => fnd_date.date_to_displaydate(p_pai_start_date),
568: p_entry_value2 => fnd_date.date_to_displaydate(p_pai_end_date)
569: );
570:
571: -- set out value
572: l_session_date := l_element_entry_start_date;

Line 589: fnd_date.date_to_canonical(l_element_entry_start_date));

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

Line 640: fnd_date.date_to_canonical(l_element_entry_start_date));

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

Line 648: fnd_date.date_to_canonical(l_element_entry_start_date));

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

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

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

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

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

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

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

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

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