APPS.HXT_TIME_COLLECTION dependencies on HXT_ERRORS

Line 5310: DELETE FROM hxt_errors_f

5306: WHERE ROWID IN (SELECT ROWID
5307: FROM hxt_det_hours_worked
5308: WHERE parent_id = l_hours_worked_id);
5309:
5310: DELETE FROM hxt_errors_f
5311: WHERE ROWID IN (
5312: SELECT ROWID
5313: FROM hxt_errors
5314: WHERE hrw_id = l_hours_worked_id

Line 5313: FROM hxt_errors

5309:
5310: DELETE FROM hxt_errors_f
5311: WHERE ROWID IN (
5312: SELECT ROWID
5313: FROM hxt_errors
5314: WHERE hrw_id = l_hours_worked_id
5315: AND hrw_id IS NOT NULL
5316: --hxt11ipatch don't delete timecard
5317: ); --level errors

Line 5331: UPDATE hxt_errors_f

5327: WHERE ROWID IN (SELECT ROWID
5328: FROM hxt_det_hours_worked
5329: WHERE parent_id = l_hours_worked_id);
5330:
5331: UPDATE hxt_errors_f
5332: SET effective_end_date = l_session_date - 1
5333: WHERE ROWID IN (
5334: SELECT ROWID
5335: FROM hxt_errors

Line 5335: FROM hxt_errors

5331: UPDATE hxt_errors_f
5332: SET effective_end_date = l_session_date - 1
5333: WHERE ROWID IN (
5334: SELECT ROWID
5335: FROM hxt_errors
5336: WHERE hrw_id = l_hours_worked_id
5337: AND hrw_id IS NOT NULL
5338: --hxt11ipatch don't expire timecard
5339: ); -- level errors

Line 5983: DELETE FROM hxt_errors_f

5979: WHERE ROWID IN (SELECT ROWID
5980: FROM hxt_det_hours_worked
5981: WHERE tim_id = p_tim_id);
5982:
5983: DELETE FROM hxt_errors_f
5984: WHERE ROWID IN (
5985: SELECT ROWID
5986: FROM hxt_errors
5987: WHERE tim_id = p_tim_id

Line 5986: FROM hxt_errors

5982:
5983: DELETE FROM hxt_errors_f
5984: WHERE ROWID IN (
5985: SELECT ROWID
5986: FROM hxt_errors
5987: WHERE tim_id = p_tim_id
5988: AND hrw_id IS NOT NULL
5989: --hxt11ipatch don't delete timecard
5990: ); -- level errors

Line 5999: UPDATE hxt_errors_f

5995: WHERE ROWID IN (SELECT ROWID
5996: FROM hxt_det_hours_worked
5997: WHERE tim_id = p_tim_id);
5998:
5999: UPDATE hxt_errors_f
6000: SET effective_end_date = p_effective_start_date - 1
6001: WHERE ROWID IN (SELECT ROWID
6002: FROM hxt_errors
6003: WHERE tim_id = p_tim_id AND hrw_id IS NOT NULL

Line 6002: FROM hxt_errors

5998:
5999: UPDATE hxt_errors_f
6000: SET effective_end_date = p_effective_start_date - 1
6001: WHERE ROWID IN (SELECT ROWID
6002: FROM hxt_errors
6003: WHERE tim_id = p_tim_id AND hrw_id IS NOT NULL
6004: --hxt11ipatch don't expire timecard
6005: ); -- level errors
6006: END IF; -- Update or Correction