APPS.GME_POST_MIGRATION dependencies on GEM5_WIP_TRANS_ID_S

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

1299: OPEN Cur_step_txfrs;
1300: FETCH Cur_step_txfrs BULK COLLECT INTO l_step_txfrs_mig_tbl;
1301: CLOSE Cur_step_txfrs;
1302: FOR i IN 1..l_step_txfrs_mig_tbl.count LOOP
1303: SELECT gem5_wip_trans_id_s.NEXTVAL INTO l_step_txfrs_tbl(i).wip_trans_id FROM DUAL;
1304: l_step_txfrs_tbl(i).batch_id := p_new_batch_id;
1305: l_step_txfrs_tbl(i).batchstep_no := l_step_txfrs_mig_tbl(i).batchstep_no;
1306: l_step_txfrs_tbl(i).transfer_step_no := l_step_txfrs_mig_tbl(i).transfer_step_no;
1307: l_step_txfrs_tbl(i).line_type := l_step_txfrs_mig_tbl(i).line_type;