DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_STEP_RESOURCES

Line 102: FROM gme_batch_step_resources_mig

98: -- Bug 13706812 - Use old batch id to make use of index.
99: -- Bug 9090024 - Where clause was incorrectly looking at step id instead of step activity id.
100: CURSOR Cur_get_resources(v_batchstep_activity_id NUMBER, v_old_batch_id NUMBER) IS
101: SELECT *
102: FROM gme_batch_step_resources_mig
103: WHERE batchstep_activity_id = v_batchstep_activity_id
104: AND batch_id = v_old_batch_id;
105:
106: -- Bug 13706812 - Use old batch id to make use of index.

Line 444: INSERT INTO gme_batch_step_resources VALUES l_resources_tbl(a);

440: IF (g_debug <= gme_debug.g_log_statement) THEN
441: gme_debug.put_line('After insert activities');
442: END IF;
443: FORALL a IN 1..l_resources_tbl.count
444: INSERT INTO gme_batch_step_resources VALUES l_resources_tbl(a);
445: IF (g_debug <= gme_debug.g_log_statement) THEN
446: gme_debug.put_line('After insert resources');
447: END IF;
448: FORALL a IN 1..l_proc_param_tbl.count

Line 1806: FROM gme_resource_txns t, gme_batch_step_resources r,

1802: UPDATE gme_resource_txns
1803: SET trans_date = l_date
1804: WHERE trans_date < l_date
1805: AND POC_TRANS_ID IN (select t.POC_TRANS_ID
1806: FROM gme_resource_txns t, gme_batch_step_resources r,
1807: gme_batch_step_activities a, gme_batch_steps s
1808: WHERE s.batch_id = l_batch_header.batch_id
1809: AND t.doc_id = l_batch_header.batch_id
1810: AND s.batchstep_id = l_step_rec.batchstep_id