DBA Data[Home] [Help]

APPS.WSH_TRANSACTIONS_UTIL dependencies on WSH_TRANSACTION_S

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;