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 218: fnd_date.canonical_to_date(lv_screen_entry_value);

214:
215: if (upper(lv_inp_val_name) = 'EARNED START DATE'
216: AND lv_screen_entry_value IS NOT NULL) then
217: ld_rec_ele_start_date :=
218: fnd_date.canonical_to_date(lv_screen_entry_value);
219: elsif (upper(lv_inp_val_name) = 'EARNED END DATE'
220: AND lv_screen_entry_value IS NOT NULL) then
221: ld_rec_ele_end_date :=
222: fnd_date.canonical_to_date(lv_screen_entry_value);

Line 222: fnd_date.canonical_to_date(lv_screen_entry_value);

218: fnd_date.canonical_to_date(lv_screen_entry_value);
219: elsif (upper(lv_inp_val_name) = 'EARNED END DATE'
220: AND lv_screen_entry_value IS NOT NULL) then
221: ld_rec_ele_end_date :=
222: fnd_date.canonical_to_date(lv_screen_entry_value);
223: end if; -- if (upper(lv_inp_val_name) ....
224: end loop;
225: close c_check_aug_entry;
226:

Line 266: set screen_entry_value = fnd_date.date_to_canonical

262: close c_get_period_dates;
263: hr_utility.trace('Updating the Element Entry values for the NR Element');
264: -- Updating the Start Date to the Payroll Start Date
265: update pay_element_entry_values_f peev
266: set screen_entry_value = fnd_date.date_to_canonical
267: (ld_rec_ele_start_date)
268: where element_entry_value_id =
269: (select distinct peev1.element_entry_value_id
270: from pay_element_entry_values_f peev1,

Line 281: set screen_entry_value = fnd_date.date_to_canonical

277: and peev1.input_value_id = pivf.input_value_id);
278:
279: -- Updating the End Date to the Payroll End Date
280: update pay_element_entry_values_f peev
281: set screen_entry_value = fnd_date.date_to_canonical
282: (ld_rec_ele_end_date)
283: where element_entry_value_id =
284: (select distinct peev1.element_entry_value_id
285: from pay_element_entry_values_f peev1,

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

785: ln_rec_element_type_id := NULL;
786: lvr := 0;
787: lv_lookup_type := NULL;
788: ln_daily_amt_index := 0;
789: ld_dummy_end_date := fnd_date.canonical_to_date('4712/12/31');
790:
791:
792: -- Check whether this element entry is an augment element.
793: -- If not then we need not do anyhting additional

Line 842: fnd_date.canonical_to_date(lv_screen_entry_value);

838: ld_rec_ele_start_date := NULL;
839: exit;
840: else
841: ld_rec_ele_start_date :=
842: fnd_date.canonical_to_date(lv_screen_entry_value);
843: hr_utility.trace('Start Date = ' || to_char(ld_rec_ele_start_date,'DD-MON-YYYY'));
844: end if; -- if lv_screen_entry_value is null
845: elsif upper(lv_inp_value_name) = 'EARNED END DATE' then
846: if lv_screen_entry_value is null then

Line 851: fnd_date.canonical_to_date(lv_screen_entry_value);

847: ld_rec_ele_end_date := NULL;
848: exit;
849: else
850: ld_rec_ele_end_date :=
851: fnd_date.canonical_to_date(lv_screen_entry_value);
852: hr_utility.trace('End Date = ' || to_char(ld_rec_ele_end_date,'DD-MON-YYYY'));
853: end if; -- if lv_screen_entry_value is null
854: elsif (upper(lv_inp_value_name) in ('AMOUNT')) THEN
855: lv_inp_value_to_divide := lv_inp_value_name;

Line 1964: fnd_date.canonical_to_date(lv_screen_entry_value);

1960: exit when c_get_aug_entry_details%NOTFOUND;
1961:
1962: if upper(lv_inp_val_name) = 'EARNED START DATE' then
1963: ld_new_rec_ele_start_date :=
1964: fnd_date.canonical_to_date(lv_screen_entry_value);
1965: hr_utility.trace('New Start Date = ' || ld_new_rec_ele_start_date);
1966: elsif upper(lv_inp_val_name) = 'EARNED END DATE' then
1967: ld_new_rec_ele_end_date :=
1968: fnd_date.canonical_to_date(lv_screen_entry_value);

Line 1968: fnd_date.canonical_to_date(lv_screen_entry_value);

1964: fnd_date.canonical_to_date(lv_screen_entry_value);
1965: hr_utility.trace('New Start Date = ' || ld_new_rec_ele_start_date);
1966: elsif upper(lv_inp_val_name) = 'EARNED END DATE' then
1967: ld_new_rec_ele_end_date :=
1968: fnd_date.canonical_to_date(lv_screen_entry_value);
1969: hr_utility.trace('New End Date = ' || ld_new_rec_ele_end_date);
1970: elsif upper(lv_inp_val_name) = 'AMOUNT' then
1971: ln_total_amount := to_number(nvl(lv_screen_entry_value,0));
1972: hr_utility.trace('New Amount = ' || ln_total_amount);

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

2118: -- Get the End date of the recurring element.
2119: cursor c_get_entry_end_date(c_element_entry_id number
2120: ,c_assignment_id number) is
2121: select nvl(max(peef.effective_end_date),
2122: fnd_date.canonical_to_date('4712/12/31'))
2123: from pay_element_entries_f peef
2124: where peef.element_entry_id = c_element_entry_id
2125: and peef.assignment_id = c_assignment_id;
2126:

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

2483: BEGIN
2484: hr_utility.trace
2485: ('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_PREM_MOP_UP_ELE_ENTRY');
2486:
2487: ld_end_of_time := fnd_date.canonical_to_date('4712/12/31');
2488:
2489: lb_prem_flag := CHECK_PREMIUM_ELEM(p_element_entry_id
2490: ,p_effective_start_date
2491: ,lv_element_name