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_ASN_RECEIPT_PVT dependencies on WSH_NEW_DELIVERIES

Line 789: UPDATE wsh_new_deliveries

785: WSH_DEBUG_SV.log(l_module_name,'p_diff_net_weight',p_diff_net_weight);
786: WSH_DEBUG_SV.log(l_module_name,'p_diff_volume',p_diff_volume);
787: END IF;
788: --
789: UPDATE wsh_new_deliveries
790: SET gross_weight = NVL(gross_weight,0) - NVL(p_diff_gross_weight,0),
791: net_weight = NVL(net_weight,0) - NVL(p_diff_net_weight,0),
792: volume = NVL(volume,0) - NVL(p_diff_volume,0),
793: LAST_UPDATE_DATE = SYSDATE,

Line 1531: FROM wsh_new_deliveries dl,

1527:
1528: -- Cursor to fetch the delivery,delivery leg and trip infrmation for the delivery being processed.
1529: CURSOR get_delivery_info(p_del_id_c1 NUMBER) IS
1530: SELECT t.trip_id
1531: FROM wsh_new_deliveries dl,
1532: wsh_delivery_legs dg,
1533: wsh_trip_stops st,
1534: wsh_trips t
1535: WHERE dl.delivery_id = p_del_id_c1 AND

Line 1545: FROM wsh_new_deliveries dl,

1541: -- Cursor to fing if a particular delivery has legs associated with it or not.
1542:
1543: CURSOR c_has_del_leg(p_del_id_c2 NUMBER) IS
1544: SELECT '1'
1545: FROM wsh_new_deliveries dl,
1546: wsh_delivery_legs dg
1547: WHERE dl.delivery_id = p_del_id_c2 AND
1548: dl.delivery_id = dg.delivery_id;
1549:

Line 1571: wsh_new_deliveries wnd

1567: wdd.requested_quantity requested_quantity
1568: FROM wsh_delivery_details wdd,
1569: wsh_delivery_assignments_v wda,
1570: wsh_delivery_details wdd1,
1571: wsh_new_deliveries wnd
1572: where wdd.delivery_detail_id = p_delivery_detail_id
1573: AND wdd.delivery_detail_id = wda.delivery_detail_id
1574: --AND wda.delivery_id = wnd.delivery_id
1575: AND wda.parent_delivery_detail_id = wdd1.delivery_detail_id (+)

Line 3777: WSH_NEW_DELIVERIES WND

3773: wdd.po_shipment_line_id
3774: FROM
3775: WSH_DELIVERY_DETAILS WDD,
3776: wsh_delivery_assignments_v WDA,
3777: WSH_NEW_DELIVERIES WND
3778: WHERE wdd.delivery_detail_id = wda.delivery_detail_id and
3779: wdd.line_direction not in ('O','IO') and
3780: Wda.delivery_id = wnd.delivery_id and
3781: Wnd.asn_shipment_header_id = p_header_id;*/

Line 3790: Wsh_new_deliveries

3786: Cursor c_get_deliveries(p_header_id NUMBER) IS
3787: SELECT
3788: Delivery_id
3789: FROM
3790: Wsh_new_deliveries
3791: WHERE ASN_SHIPMENT_HEADER_ID = p_header_id;
3792:
3793: l_line_rec OE_WSH_BULK_GRP.line_rec_type;
3794: l_max_txn_id NUMBER;

Line 3895: wsh_new_deliveries wnd

3891: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3892: where delivery_detail_id in (select wdd.delivery_detail_id
3893: from wsh_delivery_details wdd,
3894: wsh_delivery_assignments_v wda,
3895: wsh_new_deliveries wnd
3896: where wdd.delivery_detail_id = wda.delivery_detail_id
3897: and wda.delivery_id = wnd.delivery_id
3898: and wnd.asn_shipment_header_id = p_header_id
3899: and wdd.line_direction not in ('O','IO'))

Line 4288: wsh_new_deliveries wnd

4284: wdd.delivery_detail_id, nvl(wdd.container_flag,'N') container_flag
4285: FROM
4286: wsh_delivery_details wdd,
4287: wsh_delivery_assignments_v wda,
4288: wsh_new_deliveries wnd
4289: WHERE
4290: wdd.delivery_detail_id = wda.delivery_detail_id AND
4291: wda.delivery_id = wnd.delivery_id AND
4292: wnd.asn_shipment_header_id = p_shipment_header_id AND

Line 5222: FROM wsh_new_deliveries wnd

5218:
5219: CURSOR empty_it_dlvy_csr (p_shipment_header_id IN NUMBER)
5220: IS
5221: SELECT delivery_id, ultimate_dropoff_date, name, status_code
5222: FROM wsh_new_deliveries wnd
5223: WHERE wnd.asn_shipment_header_id = p_shipment_header_id
5224: AND wnd.status_code = 'IT'
5225: AND NOT EXISTS (
5226: select 1

Line 6365: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

6361: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
6362: x_return_status OUT NOCOPY VARCHAR2) IS
6363:
6364:
6365: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
6366: l_num_warnings NUMBER := 0;
6367: l_num_errors NUMBER := 0;
6368: l_return_status VARCHAR2(1);
6369: l_organization_id Number;

Line 6374: from wsh_new_deliveries wnd,

6370:
6371: --Cursor to get the Ship method code for a Delivery ID for a given Carrier.
6372: cursor l_carrier_csr (p_delivery_id IN NUMBER, p_carrier_id IN NUMBER) IS
6373: select wcs.ship_method_code
6374: from wsh_new_deliveries wnd,
6375: wsh_carriers_v wcv,
6376: wsh_carrier_services wcs,
6377: wsh_org_carrier_services wocs
6378: where wnd.delivery_id = p_delivery_id

Line 6459: UPDATE WSH_NEW_DELIVERIES

6455: WSH_DEBUG_SV.log(l_module_name,'p_shipment_header_id_tab(i)',p_shipment_header_id_tab(i));
6456: WSH_DEBUG_SV.log(l_module_name,'p_initial_pickup_date_tab(i)',p_initial_pickup_date_tab(i));
6457: END IF;
6458:
6459: UPDATE WSH_NEW_DELIVERIES
6460: SET status_code = 'IT',
6461: ASN_SHIPMENT_HEADER_ID = p_shipment_header_id_tab(i),
6462: INITIAL_PICKUP_DATE = nvl(p_initial_pickup_date_tab(i),INITIAL_PICKUP_DATE),
6463: ULTIMATE_DROPOFF_DATE = GREATEST

Line 6511: UPDATE WSH_NEW_DELIVERIES

6507: END IF;
6508: --Done Raise Event: Pick To Pod Workflow
6509: */
6510: ELSIF p_action_prms.action_code = 'CANCEL_ASN' or p_action_prms.action_code = 'REVERT_ASN' then
6511: UPDATE WSH_NEW_DELIVERIES
6512: SET status_code = 'OP',
6513: Asn_shipment_header_id = NULL,
6514: last_update_date = SYSDATE,
6515: last_updated_by = FND_GLOBAL.USER_ID,

Line 6544: UPDATE WSH_NEW_DELIVERIES

6540: WSH_DEBUG_SV.log(l_module_name,'p_shipment_header_id_tab(i)',p_shipment_header_id_tab(i));
6541: WSH_DEBUG_SV.log(l_module_name,'p_expected_receipt_date_tab(i)',p_expected_receipt_date_tab(i));
6542: END IF;
6543:
6544: UPDATE WSH_NEW_DELIVERIES
6545: SET status_code = 'CL',
6546: RCV_SHIPMENT_HEADER_ID = p_shipment_header_id_tab(i),
6547: --INITIAL_PICKUP_DATE = p_initial_pickup_date_tab(i),
6548: --INITIAL_PICKUP_DATE = nvl(p_initial_pickup_date_tab(i),INITIAL_PICKUP_DATE),

Line 6627: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.POPULATE_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);

6623: --
6624: -- Debug Statements
6625: --
6626: IF l_debug_on THEN
6627: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.POPULATE_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
6628: END IF;
6629: --
6630: WSH_NEW_DELIVERIES_PVT.Populate_Record
6631: (p_delivery_id => p_del_ids(p_del_ids.FIRST),

Line 6630: WSH_NEW_DELIVERIES_PVT.Populate_Record

6626: IF l_debug_on THEN
6627: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.POPULATE_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
6628: END IF;
6629: --
6630: WSH_NEW_DELIVERIES_PVT.Populate_Record
6631: (p_delivery_id => p_del_ids(p_del_ids.FIRST),
6632: x_delivery_info => l_delivery_info,
6633: x_return_status => l_return_status);
6634: --

Line 6654: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

6650: --
6651: -- Debug Statements
6652: --
6653: IF l_debug_on THEN
6654: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
6655: END IF;
6656: --
6657: WSH_NEW_DELIVERIES_PVT.Update_Delivery
6658: (p_rowid => l_delivery_info.ROWID,

Line 6657: WSH_NEW_DELIVERIES_PVT.Update_Delivery

6653: IF l_debug_on THEN
6654: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
6655: END IF;
6656: --
6657: WSH_NEW_DELIVERIES_PVT.Update_Delivery
6658: (p_rowid => l_delivery_info.ROWID,
6659: p_delivery_info => l_delivery_info,
6660: x_return_status => l_return_status);
6661: --

Line 7392: FROM wsh_new_deliveries dl,

7388:
7389: --Cursor to get the Delivery Leg ID for a given Delivery.
7390: CURSOR get_delivery_info(p_delivery_id NUMBER) IS
7391: SELECT dg.delivery_leg_id
7392: FROM wsh_new_deliveries dl,
7393: wsh_delivery_legs dg,
7394: wsh_trip_stops st,
7395: wsh_trips t
7396: WHERE dl.delivery_id = p_delivery_id AND

Line 7404: FROM wsh_new_deliveries wnd,

7400:
7401: --Cursor to get the last Delivery Leg ID for a given Delivery.
7402: CURSOR c_get_last_leg(p_delivery_id NUMBER) IS
7403: SELECT wdl.delivery_leg_id
7404: FROM wsh_new_deliveries wnd,
7405: wsh_delivery_legs wdl,
7406: wsh_trip_stops wts,
7407: wsh_trips wt
7408: WHERE wnd.delivery_id = p_delivery_id AND

Line 7630: AND entity_name = 'WSH_NEW_DELIVERIES'

7626: last_updated_by = FND_GLOBAL.USER_ID,
7627: last_update_login = FND_GLOBAL.LOGIN_ID
7628: where
7629: entity_id = l_stored_del_id
7630: AND entity_name = 'WSH_NEW_DELIVERIES'
7631: AND document_type= 'PACK_TYPE';
7632:
7633:
7634: IF SQL%NOTFOUND THEN

Line 7642: p_entity_name => 'WSH_NEW_DELIVERIES',

7638: END IF;
7639:
7640: create_update_inbound_document (
7641: p_document_number => l_psno,
7642: p_entity_name => 'WSH_NEW_DELIVERIES',
7643: p_delivery_id => l_stored_del_id,
7644: p_transaction_type => p_action_prms.action_code,
7645: x_return_status => l_return_status);
7646:

Line 7667: wsh_new_deliveries

7663: -- the waybill has not changed within the lines belonging to the
7664: -- same delivery.
7665: IF ((l_waybill_flag = 0) AND (l_waybill IS NOT NULL) ) THEN
7666: UPDATE
7667: wsh_new_deliveries
7668: SET
7669: waybill = l_waybill,
7670: last_update_date = SYSDATE,
7671: last_updated_by = FND_GLOBAL.USER_ID,

Line 7743: -- input p_entity_name is 'WSH_NEW_DELIVERIES', then this parameter holds PSNO.

7739: -- Parameters :
7740: -- IN:
7741: -- p_document_number IN VARCHAR2
7742: -- This holds the PSNO/BOL depending upon the entity name.If the
7743: -- input p_entity_name is 'WSH_NEW_DELIVERIES', then this parameter holds PSNO.
7744: -- If the input p_entity_name is 'WSH_DELIVERY_LEGS', then this parameter
7745: -- holds BOL.
7746: -- p_entity_name IN VARCHAR2
7747: -- Specifies what kind of document is present in the input parameter

Line 7776: FROM wsh_new_deliveries dl,

7772: dl.ULTIMATE_DROPOFF_LOCATION_ID,
7773: t.ship_method_code,
7774: dl.organization_id,
7775: t.name
7776: FROM wsh_new_deliveries dl,
7777: wsh_delivery_legs dg,
7778: wsh_trip_stops st,
7779: wsh_trips t
7780: WHERE dl.delivery_id = p_delivery_id AND

Line 7906: ELSIF p_entity_name = 'WSH_NEW_DELIVERIES' THEN

7902: l_document_type := 'BOL';
7903: l_document_sub_type := l_ship_method_code; -- l_document_sub_type used to retrive the prefix and suufix and docuemnt category type .which is not needed
7904: l_entity_id := l_delivery_leg_id;
7905:
7906: ELSIF p_entity_name = 'WSH_NEW_DELIVERIES' THEN
7907: l_document_type := 'PACK_TYPE';
7908: l_document_sub_type := 'SALES_ORDER';
7909: l_entity_id := p_delivery_id;
7910:

Line 7954: ELSIF p_entity_name ='WSH_NEW_DELIVERIES' THEN

7950: --
7951:
7952: IF p_entity_name = 'WSH_DELIVERY_LEGS' THEN
7953: l_status := 'PLANNED';
7954: ELSIF p_entity_name ='WSH_NEW_DELIVERIES' THEN
7955: l_status := 'OPEN';
7956: END IF;
7957:
7958: --}