eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_WF_STD dependencies on WSH_NEW_DELIVERIES

Line 113: -- Finally updates the WSH_NEW_DELIVERIES or WSH_TRIPS with the

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:

Line 135: wsh_new_deliveries wnd

131: SELECT substrb(party.party_name,1,50)
132: FROM
133: hz_parties party,
134: hz_cust_accounts cust_acct,
135: wsh_new_deliveries wnd
136: WHERE
137: cust_acct.cust_account_id = wnd.customer_id and
138: cust_acct.party_id = party.party_id and
139: wnd.delivery_id = p_delivery_id;

Line 333: UPDATE WSH_NEW_DELIVERIES

329: WF_ENGINE.Startprocess(itemtype => l_itemtype,
330: itemkey => l_itemkey);
331:
332: IF (p_entity_type = 'DELIVERY') THEN
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

Line 408: wsh_new_deliveries wnd

404: SELECT substrb(party.party_name,1,50)
405: FROM
406: hz_parties party,
407: hz_cust_accounts cust_acct,
408: wsh_new_deliveries wnd
409: WHERE
410: cust_acct.cust_account_id = wnd.customer_id and
411: cust_acct.party_id = party.party_id and
412: wnd.delivery_id = p_delivery_id;

Line 610: UPDATE WSH_NEW_DELIVERIES

606: avalue => l_avalue_text);
607: WF_ENGINE.StartProcess(itemtype => 'WSHDEL',
608: itemkey => p_entity_id);
609: -- Add attributes
610: UPDATE WSH_NEW_DELIVERIES
611: SET delivery_scpod_wf_process=l_custom_process_name
612: WHERE delivery_id=p_entity_id;
613: x_process_started := 'Y';
614: END IF;

Line 669: FROM WSH_NEW_DELIVERIES WHERE delivery_id=p_entity_id;

665: x_return_status OUT NOCOPY VARCHAR2) IS
666:
667: CURSOR get_ship_dir_control IS
668: SELECT shipment_direction,shipping_control
669: FROM WSH_NEW_DELIVERIES WHERE delivery_id=p_entity_id;
670:
671: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
672:
673: CURSOR get_org_code IS

Line 1307: -- Description: This Procedure checks from WSH_NEW_DELIVERIES or WSH_TRIPS

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(

Line 1323: from wsh_new_deliveries where delivery_id = l_delivery_id;

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;
1324:
1325: l_process_name VARCHAR2(30);
1326: l_scpod_process_name VARCHAR2(30);
1327: e_invalid_type EXCEPTION;

Line 1623: UPDATE WSH_NEW_DELIVERIES

1619: END LOOP;
1620:
1621: IF (p_entity_type = 'DELIVERY') THEN
1622: FORALL i IN 1..l_suc_entity_ids.count
1623: UPDATE WSH_NEW_DELIVERIES
1624: SET delivery_wf_process=NULL,
1625: delivery_scpod_wf_process=NULL,
1626: del_wf_intransit_attr=NULL,
1627: del_wf_interface_attr=NULL,

Line 1718: FROM WSH_NEW_DELIVERIES

1714: END IF;
1715:
1716: IF (p_ship_from_location_id IS NULL AND p_entity_type = 'DELIVERY') THEN
1717: SELECT INITIAL_PICKUP_LOCATION_ID INTO l_ship_from_location_id
1718: FROM WSH_NEW_DELIVERIES
1719: WHERE delivery_id = p_entity_id;
1720: ELSE
1721: l_ship_from_location_id := p_ship_from_location_id;
1722: END IF;

Line 1806: from wsh_new_deliveries where delivery_id = l_delivery_id;

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;
1807:
1808: ENTITY_NOT_FOUND exception;
1809: INVALID_ENTITY_TYPE exception;
1810:

Line 2176: FROM WSH_NEW_DELIVERIES WND,

2172: wts.trip_id = l_trip_id;
2173:
2174: CURSOR get_delivery(l_event_key IN VARCHAR2) IS
2175: SELECT delivery_id
2176: FROM WSH_NEW_DELIVERIES WND,
2177: WSH_TRANSACTIONS_HISTORY WTH
2178: WHERE WTH.event_key = l_event_key and
2179: WTH.entity_type = 'DLVY' and
2180: WTH.entity_number = WND.name;

Line 2290: wsh_new_deliveries wnd

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
2292: AND wdl.pick_up_stop_id = wts.stop_id
2293: AND wnd.initial_pickup_location_id = wts.stop_location_id
2294: AND wnd.delivery_id = wdl.delivery_id

Line 2301: wsh_new_deliveries

2297: CURSOR c_del_carrier (p_delivery_id IN NUMBER) IS
2298: SELECT
2299: carrier_id
2300: FROM
2301: wsh_new_deliveries
2302: WHERE delivery_id = p_delivery_id;
2303:
2304: l_carrier_id NUMBER;
2305: l_return_status VARCHAR2(1);

Line 2387: wsh_new_deliveries

2383: SELECT
2384: organization_id,
2385: delivery_wf_process
2386: FROM
2387: wsh_new_deliveries
2388: WHERE delivery_id = p_delivery_id;
2389:
2390: CURSOR c_get_carrier_name (p_carrier_id IN NUMBER) IS
2391: SELECT

Line 2487: wsh_new_deliveries wnd,

2483: CURSOR c_dels(p_trip_id IN NUMBER) IS
2484: SELECT
2485: wnd.delivery_id
2486: FROM
2487: wsh_new_deliveries wnd,
2488: wsh_delivery_legs wdl,
2489: wsh_trip_stops wts
2490: WHERE
2491: wts.trip_id = p_trip_id AND