APPS.WSH_WF_STD SQL Statements

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

Line: 131

SELECT substrb(party.party_name,1,50)
FROM
    hz_parties party,
    hz_cust_accounts cust_acct,
    wsh_new_deliveries wnd
WHERE
    cust_acct.cust_account_id = wnd.customer_id and
    cust_acct.party_id = party.party_id and
    wnd.delivery_id = p_delivery_id;

Line: 174

SAVEPOINT	START_WF_PROCESS_UPDATE;

Line: 239

    WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.PROCESS_SELECTOR',
WSH_DEBUG_SV.C_PROC_LEVEL);

Line: 243

Process_Selector(p_entity_type     => p_entity_type,
                 p_entity_id       => p_entity_id,
		 p_organization_id => p_organization_id,
		 x_wf_process      => l_process_name,
		 x_return_status   => l_return_status);

Line: 333

    UPDATE WSH_NEW_DELIVERIES
        SET DELIVERY_WF_PROCESS=l_process_name
        WHERE delivery_id=p_entity_id;

Line: 337

    UPDATE WSH_TRIPS
        SET TRIP_WF_PROCESS=l_process_name
        WHERE trip_id=p_entity_id;

Line: 399

SELECT organization_code
FROM MTL_PARAMETERS
WHERE organization_id  = p_organization_id;

Line: 404

SELECT substrb(party.party_name,1,50)
FROM
    hz_parties party,
    hz_cust_accounts cust_acct,
    wsh_new_deliveries wnd
WHERE
    cust_acct.cust_account_id = wnd.customer_id and
    cust_acct.party_id = party.party_id and
    wnd.delivery_id = p_delivery_id;

Line: 447

SAVEPOINT START_SCPOD_C_PROCESS_UPDATE;

Line: 610

        UPDATE WSH_NEW_DELIVERIES
            SET delivery_scpod_wf_process=l_custom_process_name
            WHERE delivery_id=p_entity_id;

Line: 660

PROCEDURE process_selector(
		p_entity_type IN VARCHAR2,
		p_entity_id IN	NUMBER,
		p_organization_id IN NUMBER,
		x_wf_process OUT NOCOPY VARCHAR2,
                x_return_status OUT NOCOPY VARCHAR2) IS

CURSOR get_ship_dir_control IS
SELECT shipment_direction,shipping_control
FROM WSH_NEW_DELIVERIES WHERE delivery_id=p_entity_id;

Line: 674

SELECT organization_code
FROM MTL_PARAMETERS
WHERE organization_id  = p_organization_id;

Line: 679

SELECT count(*)
FROM wsh_delivery_assignments_v wda,
     wsh_delivery_details wdd
WHERE
     wda.delivery_id = p_entity_id
     AND wda.delivery_detail_id = wdd.delivery_detail_id
     AND wdd.container_flag = 'N'
     AND wdd.pickable_flag <> 'Y' ;

Line: 709

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

Line: 931

END process_selector;

Line: 1312

select trip_wf_process
from wsh_trips where trip_id=l_trip_id;

Line: 1316

select delivery_wf_process,delivery_scpod_wf_process
from wsh_new_deliveries where delivery_id = l_delivery_id;

Line: 1446

select meaning
from WSH_LOOKUPS where lookup_type = p_wf_process and lookup_code = p_org_code
and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
and enabled_flag='Y';

Line: 1452

select meaning
from WSH_LOOKUPS where lookup_type = p_wf_process and lookup_code = 'ALL'
and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
and enabled_flag='Y';

Line: 1563

SAVEPOINT	PURGE_ENTITY_UPDATE;

Line: 1617

    UPDATE WSH_NEW_DELIVERIES
    SET delivery_wf_process=NULL,
        delivery_scpod_wf_process=NULL,
	del_wf_intransit_attr=NULL,
	del_wf_interface_attr=NULL,
	del_wf_close_attr=NULL
    WHERE  delivery_id = l_suc_entity_ids(i);

Line: 1626

    UPDATE WSH_TRIPS
    SET trip_wf_process=NULL
    WHERE  trip_id=l_suc_entity_ids(i);

Line: 1711

    SELECT INITIAL_PICKUP_LOCATION_ID INTO l_ship_from_location_id
    FROM WSH_NEW_DELIVERIES
    WHERE delivery_id = p_entity_id;

Line: 1780

SELECT trip_id
FROM WSH_TRIPS
WHERE wf_item_key = l_wf_item_key;

Line: 1785

select delivery_id
from WSH_DELIVERY_LEGS wdl,
     WSH_TRIP_STOPS wts
where wdl.pick_up_stop_id = wts.stop_id and
      wts.trip_id = l_trip_id;

Line: 1792

SELECT delivery_id
FROM WSH_NEW_DELIVERIES WND,
     WSH_TRANSACTIONS_HISTORY WTH
WHERE WTH.event_key = l_event_key and
      WTH.entity_type = 'DLVY' and
      WTH.entity_number = WND.name;

Line: 1800

SELECT activity_status_code
FROM WF_ITEM_ACTIVITY_STATUSES_V
WHERE item_type = 'WSHDEL'
   AND item_key = l_eventkey
   AND activity_name = l_act_name;

Line: 1979

SELECT
NVL(wt.carrier_id, wnd.carrier_id) carrier_id
FROM
wsh_trips wt,
wsh_delivery_legs wdl,
wsh_trip_stops wts,
wsh_new_deliveries wnd
WHERE wts.trip_id = wt.trip_id
AND   wdl.pick_up_stop_id = wts.stop_id
AND   wnd.initial_pickup_location_id = wts.stop_location_id
AND   wnd.delivery_id = wdl.delivery_id
AND   wnd.delivery_id = p_delivery_id;

Line: 1993

SELECT
carrier_id
FROM
wsh_new_deliveries
WHERE delivery_id = p_delivery_id;

Line: 2078

SELECT
organization_id,
delivery_wf_process
FROM
wsh_new_deliveries
WHERE delivery_id = p_delivery_id;

Line: 2086

SELECT
carrier_name
FROM
wsh_carriers_v
WHERE carrier_id = p_carrier_id;

Line: 2117

                             p_event => 'oracle.apps.wsh.delivery.gen.carrierselected',
	                     p_organization_id => l_org_id,
			     x_return_status => l_wf_rs);

Line: 2142

                             p_event => 'oracle.apps.wsh.delivery.gen.carrierselected',
			     p_organization_id => l_org_id,
			     x_return_status => l_wf_rs);

Line: 2179

SELECT
wnd.delivery_id
FROM
wsh_new_deliveries wnd,
wsh_delivery_legs wdl,
wsh_trip_stops wts
WHERE
wts.trip_id = p_trip_id AND
wts.stop_id = wdl.pick_up_stop_id AND
wnd.initial_pickup_location_id = wts.stop_location_id AND
wdl.delivery_id = wnd.delivery_id;