APPS.WSH_WF_INTERFACE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21

SELECT status_code
FROM wsh_new_deliveries
WHERE delivery_id = to_number(itemkey);

Line: 26

SELECT count(*)
FROM wsh_delivery_assignments_v WDA,
     WSH_DELIVERY_DETAILS WDD
where
     WDA.delivery_detail_id=WDD.delivery_detail_id AND
     WDD.CONTAINER_FLAG = 'N' AND
     delivery_id = to_number(itemkey);

Line: 160

SELECT wts.stop_id
FROM   wsh_trip_stops    wts,
    wsh_delivery_legs  wdl,
    wsh_new_deliveries wnd
WHERE  wnd.delivery_id    = to_number(itemkey)
AND   wdl.delivery_id     = wnd.delivery_id
AND   wts.stop_id         = wdl.pick_up_stop_id
AND   wts.stop_location_id = wnd.initial_pickup_location_id;

Line: 206

    l_action_prms.action_code := 'UPDATE-STATUS';

Line: 214

    UPDATE WSH_NEW_DELIVERIES
	    SET del_wf_intransit_attr = 'P'
            WHERE delivery_id = l_delivery_id;

Line: 242

        UPDATE WSH_NEW_DELIVERIES
	    SET del_wf_intransit_attr = 'C'
            WHERE delivery_id = l_delivery_id;

Line: 249

        UPDATE WSH_NEW_DELIVERIES
	    SET del_wf_intransit_attr = 'E'
            WHERE delivery_id = l_delivery_id;

Line: 437

    l_action_prms.form_flag             := NULL; --PROCESS_CARRIER_SELECTION

Line: 439

    UPDATE WSH_NEW_DELIVERIES
	    SET del_wf_close_attr = 'P'
            WHERE delivery_id = l_delivery_id;

Line: 468

        UPDATE WSH_NEW_DELIVERIES
	    SET del_wf_close_attr = 'C'
            WHERE delivery_id = l_delivery_id;

Line: 475

        UPDATE WSH_NEW_DELIVERIES
	    SET del_wf_close_attr = 'E'
            WHERE delivery_id = l_delivery_id;

Line: 579

    UPDATE WSH_NEW_DELIVERIES
	    SET del_wf_interface_attr = 'P'
            WHERE delivery_id = l_delivery_id;

Line: 593

	UPDATE WSH_NEW_DELIVERIES
	    SET del_wf_interface_attr = 'E'
            WHERE delivery_id = l_delivery_id;

Line: 600

        UPDATE WSH_NEW_DELIVERIES
	    SET del_wf_interface_attr = 'C'
            WHERE delivery_id = l_delivery_id;

Line: 1340

SELECT enable_sc_wf
FROM WSH_GLOBAL_PARAMETERS;

Line: 1344

SELECT enable_sc_wf
FROM WSH_SHIPPING_PARAMETERS
WHERE organization_id = p_org_id;

Line: 1349

SELECT organization_code
FROM MTL_PARAMETERS
WHERE organization_id = p_org_id;

Line: 1420

	UPDATE WSH_NEW_DELIVERIES
            SET delivery_scpod_wf_process=l_custom_process_name
            WHERE delivery_id=to_number(itemkey);

Line: 1488

SELECT count(wnd.delivery_id)
FROM wsh_new_deliveries wnd,
     mtl_parameters mp,
     wsh_carriers wc
WHERE  wnd.organization_id = mp.organization_id
AND    wnd.carrier_id = wc.carrier_id
AND    wc.manifesting_enabled_flag = 'Y'
AND    mp.carrier_manifesting_flag = 'Y'
AND    wnd.delivery_id = l_delivery_id;

Line: 1589

PROCEDURE Selector(
		itemtype IN VARCHAR2,
		itemkey IN VARCHAR2,
		actid IN NUMBER,
		funcmode IN VARCHAR2,
		resultout OUT NOCOPY VARCHAR2) IS

l_user_id             NUMBER;

Line: 1607

l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'SELECTOR';

Line: 1693

END Selector;