APPS.GME_POST_MIGRATION dependencies on GEM5_WIP_TRANS_ID_S

Line 1434: SELECT gem5_wip_trans_id_s.NEXTVAL INTO l_step_txfrs_tbl(i).wip_trans_id FROM DUAL;

1430: OPEN Cur_step_txfrs;
1431: FETCH Cur_step_txfrs BULK COLLECT INTO l_step_txfrs_mig_tbl;
1432: CLOSE Cur_step_txfrs;
1433: FOR i IN 1..l_step_txfrs_mig_tbl.count LOOP
1434: SELECT gem5_wip_trans_id_s.NEXTVAL INTO l_step_txfrs_tbl(i).wip_trans_id FROM DUAL;
1435: l_step_txfrs_tbl(i).batch_id := p_new_batch_id;
1436: l_step_txfrs_tbl(i).batchstep_no := l_step_txfrs_mig_tbl(i).batchstep_no;
1437: l_step_txfrs_tbl(i).transfer_step_no := l_step_txfrs_mig_tbl(i).transfer_step_no;
1438: l_step_txfrs_tbl(i).line_type := l_step_txfrs_mig_tbl(i).line_type;