APPS.WMS_CONTAINER_PUB dependencies on WSH_DELIVERY_DETAILS

Line 33: FROM wsh_delivery_details

29:
30: PROCEDURE update_shipping_details(p_lpn_id IN NUMBER, p_gross_weight IN NUMBER, p_net_weight IN NUMBER, p_weight_uom IN VARCHAR2, p_volume IN NUMBER, p_volume_uom IN VARCHAR2) IS
31: CURSOR wsh_lpn_id IS
32: SELECT 1
33: FROM wsh_delivery_details
34: WHERE lpn_id = p_lpn_id;
35:
36: --Bug 5190145
37: --Added following cursor to get inventory_item_id from WLPN

Line 53: --l_changed_attributes wsh_delivery_details_pub.changedattributerectype;

49: l_api_version NUMBER := 1.0;
50:
51: --Begin bug 5190145
52: --changed to call WSH_container_grp api
53: --l_changed_attributes wsh_delivery_details_pub.changedattributerectype;
54: l_changed_attributes WSH_CONTAINER_GRP.CHANGEDATTRIBUTETABTYPE;
55: l_lpn_item_id NUMBER := -99999;
56: --End Bug 5190145
57:

Line 68: FROM wsh_delivery_details

64: SELECT delivery_detail_id,
65: container_name
66: INTO l_delivery_detail_id,
67: l_container_name
68: FROM wsh_delivery_details
69: WHERE lpn_id = p_lpn_id;
70:
71:
72: --Begin bug 5190145

Line 944: WSH_DELIVERY_DETAILS table. Bug#2200989*/

940: WHERE lpn_id = p_lpn_id;
941:
942: /* Added code to check if the LPN being updated is in Shipping
943: if so, then the updated Wt ,container item are passed on to the
944: WSH_DELIVERY_DETAILS table. Bug#2200989*/
945:
946: l_net_weight := l_lpn.gross_weight;
947: IF (l_debug = 1) THEN
948: mdebug('Associate LPN***before update of shipping details***');

Line 3811: FROM wsh_delivery_details

3807: END IF;
3808:
3809: SELECT COUNT(1)
3810: INTO l_valid
3811: FROM wsh_delivery_details
3812: WHERE organization_id = l_organization_id
3813: AND lpn_id = p_lpn_id
3814: AND released_status = 'X';
3815:

Line 3818: mdebug('LPN : '||p_lpn_id||' has unprocessed records in wsh_delivery_details table, cannot reuse');

3814: AND released_status = 'X';
3815:
3816: IF l_valid > 0 THEN
3817: IF l_debug = 1 THEN
3818: mdebug('LPN : '||p_lpn_id||' has unprocessed records in wsh_delivery_details table, cannot reuse');
3819: END IF;
3820: l_table_name := 'WSH_DELIVERY_DETAILS';
3821: RAISE l_transactions_pending;
3822: END IF;

Line 3820: l_table_name := 'WSH_DELIVERY_DETAILS';

3816: IF l_valid > 0 THEN
3817: IF l_debug = 1 THEN
3818: mdebug('LPN : '||p_lpn_id||' has unprocessed records in wsh_delivery_details table, cannot reuse');
3819: END IF;
3820: l_table_name := 'WSH_DELIVERY_DETAILS';
3821: RAISE l_transactions_pending;
3822: END IF;
3823:
3824: IF p_unpack_inner_lpns = 'N' THEN