[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';
1303: -- x_wf_process_exists - Returns 'Y' if Wf exists, else 'N'
1304: -- IF DELIVERY_C then returns 'Y' only if Cntll wf exists
1305: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1306: --
1307: -- Description: This Procedure checks from WSH_NEW_DELIVERIES or WSH_TRIPS
1308: -- if a workflow process has been started for this entity.
1309: ---------------------------------------------------------------------------------------
1310:
1311: PROCEDURE Check_Wf_Exists(
1315: x_return_status OUT NOCOPY VARCHAR2) IS
1316:
1317: CURSOR get_trip_wf_name(l_trip_id IN NUMBER) IS
1318: select trip_wf_process
1319: from wsh_trips where trip_id=l_trip_id;
1320:
1321: CURSOR get_delivery_wf_name(l_delivery_id IN NUMBER) IS
1322: select delivery_wf_process,delivery_scpod_wf_process
1323: from wsh_new_deliveries where delivery_id = l_delivery_id;
1628: del_wf_close_attr=NULL
1629: WHERE delivery_id = l_suc_entity_ids(i);
1630: ELSIF (p_entity_type = 'TRIP') THEN
1631: FORALL i IN 1..l_suc_entity_ids.count
1632: UPDATE WSH_TRIPS
1633: SET trip_wf_process=NULL
1634: WHERE trip_id=l_suc_entity_ids(i);
1635: END IF;
1636:
1798: l_scpod_process_name VARCHAR2(30);
1799:
1800: CURSOR get_trip_wf_name(l_trip_id IN NUMBER) IS
1801: select trip_wf_process
1802: from wsh_trips where trip_id=l_trip_id;
1803:
1804: CURSOR get_delivery_wf_name(l_delivery_id IN NUMBER) IS
1805: select delivery_wf_process,delivery_scpod_wf_process
1806: from wsh_new_deliveries where delivery_id = l_delivery_id;
2160: l_svc_status VARCHAR2(30);
2161:
2162: CURSOR get_trip(l_wf_item_key IN VARCHAR2) IS
2163: SELECT trip_id
2164: FROM WSH_TRIPS
2165: WHERE wf_item_key = l_wf_item_key;
2166:
2167: CURSOR get_trip_del(l_trip_id IN NUMBER) IS
2168: select delivery_id
2283: CURSOR c_tripordel_carrier (p_delivery_id IN NUMBER) IS
2284: SELECT
2285: NVL(wt.carrier_id, wnd.carrier_id) carrier_id
2286: FROM
2287: wsh_trips wt,
2288: wsh_delivery_legs wdl,
2289: wsh_trip_stops wts,
2290: wsh_new_deliveries wnd
2291: WHERE wts.trip_id = wt.trip_id