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.HRI_DBI_WMV_SEPARATION dependencies on FND_DATE

Line 290: AND sum_information1 = fnd_date.date_to_canonical(del_rec.effective_date)

286: SET sum_information4 = TO_NUMBER(sum_information4) - TO_NUMBER(del_rec.voluntary_char),
287: sum_information5 = TO_NUMBER(sum_information5) - TO_NUMBER(del_rec.involuntary_char)
288: WHERE sum_information2 = TO_CHAR(sup_rec.sup_person_id)
289: AND sum_information3 = TO_CHAR(l_sub_id)
290: AND sum_information1 = fnd_date.date_to_canonical(del_rec.effective_date)
291: AND sum_information_category = information_category;
292: --
293: -- Next subordinate is this supervisor 'cos we're going to step up the heirarchy
294: l_sub_id := sup_rec.sup_person_id;

Line 301: fnd_date.date_to_canonical(del_rec.effective_date)

297: IF l_sub_id = del_rec.supervisor_id THEN
298: dbg(
299: 'No rows returned by get_supsup for '||
300: del_rec.supervisor_id||' and '||
301: fnd_date.date_to_canonical(del_rec.effective_date)
302: );
303: END IF;
304: --
305: END LOOP;

Line 310: fnd_date.date_to_canonical(p_supv_tab(i).effective_start_date)||' '||

306: --
307: IF l_loop = 0 THEN
308: dbg('No rows returned by get_deletes_todo for '||
309: p_supv_tab(i).supervisor_id||' '||
310: fnd_date.date_to_canonical(p_supv_tab(i).effective_start_date)||' '||
311: fnd_date.date_to_canonical(p_supv_tab(i).effective_end_date)||
312: ' (data not previously record in summary, not an error)'
313: );
314: END IF;

Line 311: fnd_date.date_to_canonical(p_supv_tab(i).effective_end_date)||

307: IF l_loop = 0 THEN
308: dbg('No rows returned by get_deletes_todo for '||
309: p_supv_tab(i).supervisor_id||' '||
310: fnd_date.date_to_canonical(p_supv_tab(i).effective_start_date)||' '||
311: fnd_date.date_to_canonical(p_supv_tab(i).effective_end_date)||
312: ' (data not previously record in summary, not an error)'
313: );
314: END IF;
315: --

Line 392: fnd_date.date_to_canonical(p_eff_dt),

388: g_who_application,
389: g_who_program,
390: g_who_date,
391: information_category,
392: fnd_date.date_to_canonical(p_eff_dt),
393: TO_CHAR(p_supv_id),
394: TO_CHAR(p_sub_supv_id),
395: TO_CHAR(p_vol_sep),
396: TO_CHAR(p_invol_sep)

Line 538: OPEN chk_exists(fnd_date.date_to_canonical(p_eff_dt),TO_CHAR(p_supv_id),TO_CHAR(p_sub_supv_id));

534: --
535: BEGIN
536: --
537: -- See if there's already a row for this supervisor/subordinate on this date
538: OPEN chk_exists(fnd_date.date_to_canonical(p_eff_dt),TO_CHAR(p_supv_id),TO_CHAR(p_sub_supv_id));
539: FETCH chk_exists INTO l_rid,l_vol,l_invol;
540: IF chk_exists%FOUND THEN
541: CLOSE chk_exists;
542: --

Line 745: fnd_date.date_to_canonical(l_supv_rec.effective_date)

741: dbg(
742: 'No rows returned by get_supsup cursor for '||
743: p_supv_tab(i).supervisor_id||
744: ' and '||
745: fnd_date.date_to_canonical(l_supv_rec.effective_date)
746: );
747: END IF;
748: --
749: -- Write some debugging info and insert the data

Line 764: fnd_date.date_to_canonical(p_supv_tab(i).effective_start_date)||', '||

760: --
761: IF l_loop_cnt = 0 THEN
762: dbg('No rows returned by csr_get_supv cursor for '||
763: p_supv_tab(i).supervisor_id||', '||
764: fnd_date.date_to_canonical(p_supv_tab(i).effective_start_date)||', '||
765: fnd_date.date_to_canonical(p_supv_tab(i).effective_end_date)
766: );
767: END IF;
768: END LOOP;

Line 765: fnd_date.date_to_canonical(p_supv_tab(i).effective_end_date)

761: IF l_loop_cnt = 0 THEN
762: dbg('No rows returned by csr_get_supv cursor for '||
763: p_supv_tab(i).supervisor_id||', '||
764: fnd_date.date_to_canonical(p_supv_tab(i).effective_start_date)||', '||
765: fnd_date.date_to_canonical(p_supv_tab(i).effective_end_date)
766: );
767: END IF;
768: END LOOP;
769: --

Line 790: l_start_date DATE := fnd_date.canonical_to_date(p_start_date);

786: p_start_date IN VARCHAR2,
787: p_end_date IN VARCHAR2 DEFAULT eot_char
788: ) IS
789: --
790: l_start_date DATE := fnd_date.canonical_to_date(p_start_date);
791: l_end_date DATE := fnd_date.canonical_to_date(NVL(p_end_date,eot_char));
792: l_tot_rec NUMBER := 0;
793: l_supv_tab pay_events_wrapper.t_summary_refresh_tab_type;
794: --

Line 791: l_end_date DATE := fnd_date.canonical_to_date(NVL(p_end_date,eot_char));

787: p_end_date IN VARCHAR2 DEFAULT eot_char
788: ) IS
789: --
790: l_start_date DATE := fnd_date.canonical_to_date(p_start_date);
791: l_end_date DATE := fnd_date.canonical_to_date(NVL(p_end_date,eot_char));
792: l_tot_rec NUMBER := 0;
793: l_supv_tab pay_events_wrapper.t_summary_refresh_tab_type;
794: --
795: BEGIN

Line 888: fnd_date.date_to_canonical(l_start_date)||

884: l_end_date := SYSDATE;
885: --
886: dbg(
887: 'Refreshing from deltas: '||
888: fnd_date.date_to_canonical(l_start_date)||
889: '->'||
890: fnd_date.date_to_canonical(l_end_date)
891: );
892: IF l_start_date > l_end_date THEN

Line 890: fnd_date.date_to_canonical(l_end_date)

886: dbg(
887: 'Refreshing from deltas: '||
888: fnd_date.date_to_canonical(l_start_date)||
889: '->'||
890: fnd_date.date_to_canonical(l_end_date)
891: );
892: IF l_start_date > l_end_date THEN
893: dbg('ERROR: BIS collection utilities reports last refresh period later than current date, trying to continue anyway');
894: END IF;