APPS.WSH_DLVB_COMMON_ACTIONS dependencies on WSH_DELIVERY_DETAILS

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

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

Line 255: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Multiple_Details (

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

Line 655: FROM WSH_DELIVERY_DETAILS

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

Line 1523: FROM WSH_DELIVERY_DETAILS wdd,

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

Line 1682: FROM WSH_DELIVERY_DETAILS

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

Line 2061: FROM WSH_DELIVERY_DETAILS

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