APPS.WMS_BULK_PICK dependencies on DUAL

Line 897: from dual;

893: END IF;
894:
895: select mtl_material_transactions_s.NEXTVAL
896: into l_new_temp_id
897: from dual;
898:
899: l_mmtt_rec.primary_quantity := p_pri_qty;
900: l_mmtt_rec.transaction_quantity := p_txn_qty;
901: l_mmtt_rec.secondary_transaction_quantity := p_sec_qty ; --12747184

Line 1415: FROM DUAL;

1411: -- processed child lines will get a new header id
1412:
1413: SELECT mtl_material_transactions_s.NEXTVAL
1414: INTO x_new_txn_hdr_id
1415: FROM DUAL;
1416:
1417: IF (l_debug = 1) THEN
1418: mydebug('New header id the child lines will have :'||x_new_txn_hdr_id,l_api_name);
1419: END IF;

Line 1683: FROM dual;

1679: l_link_mtlt_needed := 'N';
1680: ELSE -- qty in mmtt > qty processed ,split anyway, will be cleaned up later on
1681: SELECT mtl_material_transactions_s.NEXTVAL
1682: INTO l_new_temp_id
1683: FROM dual;
1684:
1685: IF (l_debug = 1) THEN
1686: mydebug('split the child line with the new temp id '
1687: ||l_new_temp_id,l_api_name);

Line 1943: FROM dual;

1939: END IF;
1940: -- Split the Child mmtt and insert mtlt.
1941: SELECT mtl_material_transactions_s.NEXTVAL
1942: INTO l_new_temp_id
1943: FROM dual;
1944:
1945: l_progress := 3.2;
1946: IF l_debug = 1 THEN
1947: mydebug('Split the Child MMTT ' , l_api_name);

Line 2164: from dual;

2160: EXIT WHEN l_parent_txn_qty = 0;
2161: ELSE -- Current Child Qty is greater than Parent Picked Qty
2162: select mtl_material_transactions_s.NEXTVAL
2163: into l_new_temp_id
2164: from dual;
2165:
2166: split_child_mmtt(l_child_txn_temp_id,
2167: l_new_temp_id,
2168: l_child_pri_qty - l_parent_pri_qty,