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.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXT_DET_HOURS_WORKED_F

Line 451: DELETE FROM hxt_det_hours_worked_f

447: -- End Bug 4590163
448: --
449: -- Delete detail rows associated with summary row.
450: --
451: DELETE FROM hxt_det_hours_worked_f
452: WHERE parent_id = l_time_summary_id;
453:
454: IF g_debug
455: THEN

Line 1259: DELETE FROM hxt_det_hours_worked_f

1255: THEN
1256: hr_utility.set_location (l_proc, 64);
1257: END IF;
1258:
1259: DELETE FROM hxt_det_hours_worked_f
1260: WHERE parent_id = l_time_summary_id;
1261: END IF;
1262: END IF;
1263:

Line 1463: DELETE FROM hxt_det_hours_worked_f

1459: --Hence adding a check to prevent that scenario.
1460: --Bug 2770487 Sonarasi Over
1461: IF l_tim_sum_id_tab (l_tim_sum) IS NOT NULL
1462: THEN
1463: DELETE FROM hxt_det_hours_worked_f
1464: WHERE parent_id = l_tim_sum_id_tab (l_tim_sum);
1465:
1466: OPEN get_timecard_id (p_tim_sum_id => l_tim_sum_id_tab
1467: (l_tim_sum)

Line 1893: detail_date_worked hxt_det_hours_worked_f.date_worked%TYPE;

1889: l_new VARCHAR2 (30);
1890: l_session_id NUMBER;
1891: l_att NUMBER;
1892: l_proc VARCHAR2 (100);
1893: detail_date_worked hxt_det_hours_worked_f.date_worked%TYPE;
1894: detail_hours hxt_det_hours_worked_f.hours%TYPE;
1895: detail_time_in hxt_det_hours_worked_f.time_in%TYPE;
1896: detail_time_out hxt_det_hours_worked_f.time_out%TYPE;
1897: detail_hours_type hxt_det_hours_worked_f.element_type_id%TYPE;

Line 1894: detail_hours hxt_det_hours_worked_f.hours%TYPE;

1890: l_session_id NUMBER;
1891: l_att NUMBER;
1892: l_proc VARCHAR2 (100);
1893: detail_date_worked hxt_det_hours_worked_f.date_worked%TYPE;
1894: detail_hours hxt_det_hours_worked_f.hours%TYPE;
1895: detail_time_in hxt_det_hours_worked_f.time_in%TYPE;
1896: detail_time_out hxt_det_hours_worked_f.time_out%TYPE;
1897: detail_hours_type hxt_det_hours_worked_f.element_type_id%TYPE;
1898: detail_type VARCHAR2 (30);

Line 1895: detail_time_in hxt_det_hours_worked_f.time_in%TYPE;

1891: l_att NUMBER;
1892: l_proc VARCHAR2 (100);
1893: detail_date_worked hxt_det_hours_worked_f.date_worked%TYPE;
1894: detail_hours hxt_det_hours_worked_f.hours%TYPE;
1895: detail_time_in hxt_det_hours_worked_f.time_in%TYPE;
1896: detail_time_out hxt_det_hours_worked_f.time_out%TYPE;
1897: detail_hours_type hxt_det_hours_worked_f.element_type_id%TYPE;
1898: detail_type VARCHAR2 (30);
1899: l_det_cnt NUMBER (15);

Line 1896: detail_time_out hxt_det_hours_worked_f.time_out%TYPE;

1892: l_proc VARCHAR2 (100);
1893: detail_date_worked hxt_det_hours_worked_f.date_worked%TYPE;
1894: detail_hours hxt_det_hours_worked_f.hours%TYPE;
1895: detail_time_in hxt_det_hours_worked_f.time_in%TYPE;
1896: detail_time_out hxt_det_hours_worked_f.time_out%TYPE;
1897: detail_hours_type hxt_det_hours_worked_f.element_type_id%TYPE;
1898: detail_type VARCHAR2 (30);
1899: l_det_cnt NUMBER (15);
1900: l_min_bb_id NUMBER (15);

Line 1897: detail_hours_type hxt_det_hours_worked_f.element_type_id%TYPE;

1893: detail_date_worked hxt_det_hours_worked_f.date_worked%TYPE;
1894: detail_hours hxt_det_hours_worked_f.hours%TYPE;
1895: detail_time_in hxt_det_hours_worked_f.time_in%TYPE;
1896: detail_time_out hxt_det_hours_worked_f.time_out%TYPE;
1897: detail_hours_type hxt_det_hours_worked_f.element_type_id%TYPE;
1898: detail_type VARCHAR2 (30);
1899: l_det_cnt NUMBER (15);
1900: l_min_bb_id NUMBER (15);
1901: l_next_index BINARY_INTEGER := 0;

Line 2638: DELETE FROM hxt_det_hours_worked_f

2634: THEN
2635: hr_utility.set_location (l_proc, 67);
2636: END IF;
2637:
2638: DELETE FROM hxt_det_hours_worked_f
2639: WHERE parent_id = l_time_summary_id;
2640: END IF;
2641:
2642: IF g_debug

Line 2955: DELETE FROM hxt_det_hours_worked_f

2951: --Hence adding a check to prevent that scenario.
2952: --Bug 2770487 Sonarasi Over
2953: IF l_tim_sum_id_tab (l_tim_sum) IS NOT NULL
2954: THEN
2955: DELETE FROM hxt_det_hours_worked_f
2956: WHERE parent_id = l_tim_sum_id_tab (l_tim_sum);
2957:
2958: OPEN get_timecard_id (p_tim_sum_id => l_tim_sum_id_tab
2959: (l_tim_sum)

Line 3171: -- from hxt_det_hours_worked_f

3167:
3168: --
3169: -- select count(*)
3170: -- into l_det_cnt
3171: -- from hxt_det_hours_worked_f
3172: -- where parent_id = l_tim_sum_id_tab(l_tim_sum);
3173: --if g_debug then
3174: -- hr_utility.trace('l_det_cnt IS : ' || to_char(l_det_cnt));
3175: --end if;