APPS.WMS_BULK_PICK dependencies on DUAL

Line 857: from dual;

853: END IF;
854:
855: select mtl_material_transactions_s.NEXTVAL
856: into l_new_temp_id
857: from dual;
858:
859: l_mmtt_rec.primary_quantity := p_pri_qty;
860: l_mmtt_rec.transaction_quantity := p_txn_qty;
861: l_mmtt_rec.transaction_temp_id := l_new_temp_id;

Line 1124: FROM DUAL;

1120: -- processed child lines will get a new header id
1121:
1122: SELECT mtl_material_transactions_s.NEXTVAL
1123: INTO x_new_txn_hdr_id
1124: FROM DUAL;
1125:
1126: IF (l_debug = 1) THEN
1127: mydebug('New header id the child lines will have :'||x_new_txn_hdr_id,l_api_name);
1128: END IF;

Line 1317: from dual;

1313: ELSE -- qty in mmtt > qty processed ,split anyway, will be cleaned up later on
1314:
1315: select mtl_material_transactions_s.NEXTVAL
1316: into l_new_temp_id
1317: from dual;
1318:
1319: IF (l_debug = 1) THEN mydebug('split the child line with the new temp id '||l_new_temp_id,l_api_name);
1320: END IF;
1321: split_child_mmtt(c_mmtt_line.transaction_temp_id,

Line 1535: from dual;

1531: EXIT WHEN l_parent_txn_qty = 0;
1532: ELSE -- Current Child Qty is greater than Parent Picked Qty
1533: select mtl_material_transactions_s.NEXTVAL
1534: into l_new_temp_id
1535: from dual;
1536:
1537: split_child_mmtt(l_child_txn_temp_id,
1538: l_new_temp_id,
1539: l_child_pri_qty - l_parent_pri_qty