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_TIME_COLLECTION dependencies on HXT_DET_HOURS_WORKED_F

Line 5305: DELETE FROM hxt_det_hours_worked_f

5301: hr_utility.set_location (l_proc, 350);
5302: END IF;
5303:
5304: -- Delete
5305: DELETE FROM hxt_det_hours_worked_f
5306: WHERE ROWID IN (SELECT ROWID
5307: FROM hxt_det_hours_worked
5308: WHERE parent_id = l_hours_worked_id);
5309:

Line 5325: UPDATE hxt_det_hours_worked_f

5321: hr_utility.set_location (l_proc, 360);
5322: END IF;
5323:
5324: -- Expire
5325: UPDATE hxt_det_hours_worked_f
5326: SET effective_end_date = l_session_date - 1
5327: WHERE ROWID IN (SELECT ROWID
5328: FROM hxt_det_hours_worked
5329: WHERE parent_id = l_hours_worked_id);

Line 5875: DELETE FROM hxt_det_hours_worked_f

5871: l_proc := g_package || 'remove_tc_details';
5872: hr_utility.set_location ('Entering ' || l_proc, 10);
5873: END IF;
5874:
5875: DELETE FROM hxt_det_hours_worked_f
5876: WHERE parent_id = p_sum_id;
5877:
5878: DELETE FROM hxt_sum_hours_worked_f
5879: WHERE ID = p_sum_id;

Line 5978: DELETE FROM hxt_det_hours_worked_f

5974:
5975: IF NVL (p_dt_update_mode, 'CORRECTION') = 'CORRECTION'
5976: THEN
5977: -- Delete
5978: DELETE FROM hxt_det_hours_worked_f
5979: WHERE ROWID IN (SELECT ROWID
5980: FROM hxt_det_hours_worked
5981: WHERE tim_id = p_tim_id);
5982:

Line 5993: UPDATE hxt_det_hours_worked_f

5989: --hxt11ipatch don't delete timecard
5990: ); -- level errors
5991: ELSE
5992: -- Expire
5993: UPDATE hxt_det_hours_worked_f
5994: SET effective_end_date = p_effective_start_date - 1
5995: WHERE ROWID IN (SELECT ROWID
5996: FROM hxt_det_hours_worked
5997: WHERE tim_id = p_tim_id);