APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_NEW_DELIVERIES

Line 504: update wsh_new_deliveries

500: -- TPW - Distributed changes - Ends
501: END IF;
502:
503: IF (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') in ( 'TPW', 'TW2', 'CMS')) THEN
504: update wsh_new_deliveries
505: set status_code ='SA'
506: where delivery_id = p_delivery_id
507: and status_code IN ('OP','SR','SC');
508: END IF;

Line 694: l_delivery_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

690: l_lpn_unit_volume NUMBER;
691: l_lpn_weight_uom_code VARCHAR2(100);
692: l_lpn_volume_uom_code VARCHAR2(100);
693: -- K LPN CONV. rv
694: l_delivery_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
695: l_shipping_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
696:
697: -- TPW - Distributed changes
698: l_new_split_detail_id number;

Line 1029: wsh_debug_sv.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);

1025: l_shipping_param_info.GROUP_BY_INTMED_SHIP_TO_FLAG = 'Y') THEN
1026: --{
1027: IF l_debug_on THEN
1028: wsh_debug_sv.log (l_module_name, 'Getting the new delivery attributes-Delivery ID:',p_new_delivery_id);
1029: wsh_debug_sv.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
1030: END IF;
1031:
1032: WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD(p_delivery_id=>p_new_delivery_id,
1033: x_delivery_rec=>l_delivery_rec,

Line 1032: WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD(p_delivery_id=>p_new_delivery_id,

1028: wsh_debug_sv.log (l_module_name, 'Getting the new delivery attributes-Delivery ID:',p_new_delivery_id);
1029: wsh_debug_sv.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
1030: END IF;
1031:
1032: WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD(p_delivery_id=>p_new_delivery_id,
1033: x_delivery_rec=>l_delivery_rec,
1034: x_return_status=>l_return_status);
1035:
1036: IF l_debug_on THEN

Line 1037: wsh_debug_sv.log (l_module_name, 'Return Status from WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD', l_return_status);

1033: x_delivery_rec=>l_delivery_rec,
1034: x_return_status=>l_return_status);
1035:
1036: IF l_debug_on THEN
1037: wsh_debug_sv.log (l_module_name, 'Return Status from WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD', l_return_status);
1038: END IF;
1039:
1040: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1041: raise FND_API.G_EXC_ERROR ;

Line 2685: l_dlvy_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

2681: x_return_status OUT NOCOPY VARCHAR2) IS
2682:
2683: -- Bug 2753330
2684: l_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;
2685: l_dlvy_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2686: l_dlvy_out_rec_tab WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;
2687: l_index NUMBER;
2688: l_number_of_errors NUMBER := 0;
2689: l_number_of_warnings NUMBER := 0;

Line 3063: FROM wsh_new_deliveries

3059: /*
3060: -- Commented this part of the code as we allow the
3061: -- manifesting system to change the carrier, srv lvl, and mot.
3062: SELECT ship_method_code INTO l_curr_ship_method
3063: FROM wsh_new_deliveries
3064: WHERE delivery_id = l_del_int_rec.delivery_id;
3065:
3066: IF l_debug_on THEN
3067: wsh_debug_sv.log (l_module_name,'Current ship method', l_curr_ship_method);

Line 3470: FROM wsh_new_deliveries

3466: cursor org_del_id(c_del_id IN NUMBER) IS
3467: SELECT NVL(gross_weight,0),
3468: NVL(net_weight,0),
3469: NVL(volume,0)
3470: FROM wsh_new_deliveries
3471: WHERE delivery_id = c_del_id;
3472:
3473:
3474: -- J: W/V changes

Line 3658: UPDATE wsh_new_deliveries

3654: l_org_net_weight,
3655: l_org_volume;
3656: CLOSE org_del_id;
3657:
3658: UPDATE wsh_new_deliveries
3659: SET gross_weight = l_gross_weight,
3660: net_weight = l_net_weight,
3661: volume = l_volume,
3662: wv_frozen_flag = l_wv_frozen_flag

Line 5270: FROM wsh_new_deliveries

5266: wsh_debug_sv.logmsg(l_module_name, 'Locking the Delivery');
5267: END IF;
5268: SELECT delivery_id
5269: INTO l_dummy_id
5270: FROM wsh_new_deliveries
5271: WHERE delivery_id = p_delivery_id
5272: FOR UPDATE NOWAIT;
5273:
5274: IF l_debug_on THEN