APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_MATERIAL_STATUSES

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

1998: END Is_Valid_Uom;
1999:
2000: /*---------------------------------------------------------*/
2001: /* This Procedure validates the item condition by looking */
2002: /* through the mtl material statuses */
2003: /*---------------------------------------------------------*/
2004:
2005: PROCEDURE Is_Valid_Condition
2006: (

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

2011: l_dummy VARCHAR2(2);
2012: l_stack_err_msg BOOLEAN DEFAULT TRUE;
2013: BEGIN
2014: -- Verify that the Instance Condition is valid i.e.
2015: -- it exists in inventory material status codes (MTL_MATERIAL_STATUSES_B)
2016:
2017: IF ((p_instance_condition_id IS NULL) OR
2018: (p_instance_condition_id = FND_API.G_MISS_NUM)) THEN
2019: l_return_value := TRUE;

Line 2024: FROM mtl_material_statuses

2020: ELSE
2021: BEGIN
2022: SELECT '1'
2023: INTO l_dummy
2024: FROM mtl_material_statuses
2025: WHERE status_id = p_instance_condition_id;
2026: l_return_value := TRUE;
2027:
2028: EXCEPTION