APPS.WSH_TRANSACTIONS_UTIL dependencies on DUAL

Line 286: select to_char(WSH_DOCUMENT_NUMBER_S.nextval) into l_txns_history_rec.document_number from dual;

282: l_txns_history_rec.trading_partner_id := p_organization_id;
283: l_txns_history_rec.document_direction := 'O';
284: l_txns_history_rec.item_type := 'WSHSUPI';
285:
286: select to_char(WSH_DOCUMENT_NUMBER_S.nextval) into l_txns_history_rec.document_number from dual;
287: IF l_debug_on THEN
288: wsh_debug_sv.log(l_module_name, 'DOCUMENT_NUMBER',l_txns_history_rec.document_number);
289: END IF;
290:

Line 721: select wsh_transaction_s.nextval into l_temp from dual;

717: IF p_delivery_name IS NOT NULL THEN
718: open del_cur;
719: fetch del_cur into l_delivery_id;
720: close del_cur;
721: select wsh_transaction_s.nextval into l_temp from dual;
722: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type( p_organization_id => p_organization_id,
723: x_return_status => x_return_status,
724: p_delivery_id => l_delivery_id
725: );

Line 734: select wsh_transaction_s.nextval into l_temp from dual;

730: raise wsh_invalid_delivery_name;
731: END IF;
732: x_event_key := l_wh_type || to_char(l_temp);
733: ELSIF l_event_code IN ('SSRI','SCBOD') THEN
734: select wsh_transaction_s.nextval into l_temp from dual;
735: x_event_key := to_char(l_temp);
736: ELSE
737: raise wsh_invalid_event_name;
738: END IF;