DBA Data[Home] [Help]

APPS.WSH_CONTAINER_UTILITIES dependencies on WSH_WMS_LPN_GRP

Line 2464: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN

2460: IF l_debug_on THEN
2461: WSH_DEBUG_SV.log(l_module_name, 'Master serial number is updated on this container.', p_container_instance_id);
2462: END IF;
2463:
2464: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y' THEN
2465: --{
2466: l_wms_org := wsh_util_validate.check_wms_org(l_organization_id);
2467:
2468: IF l_line_direction IN ('O', 'IO')

Line 2472: (WSH_WMS_LPN_GRP.GK_WMS_UPD_MISC and l_wms_org = 'Y')

2468: IF l_line_direction IN ('O', 'IO')
2469: AND l_cnt_flag = 'Y'
2470: AND
2471: (
2472: (WSH_WMS_LPN_GRP.GK_WMS_UPD_MISC and l_wms_org = 'Y')
2473: OR (WSH_WMS_LPN_GRP.GK_INV_UPD_MISC and l_wms_org = 'N')
2474: )
2475: THEN
2476: --{

Line 2473: OR (WSH_WMS_LPN_GRP.GK_INV_UPD_MISC and l_wms_org = 'N')

2469: AND l_cnt_flag = 'Y'
2470: AND
2471: (
2472: (WSH_WMS_LPN_GRP.GK_WMS_UPD_MISC and l_wms_org = 'Y')
2473: OR (WSH_WMS_LPN_GRP.GK_INV_UPD_MISC and l_wms_org = 'N')
2474: )
2475: THEN
2476: --{
2477: l_sync_tmp_rec.delivery_detail_id := p_container_instance_id;

Line 2538: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

2534: END IF;
2535: --
2536: -- K LPN CONV. rv
2537:
2538: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2539: THEN
2540: --{
2541: open l_get_det_attribs_csr(det.delivery_detail_id);
2542: fetch l_get_det_attribs_csr into l_cnt_flag, l_line_direction, l_organization_id;

Line 2551: (WSH_WMS_LPN_GRP.GK_WMS_UPD_MISC and l_wms_org = 'Y')

2547: IF l_line_direction IN ('O', 'IO')
2548: AND l_cnt_flag = 'Y'
2549: AND
2550: (
2551: (WSH_WMS_LPN_GRP.GK_WMS_UPD_MISC and l_wms_org = 'Y')
2552: OR
2553: (WSH_WMS_LPN_GRP.GK_INV_UPD_MISC and l_wms_org = 'N')
2554: )
2555: THEN

Line 2553: (WSH_WMS_LPN_GRP.GK_INV_UPD_MISC and l_wms_org = 'N')

2549: AND
2550: (
2551: (WSH_WMS_LPN_GRP.GK_WMS_UPD_MISC and l_wms_org = 'Y')
2552: OR
2553: (WSH_WMS_LPN_GRP.GK_INV_UPD_MISC and l_wms_org = 'N')
2554: )
2555: THEN
2556: --{
2557: l_sync_tmp_rec.delivery_detail_id := det.delivery_detail_id;