APPS.AHL_RM_MATERIAL_AS_PVT dependencies on AHL_OPERATIONS_B

Line 2062: from ahl_operations_b

2058: l_obj_status VARCHAR2(30);
2059: cursor get_oper_status (p_operation_id in number)
2060: is
2061: select revision_status_code
2062: from ahl_operations_b
2063: where operation_id = p_operation_id;
2064: CURSOR get_efct_rec ( C_ROUTE_EFFECTIVITY_ID NUMBER )
2065: IS
2066: SELECT RM.ROUTE_ID

Line 2251: UPDATE ahl_operations_b

2247: OPEN get_oper_status (p_object_id);
2248: FETCH get_oper_status INTO l_obj_status;
2249: IF (get_oper_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
2250: THEN
2251: UPDATE ahl_operations_b
2252: SET revision_status_code = 'DRAFT'
2253: WHERE operation_id = p_object_id;
2254: END IF;
2255: CLOSE get_oper_status;