[Home] [Help]
109: -- Description: This Procedure selects and starts a Tracking Workflow process
110: -- for an entity - Trip/Delivery after checking if it is eligible.
111: -- i.e.1) No Process exists already for the Entity
112: -- 2) Global and Shipping parameters for the entity admits
113: -- Finally updates the WSH_NEW_DELIVERIES or WSH_TRIPS with the
114: -- Process name that was launched.
115: --
116: ---------------------------------------------------------------------------------------
117:
333: UPDATE WSH_NEW_DELIVERIES
334: SET DELIVERY_WF_PROCESS=l_process_name
335: WHERE delivery_id=p_entity_id;
336: ELSE
337: UPDATE WSH_TRIPS
338: SET TRIP_WF_PROCESS=l_process_name
339: WHERE trip_id=p_entity_id;
340: END IF;
341: x_process_started:= 'Y';
1297: -- x_wf_process_exists - Returns 'Y' if Wf exists, else 'N'
1298: -- IF DELIVERY_C then returns 'Y' only if Cntll wf exists
1299: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1300: --
1301: -- Description: This Procedure checks from WSH_NEW_DELIVERIES or WSH_TRIPS
1302: -- if a workflow process has been started for this entity.
1303: ---------------------------------------------------------------------------------------
1304:
1305: PROCEDURE Check_Wf_Exists(
1309: x_return_status OUT NOCOPY VARCHAR2) IS
1310:
1311: CURSOR get_trip_wf_name(l_trip_id IN NUMBER) IS
1312: select trip_wf_process
1313: from wsh_trips where trip_id=l_trip_id;
1314:
1315: CURSOR get_delviery_wf_name(l_delivery_id IN NUMBER) IS
1316: select delivery_wf_process,delivery_scpod_wf_process
1317: from wsh_new_deliveries where delivery_id = l_delivery_id;
1622: del_wf_close_attr=NULL
1623: WHERE delivery_id = l_suc_entity_ids(i);
1624: ELSIF (p_entity_type = 'TRIP') THEN
1625: FORALL i IN 1..l_suc_entity_ids.count
1626: UPDATE WSH_TRIPS
1627: SET trip_wf_process=NULL
1628: WHERE trip_id=l_suc_entity_ids(i);
1629: END IF;
1630:
1777: l_svc_status VARCHAR2(30);
1778:
1779: CURSOR get_trip(l_wf_item_key IN VARCHAR2) IS
1780: SELECT trip_id
1781: FROM WSH_TRIPS
1782: WHERE wf_item_key = l_wf_item_key;
1783:
1784: CURSOR get_trip_del(l_trip_id IN NUMBER) IS
1785: select delivery_id
1978: CURSOR c_tripordel_carrier (p_delivery_id IN NUMBER) IS
1979: SELECT
1980: NVL(wt.carrier_id, wnd.carrier_id) carrier_id
1981: FROM
1982: wsh_trips wt,
1983: wsh_delivery_legs wdl,
1984: wsh_trip_stops wts,
1985: wsh_new_deliveries wnd
1986: WHERE wts.trip_id = wt.trip_id