APPS.WSH_SHIPMENT_BATCH_PKG dependencies on DUAL

Line 840: FROM DUAL;

836: END IF;
837:
838: SELECT Wsh_Shipment_Batches_S.nextval
839: INTO l_batch_id
840: FROM DUAL;
841:
842: --Stores batch id of batches created.
843: l_batch_tbl(l_batch_tbl.count+1) := l_batch_id;
844: l_raise_batch_tbl(l_raise_batch_tbl.count+1) := l_batch_id; --Fulfillment Batch XML Project

Line 969: SELECT to_char(WSH_DOCUMENT_NUMBER_S.nextval) INTO l_txns_history_rec.document_number FROM dual;

965: l_txns_history_rec.document_direction := 'O';
966: l_txns_history_rec.item_type := 'WSHBATO';
967: l_txns_history_rec.event_name := 'oracle.apps.wsh.batch.bsro';
968:
969: SELECT to_char(WSH_DOCUMENT_NUMBER_S.nextval) INTO l_txns_history_rec.document_number FROM dual;
970: IF l_debug_on THEN
971: wsh_debug_sv.log(l_module_name, 'DOCUMENT_NUMBER',l_txns_history_rec.document_number);
972: END IF;
973: