APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_MATERIAL_STATUSES

Line 2047: /* through the mtl material statuses */

2043: END Is_Valid_Uom;
2044:
2045: /*---------------------------------------------------------*/
2046: /* This Procedure validates the item condition by looking */
2047: /* through the mtl material statuses */
2048: /*---------------------------------------------------------*/
2049:
2050: PROCEDURE Is_Valid_Condition
2051: (

Line 2060: -- it exists in inventory material status codes (MTL_MATERIAL_STATUSES_B)

2056: l_dummy VARCHAR2(2);
2057: l_stack_err_msg BOOLEAN DEFAULT TRUE;
2058: BEGIN
2059: -- Verify that the Instance Condition is valid i.e.
2060: -- it exists in inventory material status codes (MTL_MATERIAL_STATUSES_B)
2061:
2062: IF ((p_instance_condition_id IS NULL) OR
2063: (p_instance_condition_id = FND_API.G_MISS_NUM)) THEN
2064: l_return_value := TRUE;

Line 2069: FROM mtl_material_statuses

2065: ELSE
2066: BEGIN
2067: SELECT '1'
2068: INTO l_dummy
2069: FROM mtl_material_statuses
2070: WHERE status_id = p_instance_condition_id;
2071: l_return_value := TRUE;
2072:
2073: EXCEPTION