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 716: select wsh_transaction_s.nextval into l_temp from dual;

712: IF l_event_code IN ('SPWF','SSAI','SSAO','CONFIRM') THEN
713: -- R12.1.1 STANDALONE PROJECT
714: -- LSP PROJECT : Consider LSP mode also.
715: IF ( WMS_DEPLOY.WMS_DEPLOYMENT_MODE IN ('D','L') AND (l_event_code = 'SSAO')) THEN
716: select wsh_transaction_s.nextval into l_temp from dual;
717: x_event_key := to_char(l_temp);
718: ELSE
719: open get_key;
720: Fetch get_key into x_event_key;

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

724: IF p_delivery_name IS NOT NULL THEN
725: open del_cur;
726: fetch del_cur into l_delivery_id;
727: close del_cur;
728: select wsh_transaction_s.nextval into l_temp from dual;
729: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type( p_organization_id => p_organization_id,
730: x_return_status => x_return_status,
731: p_delivery_id => l_delivery_id
732: );

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

738: END IF;
739: x_event_key := l_wh_type || to_char(l_temp);
740: ELSIF l_event_code = 'BSRO' THEN --Fulfillment Batch XML Project
741: IF p_delivery_name IS NOT NULL THEN
742: select wsh_transaction_s.nextval into l_temp from dual;
743: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type( p_organization_id => p_organization_id,
744: x_return_status => x_return_status);
745: IF l_debug_on THEN
746: wsh_debug_sv.log (l_module_name,'Get_Warehouse_Type l_wh_type,x_return_status',l_wh_type||','||x_return_status );

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

749: raise wsh_invalid_batch_name;
750: END IF;
751: x_event_key := l_wh_type || to_char(l_temp);
752: ELSIF l_event_code IN ('SSRI','SCBOD') THEN
753: select wsh_transaction_s.nextval into l_temp from dual;
754: x_event_key := to_char(l_temp);
755: --Fulfillment Batch XML Project
756: --Event key will be generated for new business event added for shipment Advice Inbound Procesing for Shipment Batches.
757: ELSIF l_event_code in ('BSAI') THEN

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

754: x_event_key := to_char(l_temp);
755: --Fulfillment Batch XML Project
756: --Event key will be generated for new business event added for shipment Advice Inbound Procesing for Shipment Batches.
757: ELSIF l_event_code in ('BSAI') THEN
758: select wsh_transaction_s.nextval into l_temp from dual;
759: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(p_organization_id => p_organization_id,
760: x_return_status => x_return_status,
761: p_delivery_id => l_delivery_id);
762: IF l_debug_on THEN