APPS.WSH_DLVB_COMMON_ACTIONS dependencies on WSH_DELIVERY_DETAILS

Line 250: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

246: --
247: -- Debug Statements
248: --
249: IF l_debug_on THEN
250: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
251: END IF;
252: --
253: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Multiple_Details (
254: p_rec_of_detail_ids =>l_det_rec,

Line 253: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Multiple_Details (

249: IF l_debug_on THEN
250: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
251: END IF;
252: --
253: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Multiple_Details (
254: p_rec_of_detail_ids =>l_det_rec,
255: p_delivery_id =>p_delivery_id,
256: p_cont_ins_id =>NULL,
257: x_return_status =>l_return_status);

Line 653: FROM WSH_DELIVERY_DETAILS

649:
650:
651: CURSOR Get_Min_Fill(v_cont_id NUMBER) IS
652: SELECT nvl(minimum_fill_percent,0)
653: FROM WSH_DELIVERY_DETAILS
654: WHERE delivery_detail_id = v_cont_id
655: AND container_flag = 'Y';
656:
657:

Line 1521: FROM WSH_DELIVERY_DETAILS wdd,

1517: CURSOR Select_Cont_Flag (v_detail_id NUMBER) IS
1518: SELECT nvl(wdd.container_flag,'N'),
1519: NVL(mp.wms_enabled_flag, 'N'),
1520: nvl(line_direction,'O') line_direction -- J-IB-NPARIKH
1521: FROM WSH_DELIVERY_DETAILS wdd,
1522: MTL_PARAMETERS mp
1523: WHERE wdd.delivery_detail_id = v_detail_id
1524: AND mp.organization_id(+) = wdd.organization_id;
1525:

Line 1680: FROM WSH_DELIVERY_DETAILS

1676: CURSOR Get_Cont_Info IS
1677: SELECT inventory_item_id, gross_weight, net_weight, filled_volume,
1678: maximum_load_weight, maximum_volume,
1679: weight_uom_code, volume_uom_code, organization_id
1680: FROM WSH_DELIVERY_DETAILS
1681: WHERE delivery_detail_id = p_container_instance_id
1682: and container_flag = 'Y';
1683:
1684: gr_wt NUMBER;

Line 2059: FROM WSH_DELIVERY_DETAILS

2055:
2056: CURSOR Get_Detail_Info IS
2057: SELECT inventory_item_id, net_weight, volume,
2058: weight_uom_code, volume_uom_code, organization_id
2059: FROM WSH_DELIVERY_DETAILS
2060: WHERE delivery_detail_id = p_delivery_detail_id
2061: AND nvl(container_flag,'N') = 'N';
2062:
2063: net_wt NUMBER;