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 1301: -- Description: This Procedure checks from WSH_NEW_DELIVERIES or WSH_TRIPS

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(

Line 1317: from wsh_new_deliveries where delivery_id = l_delivery_id;

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;
1318:
1319: l_process_name VARCHAR2(30);
1320: l_scpod_process_name VARCHAR2(30);
1321: e_invalid_type EXCEPTION;

Line 1617: UPDATE WSH_NEW_DELIVERIES

1613: END LOOP;
1614:
1615: IF (p_entity_type = 'DELIVERY') THEN
1616: FORALL i IN 1..l_suc_entity_ids.count
1617: UPDATE WSH_NEW_DELIVERIES
1618: SET delivery_wf_process=NULL,
1619: delivery_scpod_wf_process=NULL,
1620: del_wf_intransit_attr=NULL,
1621: del_wf_interface_attr=NULL,

Line 1712: FROM WSH_NEW_DELIVERIES

1708: END IF;
1709:
1710: IF (p_ship_from_location_id IS NULL AND p_entity_type = 'DELIVERY') THEN
1711: SELECT INITIAL_PICKUP_LOCATION_ID INTO l_ship_from_location_id
1712: FROM WSH_NEW_DELIVERIES
1713: WHERE delivery_id = p_entity_id;
1714: ELSE
1715: l_ship_from_location_id := p_ship_from_location_id;
1716: END IF;

Line 1793: FROM WSH_NEW_DELIVERIES WND,

1789: wts.trip_id = l_trip_id;
1790:
1791: CURSOR get_delivery(l_event_key IN VARCHAR2) IS
1792: SELECT delivery_id
1793: FROM WSH_NEW_DELIVERIES WND,
1794: WSH_TRANSACTIONS_HISTORY WTH
1795: WHERE WTH.event_key = l_event_key and
1796: WTH.entity_type = 'DLVY' and
1797: WTH.entity_number = WND.name;

Line 1985: wsh_new_deliveries wnd

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
1987: AND wdl.pick_up_stop_id = wts.stop_id
1988: AND wnd.initial_pickup_location_id = wts.stop_location_id
1989: AND wnd.delivery_id = wdl.delivery_id

Line 1996: wsh_new_deliveries

1992: CURSOR c_del_carrier (p_delivery_id IN NUMBER) IS
1993: SELECT
1994: carrier_id
1995: FROM
1996: wsh_new_deliveries
1997: WHERE delivery_id = p_delivery_id;
1998:
1999: l_carrier_id NUMBER;
2000: l_return_status VARCHAR2(1);

Line 2082: wsh_new_deliveries

2078: SELECT
2079: organization_id,
2080: delivery_wf_process
2081: FROM
2082: wsh_new_deliveries
2083: WHERE delivery_id = p_delivery_id;
2084:
2085: CURSOR c_get_carrier_name (p_carrier_id IN NUMBER) IS
2086: SELECT

Line 2182: wsh_new_deliveries wnd,

2178: CURSOR c_dels(p_trip_id IN NUMBER) IS
2179: SELECT
2180: wnd.delivery_id
2181: FROM
2182: wsh_new_deliveries wnd,
2183: wsh_delivery_legs wdl,
2184: wsh_trip_stops wts
2185: WHERE
2186: wts.trip_id = p_trip_id AND