DBA Data[Home] [Help]

APPS.HXT_RETRIEVAL_ROLLBACK dependencies on HXT_REVERSED_BATCH_TC_ALL

Line 1887: DELETE FROM hxt_reversed_batch_tc_all

1883: WHERE id = p_tim_tab(i)
1884: AND batch_id = p_replacement_batch_id;
1885:
1886: FORALL i IN p_tim_tab.FIRST..p_tim_tab.LAST
1887: DELETE FROM hxt_reversed_batch_tc_all
1888: WHERE batch_id = p_batch_id
1889: AND replacement_batch_id = p_replacement_batch_id
1890: AND tim_id = p_tim_tab(i);
1891:

Line 2198: INSERT INTO hxt_reversed_batch_tc_all

2194: put_log('Updating Replacement Batch');
2195: update_replacement_batch_id(l_replacement_batch,
2196: l_tim_tab(i));
2197:
2198: INSERT INTO hxt_reversed_batch_tc_all
2199: (batch_id,
2200: replacement_batch_id,
2201: tim_id)
2202: VALUES

Line 3201: INSERT INTO hxt_reversed_batch_tc_all

3197: UPDATE hxt_timecards
3198: SET batch_id = l_replacement_batch
3199: WHERE id = p_tim_id;
3200:
3201: INSERT INTO hxt_reversed_batch_tc_all
3202: (batch_id,
3203: replacement_batch_id,
3204: tim_id)
3205: VALUES