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

Line 234: fnd_date.canonical_to_date(lv_screen_entry_value);

230:
231: if (upper(lv_inp_val_name) = 'EARNED START DATE'
232: AND lv_screen_entry_value IS NOT NULL) then
233: ld_rec_ele_start_date :=
234: fnd_date.canonical_to_date(lv_screen_entry_value);
235: elsif (upper(lv_inp_val_name) = 'EARNED END DATE'
236: AND lv_screen_entry_value IS NOT NULL) then
237: ld_rec_ele_end_date :=
238: fnd_date.canonical_to_date(lv_screen_entry_value);

Line 238: fnd_date.canonical_to_date(lv_screen_entry_value);

234: fnd_date.canonical_to_date(lv_screen_entry_value);
235: elsif (upper(lv_inp_val_name) = 'EARNED END DATE'
236: AND lv_screen_entry_value IS NOT NULL) then
237: ld_rec_ele_end_date :=
238: fnd_date.canonical_to_date(lv_screen_entry_value);
239: end if; -- if (upper(lv_inp_val_name) ....
240: end loop;
241: close c_check_aug_entry;
242:

Line 282: set screen_entry_value = fnd_date.date_to_canonical

278: close c_get_period_dates;
279: hr_utility.trace('Updating the Element Entry values for the NR Element');
280: -- Updating the Start Date to the Payroll Start Date
281: update pay_element_entry_values_f peev
282: set screen_entry_value = fnd_date.date_to_canonical
283: (ld_rec_ele_start_date)
284: where element_entry_value_id =
285: (select distinct peev1.element_entry_value_id
286: from pay_element_entry_values_f peev1,

Line 297: set screen_entry_value = fnd_date.date_to_canonical

293: and peev1.input_value_id = pivf.input_value_id);
294:
295: -- Updating the End Date to the Payroll End Date
296: update pay_element_entry_values_f peev
297: set screen_entry_value = fnd_date.date_to_canonical
298: (ld_rec_ele_end_date)
299: where element_entry_value_id =
300: (select distinct peev1.element_entry_value_id
301: from pay_element_entry_values_f peev1,

Line 817: ld_dummy_end_date := fnd_date.canonical_to_date('4712/12/31');

813: ln_rec_element_type_id := NULL;
814: lvr := 0;
815: lv_lookup_type := NULL;
816: ln_daily_amt_index := 0;
817: ld_dummy_end_date := fnd_date.canonical_to_date('4712/12/31');
818:
819:
820: -- Check whether this element entry is an augment element.
821: -- If not then we need not do anyhting additional

Line 870: fnd_date.canonical_to_date(lv_screen_entry_value);

866: ld_rec_ele_start_date := NULL;
867: exit;
868: else
869: ld_rec_ele_start_date :=
870: fnd_date.canonical_to_date(lv_screen_entry_value);
871: hr_utility.trace('Start Date = ' || to_char(ld_rec_ele_start_date,'DD-MON-YYYY'));
872: end if; -- if lv_screen_entry_value is null
873: elsif upper(lv_inp_value_name) = 'EARNED END DATE' then
874: if lv_screen_entry_value is null then

Line 879: fnd_date.canonical_to_date(lv_screen_entry_value);

875: ld_rec_ele_end_date := NULL;
876: exit;
877: else
878: ld_rec_ele_end_date :=
879: fnd_date.canonical_to_date(lv_screen_entry_value);
880: hr_utility.trace('End Date = ' || to_char(ld_rec_ele_end_date,'DD-MON-YYYY'));
881: end if; -- if lv_screen_entry_value is null
882: elsif (upper(lv_inp_value_name) in ('AMOUNT')) THEN
883: lv_inp_value_to_divide := lv_inp_value_name;

Line 2062: fnd_date.canonical_to_date(lv_screen_entry_value);

2058: exit when c_get_aug_entry_details%NOTFOUND;
2059:
2060: if upper(lv_inp_val_name) = 'EARNED START DATE' then
2061: ld_new_rec_ele_start_date :=
2062: fnd_date.canonical_to_date(lv_screen_entry_value);
2063: hr_utility.trace('New Start Date = ' || ld_new_rec_ele_start_date);
2064: elsif upper(lv_inp_val_name) = 'EARNED END DATE' then
2065: ld_new_rec_ele_end_date :=
2066: fnd_date.canonical_to_date(lv_screen_entry_value);

Line 2066: fnd_date.canonical_to_date(lv_screen_entry_value);

2062: fnd_date.canonical_to_date(lv_screen_entry_value);
2063: hr_utility.trace('New Start Date = ' || ld_new_rec_ele_start_date);
2064: elsif upper(lv_inp_val_name) = 'EARNED END DATE' then
2065: ld_new_rec_ele_end_date :=
2066: fnd_date.canonical_to_date(lv_screen_entry_value);
2067: hr_utility.trace('New End Date = ' || ld_new_rec_ele_end_date);
2068: elsif upper(lv_inp_val_name) = 'AMOUNT' then
2069: ln_total_amount := to_number(nvl(lv_screen_entry_value,0));
2070: hr_utility.trace('New Amount = ' || ln_total_amount);

Line 2220: fnd_date.canonical_to_date('4712/12/31'))

2216: -- Get the End date of the recurring element.
2217: cursor c_get_entry_end_date(c_element_entry_id number
2218: ,c_assignment_id number) is
2219: select nvl(max(peef.effective_end_date),
2220: fnd_date.canonical_to_date('4712/12/31'))
2221: from pay_element_entries_f peef
2222: where peef.element_entry_id = c_element_entry_id
2223: and peef.assignment_id = c_assignment_id;
2224:

Line 2585: ld_end_of_time := fnd_date.canonical_to_date('4712/12/31');

2581: BEGIN
2582: hr_utility.trace
2583: ('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_PREM_MOP_UP_ELE_ENTRY');
2584:
2585: ld_end_of_time := fnd_date.canonical_to_date('4712/12/31');
2586:
2587: lb_prem_flag := CHECK_PREMIUM_ELEM(p_element_entry_id
2588: ,p_effective_start_date
2589: ,lv_element_name