APPS.WMS_PUTAWAY_UTILS dependencies on INV_MATERIAL_STATUS_GRP

Line 5792: IF (inv_material_status_grp.is_status_applicable('TRUE',

5788: --check the material status, and see if a sub transfer is allowed
5789: --in the source LPN sub/loc. If it is not, that you cannot load the
5790: --LPN
5791: IF (p_mode = 2 AND x_lpn_context = 1) THEN
5792: IF (inv_material_status_grp.is_status_applicable('TRUE',
5793: NULL,
5794: 2,--subtransfer
5795: NULL,
5796: NULL,

Line 5804: inv_material_status_grp.is_status_applicable('TRUE',

5800: l_lpn_loc,
5801: NULL,
5802: NULL,
5803: 'Z') <> 'Y' OR
5804: inv_material_status_grp.is_status_applicable('TRUE',
5805: NULL,
5806: 2,--Sub Transfer
5807: NULL,
5808: NULL,

Line 11554: AND inv_material_status_grp.is_status_applicable('TRUE',

11550: )
11551: )
11552: )
11553: )
11554: AND inv_material_status_grp.is_status_applicable('TRUE',
11555: NULL,
11556: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
11557: NULL,
11558: NULL,

Line 11566: AND inv_material_status_grp.is_status_applicable('TRUE',

11562: wlpn.locator_id,
11563: NULL,
11564: NULL,
11565: 'Z') = 'Y'
11566: AND inv_material_status_grp.is_status_applicable('TRUE',
11567: NULL,
11568: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
11569: NULL,
11570: NULL,

Line 11792: AND inv_material_status_grp.is_status_applicable

11788: )
11789: )
11790: )
11791: )
11792: AND inv_material_status_grp.is_status_applicable
11793: ('TRUE',NULL,inv_globals.g_type_container_pack,
11794: NULL,NULL,p_organization_id,NULL,wlpn.subinventory_code,
11795: wlpn.locator_id,NULL,NULL,'Z') = 'Y'
11796: AND inv_material_status_grp.is_status_applicable

Line 11796: AND inv_material_status_grp.is_status_applicable

11792: AND inv_material_status_grp.is_status_applicable
11793: ('TRUE',NULL,inv_globals.g_type_container_pack,
11794: NULL,NULL,p_organization_id,NULL,wlpn.subinventory_code,
11795: wlpn.locator_id,NULL,NULL,'Z') = 'Y'
11796: AND inv_material_status_grp.is_status_applicable
11797: ('TRUE',NULL,inv_globals.g_type_container_pack,NULL,
11798: NULL,p_organization_id,NULL,wlpn.subinventory_code,
11799: wlpn.locator_id,NULL,NULL,'L') = 'Y'
11800: )

Line 12433: IF (inv_material_status_grp.is_status_applicable('TRUE',

12429: DEBUG(' p_sub => '||p_sub,l_proc_name, 4);
12430: DEBUG(' p_loc => '||p_loc,l_proc_name, 4);
12431: END IF;
12432:
12433: IF (inv_material_status_grp.is_status_applicable('TRUE',
12434: NULL,
12435: 2,--subtransfer
12436: NULL,
12437: NULL,

Line 12445: inv_material_status_grp.is_status_applicable('TRUE',

12441: p_loc,
12442: NULL,
12443: NULL,
12444: 'Z') ='Y' AND
12445: inv_material_status_grp.is_status_applicable('TRUE',
12446: NULL,
12447: 2,--Sub Transfer
12448: NULL,
12449: NULL,