730: IF p_status_id IS NOT NULL THEN
731: BEGIN
732: SELECT status_id
733: INTO l_status_id
734: FROM mtl_material_statuses_vl
735: WHERE status_id = p_status_id
736: AND enabled_flag = 1;
737: EXCEPTION
738: WHEN NO_DATA_FOUND THEN
1633: AND p_status_id IS NOT NULL) THEN
1634: BEGIN
1635: SELECT 1
1636: INTO l_chkflg
1637: FROM mtl_material_statuses_vl
1638: WHERE status_id = p_status_id
1639: AND enabled_flag = 1;
1640: EXCEPTION
1641: WHEN NO_DATA_FOUND THEN
2106: IF p_status_id IS NOT NULL THEN
2107: BEGIN
2108: SELECT 1
2109: INTO l_status_chk
2110: FROM mtl_material_statuses_vl
2111: WHERE status_id = p_status_id
2112: AND enabled_flag = 1;
2113: EXCEPTION
2114: WHEN NO_DATA_FOUND THEN