DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GEM5_BATCHSTEPLINE_ID_S

Line 381: SELECT gem5_batchstepline_id_s.NEXTVAL INTO l_resources_tbl(k).batchstep_resource_id FROM DUAL;

377: gme_debug.put_line('No. of resources = '||l_resources_mig_tbl.count);
378: END IF;
379: FOR k IN (l_rsrc_count + 1)..l_resources_tbl.count LOOP
380: l_old_bstep_rsrc_id := l_resources_tbl(k).batchstep_resource_id;
381: SELECT gem5_batchstepline_id_s.NEXTVAL INTO l_resources_tbl(k).batchstep_resource_id FROM DUAL;
382: l_resources_tbl(k).batch_id := l_batch_header.batch_id;
383: l_resources_tbl(k).batchstep_id := l_steps_tbl(i).batchstep_id;
384: l_resources_tbl(k).batchstep_activity_id := l_activities_tbl(j).batchstep_activity_id;
385: l_resources_tbl(k).actual_start_date := NULL;