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

Line 462: DELETE FROM hxt_det_hours_worked_f

458: -- End Bug 4590163
459: --
460: -- Delete detail rows associated with summary row.
461: --
462: DELETE FROM hxt_det_hours_worked_f
463: WHERE parent_id = l_time_summary_id;
464:
465: IF g_debug
466: THEN

Line 1286: DELETE FROM hxt_det_hours_worked_f

1282: THEN
1283: hr_utility.set_location (l_proc, 64);
1284: END IF;
1285:
1286: DELETE FROM hxt_det_hours_worked_f
1287: WHERE parent_id = l_time_summary_id;
1288: END IF;
1289: END IF;
1290:

Line 1490: DELETE FROM hxt_det_hours_worked_f

1486: --Hence adding a check to prevent that scenario.
1487: --Bug 2770487 Sonarasi Over
1488: IF l_tim_sum_id_tab (l_tim_sum) IS NOT NULL
1489: THEN
1490: DELETE FROM hxt_det_hours_worked_f
1491: WHERE parent_id = l_tim_sum_id_tab (l_tim_sum);
1492:
1493: OPEN get_timecard_id (p_tim_sum_id => l_tim_sum_id_tab
1494: (l_tim_sum)

Line 1866: FROM hxt_det_hours_worked

1862: IS
1863: CURSOR get_otm_records (p_tim_sum_id NUMBER)
1864: IS
1865: SELECT date_worked, hours, time_in, time_out, element_type_id
1866: FROM hxt_det_hours_worked
1867: WHERE parent_id = p_tim_sum_id;
1868:
1869: CURSOR get_timecard_id (p_tim_sum_id NUMBER)
1870: IS

Line 1933: detail_date_worked hxt_det_hours_worked_f.date_worked%TYPE;

1929: l_new VARCHAR2 (30);
1930: l_session_id NUMBER;
1931: l_att NUMBER;
1932: l_proc VARCHAR2 (100);
1933: detail_date_worked hxt_det_hours_worked_f.date_worked%TYPE;
1934: detail_hours hxt_det_hours_worked_f.hours%TYPE;
1935: detail_time_in hxt_det_hours_worked_f.time_in%TYPE;
1936: detail_time_out hxt_det_hours_worked_f.time_out%TYPE;
1937: detail_hours_type hxt_det_hours_worked_f.element_type_id%TYPE;

Line 1934: detail_hours hxt_det_hours_worked_f.hours%TYPE;

1930: l_session_id NUMBER;
1931: l_att NUMBER;
1932: l_proc VARCHAR2 (100);
1933: detail_date_worked hxt_det_hours_worked_f.date_worked%TYPE;
1934: detail_hours hxt_det_hours_worked_f.hours%TYPE;
1935: detail_time_in hxt_det_hours_worked_f.time_in%TYPE;
1936: detail_time_out hxt_det_hours_worked_f.time_out%TYPE;
1937: detail_hours_type hxt_det_hours_worked_f.element_type_id%TYPE;
1938: detail_type VARCHAR2 (30);

Line 1935: detail_time_in hxt_det_hours_worked_f.time_in%TYPE;

1931: l_att NUMBER;
1932: l_proc VARCHAR2 (100);
1933: detail_date_worked hxt_det_hours_worked_f.date_worked%TYPE;
1934: detail_hours hxt_det_hours_worked_f.hours%TYPE;
1935: detail_time_in hxt_det_hours_worked_f.time_in%TYPE;
1936: detail_time_out hxt_det_hours_worked_f.time_out%TYPE;
1937: detail_hours_type hxt_det_hours_worked_f.element_type_id%TYPE;
1938: detail_type VARCHAR2 (30);
1939: l_det_cnt NUMBER (15);

Line 1936: detail_time_out hxt_det_hours_worked_f.time_out%TYPE;

1932: l_proc VARCHAR2 (100);
1933: detail_date_worked hxt_det_hours_worked_f.date_worked%TYPE;
1934: detail_hours hxt_det_hours_worked_f.hours%TYPE;
1935: detail_time_in hxt_det_hours_worked_f.time_in%TYPE;
1936: detail_time_out hxt_det_hours_worked_f.time_out%TYPE;
1937: detail_hours_type hxt_det_hours_worked_f.element_type_id%TYPE;
1938: detail_type VARCHAR2 (30);
1939: l_det_cnt NUMBER (15);
1940: l_min_bb_id NUMBER (15);

Line 1937: detail_hours_type hxt_det_hours_worked_f.element_type_id%TYPE;

1933: detail_date_worked hxt_det_hours_worked_f.date_worked%TYPE;
1934: detail_hours hxt_det_hours_worked_f.hours%TYPE;
1935: detail_time_in hxt_det_hours_worked_f.time_in%TYPE;
1936: detail_time_out hxt_det_hours_worked_f.time_out%TYPE;
1937: detail_hours_type hxt_det_hours_worked_f.element_type_id%TYPE;
1938: detail_type VARCHAR2 (30);
1939: l_det_cnt NUMBER (15);
1940: l_min_bb_id NUMBER (15);
1941: l_next_index BINARY_INTEGER := 0;

Line 2713: DELETE FROM hxt_det_hours_worked_f

2709: THEN
2710: hr_utility.set_location (l_proc, 67);
2711: END IF;
2712:
2713: DELETE FROM hxt_det_hours_worked_f
2714: WHERE parent_id = l_time_summary_id;
2715: END IF;
2716:
2717: IF g_debug

Line 3030: DELETE FROM hxt_det_hours_worked_f

3026: --Hence adding a check to prevent that scenario.
3027: --Bug 2770487 Sonarasi Over
3028: IF l_tim_sum_id_tab (l_tim_sum) IS NOT NULL
3029: THEN
3030: DELETE FROM hxt_det_hours_worked_f
3031: WHERE parent_id = l_tim_sum_id_tab (l_tim_sum);
3032:
3033: OPEN get_timecard_id (p_tim_sum_id => l_tim_sum_id_tab
3034: (l_tim_sum)

Line 3246: -- from hxt_det_hours_worked_f

3242:
3243: --
3244: -- select count(*)
3245: -- into l_det_cnt
3246: -- from hxt_det_hours_worked_f
3247: -- where parent_id = l_tim_sum_id_tab(l_tim_sum);
3248: --if g_debug then
3249: -- hr_utility.trace('l_det_cnt IS : ' || to_char(l_det_cnt));
3250: --end if;